High Profile Healthcare Litigation

Founded in 1987, Coker Group has long established itself as a leading healthcare advisory firm. Its mission is to empower hospitals and physician enterprises to deliver sustainable, quality care through strategic, operational, financial, and technological guidance.

Excel Meets Its Limits

When a high-profile litigation case brought in over 5 million rows of historical healthcare claims, Coker Group needed a trusted partner who could handle large volumes of sensitive data and understand the Physician Revenue Cycle.

As an Excel-based organization, Coker Group repeatedly encountered performance issues with handling large volumes of data. Files crashed and stalled while opening items. The analysis was extremely cumbersome and time-consuming.

Set up a brand new data infrastructure

Coker Group had just provisioned a new PostgreSQL database in Microsoft Azure. At the time, the system had zero records and no data architecture in place.

Ingesting over 5 million healthcare claims into a production-ready database and ensuring the numbers aligned were critical to the project. There was no room for error as the involving litigation tied to the Physician Revenue Cycle.

In less than 2 weeks, Velocity Sense designed a database structure purposed for scalable claims data ingestion. We loaded and validated over 5 million of sensitive records to provide 1-on-1 direct support for litigation alongside Matt Jensen, the VP of Revenue Analytics.

A Trusted Partner During a Critical Moment

The data handled was sensitive, complex, and required accuracy to the last decimal.

Despite Coker Group’s historical reliance on Excel, Velocity Sense helped the Coker Group shift toward SQL-based workflows, unlocking speed and confidence in handling millions of records.

“Our group has traditionally been a Microsoft Excel-heavy analysis shop and new to the implementation of more sophisticated data analytics tools. Gideon was able to come into our group with little infrastructure set up and was able to, in very short order, help us get our SQL database architecture in place and started analyzing several large datasets with millions of lines of data.”

— Matt Jensen, VP of Revenue Analytics

Velocity Sense took it a step further in onboarding a new staff member to transition the new data infrastructure.

Driving Impact Across Coker Group

Thanks to this effort, Coker Group was able to analyze and interpret millions of claims records within their litigation timeline.

Coker Group could operate within a scalable, queryable Postgres environment for future cases as well as support stakeholders with faster, more defensible insights tied to revenue analytics.

“Velocity Sense quickly grasped complex concepts and instantly meshed well with our team. I would absolutely recommend him and work with him again (and in fact we did extend the contract beyond the original project scope).”

Velocity Sense continues to help organizations like Coker Group modernize their data infrastructure to streamline its revenue cycle analytics, especially when it matters most.