Finance Manager/Modeler
This strong consultant/MBA is a bright and articulate professional with extensive financial modeling and analysis experience. Career experience includes preparing board presentations, creating financial models, compiling five-year trend analysis, presenting monthly KPI metrics for individual business units, short and long-term financial forecasts, cash flow and debt analysis. Additionally, responsibilities include monthly consolidated financial statements for $5 billion asset portfolio, income statement variance analysis, financial forecasting, ROE/ROA, NPV, DCF and other KPI calculations, financial and variance analysis for balance sheets, income statement, equity, and rolling 12-month cash flow statements. Systems expertise includes Hyperion, JDE, Cognos, advanced Excel (v- and h- lookups, pivot tables, CountIF, SumIF, building and editing Macros, TRIM, Concatenate).
Additional qualifications include:
- Performed extensive data modeling to analyze the cost of product distribution by various shipping methods such as land and air, assisted with a conversion from SAP to Hyperion, and validated and cleaned-up the data used in models to ensure accurate reporting to executive management
- Led annual budget process and streamlined workflow
- Created financial models in Excel, Hyperion and Host Analytics and performed KPI analysis for management and investors
- Helped assess financials in a new way by developing models on best usage for existing cash; Excel was utilized for all scenarios and the data was extracted from Hyperion
- During a 3-year restatement process, managed the ever-changing manual reporting from India (received the information and then had to ensure the reporting matched new management requests)
Finance Manager/Modeler
This strong consultant/MBA is a bright and articulate professional with extensive financial modeling and analysis experience. Career experience includes preparing board presentations, creating financial models, compiling five-year trend analysis, presenting monthly KPI metrics for individual business units, short and long-term financial forecasts, cash flow and debt analysis. Additionally, responsibilities include monthly consolidated financial statements for $5 billion asset portfolio, income statement variance analysis, financial forecasting, ROE/ROA, NPV, DCF and other KPI calculations, financial and variance analysis for balance sheets, income statement, equity, and rolling 12-month cash flow statements. Systems expertise includes Hyperion, JDE, Cognos, advanced Excel (v- and h- lookups, pivot tables, CountIF, SumIF, building and editing Macros, TRIM, Concatenate).
Additional qualifications include:
- Performed extensive data modeling to analyze the cost of product distribution by various shipping methods such as land and air, assisted with a conversion from SAP to Hyperion, and validated and cleaned-up the data used in models to ensure accurate reporting to executive management
- Led annual budget process and streamlined workflow
- Created financial models in Excel, Hyperion and Host Analytics and performed KPI analysis for management and investors
- Helped assess financials in a new way by developing models on best usage for existing cash; Excel was utilized for all scenarios and the data was extracted from Hyperion
- During a 3-year restatement process, managed the ever-changing manual reporting from India (received the information and then had to ensure the reporting matched new management requests)