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

Job Title: Consultant Oracle Fusion (Technical - Reports) Experience: 35 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:Bachelors degree in Computer Science, Information Technology, or a related field.Oracle certifications (preferred but not mandatory).