Senior Consultant | (BI Reports, OTBI, FRS, SmartView) | Gurugram | Oracle
- Job requisition ID : 106942
- Location: Gurugram
- Entity: Deloitte Touche Tohmatsu India LLP
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.
