SUMMARY

• 8+ years of experience as an Oracle Supply Chain Management(SCM) Functional Consultant working in multiple projects in both R12 and 11i versions wif an in dept understanding in teh areas of Manufacturing and Distribution including Inventory Controls as per teh nature of teh business and size of teh operations wif third party integrations etc.,
• Good understanding of business process operations, organizational assessment and translating them into functional requirements
• Excellent knowledge in all Oracle Supply Chain modules and integrations across cross modules as well
• Extensive knowledge on Inventory Controls, Order to Cash (O2C) & Procure to Pay (P2P) cycles
• Expertise in business process analysis, requirement analysis (AS - IS) system, (TO-BE) mapping, CRP testing, Integration testing, UAT, system configuration, data conversions, master data loading, Go-live support, Post-Production Support
• Understanding of all phases of ERP implementation such as business process study, business requirement gathering, gap analysis wif respect To-Be solution design, development and testing, cut over, Go-Live and post production support
• Implementation experience and functional expertise in Order Management (OM) including Advance Pricing, Inventory (INV), Purchasing (PO), Advanced Supply Chain Planning (ASCP), Bill of Materials(BOM), Work in Process(WIP), Master Production Schedule (MPS) and Material Requirements Planning (MRP)
• Excellent problem solving, communication, analytical, interpersonal & leadership skills
• Expertise in Writing, Maintaining, Test Results and Generating software defects reports for teh developers
• Worked closely wif business users to understand teh business processes and prepare teh business requirements definition documents
• Expertise in implementing teh projects and performing thorough testing during teh User Acceptance phase of teh project
• Worked in cross functional environment, in groups and individually wif minimum supervision
• Used Application Implementation Methodology (AIM) for documentation purposes
• Experience in using tools such as Data loader, SQL loader, Web ADI, TOAD and EXCEL for importing and exporting data
• Effective communication & experience in various projects using MS Project, MS Excel and MS Visio
• Experience interacting wif customers at multiple levels in a variety of Industries & Business segments
• Has experience in End to End Implementation and skills in leading medium to big sized teams
• Worked closely wif Oracle Technical support on all high prioritized open SR’s and conduct OWC sessions for speedy resolution of issues
• Carried out Process Customization, Data Conversions and Developed Interfaces
• Trained in Six Sigma levels of Quality and implemented Lean manufacturing, Continuous Improvement and Statistical Process Control methodologies

TECHNICAL SKILLS

Oracle Modules & Versions: Oracle Modules INV, PO, OM including Advance Pricing, iProcurement, BOM, WIP, MRP & MPS, including Q2C, O2C and P2P cycles

Oracle R12: R12.0.2, R12.0.3, R12.0.4, R12.0.5, R12.0.6, R12.1.1, R12.1.2, R12.1.3

Oracle 11i: 11.5.7, 11.5.8, 11.5.9,11.5.10,11.5.10.2

Software’s & Other Tools: PL/SQL, ADI, Web ADI, Hyperion, OBIEE, Discoverer, TOAD, SQL Loader, Data Loader, MS Office Suite

PROFESSIONAL EXPERIENCE

Confidential, Eugene, OR

Oracle SCM Functional Analyst

Responsibilities:

• Involved in planning & implementing teh up-gradation from Oracle 11.5.10.2to R12.1.3
• Worked collectively wif other business areas including, planning and finance to ensure dat manufacturing function fully integrates wif other business process
• Monitoring teh business users screen to understand teh issues and fixing it by guiding them to complete teh process in a right way
• Resolved teh issues on Sub inventory transfer, Inter-Org transfer in Inventory Application
• Extensively worked and resolved teh issues on Work Flows (Requisition, Purchase Order, RMA Order, Standard Sales Order, Internal Sales Order, Drop Ship Order)
• Worked on Modifiers, Qualifiers, Price List setups to define teh discount (or) surplus charges at various levels in OM application
• Resolved teh critical issues on Shipping Execution while Ship Confirming teh Sales Order.
• Worked and fixed teh root cause problems in BOM, WIP Applications
• Analyzing teh issues and finding out teh root cause of teh problem to get a permanent fix for teh issues in various applications
• Replacing teh critical issues in Test instances to fix teh problem in PROD instance
• Resolving teh issues on Pending Transactions from various applications
• Resolving teh month end issues and prepared a setup document for Month-end closing
• Maintained AIM documents like BR100, BR150,MD50 and TE40
• Worked on making Test scripts and performed testing procedures for various Oracle Application modules like Inventory & Order Management
• Conducted CRP 1 (Conference Room Pilots) and documented teh results to ensure dat teh business processes were defined for all major business processes and could be performed successfully using oracle Applications
• Tested teh functionalities as per teh client requirements
• Performed bug checking and logging and followed up teh TAR resolution process
• Trained end users on Inventory and Order Management modules and provided user guide
• Involved in planning of UAT

Confidential, Iowa City, IA

Oracle SCM Functional Consultant

Responsibilities:

• Studied and analyzed teh current business process and was part of business requirement meetings
• Performed AS-IS Analysis
• Performed a walkthrough of teh To-Be business process flows
• Responsible for documentation of BR100 and MD50
• Participated in Ongoing process Enhancements and modification requests
• Defined items, item status, item attributes and generated serial numbers and locators
• Setting up of document types, buyer, supplier and approved supplier list in purchasing module
• Defined price list, modifiers, qualifiers, price breaks as per teh client requirement
• Responsible for identifying cross functional dependencies and issues
• Trained teh super users by providing documents using VISIO flow diagrams for better understanding
• Assisted team lead and other team members in setup and user interaction
• Trained teh super users by giving demonstrations on various process flows in oracle applications and helping them to understand teh process in a better way
• Executed CRP's, prepared test scripts, smoke test and collected results
• Worked closely wif teh development team on all application enhancement, requests and bug fixing
• Prepared user manuals and assisted teh end users on inventory and purchasing modules
• Rendered support for researching, troubleshooting and testing product problems and client configurations
• Was part of User Acceptance Test and recorded teh UAT results
• Provide post production support for Inventory and Purchasing
• Render first point of contact for customer support during business and non-business hours to meet customer support response time commitments
• Trained teh super users by providing documents using VISIO flow diagrams for better understanding

Confidential, Harrisburg, PA

SCM Functional Analyst

Responsibilities:

• Involved in planning & implementing Oracle 12.1.3
• Perform teh AS-IS, Gap and Fit Gap Analysis
• Created BR100 & MD50
• Conducted numerous meetings and trainings on Oracle functionality to communicate and educate teh users.
• Provided support and coordinated wif teh Financial team for O2C process
• Worked collectively wif other business areas including planning and finance to ensure dat manufacturing function fully integrates wif other business process
• Analyzed teh need for sub inventories, stock locators & setup shipping networks transfer
• Performed organizational set ups including inventory organizations, item categories, workday calendar, locations, freight carriers, item parameters etc
• Involved in making setup of vendor catalogue into Oracle to define new items & categories
• PO: Setup Suppliers, Assigned Approval Groups, Document Types and Purchasing, Receiving and Financial options
• Setup of various Purchase Orders
• Worked on user menus
• Conducted CRP1( Conference Room Pilot) testing for teh Purchasing and Inventory
• Communicated wif teh technical team for teh bugs found
• Worked on making Test scripts and performed testing procedures for various oracle apps module like Inventory and Purchasing

Confidential, Atlanta, GA

Oracle SCM Functional Analyst

Responsibilities:

• Analyzed and documented teh functional requirement for data conversion and coordinated wif teh technical team to process teh conversion
• Performed inventory setups like inventory organization, locations, item parameters and replenishment planning
• Setup of ABC classes for teams to aid in implementation of counting methodology
• Setting up of complete order cycle setups from order entry in order management to ship confirm in shipping execution
• Defined Price lists, Modifiers, Qualifiers, for different orders and customers in Advanced Pricing.
• Modifiers include discounts, freight discounts and point price breaks
• Analyzing teh parameters involved in physical inventory and cycle counting
• Involved in planning and execution of CRP's
• Communicated wif other functional teams in order to integrate manufacturing functionality wif teh financial modules
• Prepared TE-40 and executed teh key test scenarios which include both inbound and outbound interfaces wif external systems
• Prepared training materials to teh business users
• Provided onsite training to teh business users about teh new procedure developed for teh business transformation phase in Order Management, & Advance Pricing modules
• Participated in teh User Acceptance Testing (UAT) Planning
• Designed teh UAT test cases for various scenarios
• Resolved teh issues/bugs while teh UAT and documented teh same for further reference
• Conducted meetings for planning teh cut over and go live phase

Confidential, Arlington, TX

Oracle Functional Support Consultant

Responsibilities:

• Rendered post production support in Purchasing and Order Management modules to teh client
• Worked closely wif teh technical team on all application enhancement request and bug fixing
• Updating and validation of BR-100
• Responsible for tracking of all issues and prioritize depending on teh key business areas and time sensitive price constraints
• Rendered support for researching, troubleshooting and testing product problems and client configurations
• Trouble shoot problems pertaining to Purchase Order, Requisition, user access, notifications, suppliers set-up, payment options and buyer activities
• Created service request and prioritized as SEV1 and SEV2 and conducted web conference to resolve teh issues
• Tested and implemented teh requested changes in existing setups
• Involved in training end users on application usage and developed teh necessary document
• Prepared standard operating procedures for modification/changes to teh setup documents

Confidential, Orrville, OH

Oracle SCM Functional Consultant

Responsibilities:

• Analyzed all teh required documents like BP30, BR100. BR150,MD50
• Setup- Various types of Purchase Order, supplier and supplier site
• Created requisition templates, approval groups, approval hierarchy and approved supplier list
• Setting up of various types of Purchase Orders me.e. Standard purchase order, Blanket purchase agreement, Planned purchase order and Contract agreement
• Configuring iProcurement module
• Setup- of BOM structure, routing, operations, departments
• Conducted CRP1 testing for scenarios in Purchasing and iProcurement
• Involved in planning CRP2, data conversion, data loading and training teh end users
• Coordination wif teh team for teh test execution and issue resolution processes and providing teh status update to project management team during teh daily status calls
• Participated in teh User Acceptance Testing (UAT) Planning and Go Live Scheduling
• Tested and implemented teh requested changes in existing setups
• Trouble shoot problems pertaining to user and super user
• Maintained all teh updated documents
• Based on teh error's raised service request following wif severity 1, 2 and 3

Confidential, Milwaukee, WI

Oracle SCM Functional Consultant

Responsibilities:

• Analyzed teh current business process & performed Gap Analysis to map user requirements to oracle apps functionality
• Performed a walkthrough of teh To-Be business process flows
• Reviewed teh implication of teh functional decisions being made during teh setup processes
• Involved in a feasibility analysis of integrating oracle functionality and legacy system
• Defined product catalogue and categories in Inventory module
• Worked on various setups like creation of items, creation of BOM structure and copying to multi-Org
• Determined and defined teh workday calendar
• Setup of Bill of Material parameters, department classes, resources and locations
• Assisted in setting up of shipping parameters like picking rules, pick slip grouping rules, release sequence rules for Order Management
• Oracle Inventory - Ship Orders, Update Inventory, Create/Manage Sales Orders, Inventory Planning methods
• Involved & tested Oracle Workflow
• Coordinated wif teh finance team in order to enter teh financial information
• Mapping teh transactions relevant for client and ascertaining workarounds
• Prepared various test cases based on scenarios and performed random tests to test teh strength of teh application
• Wrote and tested business scenarios for CRP
• Worked wif end users to document teh process and functional requirement also providing them wif training material
• Involved in Data Conversion Planning
• Conducted system integration testing, involved in teh User Acceptance Testing (UAT) Planning and updated teh BR 100 document

Confidential, Evansville, IN

Oracle SCM Functional Consultant

Responsibilities:

• INV, WIP, BOM configuration setup
• Customization requirements
• Reviewed & maintained AIM documents
• Set up item status, attributes control and item template
• Wrote and tested business scenarios for CRP 1. Trained Users
• Reviewed teh implication of teh functional decisions being made during teh setup processes
• Worked on Shipping Tolerances at Customer level in Order Management Application
• Worked wif client in suggesting & developing position hierarchy for organization in Purchasing module
• Good Knowledge on Blanket Purchase Agreement and Releases in Purchasing Application
• Worked extensively on Item categories, Category sets, Category codes and resolved teh issues on Item categories for teh reports in Inventory and Purchasing modules
• Troubleshooting and clearing teh PO Approval issues, Stuck POs from teh Workflow utilizing teh standard scripts from Oracle.
• Working wif different teams to resolve teh issues for teh assigned sites. Research teh issues on Metalink and Open teh TAR wif Oracle for critical issues and following up wif Oracle support regarding bugs and patches
• Resolved teh issues on Taxes, Freight charges for teh customers in Order Management Application
• Helped in developing user guides.
• Prepared standard operating procedure for modification to teh setup document
• Prepared oracle suggested documentation for future reference

Confidential, Santa Clara, CA

Oracle SCM Functional Consultant

Responsibilities:

• Understanding teh client’s business process and gathering teh Business Requirements from teh business users to map into Oracle Applications.
• Participated in CRPII to explain teh business process flow in Oracle according to OVT business needs.
• Conduct teh GAP analysis and prepared Business Requirement Documents (BRD100) and MD050’s, MD070’s wif teh SOX approval
• Worked extensively on Unit Testing, and System Integrated Testing
• Prepared User Training Manuals in INV, PO, and OM applications and trained teh super users
• Worked extensively on Inter Company transactions, Inter Organization transactions in Inventory application.
• Creating functional design documents to build teh new Oracle custom reports and testing teh developed reports before migrating it to teh other instances
• Created various order types wif teh approval hierarchy in Order Management (OM) module
• Worked on Quote Management in OM including creation of versions for teh Quotes
• Worked extensively on Return Material Authorization (RMA) transactions in Order Management.
• Created Purchasing Hierarchies, Approval Limits, Approval Assignments for teh various positions in Purchasing application
• Worked on Internal Requisitions, Internal Sales Orders, and Drop Shipment process in Purchasing, Order Management applications.
• Created Inter Company price list for Inter Company transactions in Order Management and Inventory application
• Extensively worked on Modifiers, Qualifiers to create a price list for various items in Order Management module.
• Created setups to import Freight Costs entered at shipping into Account Receivables module
• Created setups for Physical Inventory in Inventory Application
• Setting up user defined transaction types for inventory transactions pertaining to teh issues done to teh various cost centers from Stores. Custom Pll was developed to restrict teh Transaction Types LOV based on teh Inventory Organization in which teh transaction is being performed
• Created Shipping Networks between teh organizations for Inter Organization and Internal Requisition setups
• Extensively worked on Multi Currency conversion setup in Purchasing and Order Management Applications
• Setting up of buyer less procurement process for frequently procured items through teh internal catalog for iProcurement requisitions. Set up of ASL’s for iProcurement-requisitioned items wif release generation method “Release using Create” enabling auto generation of Blanket Releases, Standard Purchase Orders against teh Blanket Agreements and Catalog Quotations
• Defining and maintaining ABC classification of items for cycle counting procedures and maintained physical inventory procedures for inventory and sub-inventory locations.
• Created category sets, category codes, default category sets for teh various items in Inventory application
• Performing regression testing during upgrades.
• Responding to functional assistance tickets from teh super users, problem analysis and resolution

Confidential, WI

Oracle SCM Functional Consultant

Responsibilities:

• Study and analysis of teh existing systems and business processes to create AS-IS document.
• Conducted conference room pilot (CRP), training and testing sessions for business champions & super users.
• Configuration, enhancement and prod support of Oracle Purchasing, iProcurement, Account payables, Account receivables, Order Management, General Ledger and Inventory modules.
• Ensured defect-free product functioning by performing extensive testing of various test scenarios.
• Delivered product functionality clarifications to clients to maximize productivity.
• As part of AIM implementation, provided client wif Application extensions functional design (MD 50), Unit Test Script (TE 20), System Test Script (TE 40) and User guide (DO 70).
• Provided timely reports and drove steering committee meetings to update on teh direction needed to solve teh issues.
• Management and coordination of teh project/issues wif onsite & Off Shore functional and technical teams.
• Cost & time estimations of enhancement projects using System Enhancement Request (SER) form for approval, visibility and control of teh top management.
• Coordination wif teh QA’s and DBA’s to complete tasks wifin teh time deadlines Worked wif business users and IT for possible enhancements and their usage.
• Carried out User Training adopting teh “Train teh Trainer” methodology.
• Worked wif Oracle support on Service Requests (SR’s SEV1) 24x7 to get teh system up and running and meet teh close deadlines.

Confidential, Detroit,MI

Oracle Functional Support Consultant

Responsibilities:

• Provide post-production support for Inventory, Order Management, Bills of Material and Work In Process applications
• Supported teh end users in creating resource, creation, copying and transferring of bills
• Maintained documentation for each issue and followed teh change management process wherever there is a functional configuration change is proposed by teh business and provide functional extension in teh production environment
• Supported production environment and users on daily basis by responding to emergency requests
• Finding out teh errors made by teh user
• Execution of teh modified test scripts wif custom components as part of post upgrade testing of teh cloned instance, for teh inventory and order management functional areas
• Proposed new solution for teh existing interfaces
• Worked on user menus and functional set-up and provided training to teh end users

Confidential

Oracle Functional Consultant

Responsibilities:

• Performed full life cycle starting from analyzing business to Go live
• Responsible for Scope of teh Project, Business
• Performed a walk through of teh To-Be business process flows
• Prepared BR100, MD50 and RD20.
• Documented teh AS-IS, training material and operating procedures
• Conducted numerous meetings and trainings on Oracle functionality to communicate and educate teh users.
• Analyzed teh current business process and did teh requirement gathering for Order Management (OM) & Purchase Order (PO)
• Performed Map and Gap Analysis
• Setup suppliers, payment terms and pricing methods
• Responsible for successful completion of conference room test pilots wif teh business process owners.
• Worked closely wif teh development team on all application enhancement and bug fixing.
• Designed new interfaces and custom components for on going enhancement requests
• Prepared test scripts and user guide to follow up
• Participated in teh User Acceptance Testing (UAT) Planning
• Resolved teh issue/bugs while teh UAT and documented teh same for further reference
• Involved in Data Conversion up to teh date