Adept Solutions Inc
OFSAA developer - Oracle Financial Services Analytical Applications
Adept Solutions Inc, Jersey City, New Jersey, United States, 07390
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. #J-18808-Ljbffr
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. #J-18808-Ljbffr