SUMMARY

• 9+ years of Experience in IT with Expertise in Oracle Applications Expertise in Oracle E Business Modules - PO, i-Procurement, Logistics, OM, Advance Pricing, Depot Repair, Service Contracts, INV, BOM, WIP modules.
• Extensive experience with Reverse Logistics and Logistics process including integration with 3PL Logistics systems
• Extensive experience with the RMA Process - Return from Vendor, Return from Customer, Retail Returns, Return with Replacement, Return with Exchange, Return with Repair, Containerization, Bar Code Scanning, etc.
• Experience with Agile Product Life Cycle Management (PLM)
• Extensive experience with Order to Cash and Procure to Pay Business flows.
• Good working knowledge in Oracle AIM Methodology. Handled Service Requests (TARs) with Oracle. Knowledge on Oracle Accelerator and Oracle R12.
• Expertise in Implementation where am involved in Module selection, Requirement gathering, Gap Analysis, Solution Design, Building, Testing, User Training and Production.
• Proficient in Creating User Requirement Specification, Functional Requirement Specification and Business Process Flows.
• Extensive experience with EDI Standards and e-Commerce Gateway.
• Good knowledge in developing and writing Test Plans, Test Cases and Test Scripts using manual testing tool HP Quality Center to perform User Acceptance Testing (UAT).
• In Upgrade projects, handled Discovery, Mapping, Testing and Transition.
• Enhancement and Support, which involved giving Production support by interacting with user for, trouble tickets and establishing the process to be followed.
• Extensive experience in conducting training sessions for users to give them knowledge about how the system is going to work.
• Good documentation skills and Proficiency in MS Visio
• Good organization skills & Ability to interact Confidential all levels in an IT organization to assess, evaluate, recommend a different and robust solution and lead through the development.
• Well-proven track in achieving the timeline for deliverables.
• Highly motivated with excellent interpersonal and communication skills.

PROFESSIONAL EXPERIENCE

Confidential, Aliso Viejo, CA

Oracle Cloud SCM Functional Analyst

Responsibilities:

• The main area of concentration was extensively testing process flows of Supply Chain (Product Master Data Management, Inventory Management, Cost Management) and Fusion Procurement (Purchasing, Self-Service Procurement, Sourcing and Procurement Contracts) and CRM Modules of Service Contracts, Install Base, Deport Repair and Field Service
• Responsible for managing the implementation around the Supply Chain (ASCP, Inventory Management, Cost Management) and Fusion Procurement (Purchasing, Self-Service Procurement) and CRM Modules of Service Contracts and Install base.
• Worked on Oracle the setup of the Cloud Order to Cash Processes.
• Worked on Oracle Retail Order Broker - maintained a periodic item and inventory update between Oracle Inventory and Oracle retail Order Broker, worked on retail order brokers routing rules to automatically assign backordered items to storefronts for fulfillment, setup retail order broker for to fulfill retail pickup, setup control values, defined retail order broker properties, etc.
• Worked on Oracle Service Contracts configurations - defined the service parts, defined coverage templates, setup QA checklists, configured contract renewal rules.
• Managed the configurations of Oracle Cloud Fusion SCM (Supply Chain (Product Master Data Management, Inventory Management, Cost Management) and Fusion Procurement (Purchasing, Self-Service Procurement, Sourcing and Procurement Contracts)
• Worked on the setups of Oracle i-Procurement - defined the Requisition Templates for Oracle i-Procurement Public Lists, Define Information Templates, Define Shipping Networks and Customer Locations for Internal Requisitions, Set Up Content Security, Create Commodity-Based Expense Account Rules
• Worked on the Configuration of Oracle i-Procurement Punchout’s to supplier sites - defined content zones, setup transparent and direct punchout’s.
• Worked extensively on System Administrator, CRM, Offers (Channel Revenue).
• Worked on OA Forms Personalization’s - Personalized the Collectors Ownership Page in Oracle Advance Collections and Collector Information forms.
• Worked on XML Publisher Report customizations.
• Worked on WEB ADI for loading offers, payment details of a customer into Advance Collections and Channel Revenue Management
• Worked on the Auto Lock Box process in AR for Bank of America
• Worked on Bank Statement Mapping for Bank of America in Oracle AR

Confidential, Providence, RI

SCM Functional Consultant

Responsibilities:

• Worked as the SCM functional consultant, actively handling OM, Costing, Depot Repair, INV, WMS, Advance Pricing modules
• Worked on several production support issues in Order Management like stuck SO lines, RMAs, pick release & shipping documents, adjustments & maintaining setups in OM and advanced pricing
• Worked on the Advance Pricing Module - defining modifiers, qualifiers, price lists, price breaks, custom attributes for pricing, price mapping, etc.
• Handled issues with the Order to Cash flows.
• Designed the functional specifications and Business Requirement Documents for the following EDI Interfaces -
• 823 - Lock Box Interface
• 840 – RFQ
• 846 – Inventory Inquiry
• 850 – PO Inbound and Outbound
• 855 – PO Acknowledgement
• 856 – Advance Shipment Notice inbound and outbound
• 860 – PO Change inbound and outbound
• 810 – Outbound Customer Invoice
• Worked on the Configuration of the INV module including setting up of the Item Catalogs, Defining Catalogs, defining change categories and Types, Defining Item structures, setting up document management, defining roles and implementing role-based security.
• Responsible for the implementation ABC codes, Cycle counting and Physical Counting.
• Complete setup of BOM, which includes defining and maintaining the BOM’s, Routings, maintaining departments and resources.
• Performed all the setups for Order Management including defining of the OM Workflows, Transaction Types, Line Transaction flows, RMA Process, Setting up Pricing in Advance Pricing (Modifiers, Qualifiers, Pricing Formulas), Shipping Networks, Shipping Parameters, etc.
• Designed the Sales order acknowledgment, packing slip, commercial invoice, shipping schedule, booking detail reports etc.
• Created test scripts for UAT (User acceptance testing) in TE040 documentation with detail testing of all modules
• Completed Multi-org configuration by creating business group, legal entity, set of books and operating unit
• Created Users, Responsibilities, Menus, Request Group, Form Folders, Key/Descriptive Flex fields, profile options etc.
• Prepared setup, testing and functional design documents like the BR100, BR110, CF250 TE040, MD050 etc
• Co-ordinated with the database administrator, developers, system administrator and end users located in various countries like India, China, Canada and Mexico to interpret business requirements and develop concise solution

Environment: Oracle Supply Chain Applications R12 (12.2.8), Quoting, Depot Repair, OM, Costing, AR and Advance Pricing

Confidential, Columbus, IN

SCM Techno Functional Consultant

Responsibilities:

• Worked on the entire Quote to Cash process including the modules of Quoting, OM, Depot Repair, Logistics, AR and Advance Pricing
• Worked on the Quoting, OM, Costing, Depot Repair, AR and Advance Pricing process to streamline the business process and improve performance and efficiency.
• Analyze business processes, work with users to determine/clarify requirements, and prepare Functional Specifications to address technology solutions for meeting business requirements. Work with the users to review, in corporate feedback and obtain approvals for the Functional Specification.
• Worked on the configurations of Advance Pricing module – defining modifiers, qualifiers, primary and secondary price lists, buy one get one free, freight modifiers, setting up qualifiers for promotional pricing, price breaks, etc.
• Worked on the configuration of the Trade Management module – defining trade funds, trade promotion profitability, minimizing claim and deduction loss, indirect sales management, etc.
• Develop Use Cases and System Flow diagrams detailing the system impacts.
• Review and provide input to Detailed Design documents and Test Plans.
• Comply with the specified Delivery Methodology and documentation requirements
• Interacted with the database administrator, developers, system administrator and end users to interpret business requirements and develop concise solutions.
• Performed requirements analysis, participating in end-user meetings and review sessions to gather functional design specifications.
• Analysis done for selecting software/ data mgt solutions
• Conducted Business Process Improvement - As-Is / To-Be Business Process Analysis & Modeling, Problems, Impacts, Solutions and Benefits Identification, Gap Analysis, Best Practice Research.

Environment: PL/SQL, SQL, Oracle Financial Applications R12 (12.2.3), i-Procurement, INV, PO, OM, AP, Advance Pricing, Depot Repair, INV, GL, i-Supplier

Confidential, Chicago, IL

SCM Techno Functional Consultant

Responsibilities:

• Worked on the Flow- OM, BOM, Advance Pricing, Trade Management, INV, PO, AP, i-Procurement and i-Supplier modules
• As a Functional Consultant implemented the Business flows including Advance Pricing, Trade Management, INV, PO, i-Procurement, i-Supplier modules.
• Worked in the configuration of the Advance Pricing modules.
• Performed Requirement and Gap analysis.
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Manufacturing modules.
• Worked on the setups of Trade Management module – defining price protection, trade funds, promotions and accruals, budget management, etc.
• Worked on the configuration of the i-Supplier module.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Worked on setting up the Modifiers, Qualifiers and Formulas in Advance Pricing Module.
• Pre upgrade testing and Post upgrade production live support.
• Support Production issues on a day to day basis including month end closure p1 issues
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex Field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
• Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Confidential

SCM Techno Functional Consultant

Responsibilities:

• Worked on the Flows OM, INV, Advance Pricing, PO, BOM and WIP
• As a SCM Functional Consultant implemented the following modules: PO, Advance Pricing, i-Procurement, AP, INV and GL
• Worked on the Functional mapping of data Conversions & Enhancements for PO, i-Procurement, AP, INV and GL modules
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Setup the Approval Hierarchies in Oracle Purchasing module.
• Involved in troubleshooting issues on Auto Invoice Import Program.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Completed Multi-Org configuration by creating a new Organization Structure for ACG by creating new Business Group, Legal Entity, Set of Books and Operating Unit.
• Conducted Regression testing to examine the effects of a new Org on the previous Org.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful training to the users in OM, Shipping, Advance Pricing, BOM and WIP Modules.

Confidential 

SCM Techno Functional Consultant 

Responsibilities:

• SPOC for the Business in resolving their day-to-day issues in OM, PO, INV.
• Providing functional Support assistance to OM and AR Internal Customers.
• Actively handling Order Management & Shipping Production issues in areas like stuck SO lines, RMAs, Pick Release, Pick slip & Shipping documents, Adjustments & maintaining setups.
• Worked on Inventory setup changes, real time defect resolution in areas like Inventory Move Order, pending Inventory transactions, material on hand & transaction quantity mismatch, Item control, Sub inventory Transfer & Month end closure.
• Advanced Pricing setups, designing Pricing Formulas, Price rounding, Modifiers, Pricing Events, Partial Pricing, Qualifiers, DFFs to track Price changes, assessment for tiered Pricing for expedited orders & maintaining Intercompany Transfer Pricing.
• Ensured appropriate seeded workflows in OM are used in the transactions. Resolved issues in application setup and configuration with the Financial Consultant to ensure proper interfacing of AR with OM and AP with Purchasing, and Inventory with GL.
• Extensively worked on Receivables and configured setups for organization structure, Auto invoice, auto accounting, Receivables Activities, distribution sets, Application of Receipts to transactions and invoice printing with remit address
• Creating Service Requests & coordinating with Oracle Metalink Support for issue resolution, bug tracking, requesting back ported patches, testing patches towards defect fixes in OM, Shipping, Inventory, Pricing & Purchasing areas.
• Update the BRD’s manuals/cheat sheets on a regular basis for all the business processes.