Bank system breaks the spreadsheet strangelhold

Deutsche Bank is poised to start using a highly scalable new global platform for credit risk and regulatory reporting.

Deutsche Bank is poised to start using a highly scalable new global platform for credit risk and regulatory reporting.

The in-house developed system, called dbArtos, should offer a long-term solution to meet the bank’s regulatory reporting obligations and improve the speed and quality of its data analysis by reducing a reliance on spreadsheets among users across its international offices.

The dbArtos platform has a front-end business intelligence reporting capability from MicroStrategy and an Oracle 10g back end running on IBM Power architecture.

It has been designed to take and load data feeds from all of the bank’s source systems, including reference data, and is capable of transforming feed data to produce outputs that meet global reporting standards.

Deutsche Bank began developing dbArtos last year when there were signs that its existing warehouse technology was close to reaching the limits of its capabilities and capacity.

The bank analyses its credit risks on a monthly production cycle, with data being loaded into the datawarehouse several times over the course of the month for interrogation and adjustment to ensure its accuracy.

Only once the bank is satisfied that its dataset is correct are final reports produced for internal management reporting and ultimately for regulatory purposes.

The dbArtos platform is set to be used by the 80 staff at the bank’s Frankfurt head office working in risk control and risk management. Despite the roll out their experience will not change because the MicroStrategy front-end is the same for both old and new systems.

dbArtos will be used in earnest for the first time at the end of July when the bank will run it in parallel with the current system. If all goes to plan, the older system will be switched off within a month.

A greater level of integration between the global data feeds and the platform should be in place before the end of the year. Deutsche Bank’s senior vice-president of risk control, Ulrike Andras, said this should reduce local users’ reliance on Excel for formatting and analysis tasks.

Vote for your IT greats

Who have been the most influential people in IT in the past 40 years? The greatest organisations? The best hardware and software technologies? As part of Computer Weekly’s 40th anniversary celebrations, we are asking our readers who and what has really made a difference?

Vote now at:

Read more on IT risk management