Open to opportunities

Ekaterina Rogova

@ekaterinarogova

Message

I turn retail and delivery data into measurable pricing, delivery, and customer-growth outcomes.

Brazil

Message

What I'm looking for

I'm seeking a fully remote Senior Data Analyst or Business Analyst role with a US-based or international team, where I can turn complex data into measurable business impact across KPIs, pricing, delivery, and customer experience.

At Leroy Merlin, I developed a customer-delivery KPI system and P&L analysis that reduced delivery subsidies by 30% without harming other KPIs. I also designed A/B tests, built Power BI and Tableau dashboards, and improved customer delivery processes with SQL and Python.

I've translated stakeholder requirements into technical specifications for BI reports and data marts, while creating a Power Query transformation tool that doubled analytical process speed through team training.

At Avon, I led campaign planning through final presentations to the General Manager, implemented a pricing strategy that increased makeup-category value by 14%, and saved $1.1M through excess-stock management. I was promoted from Senior Marketing Analyst to Omnichannel Leader.

Earlier, I built pricing, discounting, forecasting, stock-allocation, and online-store sales models across Zolla and Mercury TSUM, including a 90%-accurate online sales forecast.

Experience

Work history, roles, and key accomplishments

Senior Performance Analyst

SkillStaff

Jan 2022 - Jan 2025 (3 years)

Developed and implemented KPI system for customer delivery and conducted detailed P&L analysis, resulting in 30% reduction in delivery subsidy. Designed and executed A/B tests to optimize user experience and increase conversion rates.

SQL Python Power BI Tableau Power Query A B Testing KPI Analysis P&L Analysis

Senior Marketing Analyst

Avon

Jan 2019 - Jan 2022 (3 years)

Led full campaign planning cycle from quarterly planning to final results presented to General Manager. Developed and implemented pricing strategy that delivered 14% increase in value for the make-up category.

SQL Tableau Nielsen Euromonitor Pricing Strategy Campaign Planning

Product Analyst

Zolla

Jan 2018 - Jan 2019 (1 year)

Built clear and understandable process for pricing and discounts management that reduced excess stock and prevented storage collapses. Prepared sales forecasting models, stock allocation projects and ad-hoc reports.

SQL Python Sales Forecasting

Financial Analyst

Mercury TSUM

Jan 2015 - Jan 2018 (3 years)

Developed sales forecast model for online store with 90% accuracy and analyzed business processes for further optimization. Captured, aggregated and transformed complex data into meaningful reports for management team.

Data Analysis Forecasting Reporting