Oracle Fusion Technical Consultant (Reporting)

De Novo Solutions; Chennai District; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

De Novo Solutions seeks an experienced Oracle Fusion Technical Consultant (Reporting) to design, develop, and deliver Oracle Cloud reporting solutions across multiple client programmes. You will work with OTBI, FRS, BIP, and OAX/OAS, building reusable assets and ensuring high delivery quality in a customer-facing role.

You will contribute to reporting standards, mentor junior consultants, and collaborate with global teams across time zones.

Qualifications

• 3–5 years of Oracle Cloud reporting experience
• Proven experience delivering at least two Oracle Cloud programmes
• Experience working in a consulting environment

Responsibilities

• Design and deliver enterprise reporting solutions across Oracle Cloud platforms
• Develop OTBI analyses, dashboards, and subject area models
• Design FRS reports and management packs for financial reporting
• Build and maintain BIP report templates (RTF, Excel, PDF) and datasets for OAX/OAS
• Contribute to reusable reporting frameworks and templates
• Support reporting error handling, scheduling, and distribution strategies
• Ensure reports follow best practices and security controls

Skills

OTBI

FRS

BIP

OAX/OAS

Oracle Fusion reporting

SQL

RTF/XML templates

Excel reporting

Git

Reporting testing

Security/configuration

Education

Bachelor's degree in Computer Science / IT

Tools

Git

Job description

Role

We are seeking a Oracle Fusion Technical Consultant (Reporting) who contributes to the design, development, and delivery of Oracle Cloud data reporting solutions across multiple client and internal programmes.

This role requires strong expertise in Oracle Transactional Business Intelligence (OTBI), Financial Reporting Studio (FRS), Oracle Business Intelligence Publisher (BIP), and Oracle Analytics Cloud (OAX/OAS), combined with good communication and stakeholder management skills to work effectively across delivery environments.

As the Reporting Technical Consultant, you will contribute to reporting standards and design decisions, support junior consultants, and help ensure delivery quality across projects. You will also contribute to building reusable reporting assets and the long-term reporting capability of the organisation. This role requires working in a customer-facing capacity and requires stakeholder management, including client and cross-functional teams. Strong experience working in distributed teams across time zones is essential.

Migration Architecture & Solution Design

• Contribute to the design and delivery of enterprise reporting solutions
• Support reporting architecture decisions across Oracle Cloud platforms
• Design OTBI analyses, dashboards, and subject area models
• Develop FRS reports and management packs for financial reporting
• Build and maintain BIP report templates (RTF, Excel, PDF)
• Contribute to Oracle Analytics Cloud (OAX/OAS) datasets, workbooks, and dashboards
• Contribute to reusable reporting frameworks and templates
• Support reporting error handling, scheduling, and distribution strategies
• Ensure reports follow best practices and architectural standards

Oracle Transactional Business Intelligence (OTBI) – Design, Build, Test and Support delivery of:

• OTBI analyses and dashboards
• Subject area customisation and security configuration
• Prompted and parameterised reports
• Scheduled reporting and delivery (incl. bursting)
• Performance tuning of complex analyses

Financial Reporting Studio (FRS) – Design, Build, Test and Support delivery of:

• Financial statements and management reports
• Row and column set definitions
• Multi-currency and multi-ledger reporting
• Report Books and batch scheduling

Oracle Business Intelligence Publisher (BIP) – Design, Build, Test and Support delivery of:

• RTF, Excel, and PDF report templates
• Data models and parameter configuration
• Bursting and scheduled delivery
• Integration with Oracle Fusion data sources
• Report troubleshooting and performance optimisation

Oracle Analytics Cloud (OAX / OAS) – Design, Build, Test and Support delivery of:

• Self-service datasets and data flows
• Workbooks, visualisations, and dashboards
• Semantic model (RPD) contributions and subject area extensions
• Connections to Oracle Fusion and other data sources
• Report and dashboard performance tuning

Oracle Fusion Reporting – Develop reporting solutions across:

• Oracle HCM Cloud
• Oracle ERP Cloud
• Oracle EPM Cloud (where applicable)
• Payroll and Finance business processes

Strong understanding of:

• Oracle Fusion data models and business objects
• Security and data access controls in reporting
• Oracle reporting use cases across HCM and ERP modules

Oracle Fusion Security – Mandatory understanding and hands-on experience in Oracle Fusion Security, including:

• Role-based access control (RBAC)
• User provisioning and role assignment
• Job roles, abstract roles, and custom roles
• Data Security Policies
• Function Security Policies
• Security Console configuration and troubleshooting
• Understanding of security inheritance and access control within Oracle Fusion

Technical Leadership & Capability Development:

• Support and share knowledge with junior migration consultants
• Provide technical input across multiple concurrent programmes
• Follow and contribute to data migration design standards
• Contribute to reusable migration patterns and accelerators
• Contribute to internal migration documentation and playbooks
• Participate in knowledge sharing across distributed teams
• Participate in peer reviews and technical quality assurance

Skills & Experience:

Essential:

• 3 – 5 years of experience in Oracle Cloud reporting experience.
• Proven experience delivering at least two Oracle Cloud programmes.
• Experience working in a consulting environment

Technical Experience:

• Oracle Transactional Business Intelligence (OTBI)
• Financial Reporting Studio (FRS)
• Oracle Business Intelligence Publisher (BIP)
• Oracle Analytics Cloud (OAX / OAS)
• Oracle Fusion reporting (HCM / ERP)
• Report performance tuning and troubleshooting
• Security and data access configuration
• Report scheduling and distribution

Development Experience:

• SQL and data querying
• RTF and XML template design
• Excel-based reporting
• Git version control
• Reporting testing frameworks

Desirable:

• Oracle Cloud Reporting Certification
• Oracle Cloud Infrastructure Certification
• Evidence of successful delivery of multiple Oracle Cloud programmes
• Experience with Oracle EPM Cloud reporting
• Experience with Oracle Analytics Cloud semantic model (RPD) development
• Experience designing reusable reporting frameworks
• Experience building reporting standards and templates
• Experience working in large enterprise programmes
• Experience supporting distributed global teams

Person Specification:

• Ethical Conduct: Commitment to ethical standards, integrity, and compliance with relevant regulations and organizational policies.
• Teamwork: Strong interpersonal skills and a track record of working effectively within cross-functional teams, including stakeholders.
• Customer Service Orientation: Focus on meeting internal and external customer needs, providing responsive support, and building positive relationships with stakeholders. High level of adaptability and flexibility, with the ability to build strong long-lasting client relationships.
• Continuous Learning: Willingness to learn and develop new skills, stay updated on industry trends, and pursue professional development opportunities to enable growth. A growth mindset with a commitment to continuous improvement; for yourself, your team, and your clients.
• Consulting Skills:Strong consulting skills are essential for effectively communicating with clients, understanding their needs, providing recommendations, and guiding them through the implementation process. This includes active listening, problem-solving, and client relationship management.
• Analytical & Problem-Solving: Tailoring solutions to business goals, processes, and constraints.

Qualifications

Bachelor’s degree in computer science, Information Technology, or related field.

Compensation & Benefits

Salary – Best in Industry
Benefits – Term Life / Mediclaim / Accident insurance
Training – Certified training in Oracle Cloudas required by your role.