OFSAA Consultant

We are hiring OFSAA consultants for an independent validation engagement at a bank that is implementing OFSAA EPM, ERM and the Reconciliation Framework. You will compare OFSAA report data against Legacy report data, classify the differences, and establish their root cause. You will do this against approved requirements, FSD/SDD, rules and parameters. This is a specialist review and analysis role, as well as for SIT, UAT and regression testing.

Responsibilities:

• Review OFSAA reports against Legacy reports for agreed batch-run dates (FIC_MIS_DATE) and identify the differences.
• Validate core/application parameters, rules, methodologies and computations against Bank-approved requirements and FSD/SDD.
• Review UAT evidence, Pass/Fail test cases, defect logs and RCA to understand the existing coverage.
• Design validation test cases and queries, and run targeted data checks on OFSAA staging and result tables (e. g., FSI_D, RES_DTL).
• Classify differences (parameter, rule/methodology, computation, allocation, requirement/design, Legacy-specific) and document the evidence.
• Revalidate sample cases after fixes by the implementation team, and prepare difference logs and management reports.
• Support Go-Live and Post-Go-Live hand-holding.
• Design SIT and UAT Test Cases, Execute Test Cases, gather logs for Pass Test Cases and Fail Test Cases.

Requirements:

• Good understanding of the QA/Testing Life Cycle, and test design and preparation skills for OFSAA EPM and ERM.
• Ability to read and interpret FSD/SDD, business rules and parameter setups.
• Review and refine the Core Parameters, application-specific parameters, Rules, etc.
• Good SQL skills for data and result-table validation (Oracle).
• Understanding of the OFSAA data flow: Staging, Processing, Results Reporting.
• Strong analytical and documentation skills; clear written reporting to the bank and coordination with other stakeholders.
• Strong Excel experience and knowledge - Pivot, VLOOKUP, etc.

Good to Have:

• Experience in banking reporting / regulatory reporting (RBI).
• Exposure to data reconciliation or data-quality tools.
• Prior implementation or UAT experience on an OFSAA programme at a bank.

Required Application Experience (hands-on in at least two areas, with depth in one)

• Area
• Experience expected
• ALM / LRM
• Gap, liquidity and cash-flow reports; LCR/NSFR; run and process setup
• PFT / FTP
• Profitability and FTP rules, allocations, transfer-rate methodology
• Basel Capital Adequacy
• CAR computation, RWA, exposure and mitigant mapping, regulatory reports
• IFRS 9 - ECL / EIR
• Staging, PD/LGD/EAD, impairment and EIR computation
• OFSAA Reconciliation Framework
• GL reconciliation rule setup and reconciliation reports