Summary of Experience
Optum/Caremount Medical */2022 – Present
Sr. Financial Compensation Analyst
Compiled monthly compensation schedules for over 150 associate MDs in the Optum healthcare system for the New York metropolitan area.
Ad hoc report analysis and creation utilizing Microsoft Excel and Access.
Responsible for compiling and maintaining the Advance Practice Clinicians document that includes salary distribution for Sr. Associates.
Danone North America, White Plains, NY
Senior Financial Analyst 2021 -2022
As a consultant for a global leader in health focused food and beverage industry responsible for the daily running, maintenance, and enhancement of the Regional Channel Planning Commercial Finance P&L.
Utilized data downloads from Tagetik and Kantar to populate various financial reports in Excel.
Created monthly Orders Report to reveal shipping trends and inefficiencies.
Sabbatical from corporate career to care for my elderly parent full time. 2018 - 2021
Westcon-Comstor, Tarrytown, NY
Senior Financial Analyst 2017 -2018
As a consultant for a technology distributor, took ownership of the Hyperion Essbase Global Customer and Vendor Dashboards performing updates, handling inquiries, and adding efficiencies
Created budget templates during the budget process for EMEA and APAC divisions.
Identified reporting and ad hoc needs of various internal departments using SAP BI and Essbase
Charter Communications, Stamford, CT
Senior Financial Analyst 2017 - 2017
As a consultant, assisted telecom firm Capital Dept. in creating reports in Essbase.
Created ad hoc queries to facilitate capital decision making.
Made reports such as Capital Equipment Report more efficient using Essbase
Worldquant, Old Greenwhich, CT
Financial Analyst 2015 - 2016
As a consultant, assisted Investment firm in transitioning historical general ledger data from old legacy systems into new ERP Workday software utilizing excel models
Used complex excel models to scrub data and load data into the Workday system
Chartwells, Inc., Rye Brook, NY 2006 – 2015
Sr. Financial Reporting Analyst
For a food service company responsible for expense and revenue budgeting, financial planning & analysis, analytical support, and monthly reporting
Responsible for centralizing data and creating monthly reports utilizing SAP, Hyperion Essbase, Excel pivot tables, recorded macros, lookups, IF statements as well as Access databases to create complex financial models. Reports include Presidents Report, Inventory Trend Report, DSO, Overtime, Gross Product Cost, KPI Report
Initiated and designed first consolidated account historical P/L report consisting of 13 yrs. of history
Maintained and updated DSO report leading to the overall reduction of total A/R times.
Initiated the use of Hyperion Essbase in the regional finance office and served as reference point for future users
Michael Fichera Jr., MBA
Peekskill, New York
Cell 914-***-****, Email: *********@*****.***
Senior Consultant
Industry Experience
Distribution
Technology
Communications
Financial Services
Food Services
Areas of Practice
Financial Reporting
Financial Modeling
Data Management
KPIs
Budgeting
Financial Planning
Financial Analysis
Software Applications
Advanced Excel
Access
CA-DataQuery
Hyperion Enterprise
Hyperion Essbase (Smartview and Ad hoc) SQL Financials
Brio-Query
Oracle Financial Analyzer
SAP BI
Education
Iona College
MBA, Finance
BBA, Marketing
Minor: MIS
Previously Held Roles
Citizens Communications
Sr. Financial Systems Analyst
Resources Connection
Sr. Financial Analyst – Consultant
Accubanc Mortgage Group
Sr. Financial Analyst
Dal-Tile International
Financial Analyst
Bank of America
Trust Manager – Consultant
Liberty Sports
Financial Analyst – Consultant
Phase II, Inc.
Analyst
City of Dallas
Budget Analyst
Manufacturers Hanover
Assistant Manager