Business Challenge: A CPG manufacturer had a manual data load and refresh process and they were spending over a week every month to update forecasts in their Business Plans. They were not spending enough time to understand drivers of forecast variance to better inform their forecasts. There were manual errors from copying & pasting and the lack of standardization & disorganized file structure made the process complex and cumbersome

Approach: Developed an automated desktop tool to dynamically extract data from multiple sources, cleanse it and update forecasts swiftly

Business Impact: Eliminated manual errors and the team now spends more time on insights rather than execution of the task