CURRICULUM VITAE 

Personal 

Date of birth:      9 May 1952                                                                  

Qualifications and Education 

Professional

Qualifications     1990                 British Computer Society Part 1 Certificate

                        2003                 Mercator Core Consultant Certification 

Education          1959 - 1963       Wykeham Primary School, Neasden, Greater London

1963 - 1965       Preston Manor County Grammar School, Wembley, Middlesex

1965 - 1970       John Kelly High School for Boys, Brent, Greater London                       

Languages:       English, Dutch 

Career Summary 

Apr 2003 – date     Independent Consultancy                              DataStage/[snip]

2001 – 2002           [snip], London, England        Consultant

1998 – 2001           [snip], Eindhoven, The Netherlands             Systems Analyst

1986 – 1998           [snip]                               Higher Executive Officer (IT)

1970 – 1986           UK Ministry of Defence                                 various administrative appointments 

Profile 

Career Detail 

 Having achieved Mercator Core Consultant Certification, [snip] established his independent consultancy in April 2003 to offer his Mercator/DataStage mapping and interface development skills more directly. His clientele has included:  

Development of DataStage TX (v8.0) maps to corporate standards for the transformation of messages between XML and flat files in support of the bank's migration to the Single Euro Payments Area (SEPA) initiative. 

Designed and implemented a bidirectional DataStage TX message handling system involving transformation between flat files and XML to run on an HP-UX platform using MQ Series transport with comprehensive logging, error trapping and email user alerts fully integrated with a corporate architecture monitoring system. 

Returned at the specific request of IBM for a second assignment providing expert Mercator support to the UAT programme of a multi-interface system for the core banking business. He also developed Mercator interfaces for an Active Directory/SQL Server system for the HR department,    

Within a limited time window [snip] designed, developed, implemented and demonstrated a real-time interface solution running on an AIX Unix platform integrating the client's Advantex workforce management system with the SAP R/3 back office system of a prospective customer for a competitive bid.

Completed a project to redesign, modify, test and implement updated systems of maps, migrating from Mercator to DataStage TX. [snip] also provided rostered 24/7 on-call support for message- and file-based interfaces in a complex pan-European environment between SAP R/3 and bespoke systems.

Designed and developed systems of Mercator maps running on Windows 2000 servers interfacing legacy and new systems to a deadline of new legislative requirements. Advised on QA procedures and standards and provided mentoring services to client staff.

Advised and assisted development teams achieve a corporate EAI solution integrating core SAP Enterprise v.4.7 with  legacy systems with Mercator maps providing routing and transformation via a Logical Message Format (LMF) in XML to ensure future flexibility.

For this client [snip] “hand-crafted” Mercator type trees and developed maps for real-time interfaces between Windows-based client processes and mainframe legacy systems via Candle Roma workflow management and MQ messaging services. He conducted data analysis and design contributing to corporate standard schemas and DTDs for XML message set data structures.

 From February 2001 until December 2002 [snip] was on the staff of the [snip] practice based at their London City offices. His functions were the development of Type Tree data descriptions and the design, coding, testing and tuning of systems of Mercator maps for data transformation. He also provided mentoring services to client staff. His assignments included: 

[snip].: Member of a Mercator team developing an application for the UK Home Office for  secure data transfer between remote Oracle databases in XML format via HTTP. Developed maps incorporating dynamic SQL queries to ensure referential integrity. 

[snip], CH: Member of an international interface development and code validation team for GLOBE; a global EAI project routing and transforming data in ALE and EDI IDocs transmitted via IBM MQ Series between SAP R/3 and legacy systems.  

[snip], CH:  Devised the monitoring, logging and error reporting facilities of a Mercator implementation for this Swiss bank. His solution provided real-time audit logging with colour-coded reports generated in HTML for review in a web browser. 

[snip], Luxembourg City, LU: Member of a Mercator team assigned to the design and development of an application to transform SWIFT messages from ISO 7775 to 15022 standards for this banking client. 

[snip], Amsterdam, NL: One of a small team of Mercator consultants responsible for the development of a middleware solution transforming data between SWIFT and email messages for this securities broking client. Performance tested and tuned the application. 

 As the company’s senior Mercator practitioner, [snip] designed and implemented interfaces between the company’s MARC warehouse management product and client’s SAP systems.  

Promoted Higher Executive Officer and qualifying as IT Specialist, [snip] worked on several major projects progressing from Maintenance Programming Team Leader to Senior Analyst. A sequence of roles provided experience of a wide range of techniques and technologies including business analysis, relational database design and project management. 

 A series of administrative appointments encompassing promotion from Clerical Officer to Executive Officer and including a tour of duty in the Falkland Islands.