Job Description

Senior Oracle Business Analyst (Manufacturing – INV, BOM, WIP, Costing)1

We are seeking a highly experienced Senior Oracle Business Analystto join our team as a Functional Subject Matter Expert (SME) in Oracle Manufacturing and Supply Chain modules. This role will act as a critical bridge between business stakeholders in Operations/Manufacturing and the IT team, driving requirements definition, process optimization, and system configuration.

The ideal candidate will bring deep expertise in Oracle ERP systems—particularly within Discrete Manufacturing—and play a key role in improving operational efficiency, streamlining shop floor processes, and ensuring seamless integration across Inventory, WIP, and Costing modules.

Key Responsibilities

1. Functional Expertise & Business Analysis

Inventory Management (INV)

• Configure and support:
  • Item Master organization structure
  • Sub-inventories and locators
  • Lot and serial control
  • Replenishment strategies (Min-Max, Kanban, etc.)
  • Cycle counting and physical inventory processes
• Ensure accurate inventory tracking and control mechanisms

Bills of Material (BOM)

• Define and maintain:
  • Product structures and multi-level BOMs
  • Engineering Change Orders (ECOs)
  • Alternate and common BOMs
• Collaborate with engineering and production teams for BOM accuracy

Routings & Work in Process (WIP)

• Design and configure:
  • Routings and standard operations
  • Resource and department setups
• Manage WIP processes including:
  • Discrete job creation and scheduling
  • Shop floor transactions (move, resource, completion)
  • Job closures and variance analysis

Process Analysis

• Conduct AS-IS and TO-BEprocess analysis
• Identify gaps, inefficiencies, and opportunities for automation
• Recommend best practices aligned with Oracle standards
  

2. Project Delivery & Implementation

Requirements Gathering

• Lead workshops with stakeholders to gather and document:
  • Business Requirements Documents (BRD)
  • Functional Requirements Documents (FRD)
• Translate business needs into functional specifications

System Configuration

• Perform hands-on configuration of Oracle modules:
  • Inventory (INV)
  • Bill of Materials (BOM)
  • Work in Process (WIP)
  • Costing
• Ensure alignment with business requirements and best practices

RICEFW Development

• Prepare MD50 functional design documents for:
  • Reports
  • Interfaces
  • Conversions
  • Extensions
  • Forms
  • Workflows
• Collaborate with technical teams for development and deployment

Testing & UAT

• Develop:
  • Test plans and scenarios
  • Test scripts (TE40)
• Lead:
  • System Integration Testing (SIT)
  • User Acceptance Testing (UAT)
• Ensure data accuracy, process validation, and issue resolution

Support & Hypercare

• Provide post-go-live support and stabilization
• Troubleshoot production issues and coordinate fixes
• Support period-end close activities (Inventory, WIP, Costing)
• Train and guide end users
  

Required Qualifications & Skills

Experience

• 10+ years of experience as an Oracle Functional Consultant or Business Analyst
• Hands-on experience in Oracle E-Business Suite (R12)

Domain Expertise

• Strong experience in Oracle Discrete Manufacturing modules:
  • Inventory (INV)
  • Bill of Materials (BOM)
  • Work in Process (WIP)
  • Costing
• Understanding of end-to-end manufacturing and supply chain processes

Implementation Experience

• Proven experience in at least two full-cycle Oracle ERP implementations
• Exposure to rollout, upgrade, or support projects is a plus

Technical Skills

• Ability to write and interpret SQL queries
• Understanding of Oracle data models and key tables
• Familiarity with background workflows and concurrent programs

Soft Skills

• Strong analytical and problem-solving abilities
• Excellent communication and stakeholder management skills
• Ability to work with cross-functional teams and senior leadership
• Proactive, detail-oriented, and results-driven