Oracle EBS Manufacturing Support Consultant

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

This role is based in Seattle, WA, and requires 5 days onsite.

We are seeking both full-time and contractual candidates for this position.

Role Description & Responsibilities

Oracle R12 Manufacturing:

1. Oracle Bills of Material (BOM): Manages the creation and maintenance of product structures, including components and subassemblies.
2. Oracle Work in Process (WIP): Manages and tracks the production process, including job scheduling, resource allocation, and production reporting.
3. Oracle Cost Management: Provides detailed cost tracking and analysis for manufacturing operations, including standard costing, actual costing, and variance analysis.
4. Oracle Inventory: Manages inventory levels, tracks inventory transactions, and ensures accurate inventory records.
5. Oracle Quality: Manages quality control processes, including inspections, tests, and quality reporting.
6. Oracle Manufacturing Execution System (MES): Provides real-time shop floor control and execution capabilities, including work order management, labor tracking, and production reporting.
7. Oracle Discrete Manufacturing: Supports discrete manufacturing processes, including job-based production, assembly, and component tracking.

Possess SQL skills to:

1. Query Tables: Retrieve data from different tables to comprehend the current system status.
2. Perform Data Integrity Checks: Detect data integrity problems, such as orphaned records.
3. Execute Ad-hoc Queries: Conduct ad-hoc queries to address particular business inquiries or supply data for decision-making.