IT ERP Analyst III

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:

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

Language: English