Oracle Fusion SCM SME

Overview

Location

Experience

Key Responsibilities

• Act as the primary functional authority for Oracle Fusion SCM modules including Procurement, Inventory Management, Order Management, Finance, Supply Chain Planning, and Costing.
• Engage with business stakeholders to elicit, analyze, and document SCM reporting requirements including KPIs, operational dashboards, regulatory reports, and management information packs.
• Translate complex SCM business processes into structured functional specifications for integration and reporting design.
• Facilitate workshops and working sessions with finance, operations, and procurement teams to validate reporting scope and data requirements.
• Lead the creation and maintenance of comprehensive Source-to-Target (S2T) mapping documents covering Oracle Fusion SCM data objects including tables, views, OTBI subject areas, and BICC PVO models.
• Maintain complete data lineage documentation to ensure traceability from Oracle source systems through transformation layers to final reporting outputs.
• Collaborate closely with data engineers on ETL/ELT pipeline design and ensure S2T mappings are implementable within integration platforms such as Azure Data Factory and Databricks.
• Define and document business transformation rules for SCM data including:
• o Unit-of-measure conversions
• o Currency normalization
• o Status code lookups
• o Supplier hierarchies
• o Item classification mappings
• Support the design and development of SCM analytical reports and dashboards including:
• o Procurement spend analysis
• o Inventory aging reports
• o Supplier performance reporting
• o Order fulfillment analysis
• o Supply chain cost reporting
• Define SCM reporting data models including:
• o Fact tables (purchase orders, goods receipts, shipments, work orders)
• o Dimension tables (supplier, item, warehouse, cost center, project)
• o Bridge and aggregate layers
• Possess 7+ years of hands-on experience with Oracle Fusion, with deep expertise across two or more modules such as Procurement, Inventory, Order Management, Finance, and Supply Chain Planning.
• Demonstrate strong understanding of Oracle Fusion SCM data models including transactional tables, lookup codes, flex fields, and multi-org structures.
• Have proven experience in gathering and documenting SCM reporting requirements within enterprise implementation or migration projects.
• Be proficient in SQL with the ability to independently write and review extraction queries against Oracle Fusion SCM schema objects.
• Possess working knowledge of data warehouse/data lakehouse concepts including: o Star schema o Dimensional modeling o Fact-dimension relationships Slowly changing dimensions (SCDs)
• Have experience producing Source-to-Target mapping documentation for ETL/ELT projects, data migration initiatives, and integration workstreams.

Required Technical Skills

• Act as the primary functional authority for Oracle Fusion SCM modules including:
• o Procurement
• o Inventory Management
• o Order Management
• o Finance

o Supply Chain Planning

• o Costing
• Engage with business stakeholders to: o Elicit SCM reporting requirements o Analyze business reporting needs
• Document reporting requirements
• Support reporting initiatives including:
• o KPIs
• o Operational dashboards
• o Regulatory reports
• o Management information packs

Requirements

Preferred Qualifications

• Bachelor’s degree in B.Tech or equivalent qualification.
• Experience working on HRMS modules.
• Experience with Project Management modules.
• Experience with Primavera modules.

What We Offer