• System design using Designer 2000 and PRINCE 2 to ISO 9000 standards

• Experienced Oracle 8 DBA for large 100GB+, 300+ user systems and new installations

• Designer 2000 modelling and generation of Oracle Forms applications

• Developer 2000 including Forms 4.5 and 5.0, Reports 2.5 / 3.0 and PL/SQL procedures

• Intranet design using Oracle Web Server producing dynamic HTML pages plus Java Script

• Experienced Oracle development team leader

• HP, AIX & Alpha Unix, VAX (VMS), IBM 3090(VM & MVS) & OS/2, Windows NT 4.0, Linux

• Interfaced Oracle via ODBC, JDBC and Oracle Objects to Visual Basic and Java

Design and development of a credit scoring engine for Newcourt Finance accessible via two different applications: a) Oracle Web Server using PL/SQL packages and b) a VAX based legacy system via Java and Oracle Pipes. The legacy system interface is achieved using CORBA compliant ORB’s that allow Java access to data in both directions. Working to extremely tight timescales, the European Credit Service was implemented successfully during June, with multilingual versions being rolled out during this summer in Milan, Frankfurt and Paris.

• Designed using Erwin software tool for entity – relationship modelling

Support for multiple on going web site developments including Bath Ales Brewery Site and The Trail Riders Fellowship site.

Design and development of a financial Intranet solution for British Telecom using Oracle Web Server and PL/SQL packages to produce dynamic HTML pages which include Java Script functions. The Database server is a 10 processor DEC Alpha machine running DEC Unix. My role has been to model the current accounting system using Designer 2000 and produce modular PL/SQL code and Java Script that performs well against a 0.5 Terabyte Data Warehouse.

• Use Designer 2000 to model the table structures and modules required

• Manage a Designer 2000 repository on a Windows NT Server using Enterprise Manager

• Write PL/SQL packaged procedures and functions that produce dynamic HTML

• Write Java Script procedures to validate user input and improve the Web user interface

DBA and development team leader at Subscription Services Ltd for a high availability 300+ user Oracle 7.2.2 telesales system running on an HP Unix machine. My role was to transform business analysts application requirements into practical physical designs that perform well on the infrastructure available at this ISO 9000 approved site.

• Customer facing support of business analysts at design reviews

• Design and maintain tablespaces, users and data structures

• Design, implement and test automated backup routines and install Unix UPS’s.

• Set up Visual Basic applications accessing Oracle via ODBC and Oracle Objects

• Write PL/SQL server side packaged procedures and functions called from VB applications

• Give performance tuning advice to application developers to optimise SQL code

• Use Designer 2000 to model then generate a Forms 4.5 project budget database

• Set up an INTRANET Web server to access dynamic HTML pages from Oracle 7.3

• Use replication snapshots to set-up a distributed database across a TCP/IP network

employing SQL*Net links to Oracle 7.3 on a Windows NT server used as a data archive.

Design of Gas spot market dealing database for National Power using Oracle 7.2 on a Unix AIX platform. Oracle Forms 3.0 application accessed via Windows TCP/IP Telnet sessions.

• Bulk data handling routines using SQL*Loader and packaged functions / procedures.

• DBA and performance tuning tasks undertaken during application acceptance.

DBA and design of Oracle 7.0.16 client/server OS/2 database for NPI Pensions used to store telesales data for a new pension scheme. Win OS/2 clients accessed via SQL*Net.

• Design and implementation of database backup and disaster recovery strategies

• Liaison between users and system administrators to optimise the configuration

• Developed output reports using Oracle Reports 2.0 and Oracle Data Browser

• Prepare and deliver training sessions to users and a trainee DBA

• Design and implementation of interface from Oracle to Sedgwick Noble Lowndes for payment of pensions via the "BACS" system.

Systems analysis for Unicorn Consultancy Services Ltd., formerly Property Services Agency.

Database used to control budgets on multi-million pound commercial building projects.

• Oracle CASE methodology used to design this VAX VMS based system

• Data analysis, design and build of an Oracle 6.0 / Forms 3.0 application

• Output reports written using SQL*Report (RPT) and ReportWriter.

Design and development of an engineering database for the European Space Agency

• Built up and lead the four man design team.

• Data structure and applications designed using Oracle CASE methodology

• "Porting" of Forms to IBM 3090 mainframe environments running both MVS and VM

• Design and integration of Microsoft 'C' based data collection and graphical display tools