OFSAA Basel Technical Consultant

• 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.