challenge
One of the leading dental insurance providers in the country was struggling with data integrity. Each client they worked with, whether it was a large insurance provider or a local dentist’s office, would send them large amounts of patient information. All of this data had conflicting formatting, which slowed the claims process down, putting the client at risk of government-imposed fines, and made it harder for them to process claims correctly, resulting in over and under payments.
solution
This client receives both a steady stream of data every day, as well as a large influx during open enrollment. In order to help them operate more efficiently, we split our colleagues into two separate teams to help this client manage their data, and provide extra support leading up to the launch of their proprietary solution: Tritium and Elevate. Tritium handled all of the member enrollment and data migration tasks. These colleagues would implement BizTalk policies to automatically allow client files to process correctly each time an anomaly would appear. Elevate acted as triage, handling any help desk tickets and data clean-up. Both teams used extremely detailed SQL queries to manage and update millions of rows of data at a time, ensuring complete data integrity.
results
The Tritium team handled 357 complex ticket inquiries in the first year, and that number has increased 10-15% each year since, providing much-needed efficiency to help the client avoid government-imposed fines. The Elevate team’s ad hoc scripts were incorporated in a tool that allowed the client to complete redundant tasks on their own, which in turn helped the client operate so efficiently that they eliminated the need for one FTE on this project.
Breaking Down Data Silos for EPOCH Senior Living
EPOCH Senior Living operates 16 senior living communities across New England and Westchester, NY. As the company grew, they realized their tech stack was slowing them down and not providing the data they needed to make timely business decisions. Learn how we created a single source of truth for their data to help them increase occupancy rates and reduce operational costs.
Revolutionizing Cancer Research with Powerful Data Visualization
A world renowned research hospital with one of the largest laboratory testing facilities in the country needed to redesign their genetic research dashboard to support oncologists and hematologists in identifying key factors correlating to certain cancer types. Learn how we helped them work towards their goal of reducing the number of tests and panels needed to identify a timely and effective treatment plan for each patient.
Unified Data Warehouse Drives Transformational Growth for Upscale Retailer
An upscale regional pet retailer had fragmented data sources across a number of systems, which was causing misinformation to be reported throughout the company. They needed a partner to consolidate and transform their data for a single source of truth to generate actionable insights.
Debt Syndication Platform Provides Powerful Analytics for Capital Markets Division
A major American bank struggled with tracking their debt syndication pipeline in the investment grade, high yield and municipal bond markets. Their existing approach caused operational auditing issues across a number of teams. Learn how we streamlined deal collaboration and provided enhanced analytics.