– Create regular reports for the purposes of warehouse defects department (creating solution’s architecture with back-end, front-end and DB (OLTP) colleagues)– Create (and optimize) queries of varying complexity using window functions, various Clickhouse functions, CTEs, subqueries and create tables using various engines (ReplacingMergeTree, AggregatingMergeTree, etc.)– Prepare custom SQLfluff rules to implement as a CI/CD process– Develop an alert system for various cases (RAM usage in database, hanging database queries, DAG failure and recovery (Airflow), etc.)– Design and implement a system to find defect generators based on analysis of goods movements through various parties (supplier, warehouse employees, logistics, pick-up points)– Detected a fraud case in the warehouse and prepared a report to monitor that case. Conducted interview with warehouse staff for other possible cases

– Conducted interviews with company departments to develop and create dashboards– Created of dashboards for data visualization in Metabase– Prepared applications in HEX notebook for company partners– Prepared a tool for conducting experiments in pricing by interacting with the services of the development team– Prepared a tool for finding anomalies with support for multiple metrics– Developed and implemented ETL processes for data extraction, transformation and loading (using DBT, HEX notebook)– Collected data from various sources to prepare reports for various departments– Wrote complex queries to databases using window functions, subqueries, CASE WHEN and various types of joins (Clickhouse, MySQL)– Automated the notification system for business users (SQL -> Python -> Slack)– Automated regular reports using crontab (SQL -> Python -> Slack)

• Preparing reports using PowerBI,• Writing queries of varying complexity to the database to get the necessary information using window functions, subqueries, CASE WHEN (PostgreSQL),• Conducting interviews with company departments to build dashboards and their further building (Apache Superset),• Automation of the notification system for business users (SQL -> Python -> Discord),• Automation of regular reports with crontab (SQL -> Python -> Discord).

• Automation of reports (with crontab), • Processing and analysis of data, visualization using the Python libraries (pandas, NumPy, matplotlib, seaborn).

• Automation of business processes (for instance, automatic collection of information from the website of a government authority using Python libraries - selenium, bf4, requests),• Conducting internal audits of companies from the automotive and FMCG sectors (MS Excel).

Project No1. Conducting data analysis to calculate environmental fee (collection of necessary information and preparation of data in Excel (files up to 50,000 lines, providing analysis based on calculations and processing).Description: This project is carried out 1 time a year for a month. As part of the project, my colleague and I collected and processed data for 7-10 clients. Project No2. Conducting comparative market research and preparation of transfer pricing documentation (processing of financial data to confirm the marketability of prices in transactions with related parties) for clients from various sectors of the economy.Description: Within these projects, I searched companies similar to the analyzed company to compare their market profitability. Project No3. Development of a mechanism for calculating fines and penalties on corporate income tax using MS Excel functions.Description: Initially, it was created for the purpose of calculating tax risks within a specific project (prepared in less than a day), but later my method was used by my colleagues.