HAP is a Detroit-based healthcare insurer that strives to offer quality healthcare plans and innovation to their customers. With a workforce of more than 1,000 employees, HAP provides insurance solutions for just over 400,000 members across Michigan with 50,000 healthcare provider partners.

Modern healthcare providers face a competitive field. Since 2021, the Centers for Medicare and Medicaid Services has required healthcare and health insurance companies to publish their rates in standardized, machine-readable files. With this, large amounts of previously unknown data are now being published to the public, which creates a new avenue for data analysis.

Our Healthcare Payer Price Transparency tool uses these machine-readable files to provide business insights that were previously difficult to assess. The application leverages modern artificial intelligence with big data analysis to draw conclusions about healthcare plans such as plan coverage, covered providers, and costs to both the company and customer.

The Healthcare Payer Price Transparency web application stores files that contain information about healthcare rates from both HAP and external competitors. Users select which files they are interested in analyzing and have the option of uploading new files. The application reads the files and creates data visualizations that make it easy for the user to draw conclusions.

If the user has further questions about the files or data, they can begin a conversation with our AI chatbot that provides quick analysis of anything that interests the user.

The front end of the web application is built using industry standard HTML and CSS. For our back end, we leveraged Parquet files to store large quantities of data in smaller pieces. Python is used to manipulate data to produce insights. ChatGPT API is used for generative artificial intelligence.