Профессиональные навыки
Опыт работы
Our mission is to make games that grownups love to play
Data team lead
Октябрь 2018 — Декабрь 2019 (1 год и 3 месяца)

Responsibilities:

- Usage of Azure stack (Data Factory, Data Lake Analytics, Azure Functions, Stream Analytics, etc.) for the new ETLs processes;

- Cross-trainings within the team;

- Implementation of Agile workflow;

- Leading Data team: strategy, team coordination, RnD, technological stack, etc.

Personal results:

- Led creation of data pipeline for the company analytics;

- Created data pipelines for the interactive sports visualizations;

- Create ETL for the advertisement bidding information.

Technologies:

- SQL Server

- Application Insights

- Azure Data Factory

- Azure Data Lake Analytics

- SQL Server Integration Services

- C#

IT Department Team Lead
Июнь 2017 — Октябрь 2018 (1 год и 5 месяцев)

Responsibilities:

- Leading the IT team and Data team;

- Corporate website development;

- Usage of the Azure data processing stack (ADLA, ADF) for processing of semi-structured information;

- Organization of more streamlined work of the teams;

- Planning of the IT department’s year budget;

- GDPR related consulting for the other departments.

Personal results:

- Conducted infrastructure migration into another data center;

- As a product owner, increased the website’s revenue 5 times;

- Created ETL for financial data in the scope of switching clients to the Self-serve model.

Technologies:

- SQL Server

- C#

- PowerShell

- Azure Data Lake Analytics

- SQL Server Integration Services

Senior Database Developer
Апрель 2015 — Июнь 2017 (2 года и 3 месяца)

Responsibilities:

  • SQL Server and database performance tuning, data backups, development of new functionality, preparation of the ETLs for the analytical data;

  • Multiple minor data integrations;

  • Development of the comprehensive mapping between various inconsistent data sources such as analytical identifiers, products metadata, revenue, and financial data;

  • ETL to fetch thousands of reports from Google Analytics in an effective manner;

  • Data fetch optimization for the Qlikview backend;

  • A solution to convert a set of JSON documents with drifting schema into a relational structure for the analytical needs. 

Personal results:

  • Optimized ETL for the application with the billions of events;

  • Created application to process reports data from the configurable arbitrary sources;

  • Created ETL to fetch data from the thousands of Google Analytics accounts in the effective, multi-thread manner;

  • Developed a complicated method of matching data from various sources based on different data attributes in order to provide the analytical team with the connections between analytical, financial, sales and products data;

  • Maintained and continued development of the product databases;

  • Development migration procedure to assist the Content Management team to migrate products to the newer versions. It saved a week of manual work for each migration.

Technologies: 

  • SQL Server

  • C#

  • QlikView

WSM International
Севастополь
Software Development Lead
Август 2012 — Март 2015 (2 года и 8 месяцев)

Responsibilities:

  • Management of the software development team (5 to 10 members) including tasks-assignment, coaching, project planning, reporting, etc.;

  • The main goal was to organize productive business processes and efficient communication with the other teams. 

Personal results:

  • Managed to increase overall developers’ performance for more than 40%;

  • Made reporting more transparent and consistent;

  • Led several data migrations and data restoration projects.

Technologies: 

  • PHP

  • MySQL

  • PostgreSQL

  • SQL Server

  • C#

Data Engineer
Октябрь 2011 — Август 2012 (11 месяцев)

Responsibilities:

  • Design and implementation of the data transfer between e-commerce systems;

  • Reverse-engineering of the e-shops data structures and flows.  

Personal results:

  • Creation of the ETL system allowing data transfer between two arbitrary e-commerce systems​.

Technologies: 

  • MySQL

  • PHP

eMoo Ltd
Севастополь
Database Developer, Quality Assurance Engineer
Март 2010 — Сентябрь 2011 (1 год и 7 месяцев)

Responsibilities:

  • Database performance tuning 

  • Development of new functionality on the DB side;

  • Automation of website testing. 

Personal results: 

  • Significantly improved performance of the ETL processes and heavily loaded stored procedures;

  • Implemented strong QA processes leading to stable releases​. 

Technologies: 

  • SQL Server

  • C#

  • Selenium

  • JMeter

Разработка программного обеспечения и аутстаффинг
Севастополь
Data Engineer
Июль 2003 — Февраль 2010 (6 лет и 8 месяцев)

Responsibilities:

  • Development of the ETLs to process significant amounts of consumers’ data (hundreds of millions of records). 

Personal results:

  • Obtained in-depth skills on SQL Server stack, data analysis, code review;

  • Shaped team play, diplomatic and communication skills;

  • Created an instrument for the SQL index autogeneration and tuning based on the actual data;

  • Created a set of tools to automate repetitive tasks;

  • Created an ETL to process changes in US phones database on a daily basis, fitting in a short timeframe;

  • Got experience in training other team members.

Technologies: 

  • SQL Server

  • Data Transformation Services, SQL Server Integration Services

  • FoxPro

  • VBScript

  • C#

Высшее образование
Севастопольский национальный технический университет
Севастополь
Факультет: Автоматики и вычислительной техники; АВТ
Сентябрь 2000—Сентябрь 2005 (5 лет)