SUMMARY

• Experienced Oracle Apps SCM Techno Functional Consultant is extremely knowledgeable with all Oracle modules as well as SQL/PLSQL.
• Very skilled with supply chain management solutions.
• Has a Bachelor's Degree in Computer Engineering as well as 5+ years of experience.
• Oracle Apps R - 12 Inventory, Order Management Certified Consultant
• Broad knowledge of Oracle Apps modules including eBS SCM and Install base, Depot Repair, ASCP
• I have worked on ASCP D MANTRA planning tool.
• Experienced with R12 support and upgrade projects (two).
• Excellent communication and interpersonal skills to handle the client meetings and solution discussions. Good with Customer Management.
• Strong knowledge of SQL/PLSQL diagnostics Reports, XML Publisher, Loft ware Report, TOAD.
• Excellent customer management and experience with integrated value chains
• Extensive experience with multiple Oracle SCM modules including OM, PO INV, ACP,cMRO Depot Repair.
• Good experience in programs debugging, issue resolutions and providing new business solutions.
• Elementary Knowledge of OAF, Work Flow, SOA

PROFESSIONAL EXPERIENCE

Oracle Apps SCM Functional Consultant

Confidential, Seattle, WA

Responsibilities:

• Onsite coordinator managing the team of 5 people at offshore, interacting with business and customer gather the information and explain to off shore and do setup accordingly.
• As per the BR-100 Document do setup for Inventory, Order Management and Purchasing and ASCP module and defining the business process.
• Working on Production Support in SCM module and ASCP.
• Defining Item, Item parameter, Organization parameters, Item Type Serial controlled, UOM, Item Service Relationship, customer Item, Customer UOI, Supplier UOM, Min-Max Planning, Inventory replenishment.
• Order Management, O2C process, Drop Ship process, Scheduling ATP check, Back Order, Shipping transaction, Customer Invoice report, Pick and Ship Notification, troubleshooting the issues.
• Creating Purchase order, requisition, RFQ, Inventory receiving, Buyer setup.
• Approved Supplier list setup, assigning supplier to Item as per the Operating unit, Defining sourcing rule, Assignment set, Price List, assign item to price list.
• Defining Bill to/Sold to address, Ship to address, Supplier, shipping network,
• Install base Depot Repair cMRO module, creating repair order, Repair site Setup according to the supplier, creating the issue and return order in install base.
• ASCP Defining plan, collection assignment set sourcing rule, GOP.
• Bill To/sold to address setup, Ship to address setup, Repair site defining.
• Performing various transactions like miscellaneous issue, Miscellaneous receiving, sub inventory transfer, Move Order, Back Order, Inventory adjustment.
• Analysing the issue and find out the root cause of issue and fix it in given SLA.
• To prepare related technical documents based on the change request received. Change request may be modification of the existing program or creation of a custom program.
• Work with Oracle on the SR, update the SR as per the request in Metalink and implement the solution provided by Oracle.

Oracle Apps SCM Techno functional Consultant

Confidential

Responsibilities:

• Understand the business requirements of the application from client.
• Multi-dimensional data modeling with flexible data hierarchies for up-to-date demand visibility and one-number planning (Improve forecast accuracy).
• Ability to plan for Configure to Order (CTO) products with multiple optional or mandatory sub-components, tracking interaction between items and components
• Flexible time buckets, units, and currencies to address operational and financial planning needs.
• Specialized functions for service parts forecasting (handling intermittency)
• Deploy stand-alone or leverage out-of-the-box integration with Oracle E-Business Suite, Oracle PeopleSoft, and Oracle JD Edwards EnterpriseOne

Oracle Apps SCM Techno functional Consultant

Confidential

Responsibilities:

• Understand the business requirements of the application from client.
• Worked as Support Consultant and responsible for the Tickets Handling, Issue Resolution and Enhancements/Customization to resolve the issue.
• Defining Item, Item parameter, Organization parameters, Item Type Serial controlled, UOM, Item Service Relationship, customer Item, Customer UOI, Supplier UOM, Min-Max Planning, Inventory replenishment.
• Order Management, O2C process, Drop Ship process, Scheduling ATP check, Back Order, Shipping transaction, Customer Invoice report, Pick and Ship Notification, troubleshooting the issues.
• Creating Purchase order, requisition, RFQ, Inventory receiving, Buyer setup.
• Approved Supplier list setup, assigning supplier to Item as per the Operating unit, Defining sourcing rule, Assignment set, Price List, assign item to price list.
• Developed the interfaces and reports like Oracle to Siebel and vice versa interface, BOL report.
• To program using PLSQL programming language. All the PLSQL queries are tuned for best performance.
• To develop reports using Oracle Reports and XML Publisher. These reports are used mainly for business purpose like financial reporting and they are basically cost cutting methods.
• To prepare technical documents based on the change request received. Change request may be modification of the existing program or creation of a custom program.
• Gathering business requirements from the client
• Prepare Project documentation

Oracle Apps SCM Technical Consultant

Confidential

Responsibilities:

• Understand the business requirements of the application from client.
• Creating Menus, Functions, Value Sets, Multi Org, Concurrent Programs, Lookups, Database Objects and Shell scripts.
• Developed the interfaces and reports like Oracle to Siebel and vice versa interface, BOL report.
• Responsible for understand and analyse the provided RICE Component specifications and develop solutions by using Developer 2000, PL/SQL Developer, Report Builder 6i.
• To program using PLSQL programming language. All the PLSQL queries are tuned for best performance.
• To develop reports using Oracle Reports and XML Publisher. These reports are used mainly for business purpose like financial reporting and they are basically cost cutting methods.
• Worked on the Loft ware report for WMS
• To prepare technical documents based on the change request received. Change request may be modification of the existing program or creation of a custom program.
• Preparing MD 50, MD 70, MD-120 Document.