Health & Fitness

Senior Financial Analyst

Accomplished finance professional with over eight years of experience in financial analysis, as well as proficiency in accounting, data extraction and data validation. Extensive experience working quickly and accurately under pressure to successfully meet short deadlines. Areas of expertise include creating very detailed, grounds-up budgets; financial forecasting and modeling; variance analysis and account analysis/reconciliations; journal entries and month-end close. Microsoft Certified Application Specialist in Access, Excel, PowerPoint and Word. Proficient in SQL, Great Plains, Facets and Visio.

•	Extract and analyze cost data to perform profit and loss analysis
•	Using Tableau, extract and analyze procedure data based on CPT codes
•	Analyze physician and clinician productivity: RVUs per hour and patients per hour
•	Analyze and report procedures, and number of patients, by financial class and payors

•	Created Excel formulas to extract rate and other data from Excel files in order to generate SQL statements which add or change Medi-Cal capitation rates in the database table
•	Created complex Excel formulas and used advanced filters to extract and analyze data
•	Created an MS Access database, linked to tables on file server data bases, imported data to create Access tables, and manipulated queries to update, append and select (analyze data) in order to validate and reconcile data

Business Analyst

•	Tracked financial status by preparing the monthly budget variance analysis on a program and a consolidated level
•	Developed the CalOptima consolidated and program budgets and forecasts
•	Created complex Excel formulas incorporating conditional statements and vlookup to validate and reconcile retroactive payments to providers 
•	Researched Medicare Advantage discrepancies (e.g., eligibility, payment history) by retrieving Facets and MS Access data 
•	Created regression analysis in Excel to project membership in each Medi-Cal aid category

•	Created a budget template that increased the level of budget accuracy while reducing the time to generate them
•	Managed projects and strategic initiatives to ensure completion of critical business tasks, most notably a $1.5 million study

Project Manager

•	Prepared the annual operating and capital budgets, and the monthly forecasts which enabled more accurate projections and budgets
•	Starting the fourth month of each fiscal year, prepared monthly expense forecasts comprising actual results and revised budget amounts  
•	Analyzed budget variances to identify trends and help management identify operational areas of concern.
•	Provided information to senior management by creating an Excel model of the total cost of leasing computer equipment; saved $3 million annually by convincing management to switch from leasing to purchasing.

Principal Financial Analyst

Find out detailed information about Christopher DiFonso, Senior Financial Analyst in Mission Viejo, CA

Christopher DiFonso: Senior Financial Analyst in Mission Viejo, CA

Christopher DiFonso

Planned Parenthood of Orange and San Bernardino Counties

CalOptima

CalOptima

PacifiCare -- Prescription Solutions

PacifiCare -- Western Region I.S.

University of Southern California

University of Southern California