Oracle Ebs Scm Functional Resume
Houston, TX
PROFESSIONAL SYNOPSIS:
- More TEMPthan 7 Years of extensive experience in Oracle Applications e - Business Suite Oracle EBS as an SCM functional Analyst Supply Chain Management modules
- Handled several projects and performed Implementation, Upgradation and postproduction support projects in 11i and R12 according to the business requirements
- Worked on various SCM modules with focus in Manufacturing modules - Inventory INV, Bill of Material BOM, Work in Process WIP and Distribution/Supply chain modules - Purchasing PO, iProcurement iProc, Order Management OM, Advanced pricing, Order to Cash O2C, Procure to Pay P2P .
- Knowledge of Material Requirement Planning MRP /Master Production Scheduling MPS
- Proficient in business process analysis, implementation process mapping, functional requirement analysis AS-IS system, TO-BE mapping, GAP analysis, FIT gap analysis with providing solution design and coordinated with development team.
- Skilled and experienced in Conference Room Pilot CRP testing, System Integration testing SIT, User acceptance test UAT, System configuration, Post implementation production support, Master Data Loading, Training business users, Go-live and Presentations to the business
- Proficient in creation of Oracle AIM Application Implementation Methodology Documents such as, BR-150, BP-80, CV-40, BRD RD-20, BR-100, MD-50 and TE-40, FSD
- Skilled in handling full life cycle implementation going through all the phases until Go-live & Post-Prod. Support
- Hands on experience in Procure-to-Pay P2P and Order-to-Cash O2C cycles
- Worked in different kinds of industries, analyzed their business processes and accordingly provided solutions to the business. Leading test team with detailed and unit testing including system integration testing SIT
- Experienced in preparing user manuals, test scripts and user scripts
- Excellent presentation skills to demonstrate Oracle ERP system to the business
- Create multiple service request whenever necessary, by prioritizing the issues based on the complexity of the issues
- Experienced in communicating with business users, capturing business process scenarios including preparing test plan and detailed test scripts TE40 .
- Ability to work TEMPeffectively in onsite and offshore model projects with a huge team across multiple phases
- Knowledge in modules like Approvals Management AME, Landed Cost Management Module LCM, Warehouse Management System WMS and Advanced Supply Chain Planning ASCP
TECHNICAL SKILLS
Distribution: Inventory, PO, OM, Shipping, Advanced Pricing, iProcurement
Manufacturing: WIP, BOM, MRP, MPS, CM
Oracle ERP’s: R12 12.0.4, 12.0.6, 12.1.2, 12.1.3 11i 11.5.7, 11.5.9, 11.5.10, 11.5.10.2
Software Packages: MS office Word, Excel, Outlook, Access, HP Quality Center, Mercury
Testing Tool: MS Visio, Data Loader, Discoverer, ADI, Web ADI, PL/SQL, TOAD, Hyperion, OBIEE
PROFESSIONAL EXPERIENCE
Confidential, Houston, TX
Oracle EBS SCM Functional
Responsibilities:
- Provided detailed understanding to the users on change points and impact of moving to a Multi-Org environment through extended key user sessions
- Conducted several sessions with key users to analyze business requirements and performed fit-gap analysis to map user requirements
- Prepared Detail test for Inventory, PO, and Order Management
- Developed requisition, PO document types, approval hierarchy, financial options, purchasing options, receiving options and approved suppliers list using R12 PO module functionalities in UAT
- Provided support and coordinated with the financial team for AP module with regard to P2P cycle
- Performed User Acceptance Testing (UAT) and System Integrated testing (SIT) to ensure all user data was migrated and business requirements met.
- Test all functionalities as per clients requirements and provide on-going support through service and change requests
- Complete setups of Procure to Pay cycle.
- Participated in the User Acceptance Testing (UAT) Planning
- Gatheird and analyzed current setups for Purchasing and Performed PO setups like Setup of Suppliers, Purchasing, Receiving and Financial
- Responsible for setting up Oracle Purchasing for all employees in various units and the approval hierarchies AME
- Responsible for validation of data and coordinating data conversion activities with conversion team
- Defined purchasing, financial and receiving options. Defined ATP rules, document types, approved suppliers, buyers, approval limits and groups in PO application
- Resolved the issues/bugs while the UAT and documented the same for further reference
- Defining user responsibilities set up and menus and requests sets based on user responsibilities
- Developed user training documents for knowledge sharing on application usage
Confidential, Monroeville, PA
SCM Functional Consultant
Responsibilities:
- Coordinated with the team onsite & offshore and ensured the completion of activities as scheduled
- Held meetings frequently to receive and review the status/progress of all the team members
- Created and reviewed testing documents like TE 40 and conducted unit testing
- Involved in sharing knowledge to users on applications usage and developed necessary documents
- Analyzed user requirements to R12.1.3 functionalities of Inventory and PO
- Setting up of Inventory and PO setups after finalizing the requirements
- Setting up requisition, PO document types, approval hierarchy AME, financial options, purchasing options, receiving options and approved suppliers list
- Provided support and coordinated with the financial team for AP module with regard to P2P cycle
- Worked on making Test scripts and performed testing procedures for oracle apps modules Inv & PO
- Analyzed and resolved problems related to applications and the business processes
- Raised Service Request by prioritizing based on the level of impact on the issues aroused
- Worked with the technical team on API to setup and understand the functioning of the concurrent programs
- Executed these concurrent programs to test the various stages of the P2P cycle
- Trouble shoot problems pertaining to Purchase Order, Requisition, Inventory
- Provided UAT & production support for INV & PO modules
- Performed Purchasing setups like Setup of Suppliers, Purchasing, Receiving and Financial Options
- Approved Supplier List, Employees, Jobs, Approval Groups, Approval assignments, Document Types
- Performed UAT, documented and shared the results and other documentations through sharepoint and frequently communicated with the business team about the UAT performance.
Confidential, Westfield, MA
Position: SCM Functional Consultant
Jen-Coat is a privately held company and is an industry leader in specialty coating & laminating services. They have recently ventured into food packaging, health care and industrial markets.
Project was an implementation of R12.1.3 (INV, PO, OM, Advanced Pricing and BOM)
Responsibilities:
- Analyze of existing business processes
- Involved in the creation of Manufacturing and Supply Chain structure for the business processes.
- Conducted conference room testing sessions, HPQ testing
- Gathering the business data requirement from the client and mapping them with the Oracle EBS functionalities
- Working with business to identify and define best business practices and project/enhancement requirements.
- Conducting workshop with all the business stake holders and user community.
- Performed AS-IS Analysis for setups and identified GAP’s
- Provided the GAP Analysis results to the business and explained the TO-BE business process flow
- Analyzed business requirements BRD and performed FIT GAP analysis to map the user requirements using AIM methodology
- Improving the process gaps and suggesting best practices.
- Communicated with business team frequently to get the approvals for requirements proposed
- Responsible for developing and maintaining documentations like BR-100, CV-40 and TE 40
- Performed Inventory setups like Inventory Organizations, Locations, Item Parameters, Freight Carriers
- Configured Min - Max planning as a default replenishment planning method when purchase orders are placed for raw materials
- Tested the move orders and sub inventory transfer functions
- Setting up of inventory parameters and receiving options
- Conducted designing test, automation strategy, created test scenarios, test plans and performed inspection in test scripts.
- Worked on setting up order verification holds and new customer credit check holds in OM
- Worked with end users in creating sales order, booking the sales order, pick releasing the sale order and shipping.
- Placed holds against the customer who had exceeded their Credit limit
- Performed setups for process involving split shipment process, drop shipment process, RMA process in order management
- Performed setups for shipping parameters like picking rules and freight terms
- Supported the end users in copying, transferring & checking for loops in bills
- Communicated with technical teams for data mapping and requirement changes from business users for items, Purchase Orders and setups
- Defined user responsibilities and request groups based on user responsibilities
- Prepared FSD, test scripts and performed smoke tests for CRP 1
- Performed UAT, documented the results and frequently communicated with the business team about the UAT performance and also the results documented through SharePoint.
Client: Mattress Firm, Stuart, FL Nov 11 - Jul 12
Position: Oracle EBS SCM Business Analyst
Mattress Firm are among top three largest specialty bedding retailers in USA with over 680 stores all over the country. They sell a variety of bedding products like mattress, bed sets, furniture, protectors, etc.
Project was an Implementation and migration from legacy system of Oracle R12.1.3(INV, PO, OM and Advanced Pricing)
Responsibilities:
- Prepared business requirement documentation BRD by analyzing the current business process, accordingly created new business process design and solution design using oracle AIM methodology
- Part of the feasibility analysis team to integrate oracle apps functionality and client’s legacy system
- Coordinate activities related to requirements gathering, solution design, testing, documentation, and support
- Developed detailed design and modeling documents using MS-Visio
- Performed the AS-IS, GAP analysis and involved in creation of BR 100 & FSD
- The Client needed a comprehensive Oracle Procure-to-Pay Workflow implementation dat allows flexibility for the Purchasing and Procuring team to work independently from the Sourcing team theirby adding value to Business Process Automation.
- Assisted team lead and other team members in setup and user interaction
- Involved in training users on applications usage and developed necessary documents
- Was part of user acceptance test phase and was responsible for approval process
- Involved with user acceptance testing UAT and end user training
- Prepared and provided comprehensive training materials, practice exercises and other documents with the client through SharePoint
- Uploading Catalog or Loading Items into the Unified Catalog and Enable Categories for iprocurement
- Created purchase requisitions and confirmed receipt of requisitioned goods using a web browser
- Respond to workflow notifications to approve, reject, and reassignpurchase requisitions and monitor the on-line approval process
Client: Del Monte Fresh produce, Inc., Coral Gables, FL Jan 11 - Nov 11
Position: Supply Chain Management Functional Analyst
Del Monte is one of the world’s largest producers, marketers and distributors of high-quality vegetables & fruits
The project was an Up-gradation from 11.5.10.2 to R12.1.2 & Support (INV, PO, OM, WIP, BOM, MRP, MPS, P2P, O2C and Advanced Pricing )
Responsibilities:
- Gatheird and analyzed the business requirements, Process mapping, carried-out FIT GAP analysis and was responsible for preparing test scripts
- Configured basic settings of Inventory, WIP, BOM, advanced pricing, AP and AR
- The requirement gathering was complete and my role was to setup the Oracle Order to Cash workflow in an upgrade from 11.5.10.2 to R12.1.2.
- Configured & created suppliers, approved supplier list and performed settings on modifiers and qualifiers
- Performed smoke test, collected errors and tracked issues in ‘bugzilla’
- Performed CRP1, CRP 2 and documented the results
- Updated MD 50 documents according to the customization and solutions proposed
- Was part of data migration planning and process team
- Worked on user & super user menus
- Complete Setups for Procure to Pay Cycle P2P and creation of invoices in Accounts Payable AP module
- Worked on price breaks and configured items accordingly
- Rendered support for troubleshooting and client configurations
- Updated BR-100 documentation based on the changes performed and results produced
- Tested the system functionality after scheduled upgrades and customizations
- Communicated with the technical team for the bugs found in order to apply patches
- Involved in creating test scripts for Inventory, WIP and PO
- Prepared standard operating procedure for the end users
- Created, defined and helped the end users in suppliers, unit of measures, requisitions and receiving options like direct, inspection and standard.
- Performed setups for process involving RMA process in order management
- Performed setups for shipping parameters like picking rules and freight terms
- Worked on setting up order verification holds and new customer credit check holds in OM
- Worked with end users in creating sales order, booking the sales order, pick releasing the sale order and shipping.
- Placed holds against the customer who had exceeded their Credit limit
- Worked on quarrying the interface tables for purchasing and order management and reporting using the business object tools
Client: Nabors, Houston, TX May 2010 - Dec 2010
Position: Oracle EBS Business/Functional Analyst
Nabors is anoil,natural gasandgeothermaldrilling contractor operating on land throughout theWorld. It also performsonshorewell-servicinginNorth America, and provides rigs for offshoreoil platform work over, and also for offshoredrilling rigservicing.
project was on Implementation of 12.0.6 (Advance Pricing, OM, PO)
Responsibilities:
- Defined Order, Line Types and customized Workflow designs to provide conditional approvals, Approvals on all Order Types including returns, and Approval timeout functionality
- Defined and done setups of Pricelist, Qualifier for Pricelist in order to cash cycle
- Defined and Set up of Modifiers and Qualifier for Modifiers and trained the end users on discounts and promotions in modifiers in order to cash cycle
- Worked with Nabors as an Oracle Supply Chain Functional Analyst and responsible with PO, OM and Adv. Pricing, right from CRP 1 phase through to GO-Live.
- Setup Discounts, Deals and Promotions, and Freight and Special Charges in order to cash life cycle
- Analyzed business requirements & performed Gap Analysis to map user requirements to oracle apps functionality & performed prototyping of “To Be” business process flows and prepared the BRD & FSD
- Setting up of purchasing setups from Purchasing Options, Buyers and Setups in Receiving Options, Suppliers, Sourcing Rule, Position Hierarchies and Employees.
- Worked on iSupplier by making handy guides for end users to work on iSupplier
- Worked in a team in understanding the integration of Advanced Pricing with OM process
- Involved in designing & integration testing of outside processing process OSP related to Purchasing, Procurement.
- Documented the new business processes & functional requirements & also provided with training materials to the business users.
- Supported Order Management by validating workflow Order-to-Cash for order booking, pick release, ship confirmation and receivable interface
- Provided onsite training to the business users about the new procedure developed for the business transformation phase in Order Management and Advance Pricing modules and also the Accounts Receivable AR module
- Participated in the User Acceptance Testing UAT Planning.
- Provided user support in the live phase
Client: Essilor of America, St. Petersburg, FL Sept 2009 – May 2010
Position: Oracle EBS SCM Consultant
Essilor is the leading manufacturer and wholesale distributor of optical lenses in the United States. In 1996, with the establishment of Essilor Laboratories of America, Inc. Essilor Laboratories, Essilor became the first fully integrated optical company in the United States.
the project was to Upgrade from 11.5.10.2 to R12.0.6 & Support (INV, WIP, BOM, PO, P2P, O2C, OM, MRP, MPS and Advanced Pricing)
Responsibilities:
- Performed UAT, documented the results and frequently communicated with the business team
- Conducted meetings regarding the cut over & Go live plans
- Provided post-production support for INV, WIP, BOM, PO, P2P, O2C, OM, MRP, MPS and Advanced Pricing
- Rendered support for troubleshooting, testing product problems and client configurations
- Conducted meetings to identify and assess the impacts of production issues and provided solutions
- Transferred engineering items to WIP, INV and defined standard operations
- Designed the UAT test cases for various scenarios.
- Assisted and monitored the transactions in inventory such as miscellaneous transactions & inter org transfers
- Supported the end users in copying, transferring & checking for loops in bills
- Performed setups for process involving drop shipment process, RMA process in order management
- Performed setups for shipping parameters like picking rules and freight terms
- Handled issues dat came up during the live phase, prioritized them based on the severity and raised Service Requests
- Worked with the technical team on API to setup and understand the functioning of the concurrent programs
- Executed these concurrent programs to test the various modules
- Documented issues which came up during Unit Testing, performed change management process proposed by the business
- Tested the system functionality using the HP Quality center after scheduling upgrades and customizations
- Handled customer requests for system enhancements, testing and maintenance
- Updated user scripts and proposed best practices for Inventory, BOM and OM
- Updated the BR 100 documentation according to the changes processed
- Assisted users in performing daily activities and resolved issues
Client: Tektronix Inc., Portland, OR Jan 2009 - Sept 2009
Position: Oracle EBS functional consultant
Tektronix Inc. is a world leader in test, measurement and monitoring technology, we enable our customers to do more TEMPthan they ever have. Technical innovators of all kinds benefit from our products and expertise.
the project Upgrade from 11.5.10.2 to R12.0.5 (INV, OM, me Procurement and shipping)
Responsibilities:
- Studied the existing business process & was part of client business meetings
- Performed GAP analysis to map the business requirements to oracle functionality
- Involved in planning & implementing the up gradation from Oracle 11.5.10.2 to R12.0.4
- Setting up of shipping, Procure to pay cycle setups from entering the requisition in PO to entering the receipts in receivables and generating invoice in accounts payable module
- Created requisition templates, approval hierarchy and approved supplier list
- Assisted in integration of purchasing with iProcurement
- Assisted in setting up shipping parameters like pick slip grouping rules, release sequences for order management
- Provided a complete advance pricing setup like defined and set up of Pricelist and Set up of Qualifier for Pricelist
- Defined and Set up of Modifiers and Set up of Qualifier for Modifiers
- Complete set ups of order to cash business flow to meet the business needs
- Conducted CRP1 testing by developing test plans for various business scenarios in purchasing & iProcurement
- Involved in data Migration planning from 11.5.10.2 to R12.0.4
- Trained end users on Inventory, Order Management modules
- Created purchase requisitions and confirmed receipt of requisitioned goods using a web browser
- Defined the approval hierarchy and tested the workflow notifications to approve, reject, and reassignpurchase requisitions
- Worked on Costing with other team members on how to Adjust Average Cost with Invoice Price Variances
- Integrate & configure certain accounting, costing and period-end activities
Client: Kokusai Electric, San Jose, CA Aug 2008 – Jan 2009
Position: Oracle EBS SCM analyst
Kokusai Semiconductor Equipment Corporation KSEC provides comprehensive North American operations for its parent company, Hitachi Kokusai Electric - a premiere global supplier of Semiconductor Manufacturing Equipment.
the project was to Support for 11.5.10.2 (INV, Advanced Pricing, MRP, P2P, O2C PO, OM, MPS, WIP and BOM)
Responsibilities:
- Testing and implementing the requested changes in existing setups
- Participate in ongoing process enhancements and modification requests
- Involved in sharing knowledge to users on applications usage and developed necessary documents
- Prepared standard operating procedure for modifications to the setups performed
- Based on the level of impact on the issues aroused, raised Service Request by prioritizing
- Updating and validation of BR-100
- Creating new responsibilities and defining the required system profile options
- Creating value set and assigning its values.
- Defined Inventory Parameters and the key flexfields and DFFs system items, categories, catalogs, stock locators
- Worked with the technical team on API in setting up and testing the functioning of the concurrent programs
- Setup various Account Aliases, Picking Rules, receiving parameters, Units of Measure UOM, UOM classes and conversions
- Worked on user’s menus and functional set-up and provided training to the end users on the Order Management System Parameters and Transaction Types Order and line, Holds and Document Sequence, Payment Terms, various Shipping Roles and Grant Roles
- Setup the Price Lists, Pricing Agreements, Modifiers and added Items to the price list
- Setup Shipping Parameters, Freight Carriers, ship methods, Release rules
- Defined Pick Slip Grouping Rule and Release Sequence Rule and various shipping document sets
- Created Functional Specifications for various reports Order Management and Shipping
- Completed user training and application setup/ training documentations
Client: Hampton Scientific Inc., Chalfont, PA Mar 2008 - Aug 2008
Position: Oracle Apps SCM functional consultant
Company was into coatings and manufacturing films for optical industries.
the project was an Implementation of R12.0.4 (OM, BOM, INV & PO, P2P and O2C)
Responsibilities:
- Gatheird and analyzed the business requirements, Process mapping, carried-out FIT GAP analysis and was responsible for preparing test scripts
- Analyzed business requirements and developed TEMPeffective configuration solutions.
- Preparation of functional requirement document BR-100 for purchasing & BOM
- Created routings for bill of materials, checking for loops, making bill of materials, defining items
- Was part of the team when doing ATO cycle
- Created documents like BP80 and did requirement gathering
- Defined Purchase orders, receiving options, created suppliers, created locations, created UOM setups
- Post production support in purchasing requisition, creating approval groups and approval assignment
- Designed item status, item attribute control, item templates, serial control & UOM
- Defined cycle counting and created steps for ABC analysis.
- Setting up of BOM parameters
- Setups in shipping, picking rules, order creation, order release and move orders.
- Prepared test scripts, smoke test and executed CRP1
- Responsible for system administrator functions including setting up users, defining responsibilities, determining request groups, and setting menus
- Implementation support for OM and manufacturing modules
- Unit testing of OM, INV and BOM
Client: Macsteel Holdings, Philadelphia, PA Oct 2007 – Mar 2008
Position: Oracle Apps EBS supply chain Analyst
Macsteel Holdings is one of the largest private service centers in the world, as it distributes metals all over North America and Puerto Rico from its 30 branches The project was to be implemented on Oracle R12.0.2. (INV, PO, OM, including O2C and P2P)
Responsibilities:
- Analyzed the current business process and did the requirement gathering for Inventory and OM
- Reviewed the implication of the functional decisions being made during the setup processes
- Performed a walkthrough of the To-Be business process flows
- Involved in a feasibility analysis of integrating oracle functionality and legacy system
- Create users and assign corresponding responsibilities.
- Implement Holds, Processing Constraints and Defaulting Rules to support new processes.
- The implementation mainly concentrated on INV, OM and O2C.
- Created a blanket sales order in OM, and then entered dis blanket sales order on the release.
- Setting up of inventory parameters and coordinating with finance team for financial information
- Prepared standard operating procedure for modification to the setup documents
- Performed setups for process involving split shipment process, drop shipment process, RMA process in order management
- Performed setups for shipping parameters like picking rules and freight terms
Client: Godrej & Boyce Mfg. Co. Ltd, Mumbai, India July 2007 – Sept 2007
Position: Oracle Supply Chain Entry Level – Grade 1A.
Godrej & Boyce Mfg. Co. Ltd., the holding company of the Godrej Group, is in the manufacturing of consumer, office, and industrial products and services of the highest quality to every corner of India and across the globe.
Project was to Assist the implementation team with create and update documentation and track tickets on proposed processes.
Responsibilities:
- Provided support and coordinated with the financial team for P2P cycle including documentation, issue resolution and detailed testing. Track the test results and share in status meetings.
- Worked on making Test scripts and performed testing procedures for oracle apps modules Inv & PO
- Created testing documents like TE 40 and conducted unit testing. Conduct detailed SIT (System Integration Testing)
- Worked with other business teams to ensure dat manufacturing & distribution integrates with other business process and create future business process model documents with the third party integrations etc.,
- Trouble shoot problems pertaining to Purchase Order, Requisition, user access and assist in issue resolution raising out of detailed testing at different stages.
- Tested the functionalities as per the clients requirements