Otto (GmbH & Co KG)

- Development, providing support and maintenance of the entire reportingsystem in a part of collaborating with delivery services: Russian Post, DHL,SPSR, O-Courier, etc. (creating an interface and forms in MS Access, VBA,writing complex server-side SQL queries). - I gained valuable experience in writing complex SQL queries (Oracle syntax):for the purposes of creating operating and analysis report. - I had an appointment as Software Engineer in the development team thatprovided the internal multifunctional system for administering to the businesswants: designing cross-browser modules (client part: HTML, Java Script,ExtJS, CSS; server part - PHP, Oracle, PL/SQL). During this period I've done: - Implementation a project (development of client and server parts) forautomatic weighing of postal items, including calculation of the delivery rateand printing of postal documents (reports), - in MS Access. - Development and maintain an extensive system for calculating salary in unitsfocused on piece-rate job. - Implementation of an integration with the DHL web-service (within theexisting system) for the transmission and dispatch of shipments, providing thedocuments (and printing them, where appropriate), address labels on thermaltransfer printers through data exchange via the SOAP protocol. - Performing analytical tasks: analysis of business processes, search formutually acceptable business solutions, writing technical specifications. - I gain some experience of HR organization development: softwareimplementation, organization and carrying out of tests. I have the skills: PhotoShop, CorelDRAW: during the student years, I wasengaged in design (web design, creation of logos and corporate identity).Participated in the design of the interface part of the system, became theauthor of the project logo. I am able to solve problems effectively on my own in conditions of fuzzyformulation, I am hardworking, independent, organized, responsible, sociable,curious.

Philip Morris International

- Business analyst of a single data warehouse. Data engineering, Designing the DWH structure, organizing data migrationfrom various sources, developing ETL using CloverETL and Matillion, buildingpipelines based on Kappa Architecture. - Extensive experience in writing complex SQL queries: hierarchical queries,queries using analytical window functions, tuning query performance in Amazon Redshift and MS SQL Server (working with query plans, optimizingthe structure of tables and indexes/keys). - Development of the architecture of the NPS (Net Promoter Score) systemintegration project,close work with AWS: Amazon RedShift, S3, AWS Lambda. - Development and support of current ETL processes (Matillion, CloverDX),integration of data from external systems, integration of web services. - Business analysis, system analysis, development. - Implemented data loading via API connection from the Pardot system to theRedshift storage.Working with Python libraries: pandas, boto3, pypardot4, multiprocessing. - Development of a fully satisfactory algorithm for loading data in contexts strongrestrictions on the number of API requests per day and internal limitations ofthe Pardot system. - Business analysis, working with global business partners in a part ofthe coordination of requirements for the integration of external systems,development a data transfer to internal PMI systems (for loading data fromanalytical agencies), system analysis, development: building ETL processesusing data from internal and external sources. - Creating datamarts for legal and financial departments in Tableau. - Downloading data from the Nielsen analytical agency.Collecting business requirements for reports. - Working with VC systems: GitHub, GitLab, Git Bash, TortoiseGit. - Management experience: coordinating the work of the development team ofexternal contractors.

Sberbank-Technology

Promotion the direction DaaS in Retail Banking Division. Leading a team of 3 engineers (including DevOps and DE). Creating data platform with batch and stream processing. - Migrated old codebase from SSIS to Airflow 2.x.x. - Created full development and delivery processes: * Separate development (local, test, preprod, prod) environments. * CI/CD process on top of Jenkins. * Granulation, planning and task control. - Development Spark and Spark Streaming jobs for creating ETL processes.