This page contains a Flash digital edition of a book.
workfl ow designer took the plan past basic fi le valida- tion (such as “no blank required fi elds” or “dates in the proper format”). Andrews explains, “We’re even doing eligibility checks within our project. The process design completed by Pervasive’s consultants goes out into our data warehouse and checks to see if our clients’ employees are eligible for the benefi ts we’re about to process.” Processes were set up to handle the several hundred different types of fi les from third-party administra- tors such as Blue Cross, Blue Shield, Aetna and the many small regional groups. Pervasive Data Integrator pulls data from all of those formats, transforms the data to a standard format and validates the metadata against key data in the data ware- house.

Matt Cheatham is managing director of information systems and data management at APH. For more information on APH solutions: For more information on Pervasive Software solutions:

Several project requirements changed midstream, causing some concern that the six-week im- plementation time line would be missed. Andrews says of the pro- fessional services consultants, “We had an aggressive time line, yet everybody was super-professional and fl exible about all of our demands. Everything was turned around fast.” The result was an easy-to-use sys- tem for non-technical staff, without the high levels of expense, time and upheaval normally associated with major integration projects of this kind.

Results From the initial 20 to 28 weeks, new customer

on-ramping was reduced to nine to 12 weeks with fully automated validation, thanks to reusable Pervasive inte- gration components and the ability to handle virtually any format. “We only get paid when we’re providing analytics,” Andrews says. “Getting customers’ data in the system faster allows APH to provide the analytics faster, which leads to faster return of revenues.” “Replacing the outsourced ETL process with the solution from Pervasive cut APH’s new-customer load time in half,” says Andrews. In addition, automated quality assurance and error checking decreased loading existing customer updates from eight hours on average to only four hours.

Even as APH’s business has doubled in size, the

organization hasn’t had to add any new staff. The new data warehouse has become the hub of data integration in the enterprise providing better master data manage- ment, richer data segmentation and improved data and risk selection.

By discovering actionable data through data profi l- ing, predictive modeling and advanced analytics, APH can more accurately evaluate historical trends as well as project future health costs and risks, thus better meeting customer needs. This enables APH to provide proactive suggestions to its clients to mitigate some of the claims payments and improve the health situation of patients.

Planning for the future Nothing stays static in the current business climate,

so the Pervasive integration workfl ow was designed for change. Since the business-oriented APH staff has full in-house understanding and control of the integration processes, the group has been able to organically add on functionality since the initial implementation to expand the company’s business offerings. For instance, workmen’s compensation claims are now checked for “double dipping” and fraud through the ability to check new claims against previous claims in the data warehouse.

Andrews says, “Our client satisfaction improved tremendously … partly because they’re seeing that the data set we’re giving them is really clean. Now the APH system from Pervasive has become the system of source for our clients – they really trust our data.”


Page 1  |  Page 2  |  Page 3  |  Page 4  |  Page 5  |  Page 6  |  Page 7  |  Page 8  |  Page 9  |  Page 10  |  Page 11  |  Page 12  |  Page 13  |  Page 14  |  Page 15  |  Page 16  |  Page 17  |  Page 18  |  Page 19  |  Page 20  |  Page 21  |  Page 22  |  Page 23  |  Page 24  |  Page 25  |  Page 26  |  Page 27  |  Page 28  |  Page 29  |  Page 30  |  Page 31  |  Page 32  |  Page 33  |  Page 34  |  Page 35  |  Page 36