Test Management – Zero Defect Leakage
Background
The PRA requisitioned new reporting for this tier one bank to track the performance of a facility over a specified period of time. The Forbearance Workstream was mobilized as a result. The timelines for delivery were strict, the module was complex and functionality was not properly defined. Given that this was a regulatory reporting requirement it was imperative that the delivered solution was free of defects before reaching the UAT environment and remained so. ACS was engaged to deliver the end to end reporting solution for Forbearance.
Approach
- All ACS teams (BA, Development and Testing) worked cohesively using the Agile methodology for requirement gathering, development and testing to deliver the workstream.
- Domain knowledge, requirements and design focused sessions were conducted, so that the technology team fully understood the needs from the business users’ perspective.
- A review process for all phases (Requirement, Design, Development & Testing) was conducted and adhered to.
- Knowledge sharing sessions for architecture, data flow and system flow were conducted ensuring the team delivered in line with business expectations.
- Exit and entry criteria for each functional feature were reviewed with the business.
- Root cause analyses for all defects were shared with both the development and the testing teams to ensure that repeat errors were NOT committed.
Solution
- OFSAA for loading data from external source to the system tables.
- Oracle and TOAD used for ETL across all the layers during reconciliation process.
- OBIEE for building reports as per specifications.
Data Verification
- The development team ensured that unit test cases provided full code coverage to pick up issues during the build phase.
- The Testing team only started writing test cases once the functional specification (FS) had been reviewed.
- The team initiated execution of ETL test cases and data was compared thoroughly at each layer (i.e. stage, transform, fact) for data validation and data verification.
- All issues were discussed and raised with the ETL team including evidence and possible cause for early closure.
OBIEE Report Verification
- All reports were compared with SQL results, including drill-down details to a granular level.
- Defects were discussed and raised with the reporting team and were supported with evidence and possible cause.
Note: Once the system test cases were created the testing team worked with the business users to provide critical UAT scenarios, which could then also be tested during the SIT. This helped in early detection of possible issues.
Benefits
- No Defects found by the UAT team.
- Module was delivered to the client before time, with all required test cases and evidence.
- Communication was very effective between the various teams, an excellent working relationship was established.
For more information about how we can help you please contact us
Vijay Jadhav
Director
Managing Consultant
BI Architecture
Recent Case Studies
Extensibility & Scalability of Data Warehousing
In order to minimize bad debt volumes, this…Read more
End to End Data Warehouse Testing (FDSF)
The PRA initiated an industry-wide programme called FDSF…Read more
Delivery that counts
Our track record for end to end delivery speaks for itself. In our short history, we have delivered some of the most complex business and IT change across some of the worlds largest organisations. Our people are happy and so are our clients. If you would like to know more about a career in ACS please click here.