Job Description*

To perform the end-to-end conformance testing program for Regulatory Liquidity Reporting. This will include:

1. identification of scope and building test plans;

2. agreeing the scope and test plans, sampling criteria, etc. with relevant stake holders;

3. gather relevant regulatory instructions, business requirements, interpretations, code sourcing data sourcing and transformations, etc.;

4. execute test plan

5. report test results and agree ownership for remediation plan, if any

The role will require strong analytical skills and functional knowledge of reading and writing SQL scripts. To proactively engage the on-shore report owners and relevant data and technology teams responsible for implementing the report to agree and execute the testing plans. The role will involve collaborating with multiple on-shore and off-shore business partners across the bank to understand different report implementations.

Responsibilities*

• Identify and prioritize testing scope

• Build test plan. Agree the same with all stakeholders and publish/notify the milestones and timelines.

• Develop sampling approach and criteria

• Identify information requirements and notify relevant stakeholders

• Engagement with Global liquidity Management Report owners, SMEs and other stakeholders to obtain the relevant reports, reporting instructions, business requirements, interpretations, sourcing logic and code for data and transformations, definitions for elements in sourcing logic, etc.

• Prioritize different data elements for testing

• Translate the SQL code/logic into plain English 

• Liaison with Code testing team to execute the testing for coded logic and transformation.

• Execute testing of other elements

• Compare output of the testing output to report instructions

• Aggregate the test results and findings and document the same

• Review the findings with relevant stakeholders

• Coordinate initial escalation and reporting management to address disputed observations/findings including agreeing additional testing

• Agree the final findings and remediation owner for each

• Agree remediation plan and timelines

• Complete the test report and remediation plan