Summary

Data Warehouse/Business Intelligence Architect with over many years of

corporate IT experience and focus on Microsoft data management solutions

with a proven track record of successful, high-profile analytical and

Enterprise Data Warehouse (EDW) implementations within various business

environments including finance, manufacturing, healthcare, market research,

retail, re-(insurance), logistics, content management and education. Expert

in Ralph Kimball Enterprise Data Warehouse Engineering Method, ETL process

implementation, OLAP cube modeling and SSRS MDX and DAX scripting.

Specialization: Microsoft SQL Server BI Toolset (SSIS, SSAS, SSRS,

PowerPivot, BI Office, .NET BI Solutions, C#/VB.NET,

PerformancePoint/SharePoint), SSAS multidimensional and tabular modeling,

MDX and DAX optimization.

Professional BI Blog: http://bigorakine.wordpress.com/

SSAS Wiki (10 articles): http://www.ssas-wiki.com/w/Articles

DW/BI Expertise Summary

. Business Process and Data Source identification.

. Data Source Profiling and Data Quality assessment. Data Mapping and DW

documentation

. ETL architecture, development and optimization (SSIS). DW initial and

incremental loading

. Enterprise Data Warehouse (EDW) Kimball Method architecture and custom

optimization

. OLAP cube modeling, including: MDX scripting, aggregations,

partitions, dynamic dimension and cell security, KPI's, actions,

writebacks and perspective's development (SSAS)

. Operational and summary reporting framework design and development

(MDX, PowerPivot, DAX, SSRS, ProClarity, Crystal Reports)

. Scorecard and dashboard development and deployment (PerformancePoint,

SharePoint)

. Data Mining model development (SSAS)

. DW/BI systems project management

. Assessment of the existing DW implementations and best-practices

consulting

Experience

Lord Abbett & Co LLC, 05/2013 - Current (Jersey City, NJ) - BI/ETL

Architect

. Provided consulting services as a technical project lead to analyze

existing data feeds, design and implement a complete ETL and Reporting

solutions to load mutual funds' monthly and daily performance

data(breakdowns, benchmarks, ratios, positions) for a new corporate

site with a number of statistical reports. Technically, solution

delivered:

1. data integration from various data sources (including DB2,

Oracle, Excel files, Web Services, SQL Server)

2. complete migration from Oracle environment to SQL Server

3. following list of the Enterprise ETL services, including: running

batch statistics, notification services, transactional support,

batch re-startability, logical and data completeness filtering,

logical rollback, files archiving, zipping and FTP shipping, data

discrepancy functionality and variance reporting.

. Built statistical reports in PowerPoint v2.0, DAX was used to create

various calculations, including ratios to total/parents, financial

comparisons between dates and previous runs.

. Mentored development team, provided best practices, optimized data

extracting queries, developed and optimized over 30 SSIS packages and

10 PowerPivot reports, provided technical documentation

. Technologies: SQL Server 2012, SSIS, Oracle, PowerPivot (Tabular

Model, SSAS), DAX, Erwin, Tidal

Morgan Stanley, 11/2012 - 05/2013 (New York, NY) - DW/BI Consultant

. Hired as a DW/BI specialist to advise on best practices and provide

enhancements to the existing BI infrastructure

. Involved in the user interviewing sessions to further understand

navigating patterns and reporting requirements of the existing DW

schemas

. Working with large dimensions to optimize ETL load and SSAS processing

times

. Optimizing automated cube-refreshing components to reduce uploading

and processing time

. Building POC's to support different design implementations

. Technologies: SQL Server 2012, (SSIS, SSAS), PowerPivot, DAX, DB2,

Sybase, MDX, DBArtisan

Federal Reserve Bank of New York, 12/2009 - 11/2012 (New York, NY) - Lead

MS BI Architect

. Participated in development of numerous Enterprise BI applications as

a back-end (ETL, SSAS) specialist and best practice consultant

. Conducted business sessions to review client requirements and solution

scenarios

. Analyzed and implemented ETL solutions: developed SSIS dimension, fact

and master packages, logging, error and event handling, package

configuration, complex SQL implementation with SSIS scripting, package

optimization, production deployment and maintenance

. Designed complete OLAP solutions: cube modeling and design, semi-

additive measures, many-to-many and references relationships, user-

designed and parent-child hierarchies, aggregations, cube optimization

and monitoring (SQL Server Profiler, Performance Monitor)

. Designed complex cube's MDX spaces: static and dynamic sets,

calculated members with custom calculations at the different hierarchy

levels, scopes

. Implemented SSAS dynamic dimension and cell security with user

specific sub-set calculations

. Mentored Bank BI team in understanding and utilizing DW/BI concepts

and best-practices

. Technologies: SQL Server 2008, 2012 (SSIS, SSAS, SSRS), PowerPivot,

DAX, Oracle, Informatica, EDW Kimball Method, PerformancePoint,

ProClarity, MDX, MDX Studio, SQL Server Profiler, Subversion

GNet Group, 03/2009 - 12/2009 (Minneapolis, MN) - BI Solution Tech Lead

Technical Presentations

. "The CUBE" - BI Summit, Minneapolis, 2009

. "SSAS Cube Design" - Microsoft Technical Conference, Minneapolis, 2009

GNet Group Client list

Capella University, 03/2009 - 12/2009

. Responsible for Enterprise Data Warehouse (EDW) initial assessment,

source system data readiness and data profiling. Provided phase-one

ETL mapping documentation.

. Conducted business user interviews to identify current and future

system and reporting requirements.

. Performed sorting of the existing reports by business process and data

granularity.

. Responsible for source systems integration map and confirmation rules.

. Identified first set of the conformed dimensions, created data mapping

documentation and verified dimensional structure (hierarchies,

captions, levels, cardinality, value validity rules and format) with

business users.

. Completed Prove of Concept (POC) project to prove design model.

. Developed production data marts (total of 3) following critical

business processes: Inquiry, Enrollment, Forecast and Planning.

. Designed enterprise SSIS package template by introducing event

notification, logging and configuration best practices. Performed SSIS

data flow parallelism and buffer throughput by reducing data row size

and buffer tuning.

. Implemented SSAS cubes with MDX structures (Best/Least performing

sets, ordered and ranked sets, Current Date members, Previous/Current

YTD running totals, Growths, Averages, Sub-totals calc members, Child

to Parent total calculations, Scopes) to set expectations and provide

clear vision as well as training platform of the future deliverable.

. Designed prototype SSRS/MDX and ProClarity reports to prove MDX

calculating advantages over T-SQL.

. Technologies: SQL Server 2008 (SSIS, SSAS, SSRS), EDW Kimball Method,

Performance Monitor, MDX, MDX Studio, ProClarity 6.3, SharePoint,

Oracle 10g, Oracle SQL Developer, SQL Server Profiler, TFS

Magenic Technologies, 02/2006 - 03/2009 (Minneapolis, MN) - Senior BI

Consultant

Magenic Technologies Client list

Long Term Care Group (LTCG), 1/2009 - 03/2009

. Worked as a technical project lead to mentor Magenic BI development

team and design the most critical framework components. Overviewed and

assigned tasks to junior developers.

. Analyzed short-term project requirements, prioritized deliverables and

provided detailed project execution plan to fit into the allocated

budget and timeframe.

. Built the QA automation system (SSIS framework) to run various number

of plug-in MDX/SQL quality gates/batches to provide reporting platform

for the exception analysis.

. Designed and optimized MDX/SQL SSRS/ProClarity reports (total of 20)

to provide client with additional statistics related to the ETL

running processes. Created PerformancePoint/SharePoint dashboards with

trend charts and summary reports.

. Delivered framework documentation. Worked with clients' team to

provide training, knowledge transfer and production-run optimization.

. Technologies: SQL Server 2008, SSIS, SSAS, SSRS, MDX/T-SQL,

PerformancePoint, TFS, .NET, SharePoint, Visio

Gfk, 02/2008 - 1/2009

. Responsible for assessment of the existing EDW implementation with

emphasis on present limitations and future business requests. Provided

detailed report to the business community with design improvement

recommendations.

. Conducted business user interviews to identify existing business

processes and their dependencies, such as: fact data granularity,

confirmed dimensions, security and reporting framework (number of

analytical and operational reports, query response time, dashboards).

. Responsible for the dimensional schema design and implementation.

Built dimensional, fact, outrigger and group tables with Analysis

Services optimization techniques.

. Setup a stage area for the ETL process. Reviewed and advised on

hardware requirements.

. Migrated and enhanced an existing ETL solution from DTS to SSIS

packages (total of 30), including: transactional ETL scripts

migration, control flows and memory buffers optimization, data flow

parallel execution

. Implemented logging and process audit, error handling, check points

and SQL Server package configuration.

. Updated existing mapping documents and ETL metadata repository.

. Built SSAS multi-dimensional space: dimensions attribute hierarchies,

user-defined hierarchies, measure groups, partitions, perspectives,

actions, MDX cube space (including: calculated members, sets, scopes),

and cubes.

. Designed SQL Server stored procedures (total of 50) to call dynamic

MDX to populate SQL Server reporting tables with results of MDX

calculations. MDX calculations included: 1-12 months rolling totals

and averages, averages over different levels of hierarchy, YTD

calculations, counts, semi-additive aggregations and ratios to max,

totals and averages.

. Modified SSRS reports (total of 30), by upgrading them from SQL to MDX

environment.

. Moved solution to production and provided support to ensure expected

continuous operation.

. Prepared functional documentation and conducted knowledge transfer

sessions with IT and business users.

. Technologies: SQL Server 2005/2008 (DTS/SSIS, SSAS, SSRS), EDW Kimball

Method, MDX/T-SQL, MDX Studio, Dundas Charts, ProClarity 6.3, .NET,

SharePoint, TFS, Visio

Willis RE, 08/2007 - 02/2008

. Identified problems with existing EDW: dimensional and OLAP models,

reviewed and documented changes in business requirements, conducted

interviews with subject matter experts to obtain domain and business

processes knowledge.

. Introduced functional changes to the relational table layout to

provide the most optimized source for the SSAS cube design, including:

dimensional de-normalization, identification of the bridge fact tables

for many-to-many relationships, identification of the degenerate and

junk dimensions, isolation of the fast changing attributes to the

separate fact tables, identification of the attributes as SCD of Types

1 and 2.

. Developed enterprise SSIS package templates with pre-built

functionalities including error handling, logging, checkpoints and

email notifications.

. Participated in the SSIS package design and development to provide

initial and incremental load and in-process data consistency checks.

. Optimized ETL window, designed scientific calculation modules in SSIS

2005 packages, set staging area for data archiving, computation and

data conversion. Developed data-quality screens.

. Optimized existing OLAP databases by reducing number of dimensions,

attribute hierarchies and calculations, developed SSAS actions and

security layer. ProClarity reports optimization.

. Technology: SQL Server 2005, SSIS, SSAS, SSRS, ProClarity Desktop

Professional, MDX, Visio, Embarcadero, Excel PivotTable reports, TFS.

Xata Corporation, 04/2007 - 08/2007

. Developed dimensional models in relational and multi-dimensional (UDM)

spaces for number of Data Marts (total of 3)

. Data-profiled existing master data sources. Developed ETL modules to

provide initial, incremental and real-time data loads.

. Optimized Analysis Services response time and memory utilization.

Completely tested data availability and query response time under the

stress test to match existing service level agreements.

. Developed SSIS Script Task (.NET) modules for dynamic SSAS 2005

database XMLA installation and processing.

. Developed MS Clustering and MS Classification algorithms for Data

Mining models.

. Advised on MDX utilization and tuning for SSRS 2005 and ProClarity

reports.

. Mentored on best DW/BI practices and methods. Advised on hardware

installation to optimally meet SSAS processing and querying thread

management. Monitored SSAS clustered installation on Windows Cluster

service.

. Technologies: SQL Server 2005, SSAS, SSIS, SSRS/ProClarity, MDX-

scripting/querying, BIDS, Visio, .NET Framework, TFS, SQL

Profiler/Performance Monitor.

C.H.Robinson, 06/2006 - 04/2007

. Analyzed existing business processes, identified data gathering

points, profiled production record systems, advised on existing

Enterprise Data Warehouse (EDW) deficiencies.

. Conducted interviews with business users, identified reporting,

performance and metadata requirements, prepared project documentation

including data mapping and data profile report.

. Designed dimensional model by closely following R. Kimball DW method.

Identified star, snow-flaking and degenerate dimensions.

. Developed and tested ETL processes utilizing SSIS 2005, advised on

infrastructure setup and configuration. Optimized data flow

throughput.

. Migrated existing 5 OLAP databases (total of 35 cubes) from AS 2000 to

SSAS 2005 environment and enhanced them by following Microsoft

migration guidelines for SSAS 2005.

. Redesigned attribute and user defined hierarchies

. Developed Drillthrough, URL, Rowset actions to enrich client

navigational experience.

. Developed SSAS Dimensional and Cell security modules by utilizing SSAS

.NET (ADOMD.NET Server) stored procedures.

. Installed and tuned SSAS 2005 aggregations by utilizing Usage-Based

optimization. Applied measure group's partition strategies.

. Redesigned existing MDX reports (total of 25) to satisfy updated

report requirements and SSAS 2005 MDX optimization techniques.

. Technologies: SQL Server 2005, SSAS 2000/2005, SSIS, SSRS, EDW Kimball

Method, MDX, .NET Framework, UML/Visio, TFS, SQL Profiler/Performance

Monitor.

SuperValu, 03/2006 - 06/2006

. Analyzed and developed initial SSAS 2005 framework to support profit

and losses analysis including relational data warehouse table layout,

OLAP database design implementation and cube security layer.

. Optimized cube process procedure in response to the short (15 minutes)

"data availability window" requirement. Implemented ProcessAdd for

fact tables and ProcessUpdate for dimension tables load types.

. Worked directly with business users, delivered required set of

artifacts/documentation, iteratively modified initial design to

reflect ongoing request changes, tuned the system under production

load. Advised on DW/BI best practices.

. Technologies: SQL Server 2000/2005, SSAS/SSIS, BIDS, MDX, Visio, Excel

PivotTable, UML, SQL Profiler/Performance Monitor.

Transamerica/AEGON Canada, 01/2005 - 02/2006 (Toronto, ON) - Data

Warehouse Architect

. Analyzed, identified and documented data mapping between source, stage

and destination repositories.

. Designed reporting ODS, staging area and data marts for each Line of

Business (total of 5) to deliver Enterprise Data Warehouse (EDW)

. Designed DTS packages between FileNet P8 system and SQL Server 2000 to

provide data validation, scrubbing, aggregation and transformation.

Coded data cleansing logic utilizing regular expressions.

. Created enterprise reporting solution utilizing SQL Reporting Services

2000, T-SQL and MDX.

. Implemented security, scheduling and maintenance plans for the DTS

packages and reports.

. Stress tested designed framework under full processing load, provided

documentation and knowledge transfer to a client's BI team.

. Technologies: SQL Server 2000, Analysis Services 2000, EDW Kimball

Method, T-SQL, MDX, FileNet P8 Platform, SSRS 2000 (VS.NET 2003),

Visual Basic 6.0, VBA.

FileNet/Galantis, 04/2004 - 12/2004 (Los Angeles, CA) - FileNet/ECM DW

Consultant

. Developed OLAP and application layer of the corporate data warehouse.

Designed MDX/SQL performance and summary reports and Excel Pivot

tables/charts.

. Lead data conversion and data migration projects, developed

documentation and change management practices.

. Provided DW/BI consulting services to the client.

. Technologies: SQL Server 2000, MySQL, Oracle, Analysis Services 2000,

MDX, DTS, C#, FileNet P8/BPM Platforms.

Georgia Pacific, 03/2003 - 03/2004 (Atlanta, GA) - Senior DW/BI Architect

. Performed architecture and code review of the existing business model,

established development and delivery processes, designed project

execution plan.

. Developed Data Marts schemas for multiple business divisions (total of

4).

. Tuned ETL stored procedures, triggers and user defined functions.

Designed and developed DTS packages, designed and enhanced OLAP cubes.

. Participated in numerous report development utilizing Active Report

and Crystal Reports components.

. Supervised stress test and roll-out phases. Provided disaster recovery

plan.

. Technologies: SQL Server 2000, Oracle, VB.NET, VBA, OLAP Server, DTS,

T-SQL, Active Reports, Crystal Reports, UML, EDW Kimball Method

William M. Mercer, 06/1998-03/2003 (Toronto, ON) - Data Warehouse

Architect

As Data Warehouse Architect participated in the following projects:

. Corporate Enterprise Data Warehouse (EDW) development and upgrade.

Designed star, show -flake DW schemas including dimension tables (SCD

Type 1 and 2), fact and fact-less tables, outriggers and junk

dimension tables.

. Content Management/Warehouse/OLAP project, implemented on

ASP.NET/C#/SQL Server 2000/Analysis Services 2000, MDX platform with

FileNet BPM system integration, designed to store and serve the

corporate knowledge and customer data. Activities performed: full

software development lifecycle, development, team leadership, and post-

installation support.

. Multi-user, B2B real-time application, designed to support internal

corporate rules related to internal profit/loss business activities.

Activities performed: domain analysis, use cases modeling,

development, deployment, post-installation support. UML/Visio, SQL

Server 2000, ETL/DTS, OLAP

. Corporate Financial Processing portal, designed to provide various

financial and banking consulting services, utilizing workflow and

automated routing principles. SQL Server 2000, Visual Basic, OLAP

Server 7.0

. Business Collaboration portal, implemented on MS Exchange Server/.NET

framework to facilitate internal client-knowledge collaboration and

team communication processes. UML/Visio, SQL Server/OLAP Server,

ETL/DTS

. Technologies: Oracle, PL/SQL, C++, Visual Basic/VBA, DTS, COM/COM+,

EDW Kimball Method, UML, Visio, Brio, Oracle Reports

Fastrak Systems, 02/1997-06/1998 (Toronto, ON) - DW/System Application

Developer

. Participated in defining the Service Level Agreements (SLA) with

external clients and business partners.

. Developed ETL functionality for internal Enterprise Data Warehouse

(EDW) to support analysis of the operational, accounting, HR and

financial modules. Developed data cleansing screens to improve data

deficiencies and provide feedback to the data source systems. Designed

and maintained various operational and summary reports.

. Developed Data and Business tiers for OLTP database framework to

support multi-transactional, enterprise-level system, designed for

Harris Bank, Chicago. Completely rebuilt business-rule processing

engine to meet scalability, concurrency and speed required. Stress

tested the system to support over half million transactions per

business day. Provided post-installation support, on-site tuning and

documentation.

. Participated in data warehouse development for Unisys Corporation,

designed to support reporting analysis of the share-vesting, employee-

beneficiary and retirement plan management system. Key

responsibilities included requirements gathering, conceptual modeling,

prototyping, ETL data mapping and profiling, dimensional design, ETL

implementation and optimization, customer review sessions and best

practices consulting.

. Provided various "in-house code maintenance" procedures including

reengineering and replacement of the outdated code modules (T-SQL,

C++, Visual Basic and VBA), data profiling and data enhancement, GUI

multi-lingual support, data flow modeling and UML diagramming.

. Technologies: SQL Server, Oracle, C++, Visual Basic/VBA, DTS,

COM/COM+, EDW Kimball Method, UML, Visio, Crystal Reports

Canopus Info, 03/1994-02/1997 (St. Petersburg, Russia) -

Database/Application Developer

. Conducted interviews with stakeholders and users to define project

scope and business requirements.

. Participated in design, development, deployment and maintenance of

numerous OLTP/ODS/Data Warehouse data management systems on various

RDBMS installations.

. Coded and optimized ETL database executable modules/batches using

PL/SQL, T-SQL and FoxPro.

. Coded, optimized and deployed front and middle-tier executables/DLL's

for GUI business applications using C/C++, Visual Basic, VBA and

Delphi.

. Developed operational and performance reporting solutions using MS

Access, Excel and Crystal Reports.

. Various roles and activities performed, including: data mapping and

profiling, ETL design, database management and administration, data

conversion and migration, data maintenance and archiving, project

management, project documentation and recovery plan design.

. Technologies: Sybase, Oracle, SQL Server, Access, FoxPro, MySQL,

C/C++, Visual Basic, COM/COM+, Delphi, Crystal Reports,

Windows/DOS/UNIX/Linux.

Education

. MCSD/MCAD, MCDBA

. P8 Administrator/Developer FileNet Certifications

. Business Management Diploma, Thomson Education Direct Online, Toronto,

Canada, 2003

. Computer Science Professional Diploma, Saint-Petersburg Microsoft

Authorized Technical Training and Testing Center, Russia, 1996-1997

. Master's Degree in Electronics Engineering, Saint-Petersburg State

University of Aerospace Instrumentation, Russia, 1987-1994

Contact this candidate