• Sole analyst for $6 MM budget • Automated and streamlined budget review process by eliminating 25% of errors, reducing budget review process by 8 hours, and eliminating 25% of recurring errors through deep investigation• Tracked and facilitated 100+ contracts through the lifecycle. Initiated contract renewal process• Collaborated with legal to ensure accuracy of NDAs, MSAs, SOWs• Created Agriculture Power BI report displaying volume by acre and supplier by region

• Led utility project to automate < 5min interval data for energy and water for 34 plants• Designed and built data analytics to support PepsiCo’s Climate and Water goals in Tableau platform• Managed reporting to track productivity for 34 sites and 26 tactics • Delivered $2.7MM AOP Energy & Utility field productivity• Refined Electricity True-Up process to balance inflation and deflation plan cost• Officiated period calls with 37 sites to review key performance indicators and project updates• Owned the training process in the Enablon system and Tableau performance reporting

• Managed project to integrate data systems for Global reporting across all functions of PepsiCo• Ensured global KPIs met DJSI guidelines, achieving 100% compliance• Supported public/private reporting requirements- including: DJSI, CDP, GRI, Energy Star, and DOE• Designed Tableau reporting to support energy and climate goals• Created new processes for non-manufacturing greenhouse gas emissions calculations• Collaborated with cross functional teams to design environmental global sustainability metrics reporting• Worked with 3rd party vendor to create accurate greenhouse gas calculations to support global reporting initiatives• Led the efforts to identify and write requirements for sector level reporting• Analyzed sustainability data to understand future risk• Created training to enhance power point reports

• Created Access database tools to enhance accuracy and improve efficiencies during audit process• Implemented CARS “import” process to gain productivity• Developed enhancement/requirement documents for system improvements• Automated feed from Excel to PowerPoint to update energy reports• Published weekly sales reporting to senior management• Provided analysis of merch data forecasting resulting in $10 MM cost savings• Developed net sales analysis to aid in better decision making for field finance