Jun Gao

Jun works with health plans and state Medicaid agencies to effectively manage, organize, and warehouse health data. He is highly adept in SAS and C++ programming with more than 10 years of experience in each. He also has deep experience in T-SQL programming with Microsoft SQL Server.

Examples of Jun’s expertise include:

• Data warehousing of Mississippi state Medicaid data using SQL Server for data aggregation, validation, and reconciliation.
• Medicare experience aggregation and summaries for Medicare Advantage bids using SAS to process Milliman health databases.
• Milliman Healthcare Reform Financing Model. Programmed a seriatim simulation model of the U.S. health care financing system to measure the impacts of health care reform on employers, individuals, and health plans.
• Data warehousing for commercial HMOs and PPOs using an SQL Server database.
• Visual Basic (Microsoft Excel) programming for cash flow testing models, long-term care insurance reserve models, and other analytic applications.