Pavel K.

AVO is an online-first bank accessible via smartphone. It achieved impressive results in its first year and sets ambitious goals for the future in Uzbekistan's fintech market.
The Data Warehouse is the bank's central data repository, consolidating all the data the business needs for decision-making: from marketing communication data to optimizing risk assessment models for credit approvals.

- Implemented several analytical solutions from scratch to evaluate the performance of new banking products, enabling stakeholders to make data-driven decisions from day one.
- Took on Data Engineering tasks, effectively reducing development time and accelerating the delivery of new data marts for the product team.
- Implemented an Activity Schema to centralize key user events, which standardized business logic, reduced code duplication, and shortened time-to-market for new product analytics.
- Integrated Data Quality controls into data marts, allowing for faster incident detection and increasing business trust in DWH data.
- Initiated and executed the refactoring and optimization of pipelines for key data marts, improving SLAs and reducing data availability time.

A startup in the e-commerce domain that enables sellers to optimize their operations across marketplaces through automation tools.

- Designed DWH infrastructure and ETL processes for a B2B analytical solution in e-commerce, covering sales, marketing, and inventory reporting.
- Automated financial and management reporting, saving the team approximately 10 hours of manual work weekly.
- Implemented comprehensive analytics for sales, marketing, and inventory management, increasing process transparency and accelerating decision-making.
- Deployed automated quality checks for data incoming from marketplaces to prevent incorrect data from entering the DWH.
- Executed a smooth migration from Looker Studio to an open-source BI tool, enhancing system flexibility and reducing dependency on SaaS providers.

Event Warehouse is a centralized data repository product being developed for Samokat, one of the largest dark-store grocery e-commerce platforms in Europe. It captures user actions and interactions within the mobile app and website, enabling the marketing team to deliver personalized product recommendations, driving higher conversion rates and customer satisfaction.

- Developed a solution to block fraudulent in-app advertising traffic, increasing ROMI by 20% and reducing infrastructure load by 15%.
- Created a solution for updating the actual order size acquired through advertising partners, resulting in a monthly cost reduction of 100K USD for customer acquisition.

Inter RAO Engineering is the Engineering Division of Inter RAO, the largest electricity producer in Russia.

- Reorganized the ad-hoc reporting process by automating data collection, storage, and reuse, ensuring a 98% on-time delivery rate.
- Developed a database and ETL processes from scratch to automate reporting for the Ministry of Energy and the parent company.
- Acted as the key analyst gathering requirements from business stakeholders and translating them into technical specifications for development.