Consultant | (BI Reports, OTBI, FRS, SmartView) | Mumbai | Oracle

Job Title: Consultant – Oracle Fusion (Technical - Reports)

Experience: 3–5 Years

Location:

Job Type: Full-Time

Travel: As per project requirement.

Job Summary:

We are seeking a highly skilled and motivated Oracle Fusion Technical Consultant specializing in BI Publisher, OTBI, and FRS Reports. The ideal candidate will have hands-on experience in developing, customizing, and supporting reports within Oracle Fusion Cloud Applications. This role requires strong technical knowledge, analytical thinking, and problem-solving skills to deliver high-quality solutions in line with business requirements.

Key Responsibilities:

• Design, develop, and deploy reports using BI Publisher, OTBI, FRS, Smart View, and Excel-based templates.
• Gather business requirements and translate them into technical specifications for report development.
• Customize and extend standard Oracle Fusion reports as per client requirements.
• Work on data extraction using SQL, data modeling, and report layout designing.
• Collaborate with functional consultants to understand business needs and ensure accurate data representation.
• Perform unit testing, integration testing, and support user acceptance testing (UAT).
• Provide technical documentation for all developed reports and solutions.
• Troubleshoot and resolve issues in reports, including performance optimization and data accuracy.
• Support production environments, perform bug fixes, and handle change requests.
• Participate in project planning, estimations, and status reporting activities.

Technical Skills Required:

• Proficiency in BI Publisher, OTBI (Oracle Transactional Business Intelligence), FRS (Financial Reporting Studio).
• Strong SQL and PL/SQL skills for data extraction and manipulation.
• Experience in working with Oracle Cloud ERP modules like Finance (GL, AP, AR, FA), SCM, and HCM is a plus.
• Knowledge of Oracle Cloud Data Model and security structure.
• Familiarity with Web Services, FBDI, ADFDI, and HDL is desirable.
• Understanding of Fusion reporting tools integration with Excel, Smart View, etc.

Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Oracle certifications (preferred but not mandatory).