Eugene Turkestanov

Calgary, Alberta, Canada ad23vu@r.postjobfree.com linkedin.com/in/etldeveloper

Summary

** *****’ experience in Information Technology area.

More than 17 years’ experience as Database Developer

6 years’ experience as Data Engineer

7 years’ experience as DBA.

Specialized in SQL Server 6.5 - 2019 and MySQL.

Proficient in data architecture, database design, data modeling, analysis, installations, upgrades, performance tuning, scheduling backups/recovery, SSIS, SSRS, Enterprise Data Warehousing.

Data migration, ETL and BI development, including stored procedures, functions, views, and triggers.

Ability to work in a team and with individuals of different skill levels, strong commitment to meet deadlines under pressure.

Experienced in the documentation.

7 years’ experience in Agile.

2 years Python and 3 years’ Power BI experience

1 year of Snowflake cloud experience

5 years MS Azure, Data Factory and Synapse

7 years experience in Team Leading

Experience

Senior Data Engineer

Silver Creek Software

Pipelines and EDW solutions for the Government of Alberta

July 2021 - current

Created ADF pipelines to deliver data from multiple sources such as JSON, Azure SQL, Synapse, Oracle

Created Azure resource groups, environments, Key Vaults

Developed Synapse data storage, Lake Databases and Delta lakes to keep incremental changes.

Created logic App to get data from JSON payloads.

Created APIs with Azure functional apps (Python) to deliver data in JSON.

Data model design, applying data architecture design to build data storage and support report creation.

Created and maintained Control Framework

Created Power BI reports.

Technologies: MS Azure, ADF, Synapse, Delta Lake, Power BI, DevOps, Logic App, Python, T-SQL, JSON, ELT

Data Analyst (contract)

CGI Business Consulting

The analytical solution as part of Enterprise Data Warehouse was implemented for Blue Cross Nova Scotia, including ETL and SSAS.

Jan 2021 – June 2021

BI Development and ETL to create analytical cubes (SSAS)

Created SSIS packages to deliver data to dimensional data model

Created Power BI reports

Technologies: SSIS, MS SQL Server 2019, SSAS, T-SQL, PL/SQL, Power BI

Database Developer (contract)

H&R Block (hrblock.ca)

Nov 2019 - Dec 2020 (1 year)

Built integration solution between SQL Server on premise, MS Azure and Snowflake cloud platform, created Enterprise Data Warehouse on Snowflake platform.

Created Integration Architecture to load data from multiple sources to Snowflake

Created SSIS and Python integration to populate Snowflake storage

Data Analysis and Data Modeling for internal applications

MS Azure integration with Data Factory to connect to Snowflake

Technologies: MS SQL Server 2008 - 2017, SSIS, SSRS, T-SQL, Python, Snowflake, MS Azure, Data Factory, Power BI, JSON, XML

Data Integration Specialist (contract)

Grid Group (Calfrac Wells Services) – contract (calfrac.com)

Oct 2018 - Nov 2019 (1 year 2 months)

Created integration architecture between internal applications, data migration from UltiPro to Kronos HR systems, participated data transition to Oracle BI platform

Created Integration Architecture to load multiple internal applications

ETL development to populate models with data coming from multiple sources

SSIS projects design and development

Data migration from MS Access to MS SQL Server.

Azure data Factory integrations to load cloud based data storage.

Technologies: MS SQL Server 2008 - 2016, MS Access, SSIS, SSRS, T-SQL, Power BI, Erwin, Python, MS Azure

Senior BI and ETL Developer (contract)

Copperstone Connect (Mawer Investment Management) – contract

Nov 2013 - Oct 2018 (5 years)

Mawer engaged Copperstone to create a modern Enterprise Data Warehouse as well as Analytical solution based on Power BI.

Leading team of developers: mentoring, tasks assigning, project plans, Agile, scrum.

BI Development and ETL

Enterprise Data Warehouse development (ODS, Kimball methodology) to support internal reports and analysis.

Implementing Data Governance processes

Master Data Management

SSIS projects design and development

Data Factory integration

Power BI development

Data Analysis, Data Modeling

Python development

Technologies: MS SQL Server 2008 - 2016, SSIS, SSRS, T-SQL, .NET, VBA, Python, Azure, Data Factory, Jira

Sr Database Developer

Propak Systems Ltd. (propaksystems.com)

Feb 2011 - Nov 2013 (2 years 10 months)

Established integration architecture and data transfers between internal applications, created reporting and analytical solution.

Database and web development

Leading team of report developers: mentoring, assisting with complex queries.

SSIS packages design and development

Data migration from MS Access to MS SQL Server.

SSRS, BI Development and ETL

Data Modeling

MS Analysis Services, OLAP solution

Technologies: MS SQL 2005-2008 R2, MS Access, ASP.NET 3.5, 4.0, MVP, MVC, AJAX, SSIS, SSAS

DBA

Call Genie

Sep 2007 - Feb 2011 (3 years 6 months)

Administered around 50 virtual MySQL servers and MS SQL Server

Administering MySQL and MS SQL Server 2005

Reporting and BI Development

Data migration and data extracts

Executed database backups and recovery, implementation, tuning, monitoring, capacity planning, query performance tuning, database server performance tuning, security, database maintains, code reviews, data architecture and analysis.

Documented database servers’ environment, user manuals.

Recommendations for development team.

Developed web application based on Google maps.

Technologies: Pentaho ETL, PHP, Ajax, JavaScript, MySQL, MS SQL Server, VBA, RDBMS

ETL Developer

Hitachi (Ideaca), Calgary, Alberta

Jun 2007 - Aug 2007 (3 months)

CanCarb (TransCanada) engaged Hitachi to implement MS Dynamics in order to replace JD Edwards ERP system.

Data migrating from JD Edwards to MS Dynamics Axapta (Oracle and MS SQL Server 2005)

Technologies: ETL, MS SQL Server, Oracle, Excel, RDBMS

Win/Web Developer, database developer

inUnison is a joint venture between 1st Calgary Savings and Envision Financial, providing services for credit unions.

Nov 2005 - Jun 2007 (1 year 8 months)

The project of banking conversion to replace the old application.

Reports and Database development.

Created internal banking applications.

Worked on design of new banking system database.

DBA duties (SQL Server 2000 and 2005): backup, recovery, security, performance, tuning.

Database analysis in banking conversion project.

Technologies: MS SQL Server, .NET, T-SQL, Crystal Reports, Excel, RDBMS

Database developer/DBA

RRC

Jan 2001 - Jun 2005 (4 years 6 months)

Reports and database development.

Developed new modules and features for Platinum SQL ERP.

Provided maintenance/support activities.

Created DTS packages and OLAP solutions.

Executed database backups and recovery, implementation, tuning, monitoring, capacity planning, provided general technical and network troubleshooting, performance tuning. Created internal tracking system.

Technologies: MS SQL Server, Crystal Reports, T-SQL, DTS(SSIS), OLAP, VBA, RDBMS

Technical Support Engineer

Epicor corp

Jul 1997 - Dec 2000 (3 years 6 months)

Analyzed clients' databases and troubleshooting.

Recommendations on improvement of the system functionality for development team.

Solving problems in administering SQL Server 2000 as backup and recovery database, maintenance tasks configuring, managing database files, jobs, troubleshooting, performance tuning; Provided technical support of Platinum SQL ERP system.

Data analysis

Technologies: MS SQL Server, Crystal Reports, T-SQL, DTS, OLAP, VBA, RDBMS

Programmer

FutureWare-AMF

Jul 1996 - Jun 1997 (1 year)

Interface development, development tools, test environments and Installation at client sites.

Developed accounting applications based on SQL Server platform.

Technologies: MS SQL Server, Crystal Reports, T-SQL, Delphi, RDBMS

Education

Moscow State Industrial University (MSIU)

Bachelor's Degree, Computer Science

1991 - 1996

Moscow Accounting College

Diploma, Accounting

1987 - 1990

Contact this candidate