Senior Analyst, Supply Chain Finance
Kansas City , Ks, Us
I support two groups in the Supply Chain Organization: Procurement and Dean Foods distribution warehouses (National Warehouse).Support to Procurement:- Mine data from a variety of sources within Dean Foods, providing a comprehensive analysis of Dean’s key commodity usage and spend. Use sources of data to create and implement forecasting and reporting via Tableau, Alteryx and Excel.- Work with cross-functional teams to assess, analyze and implement solutions that reduce costs. Owned financial analysis for single largest 2018 productivity initiative, presenting to C-suite multiple times until winning CapEx approval.- Further automated existing reporting, resulting in 0.2 reduction FTE, enhanced consistency, and a reduction in manual errors using Tableau, Alteryx and Excel.- Work with Procurement Directors, R&D food scientists, and packaging engineers to assess, analyze and implement solutions that reduce costs.- Provide analytical support and prepare business cases for innovation and standardization initiatives, and present initiatives to cross functional teams to gain strategic alignment.- Assist with cost analysis to support RFPs and pricing exercises, as well as work on special projects and develop various ad-hoc reports as needed.- Provide support for analysis, validation, and reporting of Procurement cost savings and productivity targets.- Serve as Dean Foods system admin for third party utility usage and payment system.- Support centralized pricing updates and communication to the field on vendor cost changes.Leading FP&A for National Warehouse:- provide reporting via Tableau/Excel/PowerPoint on logistics KPIs; supplier management KPIs; customer service KPIs, etc.- providing product costing.- forecast for budgets.Work platforms include:Tableau, Alteryx, Microsoft SQL Server, Essbase, MicroStrategy, JDE, AS/400 iSeries, Microsoft Office Suite (especially Excel), SharePoint, and Microsoft Teams.