Serve as the lead for our administrative expenses benchmarking project. Involves working with consultants to conduct interviews, gather and interpret data, and engage in complex financial modeling. Requires in-depth analysis of financial information, presenting and explaining results to leaders, working to resolve issues with the interpretation of the data, and troubleshooting issues in the financial model.
- Responsible for two special projects that involved gathering and synthesizing our administrative expenses from all company divisions, requiring the classification of the expenses into eight core processes and sub-buckets. Created a complex EXCEL spreadsheet to perform all of the calculations and to organize the data. Presented the data to upper management, including the CFO and CEO. Involved several team meetings with the CFO and Division Heads.
- Responsible for all FTE (Full Time Equivalents) reporting. Worked with three financial analysts to compile all budgeted heads for the cost centers into one comprehensive spreadsheet and walk. Responsible for creating new FTE reports using several different data downloads, requiring complex EXCEL modeling. Created multiple monthly reports showing several different views and analyses of the FTE data for presentation to the CFO.
- Served as a team lead for a project which classified all administrative cost center expenses to product segments. Involved creating an allocation template for the use by the cost center leaders and performing complex calculations to properly allocate the expenses. less