Experience

Litres

• Russian Federation
• Technology, Information and Internet
• 100 - 200 Employee

• Data Architect

  • May 2023 - Present

  • Developed architecture and structure of data warehouse. Selected software stack for whole solution (Data capturing, ETL, databases, BI) • Gathered business requirements, defined main metrics and dimensions. • Developed and agreed roadmap with main stakeholders • Developed data model of data warehouse, analyzed data sources, source systems and business processes • Developed architecture and structure of data warehouse. Selected software stack for whole solution (Data capturing, ETL, databases, BI) • Gathered business requirements, defined main metrics and dimensions. • Developed and agreed roadmap with main stakeholders • Developed data model of data warehouse, analyzed data sources, source systems and business processes



Stenn Technologies

• United Kingdom
• Technology, Information and Internet
• 100 - 200 Employee

• Data Architect

  • May 2022 - May 2023

  • Developed the reporting and analytics system strategy, formed the roadmap • Managed the team of 4 people (analysts and ETL developers) in terms of implementing data loading tasks (Azure Data Factory), filling data warehouse (MS SQL Server), BI datasets/reports in PowerBI and uploading to external systems (Azure Data Factory) • Analyzed business requirements, coordinated the implementation methods • Designed and developed prototypes of data models, BI datasets, reports • Set tasks for analysts and ETL developers • Сompared stack options and selected the optimal set of tools that led to creating the single BI business model used as a base for KPI reporting and datasets for ad-hoc users analytics. Show less



Ramax International

• Moscow, Russia

• Head of DWH&BI Department

  • Apr 2017 - Apr 2022

  • Guided analysts and ETL developers in projects for the development of data warehouses, subject areas and BI reports • Developed architectural solutions for loading data into the Storage and visualization in Oracle BI • Analyzed business requirements and data in source systems to load data into the Warehouse and visualized them • Created technical specifications and project documents for ETL and BI development • Developed reports and a repository on Oracle BI • Analyzed aviation business processes and booking systems (Saber GDS) • Developed architectural solutions in the project for the implementation of a data management system (Data Governance) based on the IBM Infosphere Information Server/IBM CloudPAK platform • Drove the BI implementation project in an aviation company, which allowed the business to reduce the reporting time and get ad-hoc analytics tools. • Led the project of implemention a data management system in the bank, which made it possible to build correct reporting to the regulator and reduce the reserve rate by switching to the latest risk assessment models Show less



Aeroflot Bonus Loyalty Program

• Moscow, Russia

• Analysis Team Lead

  • May 2013 - Jul 2017

  • Developed Oracle BI and database reports • Developed and approved of a methodology for calculating the loyalty program KPIs • Set requirements for the implementation of reports on key indicators of the loyalty program • Set requirements for the completion of the Data Warehouse, Oracle BI reporting system • Developed segmentation of loyalty program participants • Set up, run and reported on targeted email campaigns in the Siebel Marketing communications management system • Developed the efficiency assessment methodology for targeted campaigns • Set and monitored the implementation of requirements for finalizing the Siebel Marketing communications management system • Set requirements for the Siebel Loyalty loyalty system and integration with other company systems • Analyzed existing processes for points recording in the loyalty program • Developed the methodology and economic model for the loyalty program points recording system • Developed economic models for the payback of projects Developed functional requirements for the implementation of additional functionality Show less



Fast Lane Ventures

• Russian Federation
• Venture Capital and Private Equity Principals
• 1 - 100 Employee

• Senior Database Analyst

  • Mar 2012 - May 2013

  • Drove the automation of loading data from various operational sources (MySQL, PostgreSQL, Mongo) using MS Integration Services • Developed, supported and refined data warehouses in MS SQL SERVER • Developed operational and analytical reporting in MS Reporting Services • Developed the client base segmentation • Provided analytical support for projects • Drove the automation of loading data from various operational sources (MySQL, PostgreSQL, Mongo) using MS Integration Services • Developed, supported and refined data warehouses in MS SQL SERVER • Developed operational and analytical reporting in MS Reporting Services • Developed the client base segmentation • Provided analytical support for projects