OFSAA developer - Oracle Financial Services Analytical Applications

Adept Solutions Inc.; Jersey City (NJ); On-site; USD 100,000 - 120,000; Full time

Job summary

A financial solutions company in Jersey City seeks an experienced OFSAA Developer. This role involves configuring allocation rules, troubleshooting technical issues, and maintaining OFSAA batch processes. Candidates should have over 5 years of experience with OFSAA modules and strong SQL skills. Additional knowledge in data warehousing will be advantageous. Join us for a rewarding opportunity to leverage your expertise in a dynamic environment.

Qualifications

• 5+ years of hands-on experience with OFSAA modules.
• Ability to write and debug complex SQL queries.
• Good understanding of profitability calculations.

Responsibilities

• Configure allocation rules in OFSAA for profitability.
• Troubleshoot technical issues in OFSAA log files.
• Maintain end-to-end OFSAA batch and provide support.

Skills

OFSAA v6.1 Profitability

Complex SQL queries

PL/SQL

Data Warehousing concepts

Transfer pricing rules

Job description

• Contract

Job Description

The OFSAA developer will be part of a development team implementing profitability solution using OFSAA

Key responsibilities

• Configuration of rules for cost and revenue allocation in OFSAA for profitability calculation. Configure FTP rules in OFSAA. Write T2Ts to transform data. Develop procedure using PL/SQL. Understand business requirements and implement technical solution within OFSAA in an efficient way. Test OFSAA configurations and fix defects as appropriate.
• Troubleshoot technical issues by analyzing OFSAA log files and fixing the issues.
• Understand complex SQL queries, analyze data related issues and identify root cause of issues / defects. Develop and implement performance optimal system.
• Maintain the end-to-end OFSAA batch and provide technical support.

Major responsibilities include

• Production support of OFSAA, this includes batch runs and minor development requests to fix defects as required.
• Troubleshoot technical issues by analyzing OFSAA log files and fixing the issues. Analyze data related issues and identify root cause of issues / defects.
• Develop rules for cost and revenue allocations in OFSAA including configuring FTP rules and writing T2Ts to transform data. Develop adhoc procedures using PL/SQL.
• Testing in support of projects and creation of project artifacts as required by project life cycle.

Qualifications

Qualifications:

• 5+ years of Hands-on experience in OFSAA v6.1 Profitability, FTP and GL Reconciliation modules.
• Good expertise in configuring allocation rules in OFSAA for cost allocation and revenue allocation for profitability management.
• Good expertise in configuring Transfer pricing rules in OFSAA FTP module.
• Good expertise in building T2T (Table to Table) transformations in OFSAA.
• 3+ years of expertise in developing forms with the help of OFSAA forms framework.
• 6+ years of experience writing and debugging complex SQL queries and Stored Procedures in Oracle database.
• In-depth understanding of Dimensions, hierarchies and attributes as it applies to OFSAA profitability modules.
• In-depth understanding of Data Warehousing concepts and dimensional modeling.
• Good understanding of functional aspects of profitability calculations.
• Working knowledge of OFSAA Run-Rule framework as it applies to Credit Risk application is a plus.
• 6+ years of experience working in the financial industry. Flexible in managing competing priorities and objectives.

Additional Information

All your information will be kept confidential according to EEO guidelines.