Ofsaa Llfp Consultant

We are seeking an experienced Oracle OFSAA Consultant with strong expertise in Loan Loss Forecasting & Provisioning (LLFP) and Liquidity Risk Management (LRM) . The candidate will be responsible for implementing, configuring, customizing, and supporting OFSAA solutions for regulatory reporting, IFRS 9/CECL, liquidity risk, and enterprise risk management.

Experience with the OFSAA infrastructure and data model is essential. LLFP supports expected credit loss calculations for IFRS 9/CECL, while LRM provides liquidity risk analytics, stress testing, and regulatory reporting.

Key Responsibilities

Implement and support Oracle OFSAA LLFP and LRM modules. Gather and analyze business requirements from banking stakeholders. Configure OFSAA metadata, dimensions, hierarchies, assumptions, and rules. Develop and customize: T2T (Table-to-Table) transformations Data Mapping Business Rules Batch execution workflows Perform IFRS 9 Expected Credit Loss (ECL) implementation using LLFP.

Configure Probability of Default (PD), Loss Given Default (LGD), Exposure at Default (EAD), staging, and provisioning logic. Configure liquidity gap analysis, LCR, NSFR, cash flow projections, behavioral assumptions, and stress testing in LRM. Develop SQL, PL/SQL, and shell scripts for data processing and automation. Troubleshoot production issues and optimize application performance.

Coordinate with business, testing, and infrastructure teams. Prepare technical documentation and deployment artifacts.

Required Skills

Strong experience with Oracle OFSAA Infrastructure. Hands-on experience with: LLFP (IFRS 9 / CECL) LRM (Liquidity Risk Management) Strong Oracle SQL and PL/SQL skills. Experience with: ODI/OFSAA ETL Data Foundation (FSDF) Information Domains Batch Framework Metadata Configuration Data Quality Knowledge of Linux/Unix scripting. Experience with Oracle Database.