IT ERP Product Analyst III - Oracle Manufacturing

JOB DESCRIPTION  

Position Summary:  

The IT ERP Analyst III is responsible to design and deliver solutions to fulfill requirements of Regal’s Manufacturing business. The individual should possess comprehensive techno-functional competencies in Manufacturing (INV, BOM, WIP, and Costing) modules of Oracle EBS and working knowledge of Advanced Supply Chain Planning (ASCP), Demantra and Inventory Optimization (IO) modules of Oracle VCP. 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. Gathers and analyzes requirements, designs, develops and tests enhancements, extensions and integrations (RICEW / CEMLI) for existing Oracle EBS Manufacturing / VCP modules. Maintains technical documentation (BR100s, MD50s/70s, CV40s/70s, etc). Assists in defining, reviewing and maintaining standards. Liaises and coordinates with other stakeholders including team members located in other countries. Participates in formulating and defining scope of Oracle EBS / VCP projects and own delivery of several components. 

Major Responsibilities: 

• Gather and analyze business requirements; design, develop, test and implement technical solutions to fulfill requirements of supply chain, manufacturing, and planning areas; and provide post implementation maintenance and support 

• Document system specifications (SSDs - high level) (MD50s), detailed design (DDDs) (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 Manufacturing 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. 

• Design, develop, test, and deploy Reports, Interfaces, Conversions, and Extensions (including workflows) to enhance existing Oracle EBS / VCP solutions and integrate it with other applications. 

• 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:  

• Educations: 

• Bachelor's degree or equivalent related experience 

• Experience 

• 8+ years of experience building and supporting solutions based on Oracle EBS Manufacturing modules (INV, BOM, WIP, and Costing) in global environment – with at least 2or 3 full lifecycle implementations or 3+ 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 RICEW (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. 

• Comprehensive knowledge in collection methods, plan parameters, Demantra and Inventory Optimization architecture 

• 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) 

Regal Rexnord is a publicly held global industrial manufacturer with 30,000 associates around the world who help create a better tomorrow by providing sustainable solutions that power, transmit and control motion. The Company’s electric motors and air moving subsystems provide the power to create motion. A portfolio of highly engineered power transmission components and subsystems efficiently transmits motion to power industrial applications. The Company’s automation offering, comprised of controls, actuators, drives, and precision motors, controls motion in applications ranging from factory automation to precision control in surgical tools.

The Company’s end markets benefit from meaningful secular demand tailwinds, and include factory automation, food & beverage, aerospace, medical, data center, warehouse, alternative energy, residential and commercial buildings, general industrial, construction, metals and mining, and agriculture.

Regal Rexnord is comprised of three operating segments: Industrial Powertrain Solutions, Power Efficiency Solutions, and Automation & Motion Control. Regal Rexnord has offices and manufacturing, sales and service facilities worldwide. For more information, including a copy of our Sustainability Report, visit RegalRexnord.com.