Neil Guild

Experience

• 

  S2 Systems International

  Apr 2001 - Jul 2002

  Senior A/P Team Leader

  General maintenance (involving production support on a rota basis) and enhancements of ON/2 financial payments system running on STRATUS and a communications and mapping systems developed for a Travel Industry client (Worldspan) running on an RS/6000 (AIX 4.3) utilising EDIFACT standard messages. Lead a team of 3, providing technical guidance to 2 junior staff, until being made redundant on 19th July (due to depressed World economy). Mapping between client host system proprietary screen format and IATA EDIFACT effected using API calls to Mercator main map from within NeT/X modules (S2 multi-tasking real time communications software) written in C.Mercator mapping written and maintained on NT utilising complicated functional maps and rules to ensure smooth translation of data before porting to RS/6000 format within Mercator Map Designer. Small project undertaken (utilising Microsoft Project) to convert client maps from Mercator 1.4.2 to 5 to overcome problems with converting certain data patterns from the original clients screen formats. Extensive shell scripting constructed to effect file transfers and for map execution and general daily/weekly housekeeping on the RS/6000 and for the completion of the version upgrade (1.4.2 to 5). XML front end to the screen based input for the Worldspan system undertaken for the benefit of a number of Worldspan clients, which involved careful construction of the Mercator Type Trees to represent the XML format and then appropriate rules to manipulate between the different formats.Evaluation of Mercator version 6 undertaken before the conversion to version 5 to ensure redundancy of such an upgrade. Exposure to C++ during the writing of a LINK simulator for OpeN/2 testing/demo purposes. Show less

• 

  Phillips Electronics

  Jan 2002 - Jan 2002

  Mercator (now WTX) Consultant

  Mercator consultant working on the mapping of logistics data between EDIFACT and IDoc format for Philips SAP systems running on NT and AIX utilising MQ Series as the transport mechanism. Converted the majority of Philips maps from 1.4.2 to 5 in a team of 4 and also developed some maps to convert between XML and IDoc running under Mercator 5, involving synchronisation of IDoc formats with Mercator type trees (for EDIFACT) to ensure correct processing within the SAP system. Good communications channels to the SAP staff imperative for general design issues and live problem solving.All mapping work done under NT then ported to RS/6000 format. Maps proved under NT ensuring exact match between new and old data, then tested under AIX utilising complex shell scripts for map executions and movement of documents to/from correct locations.A new factory was added to Philips systems during this contract which necessitated painstaking updating of translation tables and rules and regression testing. Show less

• 

  National Australia Group

  Apr 2003 - Jul 2003

  DataStage TX (now WTX) consultant

  Mercator consultant working on the mapping of data between legacy CICS Cobol systems and XML for a pilot Java Front end system. The message sets for each transaction were developed using XML Spy 5.4, which was also used for documentation purposes via XML Schemas, then taken through a local approval meeting before being submitted for global approval (branches in Australia, New Zealand and England) to ensure maximum reusability. Type trees were developed by importing the schemas generated from XML Spy, along with the associated legacy COBOL copy books, into the Type Designer. The maps for each transaction were then developed within the Map Designer, involving use of functional maps and EXIT routines to manipulate the data into the correct format. Source control of the Mercator source and executables was effected under NT using Harvest. System testing was undertaken by exporting the map to Unix format then ftping the executable map to the Solaris. Routing of messages on the Solaris machine was controlled by setting up appropriate business services and elements within ROMA and the manipulation of ROMA specific data within the execution of each Mercator map within the business flow. Show less

• 

  DHL Supply Chain

  Oct 2003 - Feb 2004

  DataStage TX (now WTX) consultant

  TX consultant working on the reengineering of existing communications interfaces between Exel and 5 clients who were using FTP as a transport medium and Access databases for data manipulation to FTP/Mercator/Oracle. Time consuming research necessary to unravel existing, poorly written, Access database routines and then translate into specifications for reworking under Mercator, utilising database adapters for the interface to Oracle tables. SQL extracted from the Access routines had to be reworded to compile the resulting stored procedure successfully under TOAD. Parallel running was the format for system testing to prove reworked link against existing legacy link after initial unit testing. Show less

• 

  Pink Roccade

  Feb 2004 - Jul 2004

  DataStage TX (now WTX) consultant

  TX consultant working on the integration of Mercator/SAP/Oracle for a new system for Booker. Significant use of systems constructed using the Database Interface Designer and Integration Flow Designer, using FTP/Email/MQSeries adapters to effect communications. All maps unit tested under Windows then AIX before deploying to the live AIX system. Performance issues with the communication to/from MQ queues addressed by buffering the transfer of messages.

• 

  Bradford & Bingley

  Jul 2004 - Oct 2004

  DataStage TX (now WTX) consultant

  TX consultant working on a management information reporting system integrating SQL Server 2000 with DataStage TX to facilitate Daily/Weekly/Monthly management reporting.Built a series of run maps under control of a router map responsible for determining schedule for each run via interaction with SQL Server 2000 tables holding system status values. System constructed using the Database Interface Designer and Integration Flow Designer deploying the system to run on NT4. System information messages disseminated via email and output files transferred to SAS system using Connect:Direct scripts. Show less

• 

  EuroConex

  Nov 2004 - Mar 2005

  POS Consultant

  POS consultant working on the assimilation of existing POS system in Poland into euroConex’s proprietary system written in COBOL and running on Stratus fault tolerant hardware. Full development life cycle employed to go from requirements gathering through specification/ coding and testing using script files, to live implementation. Protocols utilised included APACS29 APACS30 APACS40 and euroConex in-house POS msg specification.

• 

  Shell

  Mar 2005 - Nov 2005

  DataStage TX (now WTX) consultant

  Contract Data Stage TX consultant responsible for the full development life cycle for migration of existing messaging interfaces from release 6.5 to 6.7 and from NT to Windows servers. A variety of communications methods employed throughout the systems including MQ Series, Connect:Direct and ftp. Script files utilised for rebuilding MQ queues on destination test machines and for manipulation of messages within queues for specific unit and system tests. Discrete systems built utilising DataStage TX integration broker. On call 24*7 support of existing and new systems on a rota basis, weekly once a month. All procedures were SOX compliant. Show less

• 

  OmPrompt

  Nov 2005 - Apr 2006

  EDI Analyst

  EDIFACT analyst working on an automated message building system to allow RAD of new message protocols for the logistics industry to facilitate the uptake of smaller trading partners into the automated businesses of larger operators such as Kimberley Clark, Kuehne & Nagel & Banner Business Supplies. The company consisted of two divisions, one developing the gui interface written in Java and the other the integration team, of which I was a member, which utilised the gui interface to develop messaging interfaces allowing translation between disparate media such as email with attachments such as pdf files for FAX and spreadsheets; flat files of various formats containing structures such as IDOC & EDIFACT; and web portals. Show less

• 

  National Australia Group

  Apr 2006 - Apr 2007

  Datastage TX (now WTX) Consultant

  Mercator consultant working on the convergence of Yorkshire bank systems in to the existing NAB system for Clydesdale Bank. Routing of messages on a Solaris machine was controlled by setting up appropriate business services and elements within ROMA and the manipulation of ROMA specific data within the execution of each DataStage map within the business flow. Regression testing undertaken to ensure Clydesdale Operations were not adversely impacted.

• 

  EDS

  May 2007 - Feb 2008

  DataStage TX (now WTX) consultant

  DataStage TX consultant working on enhancements to the UK Courts system to facilitate better communication/synchronisation of information between the courts and the Police National Computer. The majority of the enhancements were to the CRN field which was originally 13 characters long and which was split into two separate fields, Arrest Summons Number and Sequence number, to enable automatic updating of the PNC. Plus additional data regarding information at arrest time added to existing Oracle tables. XLST used for document transformation before being made available to the public. Show less

• 

  Logica

  Mar 2008 - May 2008

  WTX Consultant

  DataStage TX consultant working on testing/defect resolution of the UK Courts system enhancements previously undertaken at EDS.

• 

  Odyssey Asset Management Systems

  Dec 2009 - Jul 2010

  WTX Consultant

  DataStage TX (now WebSphere TX) 8.2 consultant working on design, development and testing of interfaces for proprietary financial system.

• 

  EIB, Luxembourg

  Jan 2010 - Jan 2011

  WTX Consultant

  Completed conversion of in house invoice and document handling system to utilise Web Services.

• 

  BNP Paribas

  Jun 2012 - Apr 2016

  Lead Technical Consultant

  ETL for business reporting.DataWarehousing for Business Intelligence.WTX Consultant for in house integration issues.

• 

  TSB Bank

  Jul 2018 - Mar 2019

  ETL/DW/Infosphere Quality&DataStage Specialist

  ETL team member writing new processes for financial risk decision taking business functionIntegral member of triage function to streamline treatment of hundreds of outstanding defects as a result of migration to a new system introduced by Sabadell in April 2018.Complex SQL queries created for updating databases using standard Kimball methodology in the DataWarehouse (Teradata databases) utilising Infosphere Quality/DataStage.Numerous Quality/DataStage functions used for processing millions of rows of data from the Teradata source files for updating various target tables in the data mart for onward reporting via MicroStrategy.Full SDLC testing covered as part of standard Route to Live procedure, utilising Jira.Simple renaming processing utilised within DataStage Designer as source control mechanism for all sources and binaries. Show less