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.