Experience

The ATCORE Group
• United Kingdom
• IT Services and IT Consulting
• 1 - 100 Employee
• Oracle Developer

  • May 2017 - Present


Simplyhealth

• United Kingdom
• Wellness and Fitness Services
• 700 & Above Employee

• Oracle / Java Developer

  • Jan 2013 - Apr 2017

  Initially started off in Application Support as a means of getting to grips with all aspects of the system quickly and subsequently moved on to make various enhancements to existing Java/Oracle application called Pulse. Pulse handled SimplyHealth’s Cashplan and PMI policies. Projects included making documents and correspondence available online , Price Review, PMI Business Sale and Data Depersonalisation project. Technically , changes varied between Java, Oracle PLSQL , JSPX, Thunderhead, Oracle Reports, Reporting Services and making good use of Jira, Confluence and BitBucket. We transitioned into the Agile way of working, initially starting off using Kanban and more recently moving to Scrum. I passed a Certified Scrum Developer Course provided by Radtac and also passed part 1 of Oracle 11G DBA Certification exam.



Metropolitan Housing Partnership

• Oracle / Java Developer

  • Aug 2012 - Jan 2013

  Customised Oracle forms and database procedures to cater for rental increases across all properties. I also Created process for uploading excel sheets into database using Java and Apache POI and transferring rental details to 3rd Party. Customised Oracle forms and database procedures to cater for rental increases across all properties. I also Created process for uploading excel sheets into database using Java and Apache POI and transferring rental details to 3rd Party.



The AA

• United Kingdom
• Motor Vehicle Manufacturing
• 700 & Above Employee

• Oracle Developer

  • Oct 2009 - May 2012

  Customised existing TIA application for Home and Motor Insurance to allow customers to view Insurance documents online. Further modifications to TIA application included EDI changes for Insurers, Tariff changes, new Insurer scheme products, modified Home Emergency Response product to allow Mid Term adjustments when adding Boiler cover/ service add-ons. Duties Included:Oracle Forms 10G development Unix shell scriptingPLSQL developmentPerformance tuning

• Oracle Developer

  • 2009 - 2010



Bupa - Ashford

• DBA Developer

  • Jul 2008 - Sep 2009

  This was a large project which involved migrating data from 7 large legacy systems into one application. This entailed extracting the data using scripts. The extracted data was then passed on to a third party for cleansing. Once cleansed the data was then passed back to us to load into the appropriate tables. In all there were about 300 files to load. My duties involved: Creating/ Updating scripts to extract data in appropriate format. Creating sqlldr scripts to load cleansed data for each of the data files. Creating a mechanism, using shell scripting, to allow data to be loaded automatically when the cleansed data was ready. Performing ad-hoc data loads. Performing DBA tasks such as resolving tablespace issues, constraint issues, unusable index violations, exports/imports, restores. Performance tuning scripts. Using my Java knowledge I created a mechanism, using Java Server Pages and JDBC to graphically show the progress of the loads and to allow sql reports to be run directly from the graphs. We would also use the reports to show the progress as primary and foreign key constraints and indexes were made usable


Bupa
• United Kingdom
• Hospitals and Health Care
• 700 & Above Employee
• DBA Developer

  • 2008 - 2009


EDS - Camberley

• Development Specialist

  • Mar 2005 - Jul 2008

  Documented existing legacy system for Department of Constitutional Affairs by creating detailed As Is Use Case documents covering existing Caseman functionality. This required in depth knowledge of Oracle Forms 4.5 and Reports 2.5. I was originally involved in the creation of these forms and reports on my first contract with EDS in December 1996. Worked on Full Life Cycle of SUPS project to upgrade existing Legacy Caseman system for handling County Court cases. Developed scripts to gather statistical information from all 218 Courts. Provided general adhoc queries / interface scripts, utilizing shell scripting and plsql/sqlplus. Converted existing Caseman Application Reports written in Oracle Reports 2.5 to Oracle Reports 10G. Provided support for rollout of new system, which required a flexible and diligent approach to resolving live issues. Performed DBA duties for current environment issues on legacy system, such as missing objects, grants, adding tablespaces, imports, exports etc.



EDS

• Brazil
• Commercial and Industrial Machinery Maintenance
• 1 - 100 Employee

• Electronic Data Systems

  • Mar 2005 - Jul 2008

  Developed Dynamic sql packages in PLSQL to transfer entire details of a Case or Warrant from one court to another over a database link. Designed and developed Interfaces to Bulk court clearing Centres using PLSQL. Developed Oracle forms using version 4.5 Developed various reports using version 2.5. Developed a Rules Engine written in PLSQL to handle all validation of a Divorce System known as FamilyMan. Creating a Rules Engine in this way facilitated the creation of forms and reports for the System. Developed the Underlying database, which was known as TUCS (The Universal Case System.) This Case System was Generic and went on to be used as the basis for a Child Care, adoption System and a High Court Forms System. Designed and developed a PLSQL Package to produce forms written in PCL (Printer Control language.) The Court Service used the PCL engine for all paper output. . Provided Technical Support for Case Management Systems.



Servista Ltd

• Business Consulting and Services

• Development Specialist

  • Dec 2003 - Mar 2005

  Duties: Provided Technical support for oracle applications interfacing with Java Middle layer. Supported installation and maintenance of oracle tool sets on Windows 200 and NT4 platforms. Shell scripting for Sun Solaris platform Customized existing product to meet needs of new customers, utilizing Oracle 8i, Plsql interfacing with Geneva Billing System. Provide 2nd line support to existing customers. This included looking at the underlying problems and resolving them as well as the every day incident resolution. Developing enhancements via Change Requests.



BUPA, Ashford

• Development Specialist

  • Nov 2002 - Jul 2003

  Network System to cater for new guidelines regarding the payment of Consultants requiring the design and development of PLSQL packages, forms and reports. Optimized code in particularly slow areas of packages written in PLSQL on an Oracle 8I Database using TKPROF and Explain Plan. Optimized Oracle Forms and reports using same tools. Designed and developed new modules written in PLSQL to cater for new requirements. Developed new Korn Shell scripts for Batch processing. Provided support for Oracle applications taking data feeds from mainframe. Applications extensively used PLSQL and Unix Shell Scripts. Provided support for Forms 6i and Reports 6i applications. Trained other colleagues in the use of PLSQL, forms, reports and performance tuning. Managing Change Requests Provided technical support for oracle applications running under Windows 2000 and Windows NT4 environments.

• Development Specialist

  • Apr 2002 - Jun 2002

  BUPA, Ashford, Middlesex Duties: Upgraded 3 separate Forms applications from version 4.5 to 6i. Upgraded all reports from version 2.5 to 6i. Provided Technical Support for Oracle applications taking data feeds from mainframe. Applications extensively used PLSQL and Unix Shell Scripts. Provided Technical Support for Forms 6i and Reports 6i applications for use on Hospital and Consultant Systems. BUPA, Ashford, Middlesex Duties: Upgraded 3 separate Forms applications from version 4.5 to 6i. Upgraded all reports from version 2.5 to 6i. Provided Technical Support for Oracle applications taking data feeds from mainframe. Applications extensively used PLSQL and Unix Shell Scripts. Provided Technical Support for Forms 6i and Reports 6i applications for use on Hospital and Consultant Systems.



London Borough of Harrow

• Development Specialist

  • Feb 2002 - Apr 2002

  Upgraded Forms application from version 4.5 to 6i. Upgraded all reports from version 2.5 to 6i. Upgraded Forms applications from version 3 to 6i. Developed enhancements to Schools Admissions System using PLSQL, Forms 6i and Reports 6i and SQLLOADER to meet new admissions changes. Upgraded Forms application from version 4.5 to 6i. Upgraded all reports from version 2.5 to 6i. Upgraded Forms applications from version 3 to 6i. Developed enhancements to Schools Admissions System using PLSQL, Forms 6i and Reports 6i and SQLLOADER to meet new admissions changes.

• Development Specialist

  • Aug 2000 - Oct 2001

  Designed and developed a large PLSQL package to handle the adjudication of a Benefits System used in Saudi Arabia for BUPA Middle East. Designed and developed new benefits database Designed and developed a PLSQL conversion script to populate existing data from Old Benefits System. Tuned System using TKPROF and Explain Plan. Once this System was in place I joined the Oracle Support section to look after various Systems making full use of my PLSQL forms, reports and Korn Shell Scripting Skills. Provided Technical Support for Oracle applications interfacing with BUPA Hospitals management and BUPA Consultant Reward Scheme.

• Development Specialist

  • Dec 1996 - Apr 2000

  • Developed Dynamic sql packages in PLSQL to transfer entire details of a Case or Warrant from one court to another over a database link. • Designed and developed Interfaces to Bulk court clearing Centres using PLSQL. • Developed Oracle forms using version 4.5 • Developed various reports using version 2.5. • Developed a Rules Engine written in PLSQL to handle all validation of a Divorce System known as FamilyMan. Creating a Rules Engine in this way facilitated the creation of forms and reports for the System. • Developed the Underlying database, which was known as TUCS (The Universal Case System.) This Case System was Generic and went on to be used as the basis for a Child Care, adoption System and a High Court Forms System. • Designed and developed a PLSQL Package to produce forms written in PCL (Printer Control language.) The Court Service used the PCL engine for all paper output. . • Provided Technical Support for Case Management Systems.



TSW International Ltd. (Working

• Development Specialist

  • Jun 1996 - Nov 1996

  This project involved working in a team to customize the standard Engarde Asset Management package for use with British Gas. This involved creating new and customizing forms and Reports as well as complex database procedures and triggers. This project involved working in a team to customize the standard Engarde Asset Management package for use with British Gas. This involved creating new and customizing forms and Reports as well as complex database procedures and triggers.



The Audit Commission

• Development Specialist

  • May 1996 - Jun 1996

  Made enhancements to Oracle Financials reports. Technical skills: PL*SQL, Oracle Reports 1.1 Duties: Made enhancements to Oracle Financials reports. Technical skills: PL*SQL, Oracle Reports 1.1 Made enhancements to Oracle Financials reports. Technical skills: PL*SQL, Oracle Reports 1.1 Duties: Made enhancements to Oracle Financials reports. Technical skills: PL*SQL, Oracle Reports 1.1



Scottish Office, Edinburgh

• Development Specialist

  • Feb 1996 - Mar 1996

  PLSQL procedures to download and vet details from the Scottish Criminal Records Office and produce files to be uploaded into SAS for statistical purposes. PLSQL procedures to download and vet details from the Scottish Criminal Records Office and produce files to be uploaded into SAS for statistical purposes.



CSC (Cyprus)

• Development Specialist

  • Aug 1995 - Dec 1995

  Taken on to modify the social insurance system for the Cypriot government. Mainly involved in modifying packaged procedures, Forms and reports to meet the rules regarding pensions and other benefits. Taken on to modify the social insurance system for the Cypriot government. Mainly involved in modifying packaged procedures, Forms and reports to meet the rules regarding pensions and other benefits.



Lombard, Redhill

• Development Specialist

  • Apr 1995 - Jul 1995

  Customized their Business and Motor loans system to allow for extra financial calculations to be shown at the quote stage. Other work included customizing their operational reports. Customized their Business and Motor loans system to allow for extra financial calculations to be shown at the quote stage. Other work included customizing their operational reports.



Charles Voegele (Switzerland)

• Development specialist

  • Apr 1995 - Apr 1995

  Customized their end of year Financial reports to meet changes in requirements. Customized their end of year Financial reports to meet changes in requirements.



Ferranti Computer Systems

• Belgium
• Information Technology & Services
• 1 - 100 Employee

• Development Specialist

  • Jan 1995 - Mar 1995

  Customized their emergency call out system for two customers, GEP and Borealis. Using this system, key people are automatically contacted and informed about a particular alarm situation, by means of telephone, fax or pager Customized their emergency call out system for two customers, GEP and Borealis. Using this system, key people are automatically contacted and informed about a particular alarm situation, by means of telephone, fax or pager



TSW International PLC

• Development Specialist

  • Jan 1994 - Jan 1995

  Customized the asset and maintenance management package (En Garde) to the specific business needs of BP exploration in Aberdeen by adding a new module (Procurement) to handle requisitions and orders for 128 users across 13 north sea oil platforms. Customized the asset and maintenance management package (En Garde) to the specific business needs of BP exploration in Aberdeen by adding a new module (Procurement) to handle requisitions and orders for 128 users across 13 north sea oil platforms.



Citibank, Holborn

• Development Specialist

  • Aug 1993 - Dec 1993

  Designed and built a mechanism for adding Global client ids to one of the customer databases. This involved producing scripts to automatically download customer information from their customer database in New York and match by whatever means possible. Designed and built a mechanism for adding Global client ids to one of the customer databases. This involved producing scripts to automatically download customer information from their customer database in New York and match by whatever means possible.



Ryder Airline Services Caledonian

• Development Specialist

  • Apr 1992 - Jul 1992

  Implemented a job costing system to break down and report on labour and materials used for the reparation of aircraft engines. Implemented a job costing system to break down and report on labour and materials used for the reparation of aircraft engines.



Barking College of Technology

• Development Specialist

  • Mar 1992 - Apr 1992

  Built Student statistical reports to meet the informational requirements on registrations and results. Built Student statistical reports to meet the informational requirements on registrations and results.



Southern Electric

• United States
• Utilities
• 1 - 100 Employee

• Development Specialist

  • Oct 1991 - Jan 1992

  Taken on for four months to make major modifications to their large customer billing system to facilitate additional charge band, tariff and reconciliation processing. This involved major changes to the billing application requiring the exclusive use of Oracle, SQL*Plus, Pro*Cobol, SQL*Forms and RPT. Taken on for four months to make major modifications to their large customer billing system to facilitate additional charge band, tariff and reconciliation processing. This involved major changes to the billing application requiring the exclusive use of Oracle, SQL*Plus, Pro*Cobol, SQL*Forms and RPT.



BTEC, Euston

• Development Specialist

  • Apr 1989 - Sep 1991

  Primarily involved in a major EDI project, which incorporated software written in DBASE III + and Pro*Cobol. Software was provided to allow Centres to register and report grades for their Students. The Student Registrations and Grades could then be transmitted to BTEC and dealt with immediately. Technical skills: Oracle 5 /6, SQL*Forms 2.3, SQL*Plus, RPT & Pro*Cobol. Primarily involved in a major EDI project, which incorporated software written in DBASE III + and Pro*Cobol. Software was provided to allow Centres to register and report grades for their Students. The Student Registrations and Grades could then be transmitted to BTEC and dealt with immediately. Technical skills: Oracle 5 /6, SQL*Forms 2.3, SQL*Plus, RPT & Pro*Cobol.



Haringey FE College

• Programmer

  • Sep 1986 - Apr 1989

  Taken on as a trainee. Initially given responsibility for maintaining the BBC Computer network. Later given responsibility over two minicomputers and the case communications equipment which served to link terminals from two sites to the minicomputers. Taken on as a trainee. Initially given responsibility for maintaining the BBC Computer network. Later given responsibility over two minicomputers and the case communications equipment which served to link terminals from two sites to the minicomputers.