Thomas Halvorson Email & Phone Number

Ann Arbor, Michigan, United States

Ann Arbor, Michigan, United States

Ann Arbor, Mi

Ann Arbor, Mi

Ann Arbor, Mi

Ann Arbor

Developed PPACA Impact Modeling Application within Excel, inclusive of Benefit Design modeling, household level Exchange premium estimates, Cadillac Tax projections, and forecasted penalties/fees. Responsible for marketing & selling this tool to numerous Fortune 500 employers, health plans, and brokers.Consulted employers on future Cadillac Tax obligations, and provided guidance on mitigation and avoidance strategies, including benefit design and contribution changes, as well as spousal surcharge/exclusion scenarios.Customized large report set for a regional health plan and subsequently produced this report for 100+ employer groups utilizing streamlined Excel & VBA techniques.Designed statistical regression models to stratify Medicare Advantage members into appropriate case management levels, including end-of-life hospice recommendations.Participated in the broad application process for customers into the Early Retiree Reinsurance Program; Truven Health clients captured over $1 billion of reinsurance dollars.Led the team responsible for the creation of the Semi-Annual MarketScan report, containing 15+ million lives gathered from Truven Health’s book-of-business. The report captures a broad spectrum of benchmarks, trends, and other useful statistics.Trained internal staff on a variety of topics: consulting, applications & tools, methodology, etc. Have worked closely with annual intern group for five years.