• Prepared month-end close and conducted variance analysis for consolidation reporting purposes using SAP Business Explorer (Bex) and Hyperion Essbase• Performed monthly audits of up to $60 million net sales across 20 major products within IP & Science• Developed Revenue Model 2020 by evaluating cost optimization initiatives including detailed analysis of revenue, regional sales, customer counts, short-term and long-term expense forecasting, coordinating with executives and five finance leads across Innovation Industries business units• Built net sales dashboards and key financial metrics utilizing Excel to generate valuable insights, which resulted in innovative data visualization and increased reporting efficiency

• Analyzed annual budget development files, identifying up to $2 million in discrepancies in the allocation analysis process and providing recommendations for improvement• Prepared projection analysis reports focusing on budgeted, actual, and projected financial data to assist management in evaluating periodic revenues and expenses• Prepared monthly expense analysis to assist Financial Planning/Marketing departments in preparing quarterly executive reports• Utilized Excel to analyze potential earnings and project future expenses for the 2016 budget from all distribution divisions