Work Model: You’ll work in a hybrid model, onsite at your designated Regal Rexnord location at least 3 days per week (Monday–Thursday), with flexibility to work remotely up to 2 days, including Friday.
____________________
The IT ERP Analyst III is responsible to design and deliver solutions to fulfill requirements of Regal’s supply chain business. The individual should possess Comprehensive TECHNO-FUNCTIONAL competencies in Supply Chain and Manufacturing (INV, BOM, WIP, Costing, OSFM, APC, QA, OM, MSCA, WMS and PO etc.) modules of Oracle EBS and some working knowledge of ASCP/Planning. The person is responsible to deliver on-time and first-time-right for complex projects and kaizen events, to resolve production incidents within SLAs, to conduct root cause analysis to prevent recurrence or problems, to monitor and improve system performance and reliability on continuous basis and to coach team members as necessary.
Major Responsibilities:
- Gather and analyze business requirements: Design, Develop, Test and Implement Oracle EBS TECHNICAL solutions to fulfill requirements of Supply Chain and Manufacturing areas.
- Development & Customization: Write and maintain Custom Code, Reports, Interfaces, Extensions, and workflows using SQL, PL/SQL, Oracle Forms, Reports, and BI Publisher, etc.
- Data Conversions and Maintenance: Capable of Planning, Designing of Data Conversions between multiple systems (SAP to Oracle, Baan to Oracle etc.) – including Coding, Program building, Conversions executions, Audit and Error handling, etc.
- Technical Documentation: Must be capable of documentation of System specifications (SSDs) (MD50s), Detailed design (MD70s), Unit Test Plan, Deployment Notes (MD120s), etc. using Oracle AIM (Application Implementation Methodology).
- Support System Functional testing: End-To-End Integration testing, Regression testing, and User Acceptance testing within defined Service Level Agreements (SLAs).
- Coordinate among onsite and offshore members of Oracle EBS Supply Chain / VCP technical developers to design, build, unit test and support solutions that are on-time, first-time-right and within budget.
- Ensure compliance to Release management, Change management and configuration management processes.
- Respond, analyze and resolve production incidents within SLAs, perform routine maintenance tasks, and monitor / enhance performance of scheduled programs to ensure business continuity.
- Automate and maintain Integration of Oracle EBS / VCP modules with other internal and external systems.
- Participate in following activities:
- Analyze and plan Oracle EBS / VCP upgrades (i.e. Family Packs)
- Create and resolve service requests in collaboration with ‘My Oracle Support’
- Provide production support as per Service Level Agreements (SLAs)
- Continuously improve system performance and reliability by identifying opportunities for root cause analysis and automation
- Facilitate in establishing standards and Best Practices for software design, development and Unit Test and lead team to leverage these standards and best practices to deliver high quality and cost effective solutions.
- Use systematic techniques and process modeling tools for effective system specifications and design - like Use-case scenarios, Activity Diagrams, Data-flow Diagramming etc.
Required Education / Experience / Skills:
Education:
- Bachelor's degree or equivalent related experience
Experience:
- 5+ years of experience building and supporting solutions based on Oracle EBS Supply Chain R12 in global environment – with at least 2 or 3 full lifecycle implementations or 4+ years of monitoring, maintaining, enhancing, integrating and upgrading
- Awareness or Green Belt certification in Lean Six Sigma or APICS (CPIM, CIRM) certification preferred
Technical Skills:
- Highly skilled in Oracle E-Business Suite's APIs, Open Interfaces structure, EBS / VCP data models, building FRICEW (Forms, Report, Interface, Conversion, Extension, Workflow) or CEMLI (Configuration, Extension, Modification, Localization, and Integration) objects, Forms, Form Personalization, XML Publisher, OA Framework, SQL, PL/SQL (Stored procedures, packages and triggers), Bulk processing, ETL operations, REF cursors, collections, etc.
- Ability to analyze and resolve supply-demand exceptions and issues as per SLAs
- Experience with SQL*Plus, SQL*Loader, Data Loader, Export/Import, TKPROF, Oracle scheduler, Advanced Queues, Object management
- Proficient in tools like TOAD, PL/SQL Developer, Data Modeling tools, Version Control tools.
- UNIX shell scripting experience (desired)
- Conversant with Oracle AIM (Application Implementation Methodology)
- Professional Certification(s) like Supply Chain industry or Oracle E-Business Suite R12 (strongly desired)
- Working experience in Oracle EBS R12 Supply Chain (Discrete Manufacturing) modules (strong desired)
- Following additional skills will be preferred: Power BI Dashboard building, Knowledge of Oracle AIDP AI Agent Building, PQL (Process Query Language), etc.
Travel: 25% of time – mostly during project milestones, kaizen or similar events
Language: English
Candidates must be eligible to work in the United States without requiring company sponsorship to obtain or keep U.S. work authorization.
Benefits- Medical, Dental, Vision and Prescription Drug Coverage
- Spending accounts (HSA, Health Care FSA and Dependent Care FSA)
- Paid Time Off and Holidays
- 401k Retirement Plan with Matching Employer Contributions
- Life and Accidental Death & Dismemberment (AD&D) Insurance
- Paid Leaves
- Tuition Assistance