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

Job Description

Design, develop, and maintain reports, dashboards, and analytics within Oracle Fusion Cloud Applications.

Develop and support reporting solutions using BI Publisher (BIP), OTBI (Oracle Transactional Business Intelligence), FRS and other available tools.

Gather, analyze, and translate business reporting requirements into technical solutions.

Create and customize operational, financial, procurement, HCM, SCM, and cross-functional reports based on business needs.

Develop data models, SQL queries, report templates, bursting solutions, and report scheduling in Oracle Fusion.

Work closely with functional and business teams to understand reporting requirements and provide scalable reporting solutions.

Perform data validation, reconciliation, and troubleshooting to ensure report accuracy and integrity.

Support integration and reporting requirements involving Oracle Fusion and third-party systems.

Optimize report performance and ensure adherence to Oracle reporting best practices.

Prepare technical documentation, knowledge transfer documents, and user training materials.

Provide production support and resolve reporting-related incidents.

Should have good understanding of Oracle fusion ERP  modules to build and support reporting requirement.

Key skills required

4–7 years of experience in Oracle Reporting or Oracle Fusion Applications

Strong hands-on experience with BI Publisher (data templates, Report Layouts, bursting)

Experience building OTBI reports and dashboards

Strong SQL skills and understanding of Oracle Fusion data models

Experience working in a multiple implementation and support project.