Job Title:  Senior Consultant | (BI Reports, OTBI, FRS, SmartView) | Bengaluru | Oracle

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

Experience: 5–8 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).