Five years ago, the EIB undertook a major upgrade of its Wallstreet Suite system. This was a complex project, involving many business-critical steps. As an example, all outstanding transactions on borrowings and treasury portfolios needed to be cleanly and securely migrated to the new system.
Thorough testing was essential to ensure correct configuration of the system and the integrity of the migrated data. But testing everything manually proved very timeconsuming and costly, explains Pavel Harvanek, leader of the Borrowings and Treasury Functional Support team, EIB: “We had more than 500 different test scripts and we needed to run each script three times during the product testing phase and twice more during user acceptance testing. Manual testing is not only slow, but also error-prone, leading to the need for re-testing, and additional work and delays. In fact, the upgrade project took over a year to complete, with a significant part of this time taken up with manual testing.”
As a result of this experience, Harvanek and his team wanted to find an automated testing solution which would reduce costs, save time and improve accuracy during future upgrades and the many other projects his department undertakes. It also made sense to build a re-usable library of test cases and scripts, to capture the learnings from the upgrade process and save work in the future.
After careful research, OmniFi was selected as the optimal solution for automating the testing process, because it delivers speed and accuracy, but also because it is simple to use. Lukasz Wojtukiewicz, Project Manager, Borrowings and Treasury Functional Support, EIB, explains: “With OmniFi, there’s no coding required, so we can prepare and run the testing independently within our department, without the need for additional IT resources. It really helps us to avoid a resource bottleneck and save costs.”
A cost-benefit analysis showed that licensing OmniFi would deliver pay-back to the EIB after just one major project, as a result of time and resources saved through automation.
Initially SkySparc supported the team with advice on how to get the most from OmniFi and helped with developing templates and a structure for the test case library. “SkySparc’s consultants are very knowledgeable and we were able to learn best practice from their experience,” comments Wojtukiewicz.
Although the primary reason for licensing OmniFi was to automate testing, it soon became clear that the software was very flexible and suitable for automating many other tasks too. When the EIB decided to migrate a portion of its Treasury portfolios into a new structure, it was decided to use OmniFi to automate migration of the data, closing the transactions in the old portfolios, re-opening them in the new portfolios and then running the regression tests.
OmniFi is very easy to use and very flexible; we can use it to generate almost any type of script, which will make it very valuable in many different projects in future, not only upgrades.
Pavel Harvanek, leader of the Borrowings and Treasury Functional Support team, European Investment Bank
This was an important and highly visible project that impacted right across the organization, with up to 50 users running validation reports during the User Acceptance Testing. The value of the transactions migrated was around €3.5 billion.
The automated migration and validation processes were smooth, efficient and fast, resulting in a very successful project. Says Wojtukiewicz: “At go live, we ran all the validation scripts in just five hours – a fraction of the time it would take to do this manually.” Harvanek adds: “OmniFi is very easy to use and we also found it very flexible; we can use it to generate almost any type of script we need, which will make it very valuable in many different projects in future, not only upgrades.”