Principal Analyst - responsible for the delivery of development projects within the TSB and Lloyds TSB Data Warehouse # environments.
Part of the initial TSB Data Analysis team involved in developing the Query Customer Information Data (QCID) data model and it’s subsequent implementation.
Responsible for the development, production and issue of the Invitation to Tender (ITT) document as part of the merger of the TSB and LloydsTSB Data Warehouse environments. Also part of the ITT Response Evaluation Team for the selection of the final solution to be delivered. Suppliers involved in the ITT where IBM, NCR Teradata, Oracle and Sequent.
Responsible for the running of an evaluation project into the viability of utilising ETL tools as part of the merger process for the TSB and Lloyds Data Warehouse.

Project Leadership/Management – a mixed role of Business/Systems Analysis and Project Management tasks covering the whole development lifecycle of the projects, including development and agreement of partial and full Business Cases as well as the relationship management of the Business stakeholders and project management.
- Led a large combined group of projects for the Group Data Warehouse (GDW), which in total accounted for a budget of around £6m. These included externally managed resources and liaison with external hardware suppliers. The projects included evaluation of a replacement data models, including Teradata’s Financial Services Logical Data Model (FSLDM), for the existing bespoke Data Warehouse model, implementation of a metadata repository including user access facilities, implementation of an autonomous development and testing facility and improved access security and data quality facilities.
- Managed the Customer Services element of the Wholesale Customer & Account Programme (WCAP), covering the developments for GDW and Operational Customer (OCS) with a delivery budget of around £2m.
- Led the GDW elements of the Customer Insight System (CiNS) implementation which was later presented with a National Quality Award.
- Delivered the first Data Warehouse application within TSB to provide Branch Warehouse Marketing for the Branch to undertake self development of direct marketing campaigns.
- Delivered the Customer Segmentation and Treatment Strategy identification and selection facility utilising the GDW for source information.
- Managed Teradata Hardware Upgrade for Secondary Active-Active environment.
- Managed implementation of Bill of Material system for truck manufacturing utilising existing services of parent company but requiring development of data migration from existing systems.

Architecture/CTO - covering two spells both prior and post the merger of the Lloyds and TSB Banks.
- Responsible for developing TSB and later Lloyds TSB Data Warehouse Technical Strategies and Architectures, including a comparative review of the NCR Teradata, IBM and Oracle offerings utilising visits to the IBM DB2 Labs in California and a number of reference sight interviews.
- Responsible for the development of the Wholesale Back Office Technical and Functional Architectures.

Programme Management - a management role administering the delivery of the projects and acting as consultant for solution generation.
- Managed the delivery of the Data Staging and Analytics (DS&A) stream of the Customer Value Chain Programme, approximately £2m portfolio budget, with four Project manager direct reports. Applications delivered predominantly within the Group Data Warehouse area utilising Teradata, Business Objects and Ascential ETL tools.

- IT Operations Manager – management of operational running of IT systems and data preparation at Seddon Atkinson, approximately 10 staff.
- Systems Development Manager – responsible for development lifecycle of all projects run with Seddon Atkinson with four Senior Analyst direct reports.

Various projects undertaken at all companies.