Olga Avtaikina
Sun Prairie,WI
Summary
Senior Data & Strategy Analyst with 10+ years of experience spanning strategy consulting, business development, and business intelligence. Proven track record of leading large-scale strategic initiatives, building data-driven solutions, and translating complex data into actionable business insights. Experienced in financial modeling, M&A, and operational analytics, with strong expertise in Power BI, SQL, and advanced Excel.
Overview
19
19
years of professional experience
Work History
Report Developer 2 / Data Analyst
Modivcare
Denver, Colorado
01.2023 - Current
- Developed and automated dashboards and reporting solutions to support operational performance and business decision-making
- Designed and optimized data models and reporting frameworks, improving data accuracy and scalability
- Managed end-to-end data processes (ETL, validation, visualization)
- Built Power BI dashboards and advanced Excel models to track KPIs and business performance
- Analyzed complex datasets to deliver actionable insights for process improvement
- Troubleshot and enhanced reports and data models, improving reliability and efficiency
- Partnered with stakeholders to translate business requirements into scalable analytics solutions
- Streamlined data pipelines and integrations to improve reporting timeliness
- Developed SQL-based data models and implemented QA validation frameworks to ensure data integrity
Sales Team Support Specialist
Salelytics
Appleton, WI
02.2022 - 01.2023
- Built and optimized Power BI dashboards to improve visibility into sales performance
- Automated reporting using Excel (macros), increasing efficiency and scalability
- Developed financial proformas supporting key client initiatives (including Procter & Gamble)
- Improved data models and reporting frameworks to enhance usability and decision-making
- Analyzed sales data to support strategy and operational improvements
Director of Strategic Projects
United Heavy Machinery, OMZ
Moscow
05.2011 - 11.2020
- Led a 60-person strategy team supporting production operations across a major oil & gas equipment enterprise
- Directed enterprise-wide strategic planning, investment analysis, and business transformation initiatives
- Advised executive leadership on growth strategy, capital investments, and operational performance
- Led M&A initiatives including due diligence, financial modeling, and post-merger integration
- Built financial and valuation models to support strategic decision-making
- Drove cross-functional process improvements, increasing efficiency and alignment across departments
- Presented strategic recommendations to senior stakeholders and influenced key business decisions
Business Development Manager
MTV Russia
Moscow
05.2010 - 05.2011
- Led team development initiatives by training personnel and supporting skill-building to improve overall team performance.
- Identified and implemented cost optimization and business process improvement initiatives, enhancing operational efficiency.
- Designed and implemented company-wide KPI frameworks to align performance with strategic objectives.
- Developed and optimized marketing distribution models to improve reach, audience targeting, and revenue potential.
- Contributed to business growth by identifying opportunities to improve processes, performance, and organizational effectiveness.
- Collaborated with cross-functional teams to implement strategic initiatives and ensure alignment with business goals.
Strategy Consultant
Strategy partners
Moscow
02.2007 - 05.2010
- Supported development of client strategies across growth, market entry, and operational improvement initiatives.
- Conducted structured analysis of business challenges, synthesizing findings into clear strategic recommendations.
- Contributed to defining strategic priorities and identifying high-impact initiatives aligned with client objectives.
- Assisted in evaluating strategic and investment opportunities, including market assessment and business case development.
- Developed presentations and materials for client discussions, communicating insights and recommendations to senior stakeholders.
- Collaborated with client teams and internal stakeholders to align on strategic direction and execution plans.
- Participated in problem-solving sessions to address complex business issues and refine strategic approaches.
- Supported execution planning by translating strategy into actionable initiatives and implementation roadmaps.
- Worked across multiple engagements, delivering high-quality outputs in fast-paced, deadline-driven environments.
Education
Post Graduate Program, Data Science -
Purdue University
09-2022
Master’s Degree in Economics -
Moscow State University
06-2007
Skills
- Presentation skills (10 years)
- SQL, Power BI, Tableau, Domo
- Excel (Advanced, Macros)
- Python, R
- Strategic Planning
- Financial Modeling & Valuation
- Business Process Improvement
- KPI Development
Languages
Timeline
Report Developer 2 / Data Analyst
Modivcare
01.2023 - Current
Sales Team Support Specialist
Salelytics
02.2022 - 01.2023
Director of Strategic Projects
United Heavy Machinery, OMZ
05.2011 - 11.2020
Business Development Manager
MTV Russia
05.2010 - 05.2011
Strategy Consultant
Strategy partners
02.2007 - 05.2010
Post Graduate Program, Data Science -
Purdue University
Master’s Degree in Economics -
Moscow State University