Position Summary:  

The IT ERP Product 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 (INV, BOM, WIP, Costing, and PO) 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 Supply Chain / VCP modules. Maintains technical documentation (BR100s, MD50s/70s, CV40s/70s, etc). Assists in defining, reviewing and maintaining standards. Liaises and coordinates with business and IT stakeholders including offshore team members. 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 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. 

• 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 

• 10+ years of experience building and supporting solutions based on Oracle EBS Supply Chain / VCP R12 (Advanced Supply Chain Planning, Demantra, and Inventory Optimization) 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) 

Travel: 25% of time – mostly during project milestones, kaizen or similar events