John Skubal is an actuary with experience in forecasting and reserving behavioral health claims for Medicare Advantage, Medigap, and Medicare Part D plans.
Prior to joining Wakely Consulting Group, an HMA Company, John served as a senior actuarial analyst with Optum. In this role, he set reserves and forecasted for Optum’s external (non-UHG) behavioral clients, including Medicaid, Affordable Care Act, and Medicare populations. He analyzed behavioral claim-level data to identify key trends, prepared presentations for external health plans, and compiled data from multiple data warehouses to create ad hoc reports using structured query language. John also enhanced functionality of key models by adding dynamic arrays and Excel database connections to reduce manual entry and errors.
During his time as a purchasing analyst with Pace Analytical, John created a weighted average payment model used to determine company savings when switching net payment terms with vendors. He compiled statistical data for a variety of projects, such as vendor negotiations and cost analyses, and developed and presented a cost analysis report for switching to an automated procurement system. He automated daily reports using Python and led team training seminars on using Excel for calculations and data visualization.
John earned a bachelor’s degree in actuarial science from the University of Wisconsin – Eau Claire and is an associate of the Society of Actuaries.
