MonoSpear Technologies - Oracle Fusion SCM Technical Consultant

Description :

About the Role :

We are seeking a highly skilled Oracle Fusion SCM Technical Consultant to join our team in the UAE.

The ideal candidate will possess strong technical expertise in Oracle Fusion SCM applications, reporting, integrations, and data extraction tools.

The role requires hands-on experience in designing, developing, and supporting technical solutions for Oracle Fusion Supply Chain Management modules within Manufacturing and Retail environments.

The candidate will collaborate closely with functional consultants, business stakeholders, and technical teams to deliver scalable and efficient Oracle Fusion SCM solutions.

Key Responsibilities :

- Design, develop, and support technical solutions within Oracle Fusion SCM applications.

- Develop and customize reports, dashboards, and analytics using :

1. BI Publisher

2. OTBI (Oracle Transactional Business Intelligence)

3. Fusion Analytics

- Create and optimize Oracle SQL and PL/SQL queries, packages, procedures, and scripts.

- Work on BICC (BI Cloud Connector) extracts for data migration, reporting, and integrations.

- Schedule, monitor, and troubleshoot ESS (Enterprise Scheduler Service) jobs.

- Develop data extracts, interfaces, and integrations between Oracle Fusion SCM and external systems.

- Support SCM business processes across Procurement, Inventory, Order Management, Manufacturing, and Logistics modules.

- Collaborate with functional teams to gather business requirements and convert them into technical specifications.

- Perform troubleshooting, issue resolution, root cause analysis, and performance tuning.

- Develop and maintain technical documentation, including :

1. Technical Design Documents (TDD)

2. Mapping Documents

3. Test Cases

4. Deployment Documents

- Participate in implementation, enhancement, upgrade, rollout, and support projects.

- Conduct unit testing, SIT, UAT support, and deployment activities.

- Ensure compliance with Oracle best practices and enterprise standards.

Required Skills & Expertise :

Technical Skills :

- Strong hands-on experience in Oracle Fusion SCM Technical consulting.

Expertise in :

- BI Publisher Reports

- OTBI Reporting

- Oracle SQL & PL/SQL

- BICC Extracts

- ESS Jobs

- Fusion Reporting & Analytics

Experience with :

- FBDI

- HDL

- REST/SOAP APIs

- Oracle Integration Cloud (OIC) preferred

- Knowledge of Fusion security roles, data access, and reporting security.

- Experience in developing custom reports, interfaces, conversions, and extensions.

- Strong understanding of Oracle Fusion data models and SCM architecture