Senior Performance Reporting Analyst
Lawrenceville, Ga
Prepared consistent, timely, high quality and insightful financial reporting. Recommended, developed, and implemented policies and programs that guided the organization in maintaining and improving its competitive position and profitability. Created and maintained financial modeling within Excel for budgeting, forecasting, sales profitability and expense variance, extracting and manipulating 800K+ rows of data, 30-40 worksheets within an Excel workbook in order to calculate complex formulas with data exported from SAP and utilizing index match, v-lookups, h-lookups, macros and pivot tables for development of financial models and financial statements to load into Hyperion. Explored investment options and presented risks and opportunities to the President, GM and Business Leaders utilizing Power Point. Managed the development of all weekly and monthly financial close for the NA Finance team, compared anticipated and actual results, identified areas of improvement and utilized Power BI to prepare reporting for distribution. Developed SharePoint website for the North American Region Finance department to streamline reporting. Reconciled, calculated, and approved Commissions/SIP payouts along with developed dashboards for commission tracking/reporting. Responsible for the consolidation of the forecast P&L submissions within Hyperion, along with identifying key trends and providing monthly business insight. Preparation of quarterly forecasts and yearly budget documents. Prepared the quarterly business review presentations. Implemented initiatives to make the monthly reporting process as efficient as possible, with a faster and more accurate close process, drove improved business performance with reducing the monthly close cycle by three days. Ensured reporting controls were set up and working as expected. Ad hoc financial reporting projects. Worked in guidance of IFRS and with internal and external auditors.