CD

Christopher DiFonso

Senior Financial Analyst · Planned Parenthood of Orange and San Bernardino Counties

Mission Viejo, CA

In My Own Words

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.

Work Experience

Senior Financial Analyst

Planned Parenthood of Orange and San Bernardino Counties

2013 – Present

• 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

Business Analyst

CalOptima

2007 – 2012

• 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

Senior Financial Analyst

CalOptima

2005 – 2007

• 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

Project Manager

PacifiCare -- Prescription Solutions

2003 – 2004

• 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

Principal Financial Analyst

PacifiCare -- Western Region I.S.

1999 – 2002

• 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.

Education

MBA

University of Southern California

1991 – 1993

MBA

B.A.

University of Southern California

1975 – 1977

B.A.

Industries

Health & Fitness