ORACLE REPORTING & ANLAYTICS (FDI) LEAD

Role Summary

We are seeking a highly skilled and experienced Oracle Reporting & Analytics (FDI) Lead to join our team. As an Oracle Reporting & Analytics (FDI) Lead, you will be responsible for Oracle ERP Cloud and EBS Technologies analytics reporting with solid understanding of ERP data structure in PPM, Finance, Procurement, HCM and Sales modules. You will collaborate closely with stakeholders from the business, IT peers, internal and external functional consultants, and developers, to ensure the successful delivery of Oracle Fusion Applications solutions that enable our business requirements. Your expertise will be critical in guiding the technical design and development of Oracle Fusion reports to achieve optimal performance and scalability.

Responsibilities

Gathering Business requirements, design specification, code development, unit, integration, and acceptance testing and implementation support.

Responsible to build data models to support analytical reporting requirements, reports, and dashboards. Setup application per client needs to manage their data models and data pipelines.

• Build custom data pipelines and integration with other warehouse applications
• Responsible to build reports and optimizing dashboards.
• Assist with provisioning FDI, Admin Configurations, verify FDI pre-requisites includes security, configure, and activate pipeline data loads

Key Competencies / Skills

Bachelor's degree in computer science or related field with 12+ years of experience in Data Analytics & reporting tools with specialization in Oracle FDI or Oracle Analytical Cloud (OAC) or OBIEE Analytics Reporting tools

Hands-on and demonstrable experience and knowledge of implementing FDI (FAW) and BI Analytics using Oracle Analytics Cloud (OAC) and Autonomous Data Warehouse (ADW)

Minimum one implementation experience in Fusing Data Intelligence

Able to build custom data pipelines and integration with other warehouse applications

Development experience of custom Data Warehouse projects using ETL tool as ODI/ODI Marketplace on OCI infrastructure

Good Functional Understanding on Oracle ERP Modules, Finance, PPM, Sales, HCM also well versed with Fusion Data Model.

Experienced in Data Augmentation, semantic model extensions, Optimizing dashboards and FDI roles

Excellent SQL Query, Analytical Custom Reports/Dashboards and debugging skills

Committed Team Player and Lead and mentor the team

Preferred Skills

Experienced in OBIEE, ERP cloud BIP, BICC, OCI DI and OTBI Reporting

Knowledge with Fusion PPM, CX and HCM core modules

Knowledge on GL Balance Cubes, FRS/Smart View