Oracle EBS PL/SQL Developer

Business Systems Analyst – ERP & MES

The Business Systems Analyst – ERP & MES is responsible for supporting, enhancing, and maintaining the Oracle E-Business Suite (EBS), Manufacturing Execution Systems (MES), and Oracle APEX applications. This role acts as a liaison between IT, business functions and operations to ensure efficient business processes and system functionality across manufacturing, supply chain, quality and finance.

Essential Functions:

• Provide functional and technical support for Oracle EBS modules (Manufacturing, SCM, Finance).
• Collaborate with business users to gather requirements and design solutions in ERP and MES systems.
• Design, develop, and maintain applications using Oracle APEX in support of ERP, Labelling and MES extensions.
• Coordinate with vendors and internal teams for MES system enhancements and support.
• Create functional specifications and support system configuration and testing.
• Conduct root cause analysis for production issues and implement permanent solutions.
• Ensure Data integrity and Regulatory compliance in ERP, MES, and APEX-based applications.

Additional Responsibilities:

• Collaborate with cross-functional teams to ensure alignment between business systems and operational needs.
• Provide/Facilitate user training and create system documentation.
• Support compliance with IT policies, procedures, and regulatory requirements.
• Assist with software upgrades, patching, and testing activities.
• Participate in IT projects and system implementations.
• Troubleshoot and resolve escalated issues in a timely manner.
• Perform other duties as assigned.

Job Specifications:

• Bachelor's degree in computer science, Information Systems, Business, or a related field (or equivalent experience)
• At least 7 to 10 years of experience supporting and configuring Oracle E-Business Suite (EBS) and Manufacturing Execution Systems (MES)
• Strong development background with hands-on experience in Oracle SQL/PL-SQL, T-SQL, JavaScript, REST APIs, and HTML for enterprise solutions
• Strong understanding of business processes in manufacturing, supply chain, finance, and operations
• Experience in gathering and translating business requirements into functional specifications
• Hands-on experience with ERP workflows, data integrity, testing, and support
• Familiarity with change control, system documentation, and user acceptance testing (UAT)
• Strong analytical and problem-solving skills with attention to detail
• Experience working in cross-functional teams and communicating with business and technical stakeholders
• Familiarity with regulatory and compliance standards such as 21 CFR Part 11, ISO 27001, and NIST

Desirable:

• Certifications such as Oracle Certified Professional (OCP), Six Sigma, or PMP.
• Experience with:
• MES platforms and integration with ERP systems
• Report writing and BI tools (e.g., APEX, Power BI, Oracle BI)
• ITSM tools and processes, and Change management
• Working in a validated environment with CSV principles
• Application lifecycle and low-code development
• Basic CRM knowledge, SugarCRM preferably
• Seagull Scientific Bartender Suite.
• Microsoft Visual FoxPro with Web Connection (Legacy Application platform).
• Ability to work cross-functionally with application, infrastructure, and support teams.

Physical Requirements:

• Must be able to lift 50 lbs, bend, and climb stairs as needed.
• Ability to travel Internationally to company sites as required.