Financial Modeler

176162 | Contract

This strong Financial Modeler is an FP&A consultant for large, diverse corporations. Recent experience includes budgeting, forecasting, management reporting and financial modeling. Industry experience includes retail, distribution, manufacturing, professional services, pharmaceutical and energy. Systems experience includes Hyperion Essbase, SAP, HFM and Host Analytics, (certified) Access and Excel (Power Query / BI, v-lookups, Index Match, Pivot Tables, Macros/VBA and SQL codes).

Additional qualifications include:

  • Provided significant reporting design and template creation through Essbase and Jet Reports manipulating large raw data sets
  • Added a custom tool within MS Excel that allowed end-users to create custom reporting
  • Identified opportunities to save costs, improved and automated processes, and created reporting that could be understood across the organization
  • Developed MS Access databases as an interface to the financial planning of the HR and benefits forecasting performed within MS Excel
  • Gathered existing reports and automated the headcount, annual salaries, benefits elections, payroll deductions and time and attendance details to flow through for quicker and more accurate reporting
  • Provided the COA mapping to the OneStream system for an ERP upgrade from SAP to OneStream
  • Developed an MS Access database as a bridge to communicate between SAP and OneStream
  • Maintained the monthly FP&A expense reporting, adjusted rolling 12-month forecast and provided the consolidated P&L and balance sheet
Skills: Account Reconciliations, Accruals, Balance Sheet, Budgeting & Forecasting, Compensation & Benefits, Cost Analysis, Credit, Data Migration, Essbase, Excel - Intermediate, Financial Analysis, Financial Modeling, Financial Reporting, Foreign Currency, HFM, Host Analytics, Hyperion, Inventory, KPIs & Benchmarking, Management Experience, Microsoft Access, Microsoft Office, Month End Close, PeopleSoft, Pricing, Process Improvement, Revenue, Sales, Finance & Support, S,AP SQL, Supply Chain, Treasury, VBA
Skills: Account Reconciliations, Accruals, Balance Sheet, Budgeting & Forecasting, Compensation & Benefits, Cost Analysis, Credit, Data Migration, Essbase, Excel - Intermediate, Financial Analysis, Financial Modeling, Financial Reporting, Foreign Currency, HFM, Host Analytics, Hyperion, Inventory, KPIs & Benchmarking, Management Experience, Microsoft Access, Microsoft Office, Month End Close, PeopleSoft, Pricing, Process Improvement, Revenue, Sales, Finance & Support, S,AP SQL, Supply Chain, Treasury, VBA