Created and Developed Analytics Department in the Company.My team consisted of Data Engineers, Data Analysts, Digital Analysts, BI Developers which covers 1000 project hours and 500 support hours per month. A year ago it was 40 hours per month to build and maintain a marketing report.We managed and developed projects in the following streams:1. HoD & BoD Dashboards- Developing a product - Power BI, which has 100+ users- Developing and Maintaining 10+ Dashboards for Director Board, Sales Directors and Real Estate Team Leaders, Marketing, Customer Service and other departments in the Company.2. DWH Integrations (Development)- Development DWH as a master-system of all data in the company- Configuration data transferring between systems (Leads from Email, Real Estate Portals to CRMs, Leads from CRMs to the Google Analytics, Yandex Metrica, Bing Ads, Facebook)- Setup, development and maintenance ELT, ETL pipelines (2 MySQL Replicas, Property Monitor, Google Analytics, Google Search Console, Google Ads, Yandex Direct, Bing Ads, Snapchat, Facebook, Unisender and etc.)- Setup, development and maintenance CDP (Altcraft)- Data Parsing- Daily monitoring and improving the quality of data from various systems- Introduction and development of Data Governance methods3.Digital Analytics- Setting up the collection of user data from 300+ websites- Provide KPIs for Marketing Teams- Support for the web development and Marketing Teams with insights and improvements4. Product Analysis- Building a metrics system in the company- Building and calculating metrics for product owners- Calculation of quarterly OKRs for Product Team

Led a team of 2 data analysts and 1 data engineer to solve typical problems within large projects.Typical Tasks:1. Digital Analytics:- Implementation of A/B testing for clients with the creation of a registry, definition of metrics, their calculation and determination of statistical significance using Google Sheets and Python.- Setting up a web analytics system such as Google Analytics, Yandex Metrica, Google Tag Manager and Goals using dataLayer, HTML and Javascript.2. Data Visualization:- Development of dashboards in Looker Studio, Power BI, Tableau, Yandex DataStudio, Redash for monitoring and research of key indicators.- Creation of regular automated reporting via email.3. Data Collection and Storage:- Working with databases using SQL: PostgreSQL, Google BigQuery, MySQL, ClickHouse.- Integration with API for developing data pipelines (Google Analytics, Facebook, Google Ads, Yandex Direct, CRM, Altcraft, Criteo, Snapchat, Tiktok).- Created ETL and ELT pipelines for feature engineering of large scale data sets using Apache Airflow.4. Analysis and Recommendations:- Close interaction with APIs for developing data pipelines (Google Analytics, Facebook, Google Ads, Yandex Direct, CRM, Altcraft, Criteo, Snapchat, Tiktok).- Formation of recommendations for improving the site based on the analysis.5. Cloud computing:- Management of cloud computing systems in Google Cloud and Yandex Cloud.- Implementation of analytical solution architectures based on the Google cloud platform and Yandex cloud.

Executed digital analytics tasks involving A/B testing implementation, metric definition, and statistical significance determination using Google Sheets and Python. Proficient in setting up web analytics systems and data visualization through Looker Studio and Power BI. Managed databases (PostgreSQL, Google BigQuery, MySQL, ClickHouse), integrated APIs for data pipelines, and created ETL/ELT pipelines using Apache Airflow. Provided insightful analysis, recommendations, and cloud computing system management in Google Cloud and Yandex Cloud, including implementing analytical solutions.

Projects in the Sphere of Economics, Real Estate and Tourism:Work with 15 projects, including the areas of economics, real estate and tourism.Key Results:- Setting up web analytics, goals and target actions (Yandex.Metrica, GA Universal, GTM) for 15 projects.- Product development with A/B tests and successful implementation in 5 projects using Google Optimize, GTM and web development resources.- Building a report on end-to-end analytics (CRM, costs, website data) in Power BI for an e-commerce project.- Development of a bot for notifications about the budget balance for advertising accounts.- Development of a linear chat bot for discounts, searching for the nearest office and orders for an online store.- Search for hypotheses to increase conversion using web analytics tools.

- Internal and external website optimization - Setting up web analytics (Yandex.Metrika, GA, GTM) - Development, implementation and analytics of A / B tests using GoogleOptimize - Building reports on end-to-end analytics in Power BI - Reporting automation with Google Sheets and Telegram - Competitive analysis and development of page layouts to improve site usability - Development of reports on SEO and contextual advertising in Google DataStudio - Development and implementation of a pop-up system using carrot quest - Search for hypotheses to increase conversions using web analytics tools