Power Bi Sql Server

Eugene Turkestanov

Calgary, Alberta, Canada

*******@*****.**

linkedin.com/in/etldeveloper

Professional Summary

Results-driven Senior Data Engineer with 25 years of experience in Information Technology. Demonstrates expertise in data architecture, ETL processes, business intelligence, and cloud technologies. Proficient in Agile methodologies, team leadership, and developing scalable data solutions. Skilled in Azure, Power BI, Python, Snowflake, and MS SQL Server with a proven track record of meeting tight deadlines and delivering high-quality outcomes. Exceptional analytical skills and a commitment to continuous learning and innovation.

Core Competencies

Cloud Technologies: 7+ years of expertise in Microsoft Azure (Azure SQL, Data Factory, Synapse Analytics, Data Lake, Delta Lake, Spark Pool).

Data Engineering: Extensive experience in ETL, data modeling, data architecture, and database design.

Business Intelligence: Proficient in Power BI, SSIS, SSRS, Synapse Analytics, and MS SQL Server for creating insightful reports and dashboards.

Programming Skills: Python, T-SQL, PL/SQL, JSON, and XML.

Leadership: 7 years leading technical teams and mentoring developers.

Agile Methodologies: 8+ years’ experience working in Agile environments.

Data Warehousing: Expertise in implementing Kimball methodology, Master Data Management and Data Governance processes.

Professional Experience

Senior Data Engineer

Silver Creek Software – Government of Alberta

July 2021 – December 2024

Designed and implemented ADF pipelines for data integration from diverse sources (Excel, Azure SQL, Data Lake, Oracle, Delta Lake, MS SQL Server).

Built orchestration frameworks and developed Data Flows for incremental loads.

Developed APIs using Python to integrate JSON payloads.

Collaborated on Power BI dashboards and logic apps for seamless data delivery.

Technologies: MS Azure, Delta Lake, Synapse, Python, Power BI, Logic App, T-SQL.

Data Analyst (Contract)

CGI Business Consulting

January 2021 – June 2021

Created SSAS cubes and ETL pipelines for Blue Cross Nova Scotia’s Enterprise Data Warehouse.

Generated actionable Power BI reports for stakeholders.

Technologies: SSIS, SSAS, MS SQL Server 2019, Power BI, T-SQL, XML.

Database Developer (Contract)

H&R Block

November 2019 – October 2020

Built integrations between on premise SQL Server, Azure, and Snowflake cloud platform.

Developed data pipelines using SSIS and Python for Snowflake storage.

Technologies: Snowflake, MS Azure, Data Factory, Python, Power BI, MS SQL Server.

Data Integration Specialist (Contract)

Grid Group - Calfrac Wells Services

October 2018 – November 2019

Designed ETL architecture and migrated data across internal HR systems.

Created Azure Data Factory pipelines for seamless data transfer to Data Lake.

Technologies: Azure Data Factory, Power BI, Erwin, SSIS, MS SQL Server, T-SQL.

Senior BI and ETL Developer (Contract)

Copperstone Connect - Mawer Investment Management

November 2013 – October 2018

Spearheaded the development of a modern Enterprise Data Warehouse and Power BI analytical solutions.

Managed a team of developers, ensuring Agile best practices and timely delivery.

Technologies: Kimball methodology, Python, SSIS, Power BI, Data Factory, Jira, MS SQL Server, T-SQL.

Sr. Database Developer

Propak Systems Ltd.

February 2011 – November 2013

Established integration frameworks and developed OLAP solutions.

Mentored a team of report developers.

Technologies: MS SQL Server, SSIS, ASP.NET, SSAS, T-SQL.

DBA

Call Genie

September 2007 – February 2011

Administered over 50 virtual database servers and implemented performance optimization strategies.

Developed web applications integrating Google Maps.

Technologies: MySQL, Pentaho ETL, PHP, MS SQL Server, Perl, T-SQL.

ETL Developer

Hitachi (Ideaca)

June 2007 – August 2007

Migrated data from JD Edwards to MS Dynamics Axapta.

Created ETL processes to support the implementation of a modern ERP system.

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

Win/Web Developer & Database Developer

First Calgary Financial

November 2005 – June 2007

Led database development for banking conversion projects.

Designed and developed internal banking applications and new system databases.

Performed DBA duties, including backups, recovery, and performance tuning.

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

Database Developer/DBA

RRC

January 2001 – June 2005

Developed new modules and features for Platinum SQL ERP.

Executed database backups, recovery, and performance tuning.

Created DTS packages and OLAP solutions.

Technologies: MS SQL Server, Crystal Reports, T-SQL, DTS (SSIS).

Technical Support Engineer

Epicor Corp

July 1997 – December 2000

Analyzed client databases and provided troubleshooting solutions.

Implemented database maintenance tasks and optimized SQL Server performance.

Supported Platinum SQL ERP systems.

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

Programmer

FutureWare-AMF

July 1996 – June 1997

Developed accounting applications based on the SQL Server platform.

Designed interfaces, test environments, and installation processes.

Technologies: MS SQL Server, Delphi, RDBMS.

Education

Bachelor's Degree in Computer Science

Moscow State Industrial University (MSIU)

1991 – 1996

Diploma in Accounting

Moscow Accounting College

1987 – 1990

Technical Skills

Cloud Platforms: MS Azure, Snowflake.

ETL Tools: SSIS, Pentaho.

Databases: MS SQL Server, Oracle, MySQL.

BI Tools: Power BI, SSRS, SSAS.

Programming: Python, T-SQL, VBA, PL/SQL.

Data Governance: Master Data Management, Kimball Methodology.

Languages

English: Fluent

Russian: Native

Contact this candidate