The corporate banking division of Bank of Scotland is preparing a major overhaul of its accounts processing systems after bedding in a new datawarehouse.
The accounts processing update, which will begin early next year, will be one of the biggest information management projects yet at Bank of Scotland Corporate. The bank is increasingly using datamarts to perform data transformation and analysis to meet regulations such as Basel 2, and for other business requirements.
The datamarts enable individual divisions within the bank to run reports against specified datasets on a self-service basis, rather than relying on technical staff. In most cases, reporting is carried out using business intelligence software from Business Objects.
Providing support for the new accounting system is one of many datamart projects at the bank. It has been running a project-based datamart programme for three years, after deploying IBM's Websphere Datastage in 2003 to populate its datawarehouse. So far, 20 datamarts are up and running, with a further 25 planned over the next two years.
Mark Graham, a project manager at Bank of Scotland Corporate, said getting the most out of the accounts processing system was the biggest challenge yet for the datamart programme, which was established to meet a pressing business need to automate the generation of regulator friendly outputs.
"When we were looking to develop this capability, we knew we wanted something that would satisfy not just us but the regulator. It needed a platform that was reliable and one that satisfied the Financial Services Authority that a robust solution was in place which included a clear audit trail showing the provenance for all data," he said.
The bank's Datastage system sits on a Unix platform running an Oracle 9i database.
Read article: Tote reaps data benefits
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: www.computerweekly.com/ITgreats