Demand Planning Management System (DPMS)

Databricks
Overview

DPMS was developed to enhance demand planning and forecasting accuracy for finished goods. This system aims to provide precise demand forecasts, optimize inventory levels, and align supply with demand to improve overall operational efficiency and customer satisfaction.

Challenge
  • Inaccurate demand forecasts led to inventory imbalances.
  • Missed sales opportunities due to inadequate stock levels.
  • High inventory holding costs due to overestimated demand forecasts.
  • Lack of integrated data made it difficult to gain a comprehensive view of demand trends and customer preferences.
  • Limited analytics capabilities hindered the ability to derive actionable insights and make data-driven decisions.
Technology Stack

Databricks

Azure

AWS S3

AWS Lambda

AWS Redshift

AWS Glue