Position Title: Oracle Fusion Resource - Reporting Specialist (P3B)
We are seeking a highly skilled and experienced Oracle Fusion Resource with a minimum of 5 years of hands-on experience, specializing in reporting and possessing deep knowledge of modules such as General Ledger (GL). The ideal candidate will play a crucial role in our organizations Oracle Fusion environment, focusing primarily on reporting functionalities and leveraging their expertise in GL modules.
Responsibilities:
1. Reporting Expertise:
- Design, develop, and maintain Oracle Fusion reports utilizing tools such as BI Publisher, OTBI (Oracle Transactional Business Intelligence), and FRS (Financial Reporting Studio).
- Analyze reporting requirements from various business units and translate them into effective reporting solutions.
- Optimize report performance and ensure data accuracy and integrity.
- Create dashboards for function heads & CXOs.
- Create/customize report security and data security.
2. Supporting Financial Modules - General Ledger (GL):
- Demonstrate a good understanding of Oracle Fusion General Ledger module functionalities, data, configurations, and best practices.
- Provide support in GL setup, chart of accounts design, journal entries, period close activities, and financial reporting requirements.
3. Technical Skills:
- Proficiency in SQL and PL/SQL for data retrieval, manipulation, and custom reporting requirements.
- Experience in developing and maintaining data models, data extracts, and data integrations within Oracle Fusion environment.
- Building and managing custom OTBI subject areas and loading data using ADFDI & VBCS templates.
- Groovy for App composer or exposure to any object-oriented programming.
4. Collaboration and Communication:
- Collaborate with cross-functional teams including Finance, IT, and other business users to gather requirements, resolve issues, and deliver solutions aligned with business objectives.
- Communicate effectively with stakeholders to provide updates on project status, report development, and issue resolutions.
5. Continuous Improvement:
- Stay updated with the latest Oracle Fusion updates, patches, and new features related to reporting and GL modules.
- Identify opportunities for process improvements, automation, and enhancement of reporting capabilities to drive efficiency and effectiveness.
Qualifications :
- Bachelor s degree in computer science, Information Systems, Finance, or related field.
- Minimum of 5 years of hands-on experience with Oracle Fusion applications, with a focus on reporting and GL modules.
- Proven expertise in developing and maintaining Oracle Fusion reports using BI Publisher, OTBI, and FRS.
- Strong understanding of Oracle Fusion General Ledger module functionalities, data and configurations.
- Proficiency in SQL and PL/SQL for data retrieval and manipulation.
- Excellent analytical, problem-solving, and communication skills.
- Ability to work independently as well as collaboratively in a team environment.
- Oracle Fusion certifications (optional but preferred).