Alliance and Leicester Bank

Summary

This assignment at the bank was concerned with systems integration and the further development of web-based bank account application.

I took responsibility for the end-to-end delivery of the following projects:
Extend the Online Application system to receive applications from Direct and Branch clients in addition to the Web channel. This is a commercial Internet application for the capture and processing of account applications.
Adjust the architecture of the Online Applications system and the Automated Account-Opening workflow system to reduce the time and effort required to introduce new products. The application processing and account opening packages are now table-driven.
Convert an hourly fraud-risk management activity to use the Synectics/SIRA package.
Write a suite of XSL transforms to provide statistical reports in HTML format. This required an understanding of computational stylesheet development.

Each project required liaison with management, developers, and testers, both within the bank and in the various third-party suppliers. It also required the production of a range of documents, typically including: Solution Description, User Guide, and Operating Procedures.
Skills
Visual Basic 6, ADO, and RDO
SQL/Server 2000 and T-SQL for stored procedures
Oracle 8, SQL, and TOAD
XML, XSL
Microsoft Office (Word, Excel, Outlook)
Visual SourceSafe

Achievements
As a result of adding the extra channels for online account applications, the proportion of Commercial Bank account applications coming from online sources increased from 30% to over 90% in the space of a few months.
Following implementation of the parameterisation work, the time required to introduce new products to market was reduced dramatically, because only table changes were required. This paved the way for the introduction of the Base Rate Beater and Business Instant Savings products.
Helped the bank to reduce fraud risk by implemenation of the Synectics/SIRA solution.