SUMMARY:

• Data Warehouse/Business Intelligence Developer with over 10 years of corporate IT experience implementing analytical Data Warehouse and Business Intelligence solutions within various business environments.
• Holds extensive practical knowledge of the Microsoft BI Toolset, including SQL Server Database, SSIS, SSAS, SSRS, and seeks a position of the DW/BI Developer to implement data - driven analytical solutions by applying modern DW principles and practices.
• Specialization: Microsoft SQL Server BI Toolset (SQL Server, T-SQL, SSIS, SSAS, SSRS, BI Office, PerformancePoint/SharePoint deployment), Kimball Enterprise DW Method, SSIS ETL development, SSAS modeling and MDX reporting, IZENDA BI reporting tool
• Business Process and Data Source identification
• Data Source Profiling and Data Quality assessment. Data Mapping and DW Documentation
• Enterprise Data Warehouse (EDW) Kimball Method architecture
• ETL architecture development (SSIS). DW initial and incremental loading
• Data cleansing and data enhancement
• OLAP cube modeling, including: MDX scripting, aggregations development (SSAS)
• Operational and summary reporting framework design and development (MDX, SSRS, Tableau, Excel, Looker, Izenda)

PROFESSIONAL EXPERIENCE:

Confidential

DataWarehouse/BI, ETL Senior Developer

• Architected and developed from scratch an Operational Data Store (ODS) system to support near real-time reporting requirements to analyze data from multiple business sources, including HR and Payroll systems. ODS includes Staging, Historical and Warehouse data areas populated by SSIS ETL framework, with over 100 operational and analytical reports created in Tableau, Looker and Excel.
• Developed ETL framework to load Staging and Historical sets of tables to implement SCD logic and archiving of selected datasets. Framework includes logging, error handling, and email notification.
• Developed ETL history-rebuild process to fully restore current state of data sourcing historical tables from the beginning of data record. Process fully restores SCD Type 2 history attributes for each client.
• Worked closely with business stakeholders to identify analytical requirements and setup implementation SLA’s. Identified project’s scopes, dimensional and fact granularities.
• Performed Data Modeling including ER and Dimensional Modeling including Star/Snowflake schemas.

Technologies: SQL Server 2014/2016, PostgreSQL, SSIS, SSAS, SSRS, Tableau, Looker, Visual Studio 2017, GitHub, Lucidchart.

Confidential

Database/BI/Senior Developer

• Responsible for ETL process for nopCommerce open source application to support merchandise catalogs for firm’s clients. Activities include backend programming, merging existing databases, data quality procedures, preparing ingest files as an application input.
• Working closely with business users to identify mapping and create redemption reports for internal financial and bulling departments.
• Developing SSIS packages, stored procedures, functions to support FTP load from clients.
• Technologies: SQL Server 2012, SSIS, SSRS, Visual Studio 2013.
• Data preparation to Izenda reporting tool. Creation of stored procedures including pivot and dynamic sql, increase performance of the sql queries.

Confidential

Microsoft BI/DW Developer

• Involved in development of billing and remit reconciliation projects to provide reporting framework for financial department
• Worked closely with business users to gather business requirements, created project technical documentation, database diagrams and mapping rules. Data analysis and source profiling
• Connected to various data sources and optimized the data retrieval processes to reduce the data extraction time and to minimize external impact on the source data
• Built ETL components (SSIS packages) to stage and integrate incoming data streams, to clean and load initial and incremental data from heterogeneous sources
• Created initial and incremental ETL loading processes, worked on inferred dimensional members, type 2 slowly changing dimensions with star and snowflake schemas
• Created and optimized various relational schema objects: stored procedures, execution scripts, tables, views, indexes, CTE, etc.
• Optimized packages performance to meet data-load window requirements, implemented package configuration, logging and error handling functionalities

Technologies: SQL Server 2008/2008 R2, SSIS, SSAS, SSRS, BIDS, Excel PowerPivot, MDX/DAX, T-SQL, SAS 9.3, Qlikview BI tool.

Confidential

DW/BI/SQL Server Developer

• As an ETL developer, participated in ODS system development for large re-insurance company
• Developed technical documentation including: source-to-target data mapping documents, infrastructure schemas and database diagrams
• Designed and installed SSIS packages to confirm, clean and load initial and incremental data from heterogeneous sources
• Created various relational schema objects: stored procedures, execution scripts, tables, views, indexes, etc.
• Optimized packages performance to meet data load window requirements
• Participated in knowledge transfer phase
• Worked on the data integration project for large insurance company
• Created data cleaning and confirmation scripts to match finance data between two major record keeping systems
• Created and optimized various stored procedures to calculate indemnity and expenses for paid and reserved balances
• Produced summary reports at the treaty and policy granularity

Technologies: SQL Server 2005/2008, SSIS, SSRS, BIDS, Excel PivotTable, T-SQL, Kimball DW Method

Confidential

DW/BI Developer

• Participated in project requirements identification and discovery analysis sessions. Conducted following interviews with business users to access the project readiness and scope.
• Identified and documented business processes to support Data Mart development by following the Kimball DW Method.
• Created and optimized Data Warehouse relational star/snowflakes schemas, SCD type 1 and 2
• Designed relational schema objects, including: databases, tables, table constrains, views, stored procedures, indexes, relationships, etc.
• Designed, optimized and deployed numerous SSIS packages to implement ETL process for Data Warehouse initial and incremental loads. Provided Data Mapping documentation. Documented SSIS package data transformation logic.
• Participated in SSAS Cube design and development. Created dimensions, attributes, user-defined hierarchies, optimized attribute relationships.
• Created MDX calculated members, named sets and scope statements.
• Developed numerous SSRS and Excel reports to support operational and decision making activities.
• Developed KPI’s, scorecards, analytical grids and dashboards utilizing PerformancePoint and SharePoint

Technologies: SQL Server 2005/2008, SSIS, SSAS, SSRS, BIDS, Excel PivotTable, MDX, T-SQL, PerformancePoint, SharePoint, Visio, .NET, Kimball DW Method

Confidential, Toronto, ON

Business Intelligence Developer

• Corporate Enterprise Data Warehouse (EDW) development and upgrade.
• Designed star/snowflake DW schemas including dimension tables (SCD Type 1 and 2), fact and fact-less tables, outrigger dimension, junk and mini-dimension tables.
• Participated in business process identification, documentation and diagramming. Assessed DW data readiness and identified Data Mart fact grains.
• Implemented fact and dimensional tables, indexes, relationships.
• T-SQL programming: querying, triggers, views and stored procedures design.
• ETL source/target mapping and documenting.
• SSIS packages’ design, development, testing and deployment. Implemented logging and process audit, error handling, check points and package configuration.
• Initial DW load and data profiling. Incremental DW load design and optimization.
• SSAS cube design and deployment: many-to-many and referenced dimensions, semi-additive measures, aggregations.
• Created and optimized MDX calculated members, named sets and scopes.
• Created several PerformancePoint dashboards and deployed them to the SharePoint site.
• Database general management and support. SSIS .NET programming

Technologies: SQL Server 2005, ETL/SSIS, SSAS, T-SQL, Visio, .NET, Kimball DW Method