Data warehouse / Business Intelligence Resume

PROFILE
Data warehouse/Business Intelligence practitioner with full DWH/BI stack experience from analyzing requirements to implementing solution. Experience includes analyzing business; developing enterprise data models at the conceptual, logical, and physical levels; designing ODS, data warehouses, and data marts; mapping source data to target; designing data flow and ETL processes; OLAP and reporting. Software development and system administration. Microsoft Certified Solution Developer & Database Administrator (MCSD / MCDBA).

SKILLS

7 years of experience in design, data modeling and ETL in large scale data warehouse and reporting environments from beginning to rolling out DWH/BI solutions to end users.
15+ years of common experience in analysis, design, development, and implementation of software.
Excellent problem-solving and analytical skills used in business and requirements analysis for financial, manufacturing and commercial companies.
Experience with both client's and developer's viewpoints in development project situations.
Strong project management skill. Trainer experience in technical education centers.

TECHNICAL SUMARY

Languages Visual Basic, Delphi/Pascal; ASP, PHP, JScript, VBScript; SQL.
Data modeling tools: CA Erwin Data Modeler, Sybase PowerDesigner, MS Visio.
Modeling Approach: OLTP, Star & Snowflake Approach, IBM BDW, Sybase IWS, Data Vault, DW 2.0.
Database Systems: Oracle, MS SQL Server, DB/2, MySQL, MS Access.
Reporting and OLAP: MS Reporting Services; Business Objects, MS Analysis Services.
Integration tools: Informatica PowerCenter; MS DTS.
Systems & etc.: MS Windows NT/200x; MS AD; IIS, MS Exchange.

EXPERIENCE

Implemented data warehouse for the Confidential(one of the biggest Russian banks) that consolidates data across 10+ data systems. Designed, developed, and implemented 2 Tb banking data warehouse for bank Renaissance Capital that consolidate data across 6 data systems.
Created architectures of data warehouse and data flow for solving reporting problem for head office, top management, financial and market risk departments of Confidential Performed complex data analysis to design data flow and data mapping from source to target data sets. Designed logical and physical data flow diagrams. Developed requirement specifications for ETL. Reviewed, analyzed, and optimized ETL processes.
Designed, developed, and tested the data marts for calculating and analyzing coupon income and profitability of fixed income securities (government and corporate bonds). Modeled and developed analytical data marts for finance, credit risk management, and debt collection departments.
Designed, developed, and supported Confidential reporting system for company management and employees that provided staff with much analytical abilities.
Created logical and physical data models in both normalized (3rd NF) and dimensional (Star and Snowflake) approaches for manufacture, commerce and finance organizations. Understanding principles of models Confidential.
Managed staff of 4 analysts and controlled work of 10 external consultants.
Collected, analyzed and specified business and technical requirements. Understood business challenges and translates them into data models, processes and technical solutions.
Prepared documentations: "Business Requirements Definition," "Technical System Specification," etc.
Supported and administered a legacy Informatica based system that provides CFO and top managers with profitability reports.
Designed test cases and participated in testing of data warehouses.

WORK HISTORY

New York, USA
Confidential, 04/2010 - present

Confidential, Moscow, Russia
Analyst & DWH Architect of Finance Project Department 01/2009 - 04/2010

Confidential,Moscow, Russia
Analyst of Data Warehouse Development Department 02/2007 - 11/2008

Confidential,Moscow, Russia
Senior Consultant Of Analytical Data Warehousing 08/2006 - 02/2007

Confidential, Moscow, Russia
Application Developer 01/2004 - 04/2006

Confidential,Moscow, Russia
Application Developer; Part-Time System Administrator 06/2002 - 12/2004

EDUCATION / PROFESSIONAL DEVELOPMENT
BS/MS, Teacher of physics and computer science

Administering a MS SQL Server 2000 Course
Visual Basic Development Course
Unified Modeling Language (UML) Course
Banking Technologies Course
Effective Management Methods Course
Linux Administering Course (in progress).

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship