Case Study:

Healthcare: Pharmacy Claims Analysis

Services Rendered: Data Engineering | Workflow Automation | Data Analysis



The client’s mission is to leverage data insights to reduce pharmacy costs and improve patient health. In building their core platform, they faced three main challenges:

  1. To aggregate data on group members of the managed health population, including risk level and all related medical and pharmacy data that impacts spend and patient outcome.
  2. To programmatically identify inefficient pharmacy spend and specific savings opportunities, and to surface actionable recommendations to a clinical team
  3. To produce client-facing reports that demonstrate the performance and value delivered by their platform.


We took a three-pronged approach to building out the client’s core platform:

  1. Implemented and deployed an auto-scaling ETL workflow automation tool used to ingest and process real-time and bulk data updates, including pharmacy and medical claims, eligibility, formulary, plan benefit data, and drug reference data.
  2. Developed a rules-based decision engine to identify inefficient pharmacy spend in large health plan populations and produce a prioritized list of drug therapy change recommendations used by clinical teams to reduce total cost of care.
  3. Built a reporting framework that forecasts potential drug savings and validates captured savings for health plan members who make the switch to alternative therapies.


We began working with the client before they had secured their first customer. They were pitching smaller regional employers with relatively unsophisticated internal benefits management teams and were still figuring out how to price their product.

Within 9 months of working with our team, our client was able to successfully onboard multiple health plan populations onto their platform and close their Series A funding. In the final quarter working with our client, they closed and onboarded a large national employer with a savvy benefits management team led by a known thought leader in the benefits industry.

After having fully handed off the project to the client team, they continue to utilize the tools to empower their current customers and to streamline their sales and onboarding process for new customers. They are now pursuing customers managing health populations that are 10- to 100- times larger than their first customer.

Let Aprime help you overcome your challenges

and build your core technology

Are you ready to accelerate?