Following solvability provisions, which implement Basel II into the German law, banks are obliged under the framework of applicable disclosure requirements to identify their demand for equity capital based on individual transactions. Furthermore, they have to be aggregated and then transferred into the required disclosure forms to the federal bank (Bundesbank). Banks can choose between the standard approach (KSA) and the significantly more complex internal ratings-based approach (IRBA).

The customer, a mid-size mortgage bank, applied a custom developed software (here considered as the "equity capital calculator") to identify the demand for equity capital. To fulfil the conditions of the whole group, the KSA-approach as well as the IRBA-approach needed to be fully supported. The test was composed of 23 detailed disclosure forms with a total of approx. 2,000 fields that had to be filled. In order to fill in these disclosure forms, a disclosure software (payment solution) was utilized. Via an interface, the disclosure software was provided with information concerning all of the bank's business operations that were relevant regarding the equity capital and with the results of the equity capital calculator. Partially, the disclosure software calculated the results anew using the entered data and remained a "black box" from the client's perspective.

The challenges

An examination of the forms was impossible for the specialists department due to their available ressources (very good business know-how but almost no technical skills), resulting from the fact that the forms included only strongly condensed results. The scale and complexity of the forms made a manual plausibility assessment very time-consuming and a solely manual review was practically impossible, since strict deadlines had to be kept for the delivery and release for production. The availability resources (regarding staff and finances) were very limited.

The solution

The Finaris consultants realized the following approach:

• Development of a business specification for displaying the calculation results inside the disclosure forms, regardless of the applied disclosure software. The specification is the basis for identifying the filling target of the disclosure forms for any given number of business transactions.
• Realization of the target filling disclosure form, based on RapidRep and the business side specification.
• Realization of an automated alignment between target and actual filling of the disclosure forms supported by RapidRep and a variable RapidRep test report for the display of deviations from individual form spaces. On each disclosure form space the deviations must be exhibited both as a total and based on individual transactions to ensure an efficient error analysis.

The business side specification for filling the disclosure forms  directly based on the data of the equity capital calculator was the only possibility for the specialists department to create an exact target for the illustration of a business transaction. A target for the interface filling of the standard software would not have been possible, since the final result - filled in disclosure forms - was to be tested and no intermediate result was available for detecting errors in the standard software.

The two Finars consultants prepared the business side specification within four weeks of intensive cooperation with the specialist department. The structuring functionality of RapidRep enabled a redundancy-free implementation of the specification as well as a clear exposure of the business side requirements in the implementation.

For the purpose of automating the target-performance comparison, summary tables of the disclosure software have been prepared using RapidRep in such a way that it was easily feasible to compare the processed data from the equity capital calculator on the basis of individual transactions.

The success

Not withstanding intense budget restrictions and an upcoming short-term production launch, with the support of RapidRep the test was conducted in a remarkably good quality with the support of RapidRep. As opposed to often customary random sampling tests, the entire productive data inventory (that is the entire portfolio relevant to equity capital on the basis of individual transactions) was tested. Thus many errors were detected in the interface to the disclosure software and in the disclosure software itself.

The authors of the report definition were not distracted by technical aspects, but could concentrate purely on the correct business side implementation. After four weeks already the project team was able to focus completely on the analysis of the deviations and on the detection of error causes.

The business case was an example for testing a software process that had the particular difficulty of combining business side and technical complexity. In practice such projects are usually associated with very high costs and risks. By using RapidRep the business and IT departments were now capable of cooperating extremely well. By means of the business side specification the business department always had complete control over the targets for filling in forms. Through the many structuring possibilities offered by RapidRep very complex SQL commands (with partially several hundred lines of code) were very clearly defined. Furthermore, the to-be-implemented logic of the business side specification in the report definition was structurally recognizable almost 1:1 in RapidRep.

Thanks to RapidRep it was possible to decrease the work invested into the test by more than half compared to conventional approaches as the activities were reduced to a minimum and then could be distributed optimally among business and technical personnel.