Oracle OFSAA Consultant

Job Overview:

We are seeking an experienced Oracle OFSAA Consultant to join our team and contribute to the successful implementation and optimization of Oracle Financial Services Analytical Applications (OFSAA). The ideal candidate will have a strong background in working with key OFSAA modules (ALM, FTP, Basel III) and optimizing ETL processes to ensure data integrity and compliance with financial regulations. This is an excellent opportunity to work in a dynamic environment and help deliver solutions that enhance risk management and regulatory compliance.

Key Responsibilities:

• Implement Oracle Financial Services Analytical Applications (OFSAA) modules, particularly ALM (Asset and Liability Management), FTP (Funds Transfer Pricing), and Basel III.
• Optimize ETL processes to ensure efficient data flow, processing, and storage within the OFSAA platform.
• Ensure that all solutions are compliant with relevant regulations, including Basel III and other risk management frameworks.
• Collaborate with business stakeholders to gather requirements, design solutions, and ensure smooth implementation.
• Develop, test, and implement custom solutions using Oracle OFSAA tools and technologies.
• Perform data modeling and ensure the accuracy and consistency of financial data across various OFSAA modules.
• Manage and troubleshoot issues related to the OFSAA platform, ensuring high availability and minimal downtime.
• Provide guidance on best practices for system integration, risk management, and regulatory compliance.
• Support ongoing system maintenance, troubleshooting, and user support after deployment.

Key Skills & Qualifications:

• Strong experience with Oracle OFSAA modules: ALM (Asset and Liability Management), FTP (Funds Transfer Pricing), Basel III.
• Expertise in ETL processes: Design, development, and optimization of ETL workflows to enhance data quality and operational efficiency.
• Strong PL/SQL skills: Writing efficient queries, stored procedures, and triggers for data manipulation and integration.
• Risk Management Knowledge: Experience in risk management processes and financial regulations such as Basel III.
• Data Modeling: Experience in designing data models that support financial services applications, ensuring data consistency and integrity.
• Implementation and Support: Proven track record in the successful implementation and ongoing support of OFSAA solutions in complex financial environments.
• Problem-Solving & Troubleshooting: Ability to diagnose, analyze, and resolve technical and functional issues effectively.
• Collaboration: Ability to work closely with business stakeholders and IT teams to ensure the system meets business and compliance needs.
• 8+ years of experience in Oracle OFSAA, financial services, or a related field.

Preferred Qualifications:

• Experience working with regulatory compliance requirements (e.g., Basel III, IFRS 9).
• Knowledge of Oracle Financial Services Analytical Applications best practices and methodologies.
• Familiarity with Oracle database architecture and optimization techniques.