DMITRII NOVIKOV

• Creation of web analytics system (FastAPI, RabbitMQ, ClickHouse, Superset)
• Development of streaming and batch ETL scripts (Python, Airflow, ClickHouse).
• Data warehouse modeling (Snow scheme)
• Database administration (ClickHouse, Postgres)

Over the course of the job, created a data warehouse for the company, wrote ETL and implemented reporting. With the help of the implemented solutions, the company was able to abandon the Amplitude service in favor of its own solution.

Project work on creation of the system of system of data collection and processing of data coming from web servers. All infrastructures were deployed and ETL for data processing was written.

• Development of streaming and batch ETL scripts (Python, ClickHouse, Airflow)
• DevOps of analytical infostructure (ClickHouse, Postgres, JupyterHub, Airflow, and Superset, Docker, Ansible)
• Data warehouse modeling

A data warehouse was created for a B2B food delivery branch, from scratch. Wrote ETL scripts and implemented a microservice architecture system to share data with other teams. Created a warehouse model and described all processes in Jira. Together with the analytics team, developed and implemented a food ranking model for the delivery app.

• Automate reporting and dashboard preparation (ClickHouse, PG, MSSQL, MYSQL, Superset)
• Analyzing the market of game applications, preparing calculators for estimating revenue from new projects
• Daily tasks to evaluate the effectiveness of in-game events
• User churn and revenue forecasting.
• ETL script development (Python)

Over the course of the work, a revenue forecasting model has been created. Together with the team, we completely overhauled ETL and the analytical reporting system.

• Automate reporting and dashboard preparation (MSSQL, Power BI, R-language)
• Developing traffic acquisition strategies in conjunction with the marketing team
• User churn forecasting

During the period of work, Power BI was implemented, reporting was automated and traffic purchasing was optimised.

• Development of medium complexity websites and landing pages (BitrixCRM, Wordpress, PHP, JavaScript, HTML, CSS - example of work bania-msk.ru)
• Automating the purchase of advertising in Google Ads and Yandex Direct services
• Setting up analytics systems and automating reporting