Will Funk Email & Phone Number

• Ad hoc and routine reporting; development of internal HEDIS-like reporting
• Vendor/contract oversight, review of ROI methodologies
• Provide guidance for staff regarding effective data querying practices, basicstatistical calculations, study design and ad hoc analysis
• Participate in weekly SHP Data Repository Design meetings
• Facilitate and fulfil third party data requests

Raleigh, NC

• Create, maintain and update IBNR claims model, a regression based VBA/Excel model for estimating claims that have been Incurred But Not yet Reported. Implement the model for recurring and ad hoc analyses.
• Automate, maintain and update the monthly DMA Dashboard report. Prior to automation using VBA and the IBNR model, the Dashboard was a totally manual process consuming at least 40 hours of staff time each month..
• Participation in internal workgroups, providing data-driven responses to workgroup/stakeholder "conventional wisdom.”
• Support other Actuarial Services tasks with SAS and SQL-based querying of the claims data warehouse.
• Pricing and financial impacts for proposed benefit and eligibility changes.
• Annual pricing updates for ongoing programs.

Durham, NC

• Worked cross functionally with several other departments to develop Medicare rates that reflected overall corporate strategy and sound actuarial principles. This work was recognized with a $25,000 CEO award in March.
• Prepared health insurance rate filings for NC Dept. of Insurance.
• Prepared ad hoc utilization and cost analyses.
• Responsible, in conjunction with external consultants, for preparation ofMedicare Advantage Parts C & D rate filings for submission to the Centers forMedicare & Medicaid Services.
• Performed extensive and ongoing updates and maintenance to Medicare pricing& claims models using SQL, VBA, Excel and Access.
• Presented rates & justification of rates to all levels of management including theCEO.

Master'S Degree, Mathematics

Bachelor'S Degree, Mathematics