CHRISTOPHER S. DiFONSO, MBA

***** *********, ******* *****, ** 92692

(949) 689 – 3466

ac0gi4@r.postjobfree.com

Professional Summary

Accomplished financial and data professional with more than a decade 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 budget preparation; financial forecasting and modeling; variance analysis and account analysis/reconciliations; journal entries and month-end close.

Professional Experience

West Dermatology 2016 – 2017

Director of Financial Analysis

Created and maintained financial models, standard and ad hoc reporting and forecasts. Synthesized and articulated key findings to help facilitate decision making leading to improved company performance.

Reviewed reporting processes for accuracy and efficiency

Analyzed service mix, payer mix, payer category mix, patient class mix and other data and wrote monthly operations analysis report to explain significant variances from budget

Obtained information from practice managers and updated patient volume projections

Moss Adams Healthcare Consulting April 2016 – June 2016

Sr. Financial Analyst, contract position

Created 24 detailed Excel sheets, each one a pro-forma P&L for a combination of health plan, IPA and county (two HPs, three IPAs and four counties). Also created roll-ups for consolidated, HP and county and created formulas to roll up the data.

Compared revenue by CPT code by payer for six medical groups

Audited claims against data in patients’ EMRs

Planned Parenthood of Orange and San Bernardino Counties 2013 – 2015

Senior Financial Analyst

Optimized and standardized method for gathering and reporting quarterly and annual operational data to corporate. Gathered and organized data to measure the profit/loss of services and procedures.

Analyzed purchase history and costs to prepare $11 million medical supplies budget for 9 cost centers

Proposed creation of new general ledger accounts for significant cost medical supplies currently in miscellaneous supplies accounts

Analyzed and reported procedures, and number of patients, by financial class and payers

Updated and published financial results for month and YTD with brief summary of highlights

Extracted and analyzed the costs of supplies and procedures

Created regression models in Excel to forecast future volume of procedures

Used Tableau BI software to extract, analyze and report revenue and cost, clinician productivity, and statistical data

CalOptima 2005 – 2012

Senior Financial Analyst; Business Analyst

Responsible for the preparation of complex financial reporting packages and models, as well as proactively identifying and implementing ways to improve forecast accuracy/efficiency and provide early warning to deviations vs. budgets and forecasts.

Developed the CalOptima $900 million consolidated and program budgets. This included preparing assumptions and creating Excel regression models of membership by Med-Cal aid categories.

Analyzed the income statement and prepared the monthly variance analysis

Prepared the monthly budget variance analysis on a program and a consolidated level

Created regression analysis in Excel to project membership in each medical aid category

Created Excel formulas to generate SQL statements which added or changed Medi-Cal capitation rates in the database table

Created and ran SQL queries to obtain data, which I used to perform QA on data extracted by programmers

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

Created complex Excel formulas incorporating conditional statements and vlookup to validate Access data used to pay providers

PacifiCare 1999 – 2004

Financial Analyst; Project Manager

Responsible for providing actionable business analysis and operational insight to the organization by compiling and analyzing financial data.

Created the detailed $84M annual operating and $7M capital budgets (including assumptions) and the monthly forecasts which enabled more accurate projections and budgets; analyzed budget variances to help management identify operational areas of concern

Performed detailed analysis of computer equipment lease costs resulting in senior management acting upon the data, which resulted in $3 million annual savings

Created a proposal template that increased the level of accuracy while reducing the time to generate proposal dollars. This involved interviewing experts to determine tasks, supplies and other elements of conducting typical Phase IV clinical studies and building a model with assumptions and sections for each type of cost.

Managed projects and strategic initiatives to ensure completion of critical business tasks, most notably a $1.5 million study

Technical Skills

Proficient in Excel, Word, Access, PowerPoint, Great Plains, Sage, SQL and Tableau

Education

Master of Business Administration, Management

Bachelor of Arts, Economics

University of Southern California, Los Angeles, CA

Contact this candidate