We are seeking an experienced Oracle OFSAA Consultant to implement, customize, and optimize Oracle Financial Services Analytical Applications (OFSAA) solutions. The ideal candidate will ensure compliance with banking regulations, enhance risk management capabilities, and support profitability objectives. This role requires deep expertise in OFSAA modules, PL/SQL, data modeling, and financial industry regulations.
Key Responsibilities:
Configure and optimize OFSAA solutions to meet regulatory compliance (Basel III, IFRS 9, Dodd-Frank) and business requirements.
Develop and enhance PL/SQL scripts, optimize SQL queries, and ensure efficient data processing.
Work with OFSAA modules such as FTP, ALM, LRM, PFT, and RRM.
Design and implement ETL processes, data models, and integration solutions.
Collaborate with stakeholders to translate business needs into technical solutions.
Support regulatory reporting frameworks (CCAR, DFAST) and ensure adherence to financial standards.
Follow Agile (Scrum/Kanban) methodologies for project delivery.
Utilize Oracle Exadata, OBIEE, Oracle Analytics Cloud (OAC), and BI tools for reporting.
Maintain version control using Git/Subversion and adhere to SDLC best practices.
Required Skills & Qualifications:
Bachelors degree in Computer Science, Information Technology, or related field.
5+ years of hands-on experience with OFSAA implementation and development.
Strong expertise in Oracle PL/SQL programming and SQL query optimization.
Experience with OFSAA modules (FTP, ALM, LRM, PFT, RRM).
Knowledge of financial regulations (Basel III, IFRS 9, Dodd-Frank).
Proficiency in data modeling, ETL, and data integration.
Familiarity with Oracle Exadata, OBIEE, and Oracle Analytics Cloud (OAC).
Experience with regulatory reporting (CCAR, DFAST).
Knowledge of Java, web services, and cloud platforms (OCI, AWS) is a plus.
Certification in OFSAA is preferred.
Soft Skills & Competencies:
Strong analytical and problem-solving abilities.
Excellent communication and collaboration skills.
Ability to multitask and work in a fast-paced environment.
Preferred Qualifications:
Experience with Agile/Scrum/Kanban methodologies.
Familiarity with version control (Git, Subversion).
Knowledge of cloud computing (OCI, AWS).
Numbers & Facts
Location
(Remote)
Skills
Agile Programming Methodologiesunmatched
Amazon Web Services (AWS)unmatched
Analysis Skillsunmatched
Analytics Cloudunmatched
Banking Regulationsunmatched
Basel III (Third Basel Accord)unmatched
Best Practicesunmatched
Business Intelligence Softwareunmatched
Cloud Computingunmatched
Communication Skillsunmatched
Comprehensive Capital Analysis and Review (CCAR)unmatched
Computer Scienceunmatched
Consultingunmatched
Data Modelingunmatched
Data Processingunmatched
Database Extract Transform and Load (ETL)unmatched
Dodd Frank Actunmatched
FTP (File Transfer Protocol)unmatched
Financial Regulationsunmatched
Financial Services Softwareunmatched
Gitunmatched
Information Technology & Information Systemsunmatched
International Financial Reporting Standards (IFRS)unmatched
Javaunmatched
Kanbanunmatched
Maintain Complianceunmatched
Multitaskingunmatched
Oracleunmatched
Oracle Business Intelligence Enterprise Edition (OBIEE)unmatched
Oracle Financial Analyzerunmatched
Oracle PL-SQLunmatched
Problem Solving Skillsunmatched
Profit & Lossunmatched
Query Optimizationunmatched
Regulatory Complianceunmatched
Regulatory Reportsunmatched
Risk Managementunmatched
SQL (Structured Query Language)unmatched
Scripting (Scripting Languages)unmatched
Scrum Project Management and Software Developmentunmatched