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.