Oracle Software Engineer II (798)

M&S Consulting; Pasadena (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

M&S Consulting in Pasadena, CA, is seeking an experienced Oracle EBS ODM/MRP specialist to join our onsite team. You will review business requirements, map current and future state workflows, perform fit-gap analyses, and optimize ODM/MRP configurations to improve inventory planning and manufacturing performance.

The candidate will develop Oracle SQL/PLSQL code, support interfaces and data loaders, and assist with testing, training, and documentation.

Qualifications

• Proven experience delivering two or more ODM/MRP implementations in Oracle eBS R12.13.x.
• Deep functional and technical ODM/MRP expertise including Inventory and MRP.
• Ability to map and enhance As-Is processes into Oracle EBS standard functionality.
• Expert knowledge of ODM lifecycle: BOM, Inventory, WIP, MRP, Purchasing, Costing.
• Strong SQL/PLSQL, form personalization, and BI Publisher reporting.

Responsibilities

• Collaborate with the Lead ESA to review and gather requirements.
• Map current-state and future-state business workflows.
• Recommend Oracle configuration updates to optimize processes.
• Develop SQL/PLSQL code, procedures, and triggers.
• Troubleshoot issues, support testing and training activities.
• Provide bi-weekly status reports.

Skills

ODM/MRP

Inventory

SQL/PLSQL

Form personalization

REST APIs

BI Publisher reports

MS Office

System tuning

Problem solving

Tools

Oracle SQL

PL/SQL

Form Personalization', 1

Job description

M&S (which stands for Management and Solutions) was conceived in 2002 with the vision of creating highly effective teams of elite consultants to deliver strategic process and technology solutions to enterprise organizations across the US. Our commitment to delivery in complex environments and long-term customer success has merged process and technology into innovative solutions, established deep pockets of expertise, and enabled innovative transformation for evolving businesses.

We have intentionally cultivated steady growth focused on being approachable and helpful to our dearly valued clients and closely cared-for employees. M&S people simply “care hard”, and this reflects in our work products, our interactions, and our culture.

Job Responsibilities

• Collaborate with the Lead ESA to review existing business requirements and gather new requirements from stakeholders
• Conduct fit-gap analyses and present options
• Map current-state and future-state business workflows
• Recommend Oracle configuration updates to optimize business processes
• Support ESA in implementing new features and/or system changes aligned with approved functional designs
• Troubleshoot application issues through resolution
• Log and manage Oracle Service Requests
• Create and update functional design documents, technical design documents, and process flows associated with configurations or approved customizations
• Develop scalable Oracle SQL/PLSQL code including procedures, functions, packages, and triggers
• Update existing code to meet evolving requirements
• Tune and optimize queries for performance
• Build or retrofit interfaces, APIs, and data loaders
• Support custom extensions including Form Personalization and custom.pll
• Diagnose system bottlenecks, debug functional and technical issues, and apply fixes
• Support testing and user training activities
• Perform additional duties as directed by project team
• Provide bi-weekly status reports

Required Skills

• Demonstrated experience delivering two or more Common Inventory implementations as part of broader ODM/MRP deployments in Oracle eBS R12.13.x.
• Deep functional and technical expertise in ODM, including Inventory and Oracle Master Scheduling/MRP
• Ability to map, fit, and enhance complex "As-Is"business processes into Oracle EBS standard functionality
• Expert-level knowledge of ODM/MRP including Inventory setup steps, profile options, and system parameters to optimize performance
• Comprehensive understanding of the ODM lifecycle: BOM, Inventory, WIP, MRP, Purchasing, and Costing
• Strong understanding of upstream and downstream integration points
• Strong technical skills: Oracle SQL, PL/SQL, Form personalization, custom.pll, and BI Publisher reports
• Strong analytical and problem-solving skills
• Familiarity with REST APIs
• Proficient with MS Office

Desired Skills

• Experience with JIRA and GitHub
• Knowledge of Purchasing ASL functionality
• Experience with Mobile supply chain

*Must be a US Citizen or Permanent Resident

*This is an onsite role. It is not remote. Must be in or near Pasadena, CA

*M&S Consulting proactively fulfills its role as an equal opportunity employer. We do not discriminate against any employee or applicant for employment because of race, color, sex, religion, age, sexual orientation, gender identity and expression, national origin, marital status, physical or mental disability, status as a protected veteran, or any other characteristic protected by law.