A healthcare insurance services provider within the United States and Canada wanted independent end-to-end validation of the accuracy and consistency of insurance eligibility data across multiple source and reporting applications. These applications were on various technology platforms including Lotus Notes and RPG/DB2, and were a combination of in-house developed and third party software. The organization did not have a formal QA capability, test environment and written business rules building out a data validation regression test.
The SPR onshore testing team focused on validating the integrity of healthcare eligibility data across the applications. Two of the client’s business analysts worked together with the SPR team to analyze the end-to-end flow of data across the applications under test and to create written documentation for field definitions within the databases and data mappings between screens, displays, reports, and databases. SQL queries were developed and utilized in data analysis and to select insurance policy holders based on business rules and scenarios for the regression test data. A reusable regression test case repository for end-to-end data validation was built within Microsoft’s Team Foundation Server (TFS) and Test Manager (MTM). SPR on-boarded the client to TFS/MTM by installing and configuring the tool, providing training to the client’s staff, and mentoring the client’s staff in test cases preparation, test execution, and defect reporting using TFS/MTM.
The identification of business rules and requirements during test planning aided in the creation of formal written documentation for application analysis, data validation, data mapping, field definitions, data flows and re-usable test cases. This documentation also provided value to developers in their future application maintenance activities. Data discrepancies discovered while building the end-to-end data validation regression test were investigated and resolved by the development team prior to becoming visible in production. The organization now has a re-usable data integrity regression test to monitor the accuracy of healthcare eligibility data and minimized data discrepancies across multiple applications.