Christopher DiFonso
Senior Financial Analyst · Planned Parenthood of Orange and San Bernardino Counties
Mission Viejo, CAIn 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 Counties2013 – 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
CalOptima2007 – 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
CalOptima2005 – 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 Solutions2003 – 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 California1991 – 1993
MBA
B.A.
University of Southern California1975 – 1977
B.A.