Home Page Image
 

Specialises in two particular areas: the ETL (Extract, Transform and Load) tool Datastage; and in the Pick operating system / relational database in similar flavours such as Universe, UniVerse, Reality, D3 and advanced Pick.


 
  

 

History

Please click on headings below to expand descriptions of work history performed.

 

July 2013 to the present - Brakes Group

Analysis, development and testing using DataStage Enterprise Edition version 8.7 on a Data Migration project to facilitate a change in Business practices with respect to the Pricing module along with Brakes' upgrade to SAP ECC6..

September 2012 to July 2013 - IBM UK at HSBC

Analysis, estimating, development in DataStage Enterprise Edition, unit and system testing and documentation of new change requests in the Asset Servicing and Custody Data modules. Extensive use of TOAD and UNIX shell scripting as well as DataBasic routines.

January 2012 to July 2012- IBM UK at Weir Group P&I

Development of new Management Accounting reporting system importing data from a number of DB2 iSeries and SAP systems (via SQL Server), using DataStage Enterprise Edition 8.7 on Windows, into a DB2 warehouse staging area for import into a COGNOS reporting suite. In-depth analysis of requirements with client, associated development and stringent testing and documentation.

October 2011 to December 2011 - Sopra Group

ETL analysis and development work using DataStage version 8.1 and SQL to populate Oracle tables with Mortgage data for reporting purposes for Tesco Bank.

November 29, 2010 to December 2, 2010 - IBM UK

Give DX444 DataStage 8.1 Enterprise Edition course to Lloyds TSB at the Training Centre in Edinburgh.

October 2008 to July 2011- DOT Group

ETL analysis and development work at Brakes Group using DataStage version 8.0 then 8.1 to extract and import IDocs from and into SAP, and data from and into other sources for a message broking / ERP system (written in DataStage) . The staging area is based around Oracle 10g tables and DataStage datasets. Partake in exhaustive development, testing, bug fixing, UAT and documentation. This very complicated solution made full use of v8 functionality in Sequences and Jobs, incorporating SQL and UNIX scripts in a real-time and reactive environment.

March 2008 to July 2008 - CDS Global

ETL Development work using DataStage version 7.5 to create and populate a number of Redbrick data marts from the Informix source systems and / or the Redbrick data warehouses. Incorporated automatic address/PAF functionality using the Cygnus software into the warehouse refresh process.

November 2006 to December 2007 - Nordea in Copenhagen

Development and maintenance work using DataStage version 7.5 to populate a SAP database with data from a large number of the Bank’s databases, complying with the Basel2 EU Directive

November 2005 to October 2006 - IBM (at Department for Environment, Food & Rural Affairs)
Development work using DataStage version 7.5 to populate an Avian Influenza Oracle data mart from a number of sources, transforming the data through various databases into the output data model format. Includes working with SQL, Oracle stored procedures, Business Objects reporting and UNIX scripting
March 2005 to October 2005 - Rural Payments Agency
Development project to take extracted RPA data from high volume XML files, using the DataStage XML plug-in, validate and transform the data into various streams, and populate the existing UniData file system
July 2004 to February 2005 - Associated Newspapers Limited
Development of a new Unix-based, Oracle Data Warehouse for Associated Newspapers’ Advertising data, which is continuously updated using DataStage version 7 and Oracle stored procedures
May 2004 to July 2004 - DHL in Copenhagen
Work on the final stages of a pilot project building interfaces in DataStage version 7 to load data into SAP financial applications using IDOCS
April 2002 to April 2004 - Department for Environment, Food & Rural Affairs
Analysis, definition of mapping and validation rules, and coding using DataStage 6.0 to convert and migrate three of DEFRA's legacy systems' (SQL Server and UniData) data into a new Oracle-based application
May 2001 to March 2002 - LeasePlan UK Limited
Analysis, design and coding using DataStage to convert and migrate Dial UK's RPG application data to the LeasePlan AS400 system
June 2000 to April 2001 - Infercor A/S
Product Development Manager involved with the support and enhancement of the Infer eCRM application
March 2000 to May 2000 - McGraw Hill Limited
Analysis, design and coding of bespoke reports and enhancements to the Publishing application functionality
December 1996 to February 2000 - Trilogy Computers Limited

Helpdesk support analyst providing support of Publishing and Manufacturing applications running on Pick and UniVerse databases on a variety of hardware


August 1998 to July 1999 - Dun & Bradstreet
Development work using IBM's DataStage tool as part of a project to convert German data from a Mainframe to an SQL-compliant database