- Design, develop, and implement OFSAA Basel solutions for Credit Risk, Market Risk, Operational Risk, and Capital Adequacy reporting.
- Configure and maintain OFSAA modules including Basel Regulatory Capital, Risk Analytics, and Enterprise Risk Management.
- Develop and optimize T2T (Table-to-Table) transformations, Data Mapping, and ETL processes within OFSAA.
- Perform data integration from source banking systems into OFSAA using FSDF (Financial Services Data Foundation).
- Develop and optimize Oracle SQL and PL/SQL scripts for data processing, validation, and reporting.
- Configure OFSAA metadata, business rules, hierarchies, and regulatory calculations.
- Support Basel II/III/IV implementation initiatives and regulatory reporting requirements.
- Perform data reconciliation, data quality assessments, and issue resolution.
- Collaborate with Risk, Finance, Regulatory Reporting, and Business teams to translate requirements into technical solutions.
- Participate in SIT, UAT, deployment, and production support activities.
- Conduct performance tuning and troubleshooting of OFSAA applications and database processes.
Requirements
Strong hands-on experience in OFSAA Basel implementations.
Expertise in:
- OFSAA Infrastructure (OFSAAI)
- FSDF (Financial Services Data Foundation)
- T2T Development
- Data Mapping & Metadata Configuration
- OFSAA Data Model
Advanced Oracle SQL and PL/SQL programming skills.
Experience with ETL, data warehousing, and banking data integration.
Strong understanding of:
- Basel II / Basel III / Basel IV
- Risk Weighted Assets (RWA)
- Capital Adequacy
- Credit Risk
- Market Risk
- Operational Risk
Experience with OFSAA ERM modules and Basel Regulatory Reporting.
Knowledge of Unix/Linux and Shell scripting.
Experience in performance tuning and query optimization.
