Technical Consultant - EPM (OFSAA ALM)

Overview

Technical Consultant - EPM (OFSAA ALM)

****4. Risk Analytics & Regulatory Reporting****

• Solution Architecture & Design

• Lead the architecture and design of OFSAA ALM solutions covering IRRBB and PRRBB
• Define data models, staging layers, and processing frameworks within OFSAA
• Design scalable, compliant solutions aligned with regulatory requirements
• Configure and implement Oracle OFSAA ALM modules
• Customize ALM processes including gap analysis, behavioral modeling, and cash flow engine setup
• Develop business rules, assumptions, and calculation logic
• Build and support data pipelines using ODI and OFSAA Data Foundation
• Ensure data quality, reconciliation, and lineage
• Work with large-scale financial datasets including loans, deposits, and securities
• Support reporting for IRR, LCR, and NII simulations
• Implement stress testing and scenario analysis
• Ensure alignment with regulatory and internal risk frameworks
• Optimize ALM batch processes for high-volume performance
• Tune Oracle SQL/PLSQL queries for efficiency
• Improve runtime performance of ALM engines and reporting
• Act as an SME for OFSAA ALM solutions
• Collaborate with Treasury, Risk, and Finance teams to gather requirements
• Conduct workshops, demos, and stakeholder discussions
• Analyze and resolve issues in ALM calculations and data flows
• Perform root cause analysis for discrepancies in outputs
• Provide production support and review technical artifacts
• Prepare Solution Design Documents (SDD), technical specifications, and data mapping documents
• Ensure compliance with internal standards and regulatory requirements

Requirements

• Strong experience in Oracle OFSAA ALM (mandatory)
• Hands-on experience with IRRBB / PRRBB frameworks
• Expertise in ODI (Oracle Data Integrator) and data integration
• Strong knowledge of Oracle SQL / PLSQL
• Experience in banking domain (Treasury, Risk, Finance)
• Understanding of ALM processes and risk analytics