Oracle Demantra lead

Position : Senior Oracle Demantra Consultant

Experience : 8–10 years

Key Responsibilities

Lead end-to-end implementation and support of Oracle Demantra modules, including Demand Management , Predictive Trade Planning , and Deductions & Settlement Management (DSM) .

Collaborate with cross-functional teams to gather business requirements and translate them into system configurations.

Design and configure Demantra workflows , forecast trees, and engine tuning based on demand data.

Provide expert-level troubleshooting and performance optimization for Demantra applications.

Develop and execute data extraction queries , manage Demantra tables, and ensure data integrity.

Support integration with Oracle VCP (Value Chain Planning) and other ERP modules.

Conduct training sessions and create user documentation for business stakeholders.

Required Skills

8+ years of hands-on experience with Oracle Demantra.

Strong understanding of forecasting algorithms , trade promotion planning , and demand analytics .

Proficiency in SQL , PL / SQL , and Demantra data model.

Experience with Oracle ASCP , EBS , and VCP is a plus.

Excellent communication and stakeholder management skills & should be able to work with UK Client independently

Must have strong PL / SQL, interface knowledge.

Should be able to analyze the interface and technical issues.

Should be able to debug issues and provide solutions for Demantra

Should be able to design, develop and deliver the enhancements

Should be able to coordinate with Oracle & Business for Oracle SR’s

Should be able to perform impact analysis

Should be able to detail solution design

Should be able to do Unit testing & Integration testing

Should be able to support UAT

Should be able to append documentation for requirement gatherings, use cases, Test scripts.

Should be able to hand over to production support

Should be able to help Production Support for identifying repetitive issues and propose solution for permanent fix