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.