The Challenge: Analyzing the demand portfolio for a major food manufacturing company (Compañía de Galletas Noel) was a highly manual, time-consuming process. It required heavy operational work in Excel to merge massive CSV data repositories with separate product description sheets just to extract basic weekly or monthly demand forecasts by destination.
The Solution: I conceptualized and deployed a fully automated web dashboard. By leveraging Generative AI (Gemini) to assist with the code development, I created a tool that seamlessly integrates the raw CSV demand data with the product master data. Now, stakeholders only need to input a single SKU code to instantly visualize demand trends, filtering by timeframe (weekly/monthly) and destination.
The Impact: Massive Time Savings: Transformed a tedious, multi-step manual Excel process into a 3-second automated query.
Operational Efficiency: Eliminated human error in data merging and freed up hours of valuable time for strategic analysis rather than data entry.
Tech Stack: Data Analytics, Python/Web Logic (AI-Generated), CSV Integration, Supply Chain Forecasting.