Royal Bank of Scotland Plc

The Forest project involved upgrading the Group Risk Data Warehouse to handle increased data loads after the merger with the National Westminster Bank.

Upgraded various data feeds to fit the new data architecture. This included building new unit test modules (for which I designed and built a unit test generator which was used throughout the project) and updating the technical specifications.

Wrote test specification documentation and built generic scripts for use in integration testing. Performed integration tests on various data feeds and applications of the new warehouse.

Hardware Used

  • Compaq DeskPro client PCs
  • Hewlett-Packard 9000/889 servers

Software Used

Version

UNIX HP-UX B.10.20
B.11.00
MS Windows NT 4.00.1381
Oracle Oracle7 Server 7.3.4.4.0
Oracle Oracle8i Enterprise Edition 8.1.6.0.0
8.1.7.0.0
Oracle PL*SQL 2.3.4.4.0
Oracle SQL*Plus 3.3.4.0.0
8.1.6.0.0
8.1.7.0.0
Oracle JServer 8.1.6.0.0
8.1.7.0.0
Toad
Merant PVCS 6.6.10 (build 870)
Perl 4