Developed and maintained internal DWH/BI system; designed and developed ETL processes using SSIS; wrote T-SQL scripts and stored procedures; MS SQL Server 2016 used as the DWH database; Pharmacy chain data integration and reporting.

SQL BI Developer at Finning

November 1, 2018 - September 1, 2021

Design, development and support of data warehouses and ETL processes in MS Azure environment (ADF pipelines, Azure Databricks, SSIS, TSQL, C#); destination database: MS Azure SQL Database; data ingested from various sources including REST API and flat files.

BI Consultant at Otto Group Russia

February 1, 2017 - September 1, 2018

Development and maintenance of internal DWH/BI system; SSRS reports, SSIS packages, SSAS cubes (multidimensional and tabular); Power BI experience; Ecommerce domain.

BI Consultant at lululemon athletica

March 1, 2015 - November 1, 2016

RFID BI (Inventory/Adjustments): created SSAS cube, designed data mart and ETL; developed SSRS reports and SSIS packages; Ceridian Dayforce Integration project (Informatica, Oracle, PL/SQL, SSIS).

BI Developer/ETL Developer / SQL Developer at Fujitsu Consulting (Canada) Inc.

January 1, 2014 - March 1, 2015

Projects at BC Hydro: SSIS Packages, SSRS Reports Development and Maintenance; Fraser Health: SSRS Reports, SQL queries optimization; Health care industry.

BI Developer / Report Developer at Arvato digital services

March 1, 2013 - January 1, 2014

BI Developer, Report developer, Database developer (MS SQL Server 2008R2, TSQL, stored procedures, views). SSIS, SSRS, Data warehousing. Created cube using SSAS. Created many reports using SSRS. Data Warehouse DB Administration. Reporting system Administration (SSRS). SQL Azure experience, C# development.

Database Developer / DBA at LGM Financial Services Inc.

August 1, 2009 - December 1, 2012

Database development/administration; data migration; ETL processes (TSQL, SSIS); Created Data Warehouse; Created cube using Analysis Service (SSAS); Created many reports using Reporting Service (SSRS); ASP.NET 3.5/4.0 development using C# (VS 2008/2010).

Software Developer at Intrinsyc Software

July 1, 2007 - April 1, 2009

C++ development for Symbian OS; OpenMAX components; Agile development; Tools: VS, Perforce, Bugzilla.

Software Developer at VTB Bank (open joint-stock company)

November 1, 2006 - June 1, 2007

Developed software to check for suspicious bank clients and bank transactions, based on OFAC list (SDN list) and EU list; MS SQL Server 2000; C#, C++, ADO, ADO.NET.

Software Developer at Home Credit and Finance Bank

March 1, 2006 - November 1, 2006

Developed many reports in Business Objects; migrated to ABS FlexCube (Oracle 9.2.0); analytical work with i-flex solutions team; problem definition, testing reports.

Software Developer at Commercial Interregional Trust Bank

April 1, 2004 - March 1, 2006

Software development using RSL language; integrated Credits subsystem into ABS RS_Bank 5.1 system (Pervasive SQL 2000, RSL); operation and administration of INVOCARD subsystem (Oracle 8.1.7, SQL).

System Analyst at Joint Stock Commercial Bank for Regional Development 'Regiobank'

May 1, 1994 - January 1, 2003

Developed stored procedures, views, triggers (T-SQL); developed reports using RSL, C++; administered MS SQL Server 6.5/7/2000; ran ABS 'RS_Bank'; developed software for automation of various bank operations (MS Visual C++, Borland C++, Borland C++ Builder, MS Access).