Aleksei Ogarkov

Hi, everyone! I'm Aleksei, a Business Intelligence and Revenue Analyst.

I built this website to showcase my experience and skills, and to connect with like-minded professionals for exciting career opportunities, projects, and meaningful collaborations.

For over 10 years, I have held key roles in innovative Fortune 500 companies, driving sales efficiency and building the analytical foundation for the successful launch of 7 blockbuster products and 8 acceleration projects. My expertise includes implementing 3 CRM systems and developing a cutting-edge ML-driven BI platform, which earned me recognition as one of Russia's TOP 40 Digital Experts in 2024.

Explore my CV

What I do

Strategic Alignment

I define business requirements and validate strategic hypotheses through data-driven exploration.

Data Ecosystem

I automate data workflows via APIs, wrangle and structure data from digital channels, and build scalable queries and pipelines.

Data Modeling

I develop predictive models, run marketing mix modeling, and generate forecasts using statistical and machine learning methods.

Actionable Insights

I create dashboards, craft data stories, and deliver insights using Python, advanced analytics, and statistical techniques.

Business Impact

I track KPIs, evaluate promotional effectiveness and ROI, and provide data-based recommendations for continuous improvement.

BI & CRM Systems Enablement

I implement modern data platforms, integrate new sources, and apply cloud-based ML tools to enhance commercial operations.

Commercial Operations Excellence

I support sales and marketing strategy design as a data and digital expert, ensuring measurable business outcomes.

Selected Case Studies

Explore some practical examples of how I apply analytics to solve real business problems.

Customer Value & Retention Intelligence

RFM and Cohort Analysis
powered by PostgreSQL, Python and Power BI

EXPLORE LIVE CASE

Global Insight Engine in Excel

Real-Time Macroeconomic & Digital Readiness Analytics

EXPLORE LIVE CASE

Optimizing Ad Impact: A/B Testing Insights

Tools: NumPy, Pandas, Matplotlib, Seaborn, Scipy, Statsmodels, Scikit-learn, Keras
Key steps:

Cleaned and balanced datasets (outliers removed, groups matched)
Assessed conversion lift via Z-tests, T-tests, and Chi-square tests
Modeled promo vs. control outcomes using a neural network
Uncovered optimal delivery times and exposure levels for maximum impact

Explore Kaggle notebbok

Marketing Campaign Metrics Dashboard in Excel

This Excel dashboard provides insights into campaign performance across multiple channels. The project required using structured advertising data to analyze budget allocations, actual revenue, P&L, and GAP analysis.
Key Features:

Interactive Slicers
Dynamic KPI Metrics
GAP Analysis
Multi-Level Data Views
Custom Data Visualizations
Automated P&L Calculation

Explore the video overview

An interactive marketing analytics dashboard provides real-time insights into campaign performance across multiple channels.

I’m open to new job opportunities, projects, and collaborations — feel free to reach out.
Aleksei Ogarkov

CONTACTS