• Extended the existing Data Warehouse ETL facilities by developed a suite of initial load and subsequent new / changed data extract processes from the Oracle Data Warehouse to a pre-defined set of 26 files for transmission to head office. This involved initially extracting and processing approximately 80 million records.
• Developed a suite of AS/400 RPG applications relating to improving the efficiency of daily time consuming tasks within the core application. The existing Data Warehouse ETL processes where then extended to cover these new facilities.
• Designed and developed DataStage ETL processes to extract the Companies data as part of a team set-up to refinance the Companies portfolio as part of a Securitisation project, this was carried out in conjunction with LeasePlan Corporation and the Royal Bank of Scotland.

• Responsible for the Modelling and Creation of Phase II of the Data Warehouse and the related Data Marts.
• Responsible for the design, creation, implementation and verification of the DataStage ETL processes that loaded the Data Warehouse with a pre-defined set of files from the 26 Countries.
• Responsible for the design, creation, implementation and verification of the DataStage ETL processes that loaded the various Data Marts.

• Responsible for the Modelling and Creation of Phase II of the Data Warehouse and the related Data Marts.
• Responsible for the design and implementation and verification of the DataStage ETL processes to load the Data Warehouse and Data Marts.
• Responsible for the QualityStage data investigation jobs for a global project.

• Management of 3 IT Staff.
• Managed the Data Migration, Gap Analysis and refinement processes.
• Managed the implementation and verification of the Data Warehouse ETL loading processes.
• Business Objects development and Universe Design.

• Responsible for the Development of a Data Warehouse and the data feeds from 26 countries costing € 5 million, containing over 100 million rows of data.
• Installation of DataStage and Business Objects.
• Modelling of a Risk Management Data Mart which it was estimated would save € 5 million per year.
• Modelling and Creation of the Data Warehouse and subsequent Data Marts.
• Responsible for the design and implementation and verification of the DataStage ETL processes to load the Data Warehouse and Data Marts.
• Management of 3 IT Staff.
• Business Objects development, Universe Design and Broadcast Agent.

• Management of 4 IT Staff.
• Responsible for the conversion of approximately 120,000 Vehicles and their Customers, Contracts, Service History and Finance Ledger.
• Responsible for the designed and development of the DataStage ETL conversion routines.
• Data reconciliation.
• Post conversion support.

• Management of 6 IT Staff.
• Data migration from an AS/400 application to an in-house Informix application.
• Designed enhancements to the Informix application.
• Implementation of a registration card scanning solution.
• Installation of DataStage, Informix Redbrick, Business Objects and Set Analyzer.
• Designed and developed a Data Warehouse costing £1.5m, containing over 100 Million rows of data.
• Rolled out the Data Warehouse application to other Clients.

• Management 6 permanent and contract staff.
• Part of Business Management Team.
• Recruitment.
• Building relationships with suppliers and other 3rd parties.
• Monitoring of staff work loads and development times.
• Development of the Paid Subscription System to allow for multi currencies.
• Productivity enhancements to the document image package.
• Managed the development, testing and implementation of the Y2K proofing of the Business Applications, gaining the approval of both Internal and External Auditors.

• Design and Implementation of a Vehicle Warranty application for Chrysler Jeep UK; Proton Cars UK; Daihatsu UK; Mazda Finland between the Dealership, head office, the Manufacturer and back to the Dealership.
• Designed and Implemented a Bonded Vehicle Stocking and Distribution application that gained HM Customs and Excise approval for the following Customers: - Toyota GB; Daihatsu UK; Chrysler Jeep UK; Volkswagen; Honda; Daewoo; Hyundia; Suzuki; Mazda.
• Managed the design and implementation of a suite of processes to aid Toyota GB in their central stocking process where information was received from the Manufacturer and feed to Toyota GB. This then lead to Vehicle orders and extras being processed through the workshop in the correct time with real time status updates being feed to Toyota GB. The subsequent delivery requests were received and feed to the delivery company with the delivery manifesto being received and processed and feed through to Toyota GB. This process was subsequently rolled out to Honda, Mazda, Suzuki, Hyundai, Chrysler, Daihatsu and Daewoo.