Quality Assurance - BYO Checking

Delivering real-time analytical data.

The Challenge
American Bank, a regional bank in the Southeast, had a product called Build-Your-Own Checking, or BYO Checking. BYO Checking allowed clients to opt into a range of features to customize their accounts. One of the features was a cash-back option that was paid annually. The system had been in production for just a year when a major defect was found. A bug in the logic caused the system to incorrectly calculate eligibility for the annual cash-back payment after the first anniversary of the option selection, resulting in over $650,000 being incorrectly deposited into client accounts.

Although the bank was able to reverse the transactions the next day, it was still an embarrassing moment for the organization, and the option had to be disabled until the correction was made. We were engaged to find and correct the defect quickly, so that the bank could turn that option back on.


Our Approach
We had little documentation to work with, so we had to start from the beginning. The nightly process that incorrectly calculated the cash-back payments was part of a larger set integrated processes. The first step was to isolate the portions of the processes involved and build a test environment. Then we were able to script unit, system and integrated tests, and test from the beginning of the process. We validated each component until the defect was discovered and corrected. Finally, we performed regression testing to ensure no new defects had been introduced.

Software Technologies

  • SQL Server 2005
  • Informatica PowerCenter 7.x
  • SQLUnit
Results
BYO Checking was quickly corrected and deployed. The bank was able to enable the popular option, and no further issues have been reported.