SKILLS

• Expert in database architectures, multidimensional modeling, ETL and OLAP.
• Over 12 years of experience in developing relational and multidimensional databases, data warehouses, data marts, ETL frameworks, business intelligence BI reporting solutions. Expert knowledge of MS Analysis Services SSAS , Integration Services SSIS , Reporting Services SSRS , MDX, XMLA, cubes, PowerPivot.
• Over 12 years of experience in database design and development using MS SQL Server. In-depth knowledge of T-SQL with strong emphasis on tuning complex procedures, and on multidimensional analysis. Strong knowledge of Oracle, PL/SQL.
• Strong knowledge of C .NET, C .NET, Visual C , C .
• Good/working knowledge of Tableau, Linux, PowerShell, Python, Java, Hadoop including DFS , Sqoop, Hive, NoSQL MongoDB , MySQL.
• Good knowledge of AWS, including data processing with streaming S3, MapReduce,
• S3DistCp, Hadoop Streaming API , S3 to Hadoop/Hive data export/import, Redshift.
• Strong requirements gathering and business analysis skills. Provided advanced BI and Big Data solutions for customers in financial, insurance, telecommunications, technology, retail, advertising and manufacturing industries.
• Project management experience.

EXPERIENCE

Confidential

• Consultant DW/OLAP/ETL/BI
• Summary of current/latest projects:
• Developed working prototype of ETL process to import data from Hadoop/Hive into MS SQL Server/SSAS Linux, Hadoop, Hive, Sqoop, MySQL .
• Developed MapReduce program AWS, Python, Hadoop Streaming API for log-files processing.
• Developed MS SQL Server database and Python application for automated web data collection.

Major 4 months projects:

Confidential

• MS SQL Server 2014, SSIS, SSAS, C , Python, Tableau, AWS:
• Designed from scratch MS SQL Server database running on Amazon RDS to be used for relational using Tableau and multidimensional reporting. Designed ETL framework and SSIS packages for loading Orbitz-generated XML files and Google Analytics data. This project was completed ahead of time and is currently in production.
• Developed ETL framework and SSIS packages C , Python for scheduled downloading of Google Analytics and DFA data and importing into MS SQL Server database.
• Optimized ETL system for loading data into MS SQL Server/SSAS databases AdCenter project at Microsoft , providing significant improvement in processing time.

Confidential

• MS Analysis Services 2012, SQL Server, SSIS, SSRS:
• Advised on migrating Oracle/Cognos databases to SQL Server/SSAS 2012 environment. Designed SSAS database 3 cubes, 50 dimensions, multiple ragged hierarchies replacing the original system of over 20 Cognos data cubes while preserving all important features of the original system.
• Advised on choosing between tabular and multidimensional SSAS models.
• Designed ETL framework and SSIS packages for transferring data from Oracle into MS SQL Server staging database and for loading dimensional and fact tables.
• MS Analysis Services 2008, SSIS 2008, MDX, SQL Server 2008, XMLA, SSRS 2008:
• Developed and optimized SSAS databases. Largest SSAS database contained 320 many-to-many relationships. Proposed an alternative product architecture which provided a significant improvement in reliability, scalability, as well as reduction of the database processing time.
• Wrote MDX expressions for aggregations where fact tables linked through many-to-many relationships with participating dimensions.
• Designed ETL framework, scripts and SSIS packages for loading customer-specific data from staging into production SQL Server databases.
• Advised on synchronizing and updating SSAS databases using XMLA.

Confidential

• Project Management, MS SQL Server/SSAS/SSIS/SSRS 2008 R2:
• Managed project on corporate BI infrastructure MS SQL Server, SSIS, SSRS, SSAS 700 reports, 1000 business users upgrade and optimization.

Confidential

• MS Analysis Services 2008, SSIS, MDX, C .NET, XMLA, SSRS:
• Proposed and developed C .NET application for fully automated creation, processing and removal of cube partitions.
• Reviewed, optimized, and transferred to a production environment MS Analysis Services 2014/2008/2005 databases including AdCenter project , successfully resolving a number of critical processing and performance issues.
• Optimized dimensions and partitioning strategy of a multi-gigabyte MS Analysis Services 2008 database for distinct count calculations.
• Converted SQL-based reports into MDX-based SSRS reports providing on average 20 times improvement in report generation time.

Confidential

MS Analysis Services 2005, MDX, MS SQL Server 2000/2005, SSIS:

Designed and optimized MS Analysis Services 2005 databases utilizing advanced features such us cascading many-to-many relationships, slowly and rapidly changing dimensions including dimensions with more than 6 million members , role-playing dimensions, complex indexes, surrogate keys, linked measures and dimensions.

Developed MDX expressions for use in Panorama and ProClarity reports. Optimized previously created MDX scripts providing significant performance improvement.

Advised on synchronizing and integrating MS Analysis Services 2005 databases, measure groups and dimensions using XMLA.

Proposed fast and efficient transformation of daily MS SQL Server database loads and developed SSIS packages enabling historical analysis of data while keeping the related tables compact.

Confidential

• MS Analysis Services 2000/2005, MS SQL Server, Integration Services, Sybase, DB2:
• Advised on performance tuning of MS Analysis Services 2000/2005 databases.
• Reviewed and optimized MS Analysis Services security management system capable of supporting hundreds of dynamic OLAP roles. Time required to update users' permissions has been reduced from more than 6 hours to less than 10 minutes. This resulted in significant improvement of cubes availability for business users. The system was installed at multiple client sites in New York, London, Tokyo.
• Developed utility for running scheduled comparisons of production cubes against a master-cube to find differences in structure and values of cubes/dimensions/cells.

Confidential

• MS Analysis Services, MDX, MS SQL Server 2000
• Designed MS Analysis Services-based system of 50 OLAP cubes for multidimensional analysis of sales data multi-terabyte data warehouse environment, running on Oracle . The system included 30 virtual cubes and 100 shared dimensions, size of some cubes exceeded 100 GB. Was responsible for all aspects of MS Analysis Services-related work including cube design changing and write-enabled dimensions, automated partitioning, aggregation design and usage-based optimization, drillthrough support, calculated members, etc. , processing, and performance tuning. The project was completed ahead of time, within budget, and with all of the initially planned functionality delivered.
• Designed, implemented and tuned ETL system for completely automated processing of OLAP cubes, for creating and managing partitions, including parallel processing, and for populating executive dashboard.
• Developed cube-based method and system for forecasting financial metrics.

Confidential

Position: Database Architect

• MS SQL Server 2000, Sybase SQL Anywhere, ERwin:
• Developed stored procedures, triggers, and other database components of the OpenEnterprise business intelligence and data warehousing software package, which included an integrated OLAP report generator, data movement system, and OLTP system 2,000 tables, 1,500 stored procedures . Mainly, stored procedures and triggers were designed to extract data from multidimensional summary tables with tens of millions of records and to populate them, to utilize drill down data exploring method, to maintain data cubes, snowflake and star schema data models and to support dimension hierarchies.
• Analyzed query plans, indexes, and locking behavior. Enhanced and optimized very complex stored procedures using advanced Transact-SQL programming techniques.

Confidential

Position: Database Engineer

• MS SQL Server 2000, Sybase SQL Anywhere, ERwin, PowerDesigner, Oracle:
• Developed, enhanced and optimized database components of the Transactionware OLTP system. The Transactionware product is sold worldwide in more than 30 countries.
• Initiated technical proposals on key aspects of database optimization, database architecture, development standards.
• Developed and maintained data models ERwin, PowerDesigner .

Confidential

Position: Team Lead/Database Administrator

• MS SQL Server 6.5, Access, Oracle, Visual C :
• Initiated and managed data warehouse project. Designed MS SQL Server database. Developed stored procedures, triggers, and table structures.
• Master's degree in Engineering, graduated with honors.