Senior Consultant | (BI Reports, OTBI, FRS, SmartView) | Gurugram | Oracle
- Job requisition ID : 106942
- Location: Gurugram
- Entity: Deloitte Touche Tohmatsu India LLP
Deloitte.
Be audacious in impact
When was the last time you thought the unthinkable, defined the unfathomable, or did what no one else has dared to try?
At Deloitte, we're creating bold new frontiers for our clients and communities. Our roar echoes across India and beyond. So, bring your unique self and rise louder and leap further than ever before.
Senior Consultant | BI Reports I 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.
