Experience

Банк ВТБ

• Banking
• 200 - 300 Employee

• System Analyst

  • May 2022 - Present

  Collection and analysis of requirements; Development of test scenarios and participation in testing processes; Interaction with developers, architects, and business customers; Writing scripts and maintaining documentation. Collection and analysis of requirements; Development of test scenarios and participation in testing processes; Interaction with developers, architects, and business customers; Writing scripts and maintaining documentation.



ООО "МедиаПоинт"

• System Analyst

  • Jun 2021 - Jan 2022

  Drew up reports using various databases such as Clickhouse, Postgres, and MySQL. Automated reporting using Python (Jupyter). Handled ad-hoc requests from colleagues. Prepared data for modeling. Drew up reports using various databases such as Clickhouse, Postgres, and MySQL. Automated reporting using Python (Jupyter). Handled ad-hoc requests from colleagues. Prepared data for modeling.



CG Innotech

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

• Data Engineer

  • Feb 2021 - Jun 2021

  Contributed to the development of a platform that monitored and scored business models, working closely with a team of developers to ensure a smooth rollout. Added impactful visual elements such as graphs and tables to Plotly Dash, improving the platform's usability and user experience. Worked with big data tools such as Hadoop, Hive, and PySpark, leveraging their power to optimize data processing, storage, and analysis. Specifically, I created data processing pipelines using PySpark and optimized data storage using Hive, resulting in faster and more efficient workflows. Show less



ABBYY

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Business Intelligence Analyst

  • Dec 2019 - Feb 2021

  Designed and developed interactive PowerBI reports and dashboards that provided valuable insights into marketing performance. Created dataflows and streaming datasets to keep the data up to date and accurate. Built an MSSQL storage for historical data of the marketing system (Marketo), with a volume of 30 GB. Optimized the storage design to reduce query times and ensure scalability. Developed ETL processes in Python and PowerShell using requests, pypyodbc, sqlalchemy libraries, etc., to clean, transform, and load large volumes of data into the MSSQL storage. Optimized the ETL processes for speed and accuracy, resulting in improved data quality and reduced manual errors. Worked with the API of Marketo, Salesforce, and other systems, integrating marketing and sales data to provide a holistic view of the customer journey. Built end-to-end analytics for Marketo, from first touch to opportunity. Leveraged the power of PowerBI and MSSQL to create insightful visualizations that helped the marketing team understand and optimize their campaigns. Show less



Innova Co. SARL

• Люксембург

• Project Business Analyst

  • Jan 2019 - Dec 2019

  Monitoring and analysis of the main KPIs of the project. Analysis of the effectiveness of marketing events. Analysis of in-game events, work with game logs. Presentation of research results. Administration of project reporting and data visualization. Creating PowerBI reports using stored procedures. Making changes to existing ETL processes in dwh to collect the necessary information from linked servers. SQL: writing complex queries (parsing string values, recursion, window functions, data transposition and normalization), developing/maintaining stored procedures in T-SQL. Python: development of a tool for automating routine tasks (ad-hoc requests), solving computational problems. Data visualization in plotly. Analytics: building funnels to find the moment of user abandonment. Building a predictive model of revenue by cohorts for 1 year ahead. Predicting the likelihood of dropping users using ML. Other: During the period of familiarization with the product (the first 2 weeks) - play the game, respond to applications (tickets) from the players. On a regular basis (routine tasks): Summing up the results of in-game events. Accrual of items in the game (automated daily on stored procedures). Evaluation of the nature of historical data, mapping mapping to prepare data for machine learning. Show less