• Performed benchmarking analyses for hospitals to compare reimbursement rates to market• Developed payer-contract modeling templates for providers to estimate future reimbursements • Delivered value-based analytics—Avoidable ED, Frequent Fliers, Readmissions—for providers• Built SQL program to reprice state Medicaid claims using insurance payer claim data• Provided analytical support using SQL and Tableau to generate insights from payroll/GL data

- Built SQL queries to produce Provider Cost dashboards for behavioral health provider network- Produced Executive Dashboard reports tracking key contracted metrics for plans managed- Developed logic to report on Total Cost of Care metrics: AOD, FUH, FUED, HRA/HRS- Managed production and distribution of all monthly IPA reporting to state of Illinois

• Produced Cost-Benefit Analysis reports for projects totaling over $10M in cost savings• Built and enhanced monthly operational dashboard to show financial impacts of 30+ team initiatives; collaborated with team leads to identify key performance metrics and optimize data• Managed timely submission of all performance data (SLAs, KPIs) for large employer group plans

• Managed claims review process of up to 500,000 daily pharmacy claims• Developed automation of claim reviews using Excel and Access, resulting in over $100K in annual cost savings through reduced employee hours and improved compliance• Nominated for 2015 UnitedHealth Innovation Award for work on CMS Audit Preparation