Summary
Overview
Work History
Education
Skills
Accomplishments
Languages
Awards
Timeline
LAVENDER WANGUI

LAVENDER WANGUI

Nairobi

Summary

Highly analytical and detail-oriented Demand Planner with over 9 years of experience in fast-paced manufacturing beverage and pharmaceutical industry, specializing in demand forecasting and supply chain optimization. Proven track record in achieving exceptional sales forecast accuracy, driving inventory efficiency, and supporting strategic business decisions. Well-versed at leveraging data analytics to forecast trends and align supply with demand. Strong collaboration skills with cross-functional teams, including sales, marketing, and supply chain.

Overview

10
10
years of professional experience

Work History

Demand Planner

Diageo-EABL
09.2022 - Current

· Lead the demand planning process for key product lines, achieving an average forecast accuracy of 95% over the last two years, significantly outperforming industry benchmarks.

· Collaborate with sales, marketing, and supply chain teams to align on demand forecasts, ensuring accurate and timely product availability across all channels.

· Develop and maintain forecasting models that incorporate historical data, market trends, and promotional activities, driving informed decision-making and strategic planning.

· Analyze and report on forecast accuracy metrics, identifying areas for improvement and implementing corrective actions to continually enhance forecast performance.

· Manage the Sales & Operations Execution (S&OE) process, ensuring seamless end-to-end engagement and alignment with the Business & Brand Innovation Center (BBIC).

· Support new product launches by developing accurate demand forecasts, enabling successful market entry and maximizing sales potential.

· Utilize advanced demand planning tools such as SAP APO and Excel to analyze data, generate forecasts, and optimize inventory levels.ols, leading to a 10% increase in forecast accuracy over two years.

Lead Business Demand Planner

mPharma
12.2020 - 08.2022

· Sales Forecast Accuracy: Achieved a consistent sales forecast accuracy rate of over 95%, significantly reducing stockouts and excess inventory.

· Demand Forecasting: Utilized advanced statistical models and historical data to predict demand patterns, ensuring optimal inventory levels for a portfolio of over 400 SKUs across multiple regions.

· Collaboration & Stakeholder Engagement: Worked closely with sales, marketing, and supply chain teams to align demand forecasts with promotional activities and new product launches, resulting in a 20% increase in forecast accuracy.

· Data Analysis: Analyzed market trends, sales data, and consumer behavior to improve demand planning processes, contributing to a 15% reduction in forecast error.

· Inventory Management: Implemented demand-driven inventory planning, reducing obsolete stock by 30% and improving product availability by 25%.

· S&OP Process: Led monthly S&OP meetings to align supply chain operations with business objectives, enhancing decision-making and resource allocation.

· Continuous Improvement: Developed and refined demand planning models and tools, leading to a 10% increase in forecast accuracy over two years.

Planning and Procurement Assistant

Dawa Life Sciences
04.2019 - 11.2020

· Assist in planning and executing procurement strategies to ensure the availability of raw materials and components for pharmaceutical production.

  • Coordinate with suppliers to manage purchase orders, track shipments, and ensure timely delivery of goods to avoid production delays.
  • Monitor inventory levels using ERP systems and work closely with the warehouse team to maintain optimal stock levels, reducing excess inventory by 15%.
  • ·Analyze purchasing data to identify cost-saving opportunities and negotiate favorable terms with suppliers, contributing to a 10% reduction in procurement costs.
  • Collaborate with the production planning team to align procurement activities with production schedules, ensuring the continuous availability of necessary materials.
  • Maintain accurate records of purchase orders, supplier contracts, and inventory reports, ensuring compliance with company policies and industry regulations.
  • Support the procurement manager in vendor evaluation and selection, conducting market research to identify potential new suppliers.
  • Assist in the preparation of procurement and inventory reports for management review, highlighting key metrics and trends.

Assistant Demand Planner

Dawa Life Sciences
07.2014 - 06.2018
  • Developed and advised on demand plans and forecasts in line with organizational goals and related needs as per the assessments
  • Mentored and trained planning officers in the other branches as per organizational guidelines
  • Maintained inventory levels per consumed demand
  • Identified opportunities and other areas for improvement for demand and production planning
  • Provided full support to the planning, logistics, purchase, production and warehouse departments
  • Played an active role in formulation and execution of production and demand plans
  • Assisted in the issuing and documentation of narcotics in the strong room
  • A consistent improved trend in Forecast Accuracy of 98.2% and Forecast Bias of -2%
  • Provided technical planning support leading to an improved portfolio performance and handling the roll out of a new project (Manufacturing Facility).

Education

Master's - Organizational Development

United States International University of Africa
09.2025

Advanced Demand Planning

Diageo Demand Academy
05.2024

Certifications - Business

Havard Business School
06.2022

Bachelor of Economics and Finance - Economics

Kenyatta University
12.2013

Kenya Certificate of Secondary Education - undefined

Mugoiri Girls High School
11.2009

Skills

  • Data Interpretation
  • Scenario Planning
  • Business Needs Analysis
  • Sales Forecasting
  • Data Visualization
  • Trend forecasting
  • Data Collection
  • Team building
  • Interpersonal Skills
  • Effective Communication
  • Microsoft Office
  • Decision-Making
  • Industry Trends
  • Time Management
  • Team Leadership
  • Analytical Skills
  • Reliability
  • Self Motivation
  • Organizational Skills
  • Adaptability and Flexibility

Accomplishments

    Key Achievements:

  • Played a key role in improving the on-time delivery rate of materials by 20% through proactive supplier management and effective communication.
  • Contributed to a successful audit of procurement processes, ensuring compliance with industry standards and regulatory requirements.
  • Implemented a streamlined process for tracking and reporting purchase orders, reducing administrative workload by 25%.

Languages

English
Swahili
French

Awards

  • Employee of the Year-2017
  • Hero of the Month -April 2023

Timeline

Demand Planner - Diageo-EABL
09.2022 - Current
Lead Business Demand Planner - mPharma
12.2020 - 08.2022
Planning and Procurement Assistant - Dawa Life Sciences
04.2019 - 11.2020
Assistant Demand Planner - Dawa Life Sciences
07.2014 - 06.2018
Havard Business School - Certifications, Business
Kenyatta University - Bachelor of Economics and Finance, Economics
Mugoiri Girls High School - Kenya Certificate of Secondary Education,
United States International University of Africa - Master's, Organizational Development
Diageo Demand Academy - , Advanced Demand Planning
LAVENDER WANGUI