Kyle Mckay Email & Phone Number

Austin, Tx, Us

Austin, Tx, Us

Austin, Texas, Us

• Lead and manage data analysts and engineers to develop and implement data solutions to improve the quality, efficiency, and effectiveness of TRS Health programs. • Work closely with leaders from Finance, Actuarial, Operations, and Engagement to promote data-informed decision making, prioritize requests and initiatives, and serve as the product owner of health analytic platforms and business owner of HIPAA claims data.• Responsible for using data to provide input on strategic decisions and cross functional initiatives of the division including data resources, external presentations of data, rate setting, budget requests, legislative communications, cost containment strategies, and benefit changes.

Austin, Texas, Us

• Hire, train, and manage a new team of data analysts to drive improvements in data quality and plan management.• Identified new federal revenue source and claims eligible for reimbursement which increased revenues by $286 M and reduced price increases to employees.• Proposed and managed the creation of the first customer churn prediction model on imbalanced data set. Random forest based predictions identify employers at risk of switching products. Model routinely used to make product decisions.• Implemented predictive algorithms and health claim groupers in partnership with industry leading firm to identify areas of high-cost growth and improve actuarial forecasting.• Developed technical training for employees on SQL, PowerBI, R, claims data, data visualization, SQL Server, data warehouses, ETL pipelines, and data quality.• Responsible for developing and maintaining multiple data warehouses containing high volumes of claims data.

Austin, Texas, Us

• Responsible for analyzing claims data and producing all data visualizations for health programs with 700,000 covered lives and $3 billion in annual expenditures. Key insights and data visualization are shared on a weekly basis with senior management, the Texas Legislature, and 1,100 school district CFOs.• Built consensus for improvements by presenting findings to diverse audiences, including more than 200 school districts at annual conference.• Help manage analytics team by designing interview exercises, screening candidates, conducting interviews, and managing analysts.• Proposed and created data warehouse containing 160 million medical and pharmacy claims in partnership with data engineer. Created data quality controls and automated reporting using MS SQL server and R Markdown.• Serve as agency lead for the development of a multi-payer data warehouse. Data warehouse was successfully built over two years with more than six million covered lives. Currently coordinating the launch of quality initiatives.• Analyzing data and designing visualizations using Illustrator, R, PowerBI, Excel, PowerPoint, PowerBI, Python, and a variety of tools.• Developed predictive algorithm using machine learning to forecast the financial impact of competitive product being introduced in school districts. Predictions utilize enrollment, medical, and pharmacy claims history in conjunction with customer churn analysis.

Austin, Texas, Us

Identified solutions to improve the efficiency and effectiveness of health and human services programs across Texas government. Accessibility and relevance of reports and presentations resulted in multiple invitations to testify, legislation, state agency actions, and in-depth coverage by Texas media outlets.

Austin, Tx, Us

Managed quarterly and annual operational evaluations of Medicaid managed care programs. Collected and analyzed large volumes of information maintained by offices throughout the agency.

Managed a program evaluation for a four year academic program at PG Community College, Montgomery College, and the University of Maryland for the board of the Hillman Entrepreneurs Program.

Baltimore, Maryland, Us

Responsible for reviewing Governor’s proposed budget and presenting analysis with recommendations directly to the budget committees of the General Assembly as the lead analyst for a portfolio of agencies exceeding $500 million in legislative appropriations.

Washington, District Of Columbia, Us

Graduate intern in the Economic, Human Services and Workforce Division of the Center for Best Practices.

Washington, Dc, Us

Washington, Dc, Us

Washington, Dc, Us

M.P.P., Social Policy, Public Finance

Bachelor Of Arts (B.A.), International Studies & Economics