Oracle ASCPDemantra Lead

Overview:

Key Responsibilities:

• Should have handson experience and be able to guide the team of developers.
• Create detailed IT Functional Designs and test scripts.
• Assist business users during CRPs/SITs/UATs.
• Lead the configuration/setup testing training implementation and support of Oracle application modules.
• Oversee review and ensure the development life cycle of a couple of projects in FA one for cost adjustments and one another for Mass Retirements with the creation of a couple of custom dashboards using OAF.
• Participate in the creation of SDLC (Software Development Life Cycle) and the creation of TDD (Technical Design Document) Documents
• Provide suggestions to avoid performance issues using the SQL tuning advisor.
• Should have performed the role of code reviewer as well.
• Must have Extensive knowledge of PO INV ASCP I supplier Procurement SupplierManagement/Customer Service
• Worked on PL/SQL (mandatory) forms/reports OAF integration XML publisher and BI Publisher.
• Having all is not mandatory but should be strong in PL/SQL tuning and endtoend testing.
• Functional knowledge is an added advantage.
• Knowledge of the Oracle A/R and GL tables
• Ability to write SQL queries to extract A/R and GL data
• Knowledge of standard Oracle reports Project Management experience would be a big plus specifically with projects implementing Oracle EBS A/R and GL modules and ASCP/Demantra
• Must have complete knowledge of Oracle EBS development tools (RICE) PL/SQL Forms Reports BI Publisher OAF (Oracle Applications Framework) WEBAdi Form Personalization Oracle EBS(11.5.10.2) Oracle EBS (12.2.5) Linux Window 7 and Windows 10

Required Qualifications:

• Bachelors degree in Information Technology Supply Chain Management or a related field
• 5 years of experience in implementing and supporting Oracle ASCP and Demantra
• Indepth understanding of supply chain principles and processes
• Proficiency in SQL and PL/SQL for data analysis and reporting
• Strong problemsolving skills and ability to analyze complex supply chain scenarios
• Experience with system testing performance tuning and troubleshooting
• Excellent communication and interpersonal skills
• Ability to work effectively in a team environment and collaborate with crossfunctional stakeholders
• Certification in Oracle ASCP or Demantra is a plus
• proven track record of successful implementation and optimization of supply chain systems

interpersonal skills,troubleshooting,certification,performance tuning,pl/sql,oracle ascp,system testing,communication,demantra,oracle,software development life cycle (sdlc),supply chain,applications software development,optimization,sql,ascp,implementation