Chicago, Illinois, United States
• Enhanced visibility and accountability for division level intercompany work orders (IWOs) • Utilized Microsoft Power BI to create an interactive dashboard that joins datasets from multiple business systems, streamlining the reporting of key IWO metrics by business unit and business lead • Discovered numerous issues that required manipulation and cleansing of thousands of rows of data, keeping project on time and ensuring accurate reporting • Led a presentation to senior management demonstrating dashboard functionality and key recommendations • Extracted data from SAP and optimized reporting and analysis for thousands of open purchase orders • Researched and implemented macro functionality to automate the filtering of data in excel • Maintained reports tracking divisional expenditures as compared to the budget to assess financial performance