Unlocking Reimbursement Solutions for Biopharma
For patients and providers, access to cancer and rare disease treatments depends on fast, reliable reimbursement data.
Opportunity
DKP’s analysts needed a sustainable, user-friendly tool to replace their fragile Excel system and deliver accurate, time-sensitive insights.
Results
- Manual Excel work eliminated
- Faster, more accurate reporting
- Scalable client portal added
- New revenue from interactive maps
Client
Partnering with Biopharma to Improve Patient Access
DK Pierce (DKP) helps biopharmaceutical companies bring treatments to patients by solving complex reimbursement challenges. From oncology to rare and cellular therapies, DKP provides intelligence, analytics, and consulting that guide market access strategies.
About DK Pierce
Industry
Healthcare Consulting
Headquarters
Zionsville, IN
Founded
2000
Market
Nationwide US
Opportunity
From Fragile Spreadsheets to Scalable Systems
DKP analysts managed critical payer data in a massive Excel tool that was fragile, slow, and difficult to maintain. The stakes were high: pharmaceutical manufacturers rely on this data to decide where to launch therapies, while providers and patients depend on it to know what treatments they can access.
DKP needed a modern, sustainable platform that could keep pace with their growing business and client demands.
What We Did
Flow Design
Full Stack Development
Product Discovery
Product Management
Product Strategy
Systems Thinking
Web Development
Solution
Building a Scalable Hub for Reimbursement Intelligence
We started by digging into DKP’s Excel system. It wasn’t just a spreadsheet—it was the backbone of their analysts’ daily work, with thousands of rows and columns driving critical client reports. By breaking it down, we saw how it worked, where it slowed them down, and how fragile it had become.
Partnering with Analysts
Next, we worked side by side with DKP’s analysts. We shadowed their work, asked questions, and studied how they created reports.
We saw how much time was lost to manual entry, how broken formulas created stress, and how hard it was to scale insights. Those lessons shaped the new product.
Together, we aimed for a tool that felt familiar enough to use right away, but strong enough to grow with DKP’s business.
Designing Through Feedback
We built early prototypes and put them in front of analysts. Their feedback guided every step, making sure the tool matched real-world needs.
Instead of replacing the Excel system all at once, we moved tasks over in phases. This reduced risk, built trust, and allowed adjustments as the tool rolled out.
Expanding Capabilities
With the core workflows in place, we expanded beyond what Excel could offer. We added Custom Monitoring Fields so DKP could track unique client data. We created a secure Client Portal where clients could access reports directly. And we launched Interactive Maps—mini-sites that turn complex coverage data into clear, visual insights. These maps not only support patients and manufacturers, they also became a new stream of recurring revenue for DKP.
In the end, the solution did more than replace a fragile spreadsheet. It gave DKP a sustainable, scalable platform that now supports their client-facing work and opens the door for new services.
Tech Stack
Heroku
PostgresQL
Rails (Ruby)
Results
Turning Data into New Offerings
DKP’s fragile Excel system is now a sustainable web tool at the center of their client-facing work. Analysts no longer risk broken formulas or lost files—reporting is faster, more accurate, and easier to maintain. The new platform not only improved efficiency but also enabled DKP to create new offerings, from interactive maps to client portals, driving growth and deepening client trust.
Eliminated manual Excel data entry
Faster, more accurate reporting
New recurring revenue via coverage maps
Secure client portal for direct access