1) Communication with different level representatives on clients' side, including negotiations and problem solving.2) Leading developer team in the project.3) Participation in hiring process. Interviewing candidates of different levels4) Database architecture. 4.1) Creation of data (cdm, anchor, data vault) architecture from scratch. Both logical and data storage/ETL/ELT instruments.4.2) Architectural support during the project for developers and analysts.5) Participation in project planning.6) Participation in presale activities.Current main project:1) Microsoft tech based DWH (SQL Server, SSIS, SSAS, PBI) ~9 TB-Server sizing-Functional and Technical architecture-Data Vault-Development process (data layers, environments, code versioning etc.)-Monitoring

Main streams of work: support and developement of a team, dwh archetecture, data quality, data governance and communications with business users and steakholders.1) Building and managing corporate data warehouse based on Oracle and MSSQL technologies 2) Migration to new DWH based on Data Vault 2.0 and Anchor model concept (6NF) and MPP Greenplum2) Developing analytical and communication complex based on SAS technology (SAS EG, Campaign management, RTDM)2.1) Launch of scoring system Based on SAS RTDM2.2) Launch of marketing campaigning system baesed on SAS MA3) Number of people in distributed team - 264) Building reporting system using Oracle Business intelligence and MS OLAP5) Transfer of corporate reporting system to Tableau

1) Data warehouse and analytical systems developement2) Building company reporting infrastructure using Oracle BI3) Securing data provision for reporting to regulatory authorities4) Using Agile for the developement (programming) process5) Implementation of "Theory of constraints" for improving department performance

Oracle BI and data warehouse developement.Oracle data integrator, Administration tool.PL/SQLFull-cycle reporting system creation: from normalization of raw data to creation of Oracle BI dashboardsCreating developement documentation (references, transfer guides, etc.)

Data mining, processing and presentationOracle BI: reporting, subject area planningBusiness process analyses ("As is and to be")Mathematical modellingSales forecasting (Direct Insurance and conventional channels)Сlaims settlement analyses, Customer service analysesBusiness modelling

Diploma practice