Flower & Dessert Supply Forecast

Led the forecasting of flower and dessert supply at Enviaflores.com, the largest e-commerce gift platform in Mexico, across 16 cities nationwide. Developed demand projections using historical sales data and seasonal events to ensure optimal inventory availability.

Developed and maintained demand forecasts for perishable products across 16 workshops, supporting purchase planning with ForecastPro, achieving a WMAPE of 8% for +20,000 weekly units.
Proposed financial objectives for fiscal Q2 based on demand forecasts, aiding budget approval and target setting.
Forecasted daily order volume of +4,500 orders for workforce planning, ensuring a 98% fill rate across all workshops.
Assisted in planning for high-demand events such as Mother's Day and Yellow Flower Day with +25,000 deliveries, optimizing order fulfillment, labor allocation, and inventory management
Conducted exploratory data analysis on historical demand, identifying key variables and seasonal trends affecting demand.
Maintained and optimized Python and SQL scripts for automated data extraction from Amazon Redshift, streamlining data cleaning and reporting processes.