Joseph Ferrero

• Lead in implementing Axiom cost accounting and decision support system. Help to create cost structure for 11 hospitals.
• Developed a monthly Physician Excess Days report as well as a monthly CMI analysis.
• Conducted regular audits of data sources to ensure compliance and integrity standards.
• Created an automated Daily Scorecard for Leadership.
• Created a detailed Service Line analysis for CFOs. Provided physician, charge-level, DRG and many other data points.
• Led training sessions on data interpretation for junior analysts and stakeholders.
• Implemented automated solutions for data collection, reducing manual entry errors.
• Analyzed large volumes of data to identify trends and opportunities for cost savings.
• Handled 100's of ad-hoc data requests, especially those involving profitability.

Lead in implementation of Visionware daily labor management system. Responsible for all system updates, loading of data and creating reports.

• Lead of Action OI and Lawson benchmarking systems.
• Assisted in the preparation of annual budgets and quarterly forecasts.
• Conducted variance analysis to identify discrepancies between budget and actual performance.
• Collaborated with other departments to ensure accurate budgeting and forecasting processes were followed.
• Compiled all data and submissions for yearly state surveys (IDPH and AHA), as well as other external surveys.
• Supreme knowledge of DRGs, procedure and diagnosis codes, revenue codes and all other data used to pull data.
• Completed hundreds of ad-hoc data requests.