SUMMARY

• 17 years of experience which include 2 years as a Production Analyst in Core Manufacturing, 6 years as a System Administrator in IT field and around 9 years as an Oracle SCM Functional Analyst with extensive expertise in both R12 & 11i versions of Oracle applications.
• Worked on various modules with focus in Manufacturing and Distribution domain with extensive experience in Oracle Inventory (INV), Order Management (OM) including Shipping, Pricing & Advanced Pricing, Purchasing (PO) including iProcurement (iProc), Bill of Material (BOM), Work in Process (WIP), Material Requirements Planning (MRP) and Master Product Scheduling (MPS).
• Proven expertise in business process mapping, analysis, design and configuration, customization and workarounds, functional issue resolution, System Integration and Acceptance Test as a part of Implementation and Upgradation.
• Expertise in requirement analysis, system mapping, conduct CRPs and UAT, Integration testing, system configuration, data conversions, regression testing, Go - live support and production support.
• Proficient in create and maintain documentation under AIM methodology like RD 20, BP 80, BR 30, MD 50, CV 40, BR 100, TE 40 and create User Manuals.
• Exploration Phase Scheduling- Application requirement and evaluation study, Selection of product vendor and sourcing, Product demonstration to Project Steering Committee and key business users, Selection of implementation methodology.
• Engagement Phase Scheduling- As-Is process mapping, To-be process mapping, gap and fit gap analysis, Goal setting, Mile stone fixing, Strategies scheduling, Fixing responsibilities matrix, Data sourcing and refining, Data migration and validation, Conference Room Pilot (CRP).
• Enable Phase Scheduling- Defining roles and responsibilities, on the job training for key and end users, Parallel process running, Result deviation, UAT, Going live and Post implementation issues.
• Excellent problem solving, communication, analytical and interpersonal skills.
• Follow-ups with Oracle Support on Technical Assistance Requests (TAR)/Service Requests (SR) and conduct Oracle Web Conference (OWC) to resolve high prioritized issues within the time lines.
• Create and maintain user manuals and provide multiple user training sessions for large group of users.
• Conduct System and Integration Testing (SIT) and coordinate with UAT.
• Good experience in implementation process mapping, functional requirement analysis, Gap analysis, post implementation production support, development of training material, presentations, testing and documentation.
• Worked in multicultural and multiethnic environment with coordination across different time zones including On-Site/Offshore model.

TECHNICAL SKILLS

Modules: INV, OM, PO, iProc, BOM, WIP, MRP/MPS, Advance Pricing, Costing, P2P, O2C and Q2O cycles

Versions: R12 (12.0.3, 12.0.4, 12.0.5, 12.0.6, 12.1.1, 12.1.2, 12.1.3) & 11i (11.5.8, 11.5.9, 11.5.10, 11.5.10.2)

Other Tools: Data Loader, PLSQL, SQL Loader, TOAD, Bugzilla, ADI, WebADI, OBIEE and Discoverer

PROFESSIONAL EXPERIENCE

Confidential, Eldon, MO

Oracle Supply Chain Functional Analyst

Responsibilities:

• Set up of Inventory Organizations, Sub inventories, Item Sub inventory relationships, Shipping networks and Transaction Sources.
• Automation of Item Set up including set up of Item, Setup of Item Templates and Item Categories.
• Setup of Order Management with Order Transaction Types, RMA types with various kinds of Order Holds utilizing credit check at different stages of order.
• Order entry & order booking - Use defaulting rules and processing constraints to help through order entry.
• Implementation of Holds using Oracle workflow to ensure greater control over Order Modification.
• Invoicing of the orders as per the business rules.
• Analyzed the various pricing business scenarios to understand the pricing and discounting requirement of the client.
• Implemented various pricing and discounting measures based on product hierarchy and pricing attributes.
• Defined and mapped flexible attributes & domains to control the prices & discounts applicable todifferent items, customers and orders.
• Defined various price lists, pricing contexts, attributes & attribute values to meet the business requirements of the customer.
• Setup of Price Lists for different Order Transaction types, RMA types
• Setup Modifiers to pass on charges to the customers like Freight charges to capture at the point ofshipping.
• Set up Agreements with customers to use pre-negotiated prices, freight charges & payment terms
• Set ups for Purchasing Module by configuring Jobs, Positions, Hierarchies, Buyers, and Approval management
• Set Up of sourcing rules & Approved Supplier Lists
• Prepare and review test scripts based on the business requirements
• Planned, Executed and Monitored the CRP phases in Development instances
• Imparting functional training to users and super users
• Involved in change management to follow up the necessary changes which have been made as per the business flow in day to day activities.

Confidential . Spokane, WA

Oracle SCM Functional Consultant

Responsibilities:

• Studied the existing business process & conducted meetings on client business overview.
• Performed Gap Analysis so as to map the business requirements to oracle functionality.
• Prepared business requirements documents for Purchasing & OM.
• Defining and setting up of complete Procure To Pay cycle setups from entering the requisition in purchasing to entering the receipts and creating of the invoice in account payables module to support business requirements.
• Created requisition templates, approval hierarchy, sourcing rules, approved suppliers list
• Performed organizational set ups including inventory organizations, locations, freight carriers, items, parameters etc.
• Defined product catalogs and categories in Inventory module.
• Setup stores, catalogs, mapping catalogs to purchasing categories, and defined expense account rules in iProcurement.
• Performed setups for creating requisition for catalog and non-catalog items in iProcurement module.
• Assisted a project team in understanding the integration of Purchasing with iProcurement.
• Conducted Unit testing of Purchasing (P2P) cycle, iProcurement, Inventory modules.
• Assisted in doing setups for shipping parameters like picking rules, pick slip grouping rules, release sequence rules for Order Management.
• Conducted CRP testing by developing test plans for various business scenarios in Purchasing & iProcurement.
• Executed various test cases based on scenarios and performed random tests to test the strength of the application.
• Prepared test log based on all the tests performed and their results.
• Worked with end users to document the business processes & functional requirements also providing them with training materials.

Confidential . Dallas, TX

Oracle SCM Functional Consultant

Responsibilities:

• Analyzed business requirements & performed Gap Analysis to map user requirements to oracle apps functionality & performed prototyping of “To Be” business process flows
• Setting up of complete Order to Cash cycle setups from order entry in order management to ship confirm in shipping execution module for business transformation phase.
• Incorporated a new consolidation center, added new pickup location, order types in Order Management to fulfill the requirements.
• Defined Pricelists, Modifiers, Qualifiers, for different orders and customers in Advanced Pricing. Modifiers include discounts, freight discounts and point price breaks.
• Worked in a team in understanding the integration of Advanced Pricing with OM process.
• Documented the new business processes & functional requirements & also provided with training materials to the business users.
• Provided onsite training to the business users about the new procedure developed for the business transformation phase in Order Management, & Advance Pricing modules
• Participated in the User Acceptance Testing (UAT) Planning.
• Designed the UAT test cases for various scenarios.
• Executed User Integrated System Level testing with the technical team before the UAT planning.
• Resolved the issues at the UAT phase and documented the same for further reference.
• Provided user support in the go-live phase.
• Involved in implementing the upgradation from Oracle 11.5.10.2 to 12.0.6
• Analyzed user requirements to 12.0.6 functionalities and mappings within order management, purchasing and advanced pricing modules.
• Provided manufacturing functional expertise during development of distribution execution system.
• Setting up order management, shipping execution setups after finalizing on the requirements.
• Role: Oracle SCM Analyst
• Provided support and coordinated with financial team for O2C process.
• Performed bug checking, logging and followed up with the SR resolution process.
• Helped continuously to adapt order management process and Oracle ERP system to support a dynamic business environment.
• Trained end users on order management and purchasing.
• Worked on making Test scripts and performed testing procedures for various oracle apps modules.
• Conducted CRPs (Conference Room Pilots) to ensure that the business processes are performedsuccessfully using oracle Applications.
• Go-Live stage was performed successfully.

Confidential, Thornton, Colorado

Oracle SCM Functional Consultant

Responsibilities:

• Analyzed the existing business process flows in manufacturing and supply chain management.
• Interacted extensively with the Client's formulated strategies and analyzed gaps to streamline the usage of existing oracle ERP.
• Studied and updated the existing BR100 documents by doing GAP analysis.
• Completed procure to pay cycle setups from entering the requisition in purchasing to entering thereceipts and creating the invoices in accounts payable module to support business requirements.
• Created requisition templates, approval hierarchy, sourcing rules, approved supplier lists.
• Performed organization setups including inventory organizations, locations, freight carriers, items etc
• Defined product catalogs and categories in inventory module
• Worked and performed setups on creating and maintaining items and their respective tab regions
• Conducted Conference Room Pilot (CRP1), made all the standard setup and successfully run the smoke test to check the errors.

Confidential ., Seattle, WA

Oracle SCM Function Consultant

Responsibilities:

• As a Functional Consultant I was responsible for business process mapping, functional implementation, configurations, gap identification and resolution, functional input to technical design, development and testing for (Reports, Interfaces, Customization and Extensions).
• The project phases include Process Study, Conference Room Pilots, Functional implementation and Integration.
• IR/ISO flow, Drop ship flow was also used.
• Performed Business process mapping and Gap analysis BR150 for INV, OM, BOM and WlP.
• Did the Initial System setup and configuration of INV Structure, INV Items, OM, BOM and WIPmodule as per the business requirement.
• Performed System business cycle testing.
• Developed test scripts as per the business scenario and conducted CRP.
• Prepared solution design (MD 50) and functional setup document (BR 100) for INV, OM, BOM and WlP module.
• Oracle SR Maintenance. Clearing the pending transaction for month end closure1.
• Provided onsite training to the business users about the new procedure developed for the business transformation phase in order management, inventory.
• Participated in the User Acceptance Test planning.
• Designed the UAT test cases for various scenarios.
• Executed system level testing with the technical team before the UAT planning.
• Provided user support in the live phase.
• Responsible for functional support for BOM, WIP, MRP, INV.
• Coordinated with technical team to develop reports in the area of manufacturing.
• Responsible for preparing Presales demo for prospective client.
• Helped to find out the errors made by the users.
• Resolved errors faced by users and conducted meetings to follow up with the errors.

Confidential ., NJ

Oracle SCM Functional Analyst

Responsibilities:

• Reviewed all the documents- Business requirement gathering documents (RD20), BRIO0 (Application setup document) & MD 50.
• Involved in Inventory setups from creating a organization, defining an item, item categories, calendar, sub inventories and creation of locators, cycle counting, min max planning.
• Performed setup for BOM parameter, Routing, Routing Attachments, creating Bills, Item Cost, Sub Elements, Different Costing Processes depending on item type, Employee Setup, Setup and Migration of PO.
• Defined Work in Process Parameters, Accounting Classes, Profile Options, Production Lines, Repetitive Assemblies, Schedule Groups, Resource Rates, Shop Floor Statuses & Planning Parameters and complete setup for product costing.
• Pick-to-Order (PTO) and Assemble-to-Order (ATO) items, models and hybrids supporting building configurations using other configurations as sub-assemblies internal and external sourcing of ATO models at any level in the BOM.
• Upgradation is pointed to extract the maximum benefit available in Inv modules functionality.
• After doing all the personalization and migration, asked users to lookup for the upgraded instance and updated the documents till UAT phase.
• Provided support during integration testing. Worked on some additional requirements toreduce the time gap of the similar development effort from the onsite team.
• Analyzed the setups and made changes to them upon user requirement.
• Full involvement in day-to-day activities of system and Support users by solving their problems related to day-to-day Activities.
• Tuned existing reports to improve performance speed and execution time.
• Provided user support through Service Requests (SR) and Defects logged by Business Analyst.
• Performed module functionality testing after application of patch provided by oracle.

Confidential, Evansville, IN

Business Analyst / Oracle SCM Functional Consultant

Responsibilities:

• Performed solution pilot covering prototyping of “To Be” business process flows by analyzing the gap in the business requirements & then mapping it to oracle functionality.
• Worked on setting up order verification holds and new customer credit check holds in OM.
• Performed setups & integration testing for split shipment, drop shipment process, RMA process, shipping parameters with Quoting, Order Management & custom made ‘Scheduling & Dispatch’ modules.
• Performed on-site deployment activities for Inventory, Order Management, Quoting modules & custom solutions including ‘Scheduling & Dispatch.
• Performed Item Mapping from legacy system and vendor catalogs into Oracle to define new items & categories.
• Setting up of complete Order to Cash cycle setups from Quoting & order entry in order management to ship confirm in shipping execution module.
• Developed test scripts & conducted CRP testing for the Order 2 Cash cycle.
• Involved in the deployment cycle for Item Mapping, Production Cutover activities, helping the Pilot divisions to Go-Live, & user support in live phase.
• Documented new procedures and was involved in training the business users on the new processes and also assisted them during their on-job training exercise.
• Participated and executed all phases of UAT: The test plan, developing test cases, documenting the test logs, and user sign-off.

Confidential . Mason, OH

Oracle SCM Functional Consultant

Responsibilities:

• Prepared business requirement documentation by analyzing new business process design, requirements analysis, and solution design using oracle AIM methodology.
• Was part of the business transformation project team and assisted the end-users in the functional configuration of Order Management and Inventory modules.
• Involved in a feasibility analysis of integrating oracle functionality and legacy system.
• Analyzing the parameters involved in physical inventory and cycle counting, and setup of ABC classes for teams to aid in implementation of counting methodology.
• Analyzed the need for sub inventories, stock locators & setup shipping networks transfer.
• Performed organizational set ups including inventory organizations, item categories, product catalogs, locations, freight carriers, item parameters etc.
• Responsible for defining and setting up complete Order Cycle setups from, order entry in order management to ship confirm in shipping execution module to support business requirements.
• Performed setups for process involving split shipment process, drop shipment process, RMA process, in Order Management.
• Performed setups for shipping parameters like picking rules, pick slip grouping rules, release sequence rules for Order Management.
• Conducted CRP and Integration testing for related modules.
• Maintained issue tracker and coordinated with the team for debugging.
• Involved with user acceptance testing (UAT) and end user training.
• Prepared and provided comprehensive training materials and practice exercises.

Confidential, Arlington, TX

Oracle SCM Functional Consultant

Responsibilities:

• Rendered post production support in Purchasing and Order Management modules to the client.
• Provided first point of contact customer support during business and non-business hours to meet customer support response time commitments.
• Troubleshooted problems pertaining to Purchase Order, Requisition, user access, notifications, suppliers set-up, punch-out sites, payment options, and buyer activities.
• Participated in the configuration, implementation and testing of new client rollouts.
• Researched the implementation issues on Metalink and opened a SR with Oracle for critical issues.
• Worked on user menus and functional set-ups and provided training to the end users.
• Tested and implemented the requested changes in existing setups.
• Participated in ongoing process enhancements and modification requests.
• Involved in training users on applications usage and developed necessary documents.
• Prepared standard operating procedure for modifications to the setup documents.

Confidential . Houston, TX

Oracle SCM Functional Consultant

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 walk-through of the To-Be business process flows.
• Documented the functional requirements for data conversion and historical data incorporatingindustry best practices and standards.
• Worked with full life cycle like creation of Items, Subinventories and Stock Locators.
• Worked on mapping the transactions relevant for client and ascertaining workarounds.
• Reviewed application setups to make existing business processes work.
• Documented the AS-IS, training material and operating procedures.
• Conducted Integration Testing and User Acceptance Testing.

Confidential . Pella, IA

Oracle SCM Functional Consultant

Responsibilities:

• Provided post-production support for Inventory and Order Management applications.
• Rendered support for researching, troubleshooting and testing product problems and client configurations.
• Involved in training end users on application usage and developed the necessary documentation.
• Worked closely with the development team on all application enhancement requests and bug fixing.
• Tested the system functionality after scheduled upgrades and customizations.
• Co-ordinated with oracle support on various SR’s on a periodic basis.
• Handled customer requests with respect to system enhancements, testing and maintenance.
• Involved in creating manuals, test scripts, best practice proposals for Inv and OM.
• Actively participated in all the application enhancement requests with excellent feedback from the client.
• Updated setup documents and prepared standard operating procedure for the users.

System Administrator

Confidential, Washington DC

Responsibilities:

• Wrote PL SQL procedures and build VB Projects as well.
• Researched and recommended purchase of additional hardware and software to help achieve more effective and efficient use of the network.
• Maintained knowledge of current and new trends in data communications through attendance at professional meetings/seminars and review of the current literature.
• Installed the software patches to keep the systems up-to-date.
• Installed configured and tested virtual servers and virtual desktops.
• Installed and tested the wireless network to meet the business needs.
• Installed configured and supported wireless printers and wireless access points along with wired personal and network printers.
• Participated in the rollout planning and execution of company workstations and laptops operating system migration, upgraded hardware and software applications.
• Swapped and rotated backup tapes, verified that backups completed successfully. Restarted failed or hung backups, performed manual backups and restored data on as needed basis.
• Managed user accounts, provided desk side assistance and developed training sessions for current and new employees.
• Maintained the library of software and documentation and the inventory of parts for emergency use.
• Conferred with network users about how to solve existing system problems and to inform them about the future projects.
• Planned, coordinated and implemented network security measures in order to protect data, software and hardware.
• Coordinated in relocating the company, assisted my superiors in all phases of the relocation project and reimplementation of the network.
• Evaluated areas of responsibility for continual improvement and potential cost savings.
• Assisted in reviewing quality control and other operational reports to ensure that quality standards, efficiency and schedules are met.
• Assisted in resolving daily production issues by collecting and analyzing data to determine root cause and implementing short and long term corrective actions.
• Interpreted results of laboratory activities to the manufacturing team.
• Implemented corrective actions for discrepant parts.