Test Lead (Divisional Product Migration)
Lloyds TSB
Total years of experience :11 years, 1 Months
Lloyds TSB - Feb 2010 to Dec 2011
Role: Test Lead (Divisional Product Migration)
Following the merger of Lloyds TSB and HBOS banking organisations to form Lloyds Banking Group (LBG) it became necessary to integrate the two organisations' business systems for regulatory (single customer view) and business reasons (to derive synergies) via Financial Reconciliation and Trial Migrations. My scope of the project centred on the heart of the organisation's comprehensive portfolio of asset-management services, will include interfaces to SAP for work-order management and a 'data historian' interface to capture and calibrate the information used to define the operating limits that assure asset integrity in the new Lloyds Banking Group. The system work was split between the TD01 and wCBS systems; comprising of Retail (CBS), Wholesale (ALM) Banking Management (Cards and non-Personal Accounts) and UK Private Banking accounts. Also it has to ensure all platforms (CBS, wCBS, QRM, Oracle and SAP) were all subsisting post-Live and producing their FSA Statutory and regulatory reports in line with previous operations and adhering to Basel II regulations.
Responsibilities: • Authoring and contribution to test strategies for all relevant divisions.
• Gathering Business requirements and supporting Business Test Manager
• Authoring Test Traceability matrix was set to ensure complete ETL and end 2 end tests.
• Management of cross-divisional functional testing resources and budget.
• Ownership, creation and execution of test scripts and test scenarios
•
• Ensuring recognised testing standards and practises are adopted within the testing competency centre.
Lloyds TSB - Dec 2008 to Dec 2009
Role: Test Manager
Working as part of the Freeview Programme data migration project, (£10M), which is a four year Group-wide Finance initiative which will deliver LTSB Asset management's vision to provide the services and technology (web-based order management systems) to support Lloyds' goal to continually measure and improve the reliability of its global mechanical-integrity programme, which is an integral part of its risk-based Wealth management systems that assure high-worth customer security/ dependable operations and creates a best-in-class Finance function. Employing the Agile methodology and ETL processes, the Freeview programme objectives are to significantly advance LTSB's Finance (SAP and Oracle GLs) capability and to enable Finance to become a co-pilot to the Business and adhere strictly to SOX principles and deliver reports to the BoE and FSA.
Responsibilities
• Ownership, documenting and executing of test scripts and defect management process
• Monitoring, reviewing and creating Business Performance Management processes.
• Advising, managing and training in the areas of migration testing, implementation planning and controls for a major multi-stage migration.
• Ownership of all data and environmental issues.
• Implementing a Streamline Consolidation and Reporting processing including Regulatory Reporting, by the introduction of new Applications that will be utilised across Divisions.
• Identifying the business and technical users' requirements for changes to Training, Procedures and processes, then developing and implementing the required solutions across Asset Management.
• Organising daily wash-up and fault/ defect meetings to ascertain all shareholders were in sync re: test progress and producing strategic reports.
• Continuous in-depth and thorough Risk assessment and analysis of the Bank's testing procedures.
Bank of Ireland, Dublin - System Dynamics: Apr 2008 to Dec 2008
Role: Test Manager - Including SEM BCS
The 1Finance Programme emerged as a result of the recent implementation by the Bank of Ireland of the new Group operating model and the realisation that Finance Services required a transformational change to deliver the capabilities required by the business and to ascertain the bank's business processes were in adherence with Basel II regulations. The crux of the project was data migration from Oracle 11.1 (EBS) and SAP R3 to SAP BI v7. SAP Business Intelligence 7 is utilised to provide the platform to support the processing of Retail accounts and reporting requirements of the Business Consolidation Solution and Business Performance Measurement projects (utilising Business Objects 3.1) in their delivery of the Statutory and Management reporting information for all the Bank's finance business units going forward.
AIB Dublin - System Dynamics: Apr 2007 to Apr 2008
Role: Test Manager
As part of the bank's anti-fraud enhancement projects to implement Falcon upgrades and close the gaps on Fraud Model Degradation.
Responsibilities: • Reviewing functional and technical documentation
• Managing budgets and ensuring project is delivered within planned milestones and finances.
• Supervising the creation of test scenarios from design and requirement documentation
• Supervising the creation of test conditions from scenario documentation
• Supervising the creation of test scripts from scenario and condition documentation
• Product Quality Assurance and Testing
• Co-ordinating Change, Defect and Release Management
• Delivering Ab Initio presentations to other departments to gain business for the Competency centre
• Delivery of Exit Reports
• Having a robust network of contacts across teams to discuss issues that arise during Testing and deployment of projects
LogicaCMG Apr 2006 to Dec 2006
Role: Lead Test Consultant
Head of the LogicaCMG test team, charged by CLS Bank International (CLSB) with delivering the CLS-SI System. The team was given the following brief: CLSB provides the CLS-FX system, to give its Members a cross-border multi-currency infrastructure for the Settlement of gross payment instructions relating to foreign exchange Trades in order to eliminate foreign exchange Settlement risk. The Members operate under very rigorous operational requirements for foreign exchange processing with strict demands for prompt submission of Trade Instructions, payments and error rectification via asynchronous and synchronous messaging systems (SWIFT and MQ). CLSB need the CLS-SI system to support other financial products and Trade types (full lifecycle), starting with Non-Deliverable Forwards (NDF) and FX Options (OPR) but with others to follow. CLS-SI runs in parallel with the CLS-FX system and, in this release, uses CLS-FX to settle cash flows in CLS Settlement Eligible Currencies. T
Responsibilities: • Testing CLS-SI application prior to new release
• Documenting User stories
• Creation of test scenarios from design and requirement documentation
• Creation of test conditions from scenario documentation
• Creation of test scripts from scenario and condition documentation
• Product Quality Assurance and Testing
• Testing patches and replicating reported user issues
• Identifying and tracking defects to resolution
• Preparing Issue, defect and Change logs
• Supervising preparation of Test Reports
• Preparing System, Integration, Acceptance, Performance & Regression test cases and scenarios
• Preparing project plans and timelines.
• Investigating and analyzing results.
• Assisting in the set-up of and training in QTP
• Creation of detailed reports; graphical reports.
• Generation, tracking and reporting of defects.
Halifax - Oct 2004 to April 2006
Role: Lead Test Analyst
As part of the Test team, that worked on the BW3.5 upgrade for this well established Bank. The main tasks of the team were to ensure the continued consolidation of the following: • Integration of functional modules that support the lending process from deal building through servicing and trading
• Embodying workflow and information management process that integrates front-office origination, syndication, deal structuring, documentation, credit approval, portfolio monitoring and trading with back-office servicing and accounting processes in a web environment
• Loan-processing operations that were formerly spread across three separate systems into the single information source used by all components, speeding up the process, reducing errors and eliminating redundant effort
• Enhancing the Bank's Loan syndication capability with robust testing and quality assurance of the Loan processing system
Norwich Union - Oct 2003 to Sept 2004
Role: Lead Test/Business Analyst
As part of the effort of delivering the successful Data migration (Cornerstone - Life and Pensions system) of the Commercial Union, Provident Union and General Accident systems onto the Norwich Union architecture, he was part of the Testing Team that was charged with the task of vigorously testing the components within the systems and the end to end testing of the interfaces, between the different parts of the project. The project is divided into five parts namely: Cash processing, Hub (Data Transformation), General ledger (Oracle Financials), Reconciliation and Reporting. The work involved running queries in the Data Warehouse to interrogate the WH to confirm records and transactional data using TOAD.
His work transcended all five areas and the project is currently in Phase 2 of a three - phase plan. All the work involved in the project is critical in Norwich Union adhering to the FSA Statutory Regulations and the bringing the company in line with European Financial stipulations which go into effect in 2005. In the course of the project, I have utilised various tools like Oracle Financials 11i (General Ledger Processing), TOAD (Data Processing), SQL, UNIX and Test Director 8.0 (Scripting and Defect management) . The testing is across both Mainframe (TSO and Fileaid for Data inquiry) and Windows NT platforms. The crux of the project was to ensure the following: • To move all Cash processing (legacy systems) onto a common Cashbook (ABACUS)
• To provide Norwich Union Life Finance with a common technological platform (HUB) for Data processing
• To deliver a new Oracle GL set of books, with a Chart of Accounts to facilitate common reporting and accounting
• To re-engineer existing time-consuming Reconciliation processes by implementing modern technology and management techniques
Tesco Credit Cards - Aug 2002 to Oct 2003
Role: Lead Test/Business Analyst
Newell & Budge (Oyster Card Programme) - Nov 2001 to May 2002
Role: Test Analyst/ Project Coordinator
Goldfish Credit Cards - June 2000 to Oct 2001
Role: Test Analyst
Responsibilities: • Deliver full and complete lifecycle testing for the centralised repository for all data (Transaction and Master Data) required by BPM and SEM BCS 6.0. • Deliver full and complete lifecycle testing to verify SAP R/3 as the primary source of all data for the BI7 platform. The data scope of BI7 included data from CO-PA, CO-OM, FI-SL, FI-AA, FI-GL data sources, being pushed into the PSA, DSO, Infocubes, Multi-Providers and queries being run at the Bex and Business Object levels to produce relevant reports. • Deliver full and complete lifecycle testing of the Integrated and transparent system for Statutory Reporting, with one common Chart of Accounts, data drilldown to core General Ledger system, and common codification for Chart of Accounts and hierarchies. • Deliver full and complete lifecycle testing for the solution for managing the upload of non R/3 data into the data warehouse in a controlled manner thus meeting Security and SOx requirements, for example, Integrated Planning (IP) • Liaise with senior management, Technical Architects and vendors. • Ensure all testing RAID items are addressed in weekly sessions and managed to resolution. • Manage the Defect, Business Process, Release and Change management all through the project. • Deliver full and complete lifecycle testing for the solution of the repository for the Notes to the accounts and other statistical (i.e. non-nominal) account lines. • Deliver full and complete lifecycle testing for the migration and storage of all the required data to meet the reporting needs for the Business Consolidation Solution (BCS) and the Business Performance Measurement (BPM) projects and a robust integration of SAP BI7 with Business Objects 3.1 • Deliver full and complete lifecycle Testing for the reconciliation of Hyperion (previous platform) with BI7 (new platform)