Oracle EBS Manufacturing Lead: ODM/MRP Expert

Columbus Technologies and Services; Pasadena (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

Columbus Technologies and Services seeks an Oracle EBS ODM/MRP expert to lead configuration reviews, implement enhancements, and optimize business processes at NASA JPL in Pasadena, CA. You will map As-Is processes to standard Oracle functionality and develop robust SQL/PLSQL solutions while supporting testing and user training.

The role requires deep ODM/MRP knowledge, strong problem-solving skills, and experience with Form Personalization and BI Publisher reports.

Qualifications

• Demonstrated experience delivering two or more ODM/MRP implementations as part of Oracle eBS R12.13.x deployments.
• Deep functional and technical expertise in ODM, including Inventory and Oracle Master Scheduling/MRP.
• Ability to map as-is processes to Oracle EBS standard functionality.
• Expert knowledge of ODM/MRP: Inventory setup, profile options, system parameters for performance.
• Understanding ODM lifecycle: BOM, Inventory, WIP, MRP, Purchasing, Costing.
• Understanding upstream and downstream integration points.
• Strong technical skills: Oracle SQL, PL/SQL, Form personalization, custom.pll, BI Publisher reports.
• Strong analytical and problem-solving skills.
• Familiarity with REST APIs.
• Proficiency with MS Office.

Responsibilities

• Collaborate with the Lead ESA to review and gather requirements from stakeholders.
• Conduct fit-gap analyses and present options.
• Map current and future state business workflows in Oracle EBS.
• Recommend Oracle configuration updates to optimize processes.
• Support implementation of new features per designs and troubleshoot issues.
• Log and manage Oracle Service Requests and document designs.
• Develop SQL/PLSQL code, packages, and triggers; update code as needed.
• Tune queries and build interfaces, data loaders.
• Support custom extensions including Form Personalization and custom.pll.
• Diagnose bottlenecks, apply fixes, and assist testing and training.
• Provide bi-weekly status reports.

Skills

Oracle EBS R12.x ODM/MRP

Oracle SQL

PL/SQL

Form Personalization

custom.pll

BI Publisher reports

REST APIs

Microsoft Office

Analytical problem solving

JIRA

Education

Experience with two or more ODM implementations

Tools

GitHub

Job description

Columbus Technologies and Services seeks an Oracle EBS ODM/MRP expert to lead configuration reviews, implement enhancements, and optimize business processes at NASA JPL in Pasadena, CA. You will map As-Is processes to standard Oracle functionality and develop robust SQL/PLSQL solutions while supporting testing and user training.

The role requires deep ODM/MRP knowledge, strong problem-solving skills, and experience with Form Personalization and BI Publisher reports.