“Our MI (Management Information) systems are the basis for critical executive decisions. From calculating payments, to evaluating discounts, to assessing the impact of regional developments, the company’s ability to reduce risk and drive new business hinges upon the accuracy of the data underlying our highly data-driven processes. The ability to automatically expose data impacts—as soon as they enter our systems—is vital to maintaining our competitive advantage, as well our regulatory compliance.”
— Stephen Fishwick, Director, Head of DWH, MI and Archiving, Enterprise and Data Solutions at RBS
Background
In the banking industry, “move fast and break things” is not an option. Across every customer transaction, regulatory report, and strategic investment decision, absolute accuracy is imperative.
During their most recent risk review, RBS Services (Switzerland) Ltd IT leaders observed that the growing scope and complexity of their application landscape warranted a more automated approach to identifying data impacts. It was becoming increasingly difficult to manually pinpoint all the potential impacts of each change—and their commitment to doing so was consuming resources allocated for regulatory reporting and system innovation.
Challenges
The Tricentis Solution: Automated regression testing for Data Warehouses and ETL processes
To ensure that potentially far-reaching change impacts were identified immediately and efficiently, RBS Services (Switzerland) Ltd launched an initiative to automate regression testing across their data warehouse and its various ETL processes.
For several years, the company has been using Tricentis to ensure the continued integrity of UI-driven scenarios across their core banking solution (Avaloq). When they decided to extend their test automation initiative to the data layer, they contacted Tricentis. Following an extensive pilot that covered 15 use cases ranging from Avaloq data validation to SAP BusinessObjects security tests, they selected the Tricentis solution to automate their BI/DWH testing.
RBS Services (Switzerland) Ltd is already up and running with a core set of tests that automatically cover their most pressing risks. With this automated approach, data regressions are exposed more efficiently—and much earlier in the project lifecycle.
Solution details
