Senior Consultant
- JMR Infotech
- 5 - 10 years
- Delhi, NCR
- 3 months ago
- Email to a friend
- Report this job
Job Description
Role & responsibilities
Experience: 5 10 years
Job Summary: We are seeking an experienced OFSAA Technical / Functional Consultant to join our team and contribute to the successful implementation and configuration of Oracle Financial Services Analytical Applications (OFSAA) for our financial institution clients.
OFSAA Modules Specialisation: OFSAA ALM, OFSAA FTP, OFSAA PFT, OFSAA LRM, OFSAA IFRS9, OFSAA Basel Regulatory Capital.
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.
- Analyze data related issues and identify root cause of issues / defects.
- Develop/configure rules for LCR, NSFR, Basel Regulatory Capital, IFRS9 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:
- Bachelors degree in computer science or information systems,
- 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 modelling
- 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.
Preferred candidate profile We have an hiring for technical / Functional and OBIEE as well as.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: ConsultingRole Category: Management ConsultingRole: Sr. ConsultantEmployement Type: Full timeContact Details:
Company: JMR InfotechLocation(s): Delhi, NCR
Similar positions
JMR Infotech
JMR’s approach focuses on bringing our expertise and strengths together with Oracle’s market leading Digital and Banking solutions to power best-in-class outcomes for financial institutions to transform their businesses and stay ahead of competition. JMR leverages Oracle’s cloud...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in