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

The team

Enterprise technology must do much more than keep the wheels turning; it is the engine that drives functional excellence and the enabler of innovation and long-term growth. Learn more about ET&P

Your work profile

Report Development

• Design, develop, and deploy BI Publisher reports for Oracle Fusion Cloud applications.
• Create Pixel Perfect reports including:
• Operational Reports
• Management Reports
• Regulatory Reports
• Audit Reports
• Invoice and Document Templates
• Project Reports
• Develop reports using XML, RTF, Excel, PDF, and eText templates.
• Create bursting reports for automated distribution to stakeholders.

Data Model Development

• Design and develop BI Publisher Data Models.
• Develop SQL queries and datasets using Fusion subject areas and database structures.
• Create parameter-driven and dynamic reports.
• Optimize report performance and execution times.
• Develop data extraction reports for integrations and downstream systems.

Oracle Fusion Reporting

• Develop reports across:
• Financials
• Procurement
• Project Portfolio Management (PPM)
• Supply Chain Management (SCM)
• Human Capital Management (HCM)
• Configure security and data access controls for reports.
• Support custom reporting requirements and business analytics.

OTBI & Analytics

• Develop OTBI analyses and dashboards.
• Convert OTBI analyses into BI Publisher reports where required.
• Collaborate with business users to define KPIs and reporting requirements.
• Support management dashboards and executive reporting.

Integration & Data Extraction

• Develop extract reports for:
• Oracle Integration Cloud (OIC)
• Primavera Unifier
• Primavera Cloud (OPC)
• Third-party systems
• Support file generation in XML, CSV, Excel, PDF, and Text formats.
• Develop scheduled reporting and automated report delivery mechanisms.

Testing & Support

• Prepare technical design documents and report specifications.
• Perform unit testing and support UAT activities.
• Troubleshoot report issues and optimize performance.
• Support quarterly Oracle updates and regression testing.

Key  Skills Required

Oracle Fusion Reporting

• 5–8 years of Oracle reporting experience.
• Minimum 3 years of Oracle Fusion BI Publisher experience.
• Experience in at least 2–3 Oracle Fusion implementation projects.
• Strong expertise in:
• BI Publisher (BIP)
• OTBI
• Financial Reporting Center (FRC)
• Smart View

Technical Skills

• Strong SQL and query-writing skills.
• Experience with:
• XML Publisher
• Data Models
• RTF Templates
• Excel Templates
• eText Templates
• Bursting Controls
• Scheduler Jobs
• Knowledge of XML, XSD, XPath, and XSLT.
• Understanding of Fusion Security and Role-Based Access Controls (RBAC).

Functional Exposure

Experience supporting reporting requirements across:

• General Ledger (GL)
• Accounts Payable (AP)
• Accounts Receivable (AR)
• Fixed Assets (FA)
• Cash Management (CM)
• Procurement
• Project Costing
• Project Billing
• Contracts
• SCM
• HCM

Preferred Skills

• Experience with Oracle Primavera Unifier reporting and integrations.
• Experience supporting Oracle Primavera Cloud (OPC) reporting requirements.
• Knowledge of Oracle Integration Cloud (OIC).
• Experience in data migration and reconciliation reporting.
• Exposure to Oracle Analytics Cloud (OAC) is an advantage.
• Experience in EPC, Infrastructure, Utilities, Construction, or Water Industry projects.

Qualifications

• Bachelor's Degree in Engineering, Computer Science, Information Technology, Commerce, or related discipline.
• Oracle BI Publisher and Oracle Fusion certifications preferred.

Key Competencies

• Strong analytical and reporting skills.
• Excellent SQL troubleshooting and optimization capabilities.
• Strong communication and client-facing skills.
• Ability to independently manage reporting workstreams.
• Strong documentation and requirement-gathering abilities.
• Experience mentoring junior consultants and developers.