SUMMARY:

• Business Intelligence Professional with 14+ years of experience in various projects and technologies in Analyst, Developer and Team Lead/BI SME roles in ETL, Data Warehouse, Master Data Management, Reporting, KPI/Scorecards and Forecast/Budgeting Projects.
• Complex Data and Process models across multiple datasources (local, 3rd party, Salesforce.com, Hadoop) to unify data and provide consistent datamarts and build confidence for data available for analysis.
• Able to work on multiple tasks and handle high level of details and cross - references, provide deliverables on time in fast-paced environments, including possible risks definition and issues management in real-time environment constraints disposition.
• Positive breakthrough-nature enthusiast with passion to solve challenges using proven approaches and good in building partnership with Business to define requirements scope definition/development/acceptance details in iterative spiral of Business Intelligence Solution/Product/Service lifecycle.
• Strong team player/mentor with self-starter attitude, wearing different hats, always keeping in touch with Business to get feedback ASAP on current visible output and arrange work direction accordingly, detail oriented Project Manager for onshore/offshore and mixed Teams.
• Delivering and supporting strategic targets and overall vision of Business Intelligence/Performance Management platform to provide linkage of data with Users, internal Customers and other Stakeholders/Product Owners/Senior Management
• Have solid experience on successful lead of multiple simultaneous Product lifecycle stages - re/pro-active Business Requirements mining, Architect/Design of Data/Multidimensional models and deliver PoC/Demo, BRD preparation/verification, Development, QA/UAT, Production support/health check, implemented automated Metadata/ Knowledge logic/lineage documenting.

SKILL:

Complex Data Visualization, What: If Analysis, Business/Data Analysis, Relational and Multidimensional Databases Design, Data Processing Design, Information Architecture, Project Management.

Software Development Methodologies: SCRUM/Agile, Waterfall, PMBOK/PMP

Business Intelligence/ETL Tools: IBM Cognos BI/Framework Manager/Transformer/Planning/TM1, Tableau Desktop/Server, SAP BW BI/Business Objects/HANA, Oracle OBIEE/Hyperion, Confidential SQL Analysis / Tabular / Integration / Reporting Services / SharePoint / Performance Point / Project Server / (SSAS, SSRS, SSIS), Qlikview Desktop/Server/iPad, Informatica PowerCenter, Control-M, RoamBI, D3.js, R, JasperReports, MicroStrategy, Excel data analysis including Power BI

Databases: Confidential SQL Server/Azure SQL, Oracle, HP Vertica, DB2, AMZ Redshift, Google BigQuery, SalesForce.com, Teradata, Hadoop/Hive/Pig/Sqoop, MongoDB

Languages/Automation/Source control systems: XML, Ant/NAnt/CPPAnt, JavaScript, C#, VB.NET, Java, Python, ER Studio, PowerDesigner, VBScript, Jenkins, AccuRev/CVS/SVN/GIT/Perforce, CollabNet, JIRA/Confluence, SQL, T-SQL, PL/SQL, MDX/OLAP/Cubes, DAX Various Industry and Departments Experience, incl. SDLC, Production, Marketing, Retail/Sales, Budgeting/Forecasting, Treasury, HR, Client Issues management, International Finance Accounting, etc.

EXPERIENCE:

ETL/DWH/BI Senior Developer

Confidential

Responsibilities:

• Support successful run of data ETL 24/7 processes, closing week and month end.
• About 1000 ETL processes running thru ETL Framework over 15 MS SQL Servers within more than 150 databases.
• Managing bugs tracing, monitoring automation, alerts messaging on exceptions and environment issues.
• Review and optimize current processes.
• Support Cubes refresh with recon of data results.
• Reverse back and visualize system processes for easy data issues trace back thru all system parts and components - ETL Framework, C# modules, t-SQL stored procedures, Cubes structures.
• Setup and manage Cubes access from MS Power BI and Tableau.
• Participate in new system version development thru usage of Cosmos (internal MS Hadoop) and SOA architecture.

Confidential

ETL/DWH/BI expert

Responsibilities:

• Create and support processing (SQL, PL/SQL, Informatica) of various Call data from multiple sources with providing reporting solution thru DataMart (DB2, Hive@HDP) and BI components (BusinessObjects, Tableau) linked to it. Cloud CRM (Salesforce.com) to BigData (Hive@Hadoop) data processing (SQL, Informatica) with cleansing and keeping full changes for history trace back.

Confidential

Responsibilities:

• Creating and support rules and processes in existing system (extend capabilities and functionality) of data coming from wide range of Confidential developed products - to provide unlimited number of systems being process in one time for unified data mart solution with reporting and exchange for 3rd Party tools available.

Confidential

Technical Lead

Responsibilities:

• Developed and delivered in time report for 5 areas of business using pixel-perfect technique with complex KPI’s logics included and used.

Confidential

ETL/DWH/BI expert

Responsibilities:

• Team lead and data model architect, manage activities/tasks/communications across.
• Management up to 4 developers of project team in 2 Ukraine locations.

Confidential

Senior Support Engineer

Responsibilities:

• support and development for Performance Optimization and Data Comprehensive Forecast Tool
• Was involved in full cycle client support activities from Prod support till new requirements development as L3 Support Lead.
• On daily basis thru SCRUM and Agile processes was delivered lot of patches and release of customized Customer systems configurations.
• Many workaround and new approaches was found and delivered in time for gather specific SLA requirements.
• Participation in the new system versions/abilities design.

Confidential

PM/TL/Senior programmer

Responsibilities:

• Supporting new product generation development using Cloud and BI platforms for Fire departments reporting automation.
• Developed set of reports and dashboards using latest IBM Cognos and RoamBI functionality to deliver information about all running and planned Project initiatives in Confidential by sourcing data from Planview Project Portfolio Management system
• Supported new Cognos Framework Model development and migration Active Reports (incl optimization for iPad), Widgets and Reports from old to new logic
• Automated impact analysis and documentation generator

Confidential

Responsibilities:

• Reorganized and fully updated graph of dependencies of all MS SQL Server objects (more than 35 000 objects in total) for dependencies and architectural analysis usage
• Automated documentation and graph refreshment for any future changes in MS SQL Server and MS Integration Services
• Delivered full parsing of any t-SQL code changes for CRUD (create, read, update, delete) list of actions for code review and impact analysis
• Implementation of 1S 8.1 ERP systems including integration with SAP BO Xcelsius.