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.
Ensuring 100% Data Accuracy for a Global Tech Company
Our client, a global technology company, needed to launch an internal revenue reporting system for ingesting and tracking federal revenue data. The project required coordination across a large number of teams, ERP systems and virtual desktops, with significant manual work needed to fix data issues. Learn how we helped.
Faster AI-Powered Mortgage Origination Process for Major Bank
A large bank’s mortgage origination department struggled with a time-consuming, labor-intensive application process. Reviewing and analyzing submitted documents took too long, leading to longer processing times and limiting how many applications Document Specialists could handle. The bank sought to automate the process to improve efficiency for both employees and customers. Learn how we helped.
Scaling Dropship Operations to Increase Customer Satisfaction for Global Retailer
Our international clothing and lifestyle client saw increased demand for larger items, but their retail stores lacked storage space. They needed a dropship system that used their warehouses for storage and integrated with their existing processes and inventory system. Learn how we helped.
Unlocking Actionable Intelligence Through Data Transformation
A global payments company needed insight into how marketers were utilizing email contacts so they could convert website visitors into active users for additional revenue growth. However, this exposed long-standing technical debt in their marketing systems. Learn how we built an upgraded platform so they could make better use of their data.