Nancy

Nancy

$10/hr
Senior Data and Business Analyst
Reply rate:
100.0%
Availability:
Full-time (40 hrs/wk)
Location:
Cairo, Cairo, Egypt
Experience:
7 years
Nancy Maher Senior Business & Data Analyst | 6+ Yrs in FMCG & Tech | S&OP • Workflow Automation • Market Expansion SUMMARY Business & Strategy Analyst | FMCG & Tech | 6+ Years Experience Strategic-minded Business & Data Analyst with 6+ years of experience translating data into high-impact decisions for global leaders like PepsiCo and Ureed. I specialize in building automated workflows, designing intelligent dashboards, and aligning operations with growth strategies across MENA markets. From launching national FMCG programs to revamping master data pipelines, my work has saved hundreds of hours and driven measurable performance improvements. I thrive at the intersection of analytics, strategy, and cross-functional collaboration—whether it’s forecasting sales, optimizing exports, or coaching teams to exceed KPIs. I’m passionate about using data not just to inform, but to transform. PROFESSIONAL EXPERIENCE PepsiCo Egypt Dec 2021 – Jun 2025 Promoted twice within 3 years in recognition of high-impact project delivery, cross-market planning, and automation initiatives. Senior Sales Operations & Capability Planning Analyst Dec 2024 — Mar 2025 PepsiCo Egypt Cairo, Egypt • Spearheaded capability planning within the Sales Ops team, delivering data-informed training initiatives that improved execution KPIs by 25% across 1,000+ field personnel. • Standardized the “Perfect Store” execution framework, enhancing visibility, compliance, and performance consistency across key trade channels. • Contributed to national Front-Line Mapping by deploying a tiering model that optimized resource allocation, internal mobility, and performance tracking. • Collaborated with field and data teams to refine Salesforce input processes, reducing data entry errors by 40% and improving reporting accuracy. • Acted as an operational enabler, aligning sales capability initiatives with commercial priorities and reinforcing behaviors through targeted field coaching. Senior Commercial and Franchise Analyst – Beverages Jun 2023 — Nov 2024 PepsiCo Egypt Cairo, Egypt • Led S&OP planning, Rolling Forecasts, and 2024 COOP agreement by analyzing 5-year trends, aligning targets and budgets with strategic goals. • Conducted growth simulations and scenario planning for Saudi Arabia, supporting regulatory transitions and market entry strategy. • Oversaw budget tracking for three franchise bottlers, ensuring financial accuracy, data pipelining and compliance. • Automated ETL pipelines for export reporting across the GCC, saving 170+ hours annually resulting in 75% faster reporting cycles and improved data accuracy. • Designed Machine learning powered performance dashboards, reducing manual analysis by 75% and enabling proactive course corrections. Senior Sales Analyst– Snacks Dec 2021 — May 2023 PepsiCo Egypt Cairo, Egypt • Built automated workflows in SAP-GTM to track trade credit notes, saving 696+ hours annually. • Co-developed sales target automation engine with PwC and IT, reducing manual planning time by 60%. • Created interactive dashboards to track regional inventory forecasts, field sales execution, and discount consumption. • Managed quarterly trade budget alignment with Finance, ensuring cost accuracy and risk mitigation. Ureed.com Jun 2020 – Apr 2023 Transitioned to a strategic consulting role after full-time success—recognized for driving platform engagement, operational redesign, and cross-functional alignment. Business Operations Specialist – (Part-Time) Dec 2021 — Apr 2023 Ureed.com Dubai, United Arab Emirates (Remote) Part-time, remote role conducted alongside full-time position at PepsiCo • Managed 300+ operational delivery projects, supporting high-value clients with customized workflows. • Identified process inefficiencies and redesigned handoffs, improving delivery SLAs by 30%. • Worked cross-functionally with tech and marketing to align data reporting with strategic KPIs. Business Operations Specialist (Full-Time) Jun 2020 — Nov 2021 Ureed.com Dubai, United Arab Emirates (Remote) • Prepared and maintained performance analytics for the marketplace, driving a 36% increase in platform engagement. • Leveraged platform data to increase freelancer engagement by 36% and expand verified talent pool by 120%. • Conducted root cause analysis on approval delays and revamped onboarding criteria, boosting approval quality by 60%. • Developed reporting dashboards that tracked project completion times, freelancer conversion rates, and satisfaction scores. AIESEC Egypt Nov 2016 – May 2020 Promoted to full-time national leadership role after 3 years of high-performance volunteering—recognized for driving strategic growth, coaching excellence, and operational execution. National Program Head – NGOs Sector Mar 2019 — May 2020 AIESEC Egypt Cairo, Egypt • Led 18 university chapters to achieve 30% YoY growth in NGO placements by implementing national program strategy. • Built quality control frameworks that improved program feedback scores by 20%. • Conducted national coaching sessions and performance reviews to boost team alignment and delivery. EDUCATION Bachelors in Business Administration, Cairo University 2016 - 2020 SKILLS **Analytics & Strategy: ** Data Analysis | Data Visualization | Statistical Analysis & Forecasting | Process Optimization | Workflow Automation | Data Pipeline | Data Governance **Tools & Tech: ** Power BI | SQL | Microsoft Excel (advanced) | Microsoft Word | Microsoft PowerPoint | SAP **Finance & Planning: ** Financial & Business Analysis | Budget management | Sales & Operations Planning (S&OP) **Project & People: ** Performance Management | Crisis Management | Stakeholder Management **Soft Skills: ** Problem-Solving | Critical Thinking | Communication Skills | operating models | Strategic Planning IMPACT HIGHLIGHTS • • • • Led national training rollout for 1,000+ sales reps, raising execution scores by 25% Executed capability programs and successfully rolled out the Perfect Store initiative across Egypt. Automated reporting systems saving 170+ hours annually across 3 regional markets Streamlined export and credit note reporting, increasing accuracy and improving data reliability. Achieved a 36% increase in platform engagement. Designed performance analytics at Ureed.com that boosted user interaction and improved profile quality. Enabled 30% Year-over-Year Growth in NGO Program Designed national strategies at AIESEC Egypt, coaching university teams to drive program performance. SELECTED PROJECTS • • • • Master Data Revamp – KSA, Yemen & Jordan Standardized master data structures across 3 MENA markets, improving reporting accuracy and forecasting reliability. Export Reporting Automation – GCC, NEA, EMA Built automated pipelines to streamline export reporting, saving 174+ hours annually and enhancing SLA compliance. Annual Operating Plan (AOP) Redesign – KSA Market Led workshops with franchise leads to restructure performance metrics, aligning financial targets with market conditions. COOP Agreement Planning – MENA Region Conducted multi-year data analysis to support budget alignment and performance-based planning across franchise partners. VOLUNTEERING • • • • • • Local Committee Vice President – Incoming Global Volunteer Program AIESEC Cairo University Human Resources Trainee Vodafone Member of University Relations Student Council of Cairo University Nov 2016 - Feb 2019 Jun 2017 - Aug 2017 Oct 2016 -Sep 2017
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.