Alliance for Medical Price Transparency
Data & Full Stack Development by

Alliance for Medical Price Transparency

Our goal was to provide Alliance for Medical Pricing Transparency (AMPT) with an online pricing comparison tool, to help consumers compare prices for common medical procedures across hospitals.

Service

Data Engineer and Full Stack Development

tools

AWS Redshift, AWS EC2, Python

Alliance for Medical Price TransparencyAlliance for Medical Price Transparency

The Goal

The Alliance for Medical Pricing Transparency (AMPT) is a group of medical professionals determined to increase access to healthcare, by helping consumers compare prices for common medical procedures across hospitals. Our goal was to provide them with an online pricing comparison tool (pricing tool), to prove the feasibility of their endeavor.

The pricing tool requirements were simple. A user would enter their zip code and a procedure to access a list of prices for that procedure at nearby hospitals. The first version of the tool would just have a few hospitals in Tulsa, Oklahoma, and about one hundred procedures.

Alliance for Medical Price Transparency
Alliance for Medical Price Transparency

The Process

Like most web applications, the pricing tool consisted of three main parts: a front-end, a back-end, and a data layer. In their research, our client noticed that a website very similar to what they wanted already existed. The key difference was that the existing website didn’t contain prices for the area we were interested in: Oklahoma. We partnered with the client to connect with the developer of the existing website. We found that it would be far more cost-efficient to purchase the code from the existing website’s developer rather than create it from scratch. With the code we had purchased, 90% of the front-end and back-end development was done. Our primary task was to build the data layer.

Handling the data was a key challenge in this project. The pricing data that we received from the hospitals was poor in quality. Often, prices were missing or contradicted the prices posted on the hospital’s website. We pulled the files from the hospitals, transformed them into a consistent format, and loaded them into a database. We created Python scripts for each hospital to automate the transformation of the data. We used an AWS Redshift database, for its reliability, cost, and scalability.

After ingesting the hospital data files, we found many of the procedures were still missing prices. Some of these prices could be found online, so the client volunteered to look them up. We provided the client with a form to fill in the prices. Afterward, we ingested the prices from the form into the database. With the pricing data in place, were-pointed the purchased back-end code to our database, and “re-skinned” the front-end. We hosted the application on a password-protected AWS server. All resources used by the app are under a single AWS tenant, whose ownership can be easily transferred to the client.

The End

While it was no easy task, we stood up a useful, robust, and easy to maintain web application within a few months. With this application, anyone can compare real prices across the four main Tulsa hospitals for common procedures. We helped AMPT take their first solid step in transforming medical pricing transparency in America.

Alliance for Medical Price Transparency
works

Latest Works

With more than 20 years of experience we can
deliver the best product design.

Other Customers

Contact

Are you ready?

With more than 100 years of combined experience we can deliver the best technology solutions.

Say Hi!

Say hi, we are here to help you just drop us a message here.

Say "hello"
Arrow

Have questions?

Maybe you still have questions, don't worry we got you.

common questions
Arrow