BrainHub, Moscow, Russia
Data Analyst
Participation in a project to transfer part of the corporate data warehouse of Bank from Oracle to a new platform on PostgreSQL.
– Analysis and transformation of existing SQL scripts, writing new queries to generate tables taking into account changed requirements and technical conditions.
– Work with large amounts of data.
– Analysis of ETL processes.
– Studying and maintaining documentation in Confluence
Stack: SQL, Microsoft Excel, Oracle SQL Developer,
Oracle Data Integrator, DBeaver, Confluence
2023 – 2024
1 year 4 months
Innotech, Moscow, Russia
Data Analyst
Joint project of a large bank and a trading network:
– Development of reporting on financial transactions through a mobile application (purchases, returns)
– Working with large amounts of data.
– Ad hoc requests
– Data collection, analysis and statistics (customer segmentation, turnover, average check on a loan, credit cards)
– Maintain documentation in Confluence
Data Quality Management Department
– Data quality management in the reporting system of a large bank
Stack: SQL, Microsoft Excel, Power Query, Power BI, Python, Metabase, DWH, Axon Data Governance, Agile, Scrum, Jira, Confluence
2021 – 2022
1 year 1 months
CheckROI, Moscow, Russia
WEB-Analyst
Job responsibilities:
– work with analytics systems Yandex.Metrika, Google Analytics, Yandex Webmaster, Google Search Console;
– collection and systematization of data on traffic and conversions, evaluation of the effectiveness of traffic sources, identification of problems and search for growth points in various sections and pages of the site;
– research of customer behavior;
– tracking the effectiveness of advertising campaigns;
– preparation of regular reports for management and employees;
– connecting to various data sources, creating data models and setting up reports, dashboards in Power BI;
– consulting employees on obtaining the necessary data in analytics systems and on the use of Power BI reports;
– performing ad-hoc tasks for different departments of the project.
Achievements and results:
– automation of data collection and visualization in Power BI;
– creation of specialized repots to improve the efficiency of the SEO-department
2019 – 2021
2 year 1 months
CheckROI, Moscow, Russia
SEO SpecialistSEO Specialist
– Keyword analysis, expansion and editing of the semantic core;
– Internal optimization of the structure and content of the site;
– Placement of articles and links to articles;
– Optimization of pages and increase in conversions;
– Analysis of competitors promotion strategy
2020 – 2021
10 months
OOO Promtovary, Samara, Russia, Russia
System Administrator
– creation, configuration and maintenance of databases (Microsoft Access);
– automation from scratch of warehouse and trade accounting in shoe stores using the Goods-Money-Goods program, setting up remote access and data exchange, integrating the program with online cash registers, periodically updating software;
– training of personnel, advising sellers on working with the program and equipment remotely
– creating a store website in the Tilda website builder, updating information on the website.
2014 – 2020
6 year 6 months
Skillbox, Moscow, Russia
Annual courses:
Profession – SEO specialist,
Web analytics
2020
Samara, Russia State University of Social Sciences and Education, Samara, Russia, Russia
PSICHOLOGY
1995