Wilkister Mbaka

• Run weekly demand-and-supply planning across all five markets, realigning each weeks dispatch against stock-in
shop, expected sales and warehouse availability, and leading the weekly (Monday) planning review.
• Plan around holidays and seasonal peaks, signal production to scale output ahead of anticipated demand, and
make daily production adjustments in response to sudden demand shifts.
• Track warehouse stock availability with sourcing and escalate likely supply gaps to management with
recommended mitigations.
Kenya Distribution & Product Lifecycle
• Own end-to-end stock distribution for the Kenya market across 136 retail shops and multiple channels (upgrades,
new-customer acquisition and refurbished devices), balancing allocation to prevent over- and under-stocking, and
producing the weekly dispatch plan that feeds production-line scheduling.
• Respond to all shop-level stock requests, prioritising peak sales periods, and size replenishment to each shops
delivery lead time, ensuring remote shops on 2 to 7 day windows hold sufficient cover. Requests are driven by
new-agent and group (chama) sign-ups and local demand spikes.
• Incorporate promotions, price changes and market disruptions into plans; manage inputs for new product
launches and coordinate end-of-life (EOL) transitions and replacement devices.
Forecast Integration, Data Integrity & Quantitative Modelling
• Designed a consolidated analytical model integrating live SQL data with forecast projections and historical sales
metrics.
• Track in-market Days-of-Stock against both forecast demand and trailing 7-day sales velocity, projecting forward
cover to flag stockout risk; apply time-series smoothing to reduce volatility and stabilise demand.
• Build structured SQL queries combining real-time inventory datasets (Stock in Shop, In Transit, Allocated); support
modelling of up to 165, 000 monthly device movements.
• Safeguard distribution-data accuracy through weekly validation of the Excel planning files (e.g. confirming sales
figures) and resolve discrepancies with the Data Operations team.

Reporting, KPI Tracking & Inventory Risk
• Track core planning KPIs across all five markets to monitor performance and surface risks early: outlet stock
sufficiency (service level), weekly plan-versus-actual distribution and weeks-of-stock coverage.
• Deliver weekly performance analysis and monthly demand-and-supply reports to management, and continuously
review the planning process to close gaps.
• Run deep-dive investigations into demand anomalies such as sharp sales drops, shops repeatedly requesting
stock, or a launch under-performing against expectation, working with Sales and Data Ops to find root causes.
• Structured an inventory-ageing framework (under 7, 8 to 14, 15 to 21, 22 to 30, and over 30 days) and partnered
with Sales and Business Operations to clear aged and slow-moving stock through agent sell-through pushes and
targeted promotions, reducing aged inventory from 20% to below 10%.
• Sustained zero stockouts through a period of +27% monthly operational growth.

• Supported applied research on sustainable, affordable-housing models (AffordaBuild initiative); collected and
analysed qualitative and quantitative data to inform evidence-based recommendations.