Design and build of a custom inventory forecasting and stock planning platform, replacing manual Excel-based planning with a real-time, data-driven tool for multi-warehouse US operations.
- Stock visibility: near-real-time on-hand inventory across multiple warehouses and sales channels, with weeks-of-cover calculations and colour-coded risk indicators
- Demand forecasting: seasonal velocity analysis with automated trailing-average fallback, powering accurate stock burndown projections
- Transfer recommendations: intelligent inter-warehouse transfer suggestions respecting carton quantity constraints and channel allocation rules
- Stock alerts: configurable threshold-based alerts with three-tier severity, flagging SKUs at risk of stockout across individual warehouses and country-wide
- Automated data sync: daily sync from a data warehouse and ERP tool
- Sales velocity analysis: channel-specific and warehouse-specific velocity views with weekly and monthly breakdowns across configurable lookback periods
Built with FastAPI, React, PostgreSQL, and Databricks SQL, deployed with automated daily data synchronisation.
