Oracle SCM Consultant

Skills

Extensive experience in Oracle EBS SCM implementations upgrades extension projects and production support/stabilization. Strong understanding of both Procure-to-Pay and Order-to-Cash cycles. Hands-on experience in integrating Oracle SCM modules with other Oracle applications and third-party systems using APIs and Open Interfaces. Hands-on working knowledge in: SQL Developer Eclipse JDeveloper TOAD CVS VSS Export Import. Knowledge of XML and HTML.

Description

The Oracle Supply Chain techno-functional consultant will provide domain, functional and technical expertise required to effectively design and implement Supply Chain solutions on Oracle ERP SCM modules such as Inventory, Order Management (OM), Advanced Pricing, Purchasing, Bills of Materials (BOM), Work in Process (WIP), Engineering Change Order (ECO), Order to Cash cycle, Procure to Pay cycle. The role would be 60% Technical and 40% Functional focused.

Responsibilities

• Provide techno-functional expertise for projects and initiatives involving Oracle ERP, with hands-on experience in the design, development, testing, and implementation of applications using Oracle Applications R12 (12.1.3)
• Having strong functional/technical skills on Oracle E-Business Suite/Applications with focus on Oracle supply chain management (SCM): Inventory, Order Management (OM), Advanced Pricing, Purchasing, Bills of Materials (BOM), Work in Process (WIP), Engineering Change Order (ECO), Order to Cash cycle, Procure to Pay cycle.
• Having strong technical skills on SQL, PL/SQL, Interfaces and Conversions, Oracle Reports, Oracle Forms, Discoverer Reports, XML-Publisher Reports, PL/SQL Reports, Application Object Library (AOL), Oracle Workflow.
• Expertise in PL/SQL and SQL performance tuning, including the use of explain plans and optimizer hints for query optimization.
• Proficient in Discoverer Admin and Discoverer Desktop, including creating Business Areas, Simple Folders, Custom Folders, and developing/customizing reports.
• Experience in customization of existing workflows and creating new workflows using Oracle Workflow Builder, Workflow monitor.
• Manage change requests by analyzing issues, collaborating with Business Analysts and end users, gathering requirements, preparing technical documentation, developing and migrating code, conducting code reviews, and obtaining necessary approvals.