Experience

Agro.Club

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Data Engineering Team Lead

  • Oct 2021 - Nov 2022

  Hiring and managing DWH team from scratch Building ETL pipelines from various sources (MongoDB, Postgres, API) into the Data Warehouse using Airflow Designing and engineering Data Warehouse architecture via Data Vault Development of data synchronization system with partner ERP systems and PostgreSQL backend database Used Python 3, SQL, Airflow, Postgres, dbt, kafka, debezium

• Senior Data Engineer

  • May 2021 - Sep 2021

  Organization of raw data delivery to the analytical database. Generation time of business reports accelerated from 1.5 hours to 1-2 seconds Used python 3, Kafka, Debezium



Ситимобил | Citymobil

• Russian Federation
• IT Services and IT Consulting
• 100 - 200 Employee

• Senior Data Engineer

  • Sep 2020 - Sep 2021

  Building ETL pipelines from different sources (MySQL, Clickhouse, Kafka API) into the Data Warehouse using Airflow Architectural design and development of a set of airflow statements to populate a detailed data layer in DWH via DataVault with raw data fetched from Clickhouse Used python 3, Airflow, Clickhouse, Exasol

• Senior System Analyst DWH

  • Oct 2019 - Aug 2020

  Creating a logical data model for Citymobil from scratch Reduced the time from task creation to reporting to production from 3 weeks to 1 week Used Clickhouse, Exasol



Mail.Ru Group

• Russian Federation
• Software Development
• 700 & Above Employee

• System Analyst DWH

  • Dec 2018 - Oct 2019

  Created a DWH data model for Delivery Club Creating an ecommerse mail.ru group user portrait reports in Tableau Support for spark scripts Created a DWH data model for Delivery Club Creating an ecommerse mail.ru group user portrait reports in Tableau Support for spark scripts



Tinkoff Bank

• System Analyst DWH

  • Nov 2018 - Nov 2018

• Junior System Analyst DWH

  • Oct 2017 - Oct 2018

  Designed integration to receive checks from the national payment card system Designed and prototyped Data Model and Data Marts using Data Vault architecture via SAP PowerDesigner. Worked with DBMS GreenPlum and Vertica, ETL-instruments SAS DIS and Informatica PC, BI-instruments SAS EG, SAP BO, Zeppelin. BRD and FSD writing.

• SQL Researcher Developer DWH

  • Aug 2017 - Aug 2017

GlowByte Consulting
• Russian Federation
• IT Services and IT Consulting
• 500 - 600 Employee
• Junior System Analyst DWH

  • Aug 2015 - Oct 2015