Curriculum Vitae

David Edward Stratford

Personal

NameDave Stratford
Address378 Micklefield Road
High Wycombe
Bucks
HP13 7HZ
Telephone(Home) 01494 524704
 (mobile) 07976 552546
Email dave.stratford@hexagon-systems.co.uk
AvailabilityInmediate.

Summary

I have 25 years of almost continuous ICL VME applications development experience, using all of the standard VME superstructure products. I also have experience of Perl/MySQL development for web based applications.

Technical Knowledge

Hardware

Operating systems

Languages

Applications & Tools

Most Recent Employment

EmployerIntellectual Property Office
Department/teamVME Development
AddressConcept House, Cardiff Road, Newport, Gwent, NP10 8QQ
TitleContract Programmer/Analyst.
Date of employment 17th March 2008 to 13th March 2009.
UsingVME, COBOL, Application Master, Report Master, Query Master, IDMS, TPMS, SCL, DDS, DataServe, XML
Responsibilities

Worked on all aspects of both the Designs and Trademarks systems, and both batch and TP, as well as supporting both the system testing team and the end user test team. Required to develop and write one off programs, to fix, and test, faults identified by end users, and to design, develop and test changes to the systems.

Worked on a large number of small projects, as well as a couple of larger projects. Involved with the later stages of the design process, and then the complete development and testing of the mainframe end of a small system to allow customers to input objections to trademark registration (TM7a), that used an XML and HTML interface. Reprogrammed the system that allowed the mainframe to send out registration receipts from the mainfram, via email. This was done using XML which was then transferred to the outlook email server. Liased with PC systems team to ensure end-to-end testing conpleted successfully.

Responsible for converting older style documentation into newer forms and formats, replacing wordperfect with word, updating any documentation at the same time.

Previous employment

Most recent first


EmployerPortsmouth Water Limited
Department/teamComputer Services
AddressWest Street, Havant, Hampshire. PO9 1LG
TitleContract Programmer/Analyst.
Date of employment 12th March 2007 to 11th March 2008.
UsingVME, COBOL, Application Master, Report Master, Query Master, IDMS, TPMS, SCL, DDS, DataServe
Responsibilities

Part of a tiny team responsible for the running of the companies entire IT infrastructure. Worked on system enhancements, bug fixes, one off reports as well as help & train users and help run and maintain the system.

Worked on the development of the new Traffic Management Act (TMA) interface software, writing out XML transactions from the TPMS service to send to the new server based system, in both EtON3 and EtON4 standards.

Other responsibilitiesSite First aider

EmployerNationwide Building Society
Department/teamICL Development Team
AddressNorthampton & Swindon
TitleContract programmer/analyst/designer
Date of employment 19th June 2006 to 2nd February 2007
UsingVME, COBOL, Application Master, Query Master, IDMS, TPMS, DDS + ISDA
Responsibilities

Initially the lead developer on a project to increase the size of two fields on the main mortgage database. This project had board level oversight as had it gone in late, the society would have had difficulties selling mortgages. Although this did not require a database restructure, it did require a close examination of every single program that accessed those records, along with a large number of screens and external files. Specific responsibility throughout to ensure that the DDS was maintained in such a way as to ensure other systems and projects were not inconvenienced. As this system interfaced closely with a lot of other systems, many on other platforms, within and without the society, it was necessary to ensure all these systems were made aware of the changes to the mortgage system, and to ensure that any changes in the interfaces between systems were properly tested. Became responsible for working with the senior users to ensure the smooth running of the system testing.

Responsible for the planning of the various initial production releases as autonomous parts of the project became ready, and was instrumental in the planning, implementation and support of the final production release; which required coordinating with two other systems as it was discovered that they would have to implement their changes at the same time. This eventually required over 400 modules, COBOL and AM, to be released to production just before Christmas.

After the main release, the team was scaled down to just myself on a part time basis to identify and fix any faults that were discovered from the release. Simultaneously worked on a number of small changes to many parts of the Mortgage system: general bug fixes, small system enhancements, and one-off reports. Also worked on a small data cleansing project, identifying accounts with errors in insurance premium calculations.


EmployerLogicaCMG
Department/teamWelsh Water/Thames Water Development Team
AddressEastern Business Park, Wern Fawr Lane, St. Mellons, Cardiff. CF3 5EA
TitleContract programmer/analyst/designer
Date of employment 1st August 2005 to 31st January 2006
UsingVME, COBOL, Application Master, Query Master, IDMS, TPMS, SCL, DDS
Responsibilities

Working primarily on the 'Metered DCS' project, this involving design, coding and testing of both batch and TP code for the new Debt Collection System for Metered water accounts. Wrote implementation plan for the project, and was closely involved with the live implementation. During the latter stages of the project involved with supporting the User Acceptance Testing phase, helping to diagnose and fix faults, as well as running batch jobs as requested by the Thames Water UAT team.

During the latter part of December, and all of January, I was the designer, programmer and tester on the CRYPTO project, identifying and generating letters to all properties affected by the Cryptosporidium outbreak in North Wales. This involved generating reports to enable Welsh Water staff to check and correct customer data prior to sending out Boil notices, All clear notices or Inconvenience Payments, as well as generating the Inconvenience payment processing.

Designer and developer for important changes to the Automatic Refunds processing and have also done some coding and testing for the interface to the new Banktec Payment Protection System, and to the Affordability Discount system.


EmployerRDF Consulting
Department/teamNorthern Rock Development Team
AddressFairways Business Park, Deer Park Road, Livingston, West Lothian. EH54 8WD
TitleContract programmer/analyst/designer
Date of employment 31st May 2004 to 27th August 2004, and
1st February 2005 to 25th March 2005
UsingVME, COBOL, IDMS, TPMS, SCL, DDS, Program Organiser
Responsibilities

Responsible for designing, coding and testing for any aspect of Northern Rocks business as required. Responsible for the maintenance of the Code generators, as well as the RTE test environment. Responsible for development of part of the BACS requirements for the transfers of Direct Debits and Standing Orders between financial institutions.

Other responsibilitiesSite First aider

EmployerRed Emperor Ltd
Department/teamDevelopment Team
AddressThe Hat Factory, 65-67 Bute Street, Luton, Bedfordshire. LU1 2EY
TitleContract programmer/analyst/designer/developer
Date of employment 1st March 2004 to 21st May 2004 and part time/ad-hoc to present.
UsingPerl, MySQL, HTML, Javascript, Linux
Responsibilities

Time spent partly working on the Red Emperor site in Luton, and partly working from home.

In Luton, developed and extended the functionality of the main Red Emperor game The Ancients. This involved changing and extending both the HTML templates and the perl scripts which drive the games interface. Involved, at a basic level, with some changes to the MySQL database most notably in the membership parts of the database. Responsible for writing the membership renewal system, and for its interface to the Royal Bank Of Scotlands world-pay system.

From home, developed the complete user interface to the new game Conquest which is a simplified version of The Ancients. This involved the merging and tidying of various 'Ancients' HTML templates, as well as the related Perl scripts and writing a small number of new scripts. Responsible for the new colour scheme.


EmployerRDF Consulting
Department/teamNorthern Rock Development Team
AddressFairways Business Park, Deer Park Road, Livingston, West Lothian. EH54 8WD
TitleContract programmer/analyst/designer
Date of employment 13th August 2001 to 4th April 2003, and
21st July 2003 to 26th September 2003
UsingVME, COBOL, IDMS, TPMS, SCL, DDS, Program Organiser
Responsibilities

Responsible for the production and testing of code for the RDF client (Northern Rock Building Society). This involved just about all aspects of the clients business, mortgage maintenance, insurance, broking, etc. Responsible for the programming and testing, including generation of test plans and logs, of batch and TP code, both COBOL and, where appropriate, SCL. Responsible for the design and development of tools to assist in the generation of production SCL, and to validate code against current site standards.

Other responsibilitiesSite First aider

CompanyITSA (DSS)
DepartmentJSA
AddressGovernment Offices, Heyhouses Lane, Lytham St.Annes, Lancashire
TitleContract Functional & Technical Designer
Date of Employment 11th September 2000 to 15th June 2001
UsingVME, Principia, Word, SCL, Cobol, DDS
Responsibilities

Part of the design team on the next release of the Job Seekers Allowance Payment System, the job involved taking a high level design, and turning that into functional and technical design packs, developing test plans for both system and business testing, and arranging revues and sign off of the various packs. There were often tight time scales, and working long hours was not uncommon. Worked on two principle projects alongside a number of smaller pieces of work. The first, a database tidyups, dormant case deletion, involved a lot of complex batch procedures, as well as one off batch runs. The other involved the generation of statistical information for the new Joint Claims introduced by the Government. Once programming began, my responsibilities extended to supporting the programmers: explaining the changes, and resolving any difficulties with either coding or testing.

Responsible for ensuring that the user departments were able to write their own test conditions and test scripts, explaining quite complex computer processes to non technical people.

Responsible for ensuring that a large number of changes that had been specified were merged back into the baseline specifications, ensuring that the code changes and the specification changes matched.


CompanyAutomobile Association - Insurance Services
AddressFanum House, Queen Street, Cardiff
TitleContract analyst/programmer
Employment period1st January 2000 to 31st March 2000
UsingVME & Microfocus Cobol (on DOS), IDMSX, TPMS, SCL, DDS, QM, CAFS, Altadata, MKS
Responsibilities

Responsible for a large number of correspondence changes related to Phoneday2, as the AA used a lot of 0990 numbers. Responsible for a number of minor changes related to ABI compliance rules, as well as a major data cleansing exercise.


Company3663 - formerly Booker Food Services
DepartmentIT
TitleContract Development analyst/Programmer
Employment period26th July 1999 to 23rd December 1999
UsingVME, Cobol, IDMSX, TPMS, SCL, DDS, ApplicationMaster, QueryMaster, Altadata, ITS, TPES
Responsibilities

Part of a small team, involved with the VME side of the Booker Food System, involving fix-on-fail for batch and TP, but also included developments and enhancements.

Involved in system fixes to both the AM and the TP cobol, some cobol batch fixes, and enhancements to the batch SCL.

Developed a batch suite to auto generate downloads to the unix based depot systems, alongside the development and testing of a number AM transactions that required splitting into smaller dialogues.

Other responsibilitiesSite First Aider.

CompanyAG Systems
Address51 Homer Road, Solihul, West Midlands
TitleContract analyst/designer/programmer
Employment period3rd January 1998 to 2nd July 1999
UsingVME, Cobol, IDMSX, TPMS, ITS, TPES, SCL, DDS, QueryMaster, Altadata, Maestro II
Responsibilities

Two and a half months on backlog support, clearing very old calls, involving full access to the live systems, identifying whether they were data or code faults, and passing the information to the appropriate team.

Worked on two phases of the Customer/1 (OSE) project, involving the passing of money between the gas and electricity systems. Responsible for changes to lots of batch modules as a large number of record types on the files had extra data inserted to identify type of account, and for statistical aggregations. Also responsible for splitting the reports, into three, adding new functionality at the same time. During this project, Wrote a number of ad-hoc SCL procedures to help the system testers control their testing environments.

Developed new module to control tariffs available to customers in arrears. Responsible for amending TP messages to enable the new processing, and also the development of new TP messages.
Responsible for new TP messages for quotations of, and to put customers onto, advanced payment tariffs. Closely involved with the batch changes for the change in billing for when the credit ran out, or for when a customer asked to go back onto a standard scheme requiring a refund. Also involved with design re-work to cater for unusual conditions. Supporting the business acceptance testing, helping identify unexpected results from tests, and helping in the setup of some test data.


CompanyAutomobile Association - Insurance Services
AddressFanum House, Queen Street, Cardiff
Employment period1st January 1995 to 31st December 1997
TitleContract analyst/designer
Using VME & Microfocus Cobol (on DOS), IDMSX, TPMS, SCL, DDS, QueryMaster, CAFS, Altadata, Maestro I & II
Responsibilities

Part of the Motor insurance development team, responsible for changes to all parts of the system, including batch, on-line and PC code. Also jointly responsible, for support of the live correspondence system, checking any failures as they occured, and repairing the failed letters.
Responsible for ensuring that new releases of the software were made available to the user support team. During analyst and user testing stages of a release, I was responsible for any fault reports returned, ensuring that they received prompt attention, either from the original programmer, or by myself in liason with the original programmer.

From January 1996 worked on the Home insurance fault team, diagnosing faults and liasing with the user support team in Newcastle. As the Home system is a clone of the Motor system, this involved liason between the teams, both to identify differences, where Motor code is not valid for Home, and to identify similarities, where a bug may be present in both. Developed ad-hoc programmes to identify and correct invalid data.

From January 1997, part of the Y2K team. This involved all phases after the user requirements stage, up to program test. Pilot work on the home insurance system to try and identify, in advance of the main work starting, any problems that may occur or any good practices that may need to be followed for this and other systems.
Designed, coded, and tested bridging programmes that allow Y2K compliant data to be passed to non Y2K compliant systems.


CompanyHousehold Mortgage Corporation
AddressBellfield road, High Wycombe, Buckinghamshire
TitleAnalyst/Programmer
Employment period16th March 1992 to 23rd December 1994
UsingVME, Cobol, IDMSX, TPMS, SCL, DDS, Altadata, ITS, TPES, CAFS
Responsibilities

General development and support programmer on wide ranging areas of the BankMaster system, batch and on line: letter production, cyclic and non-cyclic actions, insurance, payment and residual interest calculation, multi-account loans, further advance processing, interest rate history, statementing, IPT, and account history. Responsible for introducing a number of SCL and Cobol standards, new IDMS protocols, and standardising data dictionary usage. In charge of project ensuring all batch SCL would restart after a failure. Responsible for complete design plus initial development of large batch suite for when HMC bought the mortgage book of another company.

Other Responsibilities

Chief First-aider at HMC, running all the first-aid team meetings which took place, ensuring new first-aiders recruited as necessary, and all certificates and boxes up to date.


EmployerInternational Computers Limited
DepartmentCorporate Information Systems
AddressCavendish Road, Stevenage, Hertfordshire. SG1
TitleFinished as senior Analyst Programmer
Employment period13th July 1987 to 15th March 1992
Main responsibilities
  • Development of release 3 and 4, products database (PDB) in AM.
  • Responsible for setting up and testing IDMS re-organise and restructure procedures for release 3.
  • In charge of release 3 implementation and initial support.
  • Upgraded internal Lafis database from release 6.1 to release 8.1.
  • Development, including analysis and design, of new lafis implementation.
  • Designed and wrote SCL for IRAS-AR implementation.
  • Responsible for documenting the availability of support documentation for a large number of systems prior to a transfer of support responsibility.
  • Second line support for about 100 systems and implementations.
Other Responsibilities Main support for the tools software. Installed and supported DRS300 CDOS stacks and local network. Site first-aider

CompanyMersey Regional Health Authority
DepartmentManagement Services
AddressHamilton House, Pall Mall, Liverpool, Merseyside
Employment period20th August 1984 to 12th July 1987
Main responsibilities
  • Development of DME to CPM and Supercalc link.
  • Development of CPM based Nursing training records system.
  • Development of VME Hospital Inpatient System (HIS), including DME to VME conversion software, in charge of DDS for project.
  • Complete implementation, support and all end user training for Family Practitioner Committee (FPC) system at two FPC's.
  • Implement and support IDMS/TPMS Manpower Management System (MMS). Responsible for planning the reorganise and re-structure of MMS. In charge of MMS liason with West Midlands RHA

Other

Red Emperor

During the summer of 2003 I did a small amount of ad-hoc work for the internet gaming company Red Emperor. This has involved learning Perl and MySQL. My task was to generate a small number of routing algorithms for the web based game Empires. Subsequently been involved, again on an ad hoc basis, in bug fixing and minor interface changes. This work has usually been home based, but has occasionally meant travelling to Red Emperors Luton office. Currently working on the next game, provisionally called Dominion, a solo game based on the rise of the Roman Empire.

HTML

I have taught myself (X)HTML, CSS and Javascript, along with Perl and MySQL, and have built a number of different web sites:

All these web sites are fully W3C HTML compliant, and have been validated as correct by the W3C HTML validator, mostly to the HTML4.01 or XHTML1.0 standards. The reflections photographic site contains a small amount of javascript.

I have also written an automated HTML generator (!WebGen2) which has been used to create a number of web sites, of which part of the reflections-photographic site above is just one.

Education, Qualifications & Training

Education September 1974 King George V Grammar School, Southport
September 1978 Southport Technical College
September 1981 Huddersfield Polytechnic
Qualifications 9 GCE 'O' levels including Maths and English
1 GCE 'A' level in Computer Science (Grade B)
Higher National Diploma in Computer Studies
Training
VCC5 days VME Cobol.
VSCLP5 days VME SCL programming
VIDMP5 days VME IDMS programming
VIDMI5 days VME IDMS implementation and support
VIDMD5 days VME IDMS design
VITPF5 days VME implementation of TP facilities
DDS2 days Use of the Data Dictionary System
QBOSDAM5 days Online Application Master
QBBRAM5 days Batch AM (Report Master)
QM3 days End user Query Master
VTPIDMREC1 day VME TPMS/IDMS recovery workshop
SALD10 days Systems analysis and logical design
FSS5 days First steps in Systems Supervision
MUMPS7 days Programming and support of MUMPS
CPROG5 day C programming course run by Sun.

Personal References

Mr Nigel Painter
99 Caerleon Road
Newport
Gwent
NP19 7BY
Rev. Christopher Stevens
St. Joseph's Presbytry
Barnsley Road
Moorthorpe
West Yorkshire
WF9 2BP

Other Personal Information

An active member of High Wycombe Divisions St.John Ambulance Brigade, I regularly attend public duties and help out on public first aid courses. I have held full First Aid at Work (FAW) certificates continuously since 1990, and more recently more advanceed Ambulance aid ceertificates. During my time as a member of Stevenage St.John, I became an official physio-first aider for Stevenage Rugby Club. During the Summer of 2003 I worked part time, mainly doing holiday cover, for the Buckinghamshire St.Johm Ambulance Transport Service doing patient transfers between hospitals, and between hospital and home or residential care.

I have been driving since 1982 and have a full, clean, driving licence. I am a full member of the Institute of Advanced Motorists, having passed their advanced driving test during 1992.

For a short while I was joint treasurer of the Southport Napoleonic society, and still play RPG's and similar games. I enjoy skiing, walking, reading, cinema and listening to music. Whilst I was in Cardiff I started to learn to sail, and currently hold a RYA level 1 certificate.

I recently took up photography much more seriously, and am putting together a portfolio with the aim of becoming a member of the Royal Photographic Society. As a result of this I have also started to do a small amount of Wedding photography.

Valid XHTML 1.0 Valid CSS!