Oracle EBS SCM MFG Business Analyst

Job Title: Oracle EBS SCM MFG Business Analyst

Location: Burbank, CA

Job Type: Contract Position

Job Description

About the role

We are seeking an experienced Oracle SCM Manufacturing Business Analyst to provide ongoing support for Oracle E-Business Suite (EBS) SCM Manufacturing modules. The ideal candidate will have hands-on experience with modules such as Work in Process (WIP), Bill of Materials (BOM), Purchasing, Inventory, OM, Discrete Manufacturing, Quality, MES, Services and Cost Management.

What You’ll Do:

Oracle R12 SCM Manufacturing:

• Oracle Bills of Material (BOM) : Manages the creation and maintenance of multilevel bills, including components and subassemblies.
• Oracle Work in Process (WIP) : Manages and tracks the production process, including job scheduling, resource allocation, WIP cost analysis and production reporting.
• Oracle Cost Management : Provides detailed cost tracking and analysis for manufacturing operations, including standard costing, actual costing, and variance analysis.
• Oracle Inventory : Manages inventory levels, tracks inventory transactions, and ensures accurate inventory records, cycle counting, min max planning, Item attributes and maintenance
• Oracle Quality : Manages quality control processes, including inspections, tests, and quality reporting.
• Oracle Manufacturing Execution System (MES) : Provides real-time shop floor control and execution capabilities, including work order management, labor tracking, and production reporting.
• Oracle Discrete Manufacturing : Supports discrete manufacturing processes, including job-based production, assembly, and component tracking.
• Oracle Purchasing: Support Procurement processes including PO approvals using standard Position/job hierarchy, AME approvals, PO printing using XML publisher, PO receiving including Receive/deliver/inspect, 3way match etc.
• Oracle Order Management: Support OM including Order entry, Pick and ship processes for Serial controlled items, shipping and invoicing, Knowledge of OM Workflow and troubleshooting stuck orders.

On your first day, we’ll expect you to have:

• Bachelor’s degree in supply chain management, Industrial Engineering, Computer Science, or a related field (master's preferred).
• 15+ years of IT/Supply Chain systems experience with ERP expertise (Oracle EBS, Oracle Fusion Cloud).
• 10+ years of hands-on experience with Planning, Manufacturing, and Inventory modules (Demand/Supply Planning, MPS, MRP, BOM, Work Orders, Inventory, PO, OM).
• Strong functional knowledge of planning and manufacturing processes in discrete, project-based manufacturing.
• Query Tables: Retrieve data from different tables to comprehend the current system status.
• Perform Data Integrity Checks: Detect data integrity problems, such as orphaned records.
• Execute Ad-hoc Queries: Conduct ad-hoc queries to address business inquiries or supply data for decision-making.
• Knowledge of Forms personalization, custom forms, Custom procedures/functions, custom concurrent jobs in a heavily customized environment.
• Support users with mass updates of various entities using scripts/dataload etc.
• Support Month end activities from inventory side.