# OFSAA LLFP Consultant

**Company:** [Unison Group](http://jobs.workable.com/companies/deKpPhPMtQZga7XoPG1tSo.md)
**Location:** New Delhi, India
**Workplace:** on site
**Department:** Jonali

[Apply for this job](http://jobs.workable.com/view/b3d07c3a-aa51-4628-a48f-6d0bd1dd176f)

## Description

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.