Mikhail Sterkhov Email & Phone Number

Tbilisi, Georgia

- Leading a team of 7 people (Data/BI engineers): onboarding, planning and resource allocation, team development- Managing the team's roadmap- Identifying and structuring business needs in DWH/BI solutions- Implementing and promoting Superset as the main BI and self-BI solution- Managing the developing and evolving the services for analysts to build complete Data Platform in company- Managing the creating, supporting, and optimizing processes connected with financial dashboards for top management

- Development of ETL processes (airflow) for loading data from various sources (relational databases, json, csv, kafka) into hadoop- Data marts development for further visualization and analysts using- Development and support of BI dashboards based on QlikView, Highcharts and custom web for more than 300 users - Development of a service that automates analysts data pipelines- Development collecting data processes from various marketing APIs: Mediascope, Appanie, Trackings, etc. - Building a work process with other analytical business unitsMain achievements:- Provided the main company marketing departments with statistics of services developed in the company, based on data from Mediascope and Appanie- Developed a service that allows to automate data pipelines for more than 10 analysts

Москва, Россия

Moscow, Russian Federation

● Developing data warehouse (several tens TB volume) using MS SQL Server● Developing and optimizing extract, transform and load (ETL) processes using MS SQL Server Integration Services● Developing and optimizing OLAP-cubes using MS SQL Server Analysis Services● Refactoring data warehouse (with compression, column indexes and partitioning technologies)● Administrating analytical portal on Tableau Server● Planning sprints (Scrum) of the project of developing analytical system● Documenting data warehouse objects● Holding meetings with service consumers: setting tasks, solving current problems, defining system requirements● Helping analysts with SQL-queries, data preparation and analysisAchievements:● Data warehouse and analytical system performance was increased 1,5 times on average● I developed ETL monitoring system, which increased system reliability and data quality, also reduced time for finding and correcting errors● More than 70 reports for at least 200 users were developed● I changed data warehouse architecture, so that the volume of store data reduced up to 5 times● I received the award “Guru of digits and data” in internal quarter competition “Moment of truth”

Moscow, Russian Federation

Responsibilities:● Developing OLAP-cubes using MS SQL Server Analysis Services● Developing reports using MS SQL Server Reporting Services● Developing geodata quality system using Data Quality Services● Developing data models and reports using IBM Cognos 10.2● Documenting data warehouse objects (database, ETL processes, data models)● Meeting clients and analysts to discuss technical requirementsAchievements:● Participation in 3 large projects as BI developer: for the Russian top-30 bank, for the Russian top-3 telecommunication company and the large transport company● In one of the projects I implemented version control system using Git Tortoise, increasing speed and quality of developing the analytical system

Moscow, Russian Federation

Responsibilities:● Implementing budgeting and reporting system● Integrating data warehouse with different accounting systems (1C, CRM, IBM Cognos TM1)● Developing data model and reports using IBM Cognos 10.2● Documenting data warehouse (database, ETL processes, report data models), developing re-quirements specification and system design● Instructing users in working with the new system ● Writing user manuals● Meeting with clients and analysts to discuss technical requirementsAchievements:● Participation in 6 BI system implementation projects as BI developer● I have grown from the intern to the developer in 8 months● I studied and got the certificate «IBM Cognos BI 10 Certified Administrator»

Master Degree, Business Informatics

Bachelor Degree, Business Informatics