This candidate worked on the CTA (Cost-To-Achieve) Project as a Data/Test Analyst to manage the supplier and customer mappings for use in the monthly bill run. They developed power queries to analyse all HIBS data extracts, transforming them into data load formats for testing. They also processed and uploaded data files to HIBS to calculate for the bill run, identified gaps (defects) in CTA dataset for upload into HIBS, and designed, developed and tested a contract loader in Excel using VBA & Power BI to upload all external and intercompany contracts to Fusion. They also created visualisations in Power BI to illustrate KPIs for contract loader files, reconciling to input files.

Provided support to the Resolvability Assessment Framework (RAF) Programme, managing the collection of the Contingency Funding Investment. Responsibilities included defining the Transaction Approval Process, mapping Legal Entities through to Resolution Group, generating stress test reports and coordinating Service Companies. Achievements included optimising the Delivery Service Billing MI (DSBMI) to generate Contingency Funding and Working Capital data, and delivering high quality liquid assets (government bonds).

The Test/Data Analyst was responsible for managing the reconciliation of HIBS data to Fusion, ensuring the accuracy of data flow from HIBS to Fusion and improving processing times. The Analyst created SQL scripting for function to function and Intercept mappings, FDMEE scripting for revised mappings, Oracle contract loader for upload of new contracts and tested rules in development environment. The Analyst was successful in achieving a clear summary of data flow with known variances accounted for.

The candidate worked as a Data/Test Analyst Operational Risk for Deutsche Bank, creating and managing a risk assessment tool. This included manipulating and uploading data, maintaining reference data, performing training sessions, reporting defects, working in an agile environment, producing a requirements document, and supporting users. The candidate also created BDD scripts for the risk assessment tool in preparation for automation testing.

Provided testing and data reconciliation services for the Management Reporting Programme to deliver a new reporting platform on Tableau. Responsible for test plans, execution and daily scrums. Reported test status to Programme Manager and Head of Testing. Wrote Test Plans and Closure Reports for Senior Management approval.

Provided technical expertise in the testing and implementation of Oracle Enterprise Data Quality (OEDQ) change requests. Developed test plans and test cases, reported test requirements and results, and produced progress dashboards and defect trackers. Used basic Unix commands to perform checks for business analysts and end users. Ensured all requirements were met before changes were implemented in the live environment.

Provided expert technical support for the Group and Divisional Reporting Services (GDRS) Programme, implementation of a new SAP-based financial reporting and consolidation system. Reconciled and analysed customer balance data between HBOS and Lloyds systems, managing testers for critical business testing, proving cycles and live weekend. Designed and implemented reconciliation procedures, and worked closely with third party vendors to develop a reconciliation tool and testing platform. Managed daily defects with business, IT and third party vendors.