PERSONAL DETAILS

Address: 116 First Avenue Date of Birth: 12 July 1971

Lancing Nationality: British

West Sussex Status: Single

BN15 9QE Driving License: Full

Telephone: (01903) 851766

Mobile: (07710) 917775

SPECIFIC SKILLS

O/S: Windows95 / 98 / NT, UNIX.

Development: Oracle 8i, Oracle 7.3, PL/SQL, SQL, Pro*C, Designer 2000, Developer 2000, Visual Basic 6, C++ (MFC), Pro*C, HTML.

EXPERIENCE

May 1998 - British Airways Plc.

Present Hatton Cross, Heathrow.

Dept: I.M. Commercial

Position: Oracle Analyst Programmer (Contractor)

Responsibilities: To work as part of a 4 man team given the task of designing and implementing British Airways’ approach to Phase 1 of the Cargo 2000 initiative. The prewritten user requirements were taken and in-depth analysis undertaken to produce a Functional Specification. Full design of the database was achieved using the Designer 2000 toolset and a Technical Specification produced. Full development of the Server-side database packages used to process and manipulate the incoming freight messages was undertaken by myself along with the creation of any views needed to support the ASP based, web front end. The whole process took 8 weeks and the finished product allowed British Airways to become the first airline to attain Phase 1 Cargo 2000 accreditation.

To design and implement a Windows utility to enable users to view a selection of data from the British Airways messaging hub. This utility was written using Visual Basic, connecting to the Oracle database using ADO. The front end was tab based, utilising a different tab page for each of the views required. A number of screens were included to allow the user privileges, who can see what data, to be maintained.

To design and develop a central messaging hub capable of communicating data messages between a variety of systems. Requirements were met for efficient stripping of delimited text messages from a BA legacy system, BA80. The data from these messages is stored in an Oracle database and the data then passed on to other Oracle systems such as the Freight Handling Control System.

Communication between these systems is handled by IBM MQ/Series. My remit included full design of the interfaces between PL/SQL and MQ and also MQ and Oracle. The first is written in PL/SQL using the Oracle Procedural Gateway (OPG) and the latter is written using Pro*C. Requirements involved converting Oracle record structures into XML tagged strings and placing onto an MQ queue; also removing XML tagged messages from the MQ queues, processing into Oracle record structures and passing to Oracle stored procedures.

Full design and documentation of this application was produced using the Designer 2000 toolset.

Design and implementation of an Oracle Forms based Error Handling System. Errors from all areas of the overall system pass XML tagged error information to be parsed and stored for user interaction. Complete history and audit trail information is kept for future use. A daily archiving process copies data from the live system to an offline warehouse where it can be processed by the business.

May 1997 - Virgin Atlantic Airways.

May 1998 The Office, Manor Royal, Crawley Business Quarter, Crawley, W.Sussex. RH10 2NU

Dept: I.T. Development

Position: Oracle Analyst Programmer

Responsibilities: To develop key areas of Virgin’s Freeway application (the Frequent Flyer Loyalty Programme), including Forms, Reports and PL/SQL packages, both in Libraries and stored on the database.

To analyse, design and implement the migration of all legacy data from a Clipper based application to the Oracle database underlying Virgin’s Freeway application. A task taking five months to develop and a total of four days to transfer the data (a member base of some 520,000 records).

Sept 1993 - Shanks and McEwan (Southern Waste Services) Ltd.

May 1997 Woodside House, Church Road, Woburn Sands MK17 8TA

Dept: I.T. Department

Position: Oracle Analyst Programmer

Responsibilities: Overall development of a new operational system using Oracle Forms 4.5 and Oracle Reports 2.5 over 3 distributed databases. Initial analysis and subsequent design using Designer/2000. Co-ordination of error reports and bug fixing throughout the test phase.

A comprehensive invoicing module utilising Oracle Financials 10.5, written mainly in Pro*C. Included collation of data from the operational Oracle database, invoice production and posting of information to Financials.

EDUCATION AND QUALIFICATIONS

Sept 1989 - The Nottingham Trent University

June 1993 B.Sc. (Hons) Computing Science, Second Class Honours (1st Division) obtained

Sept 1982 - Gaywood Park High School, King’s Lynn, Norfolk.

Jun 1989 GCE A levels - Computing (B), Electronics (C)

GCE O levels - English (C), Maths (C), Computer Studies (C), Technical Drawing (C), Physics (C), English Lit. (D), Geography (D)

TRAINING

Oracle Training Services

Jul 1995 - Oracle Forms 4.5 Essential Techniques

Aug 1995 - Oracle Reports 2.5

Learning Tree International

Jun 1995 - Hands-On Windows Programming

Jun 1995 - Introduction to Client/Server Computing

Jun 1995 - Client/Server System Design & Configuration

Sept 1995 - Relational Databases: Design, Tools & Techniques

Nov 1995 - Distributing Data in Client/Server Systems

Dec 1995 - Oracle 7 for Application Developers: Hands On

May 1996 - Hands-On Visual C++: Windows Programming with MFC

Jun 1996 - Complex SQL Queries: Hands-On