SUMMARY

• A technology driven professional with 10+ years of IT Experience, which includes experience as a Business Analyst/Functional Consultant with specialization in Procurement, Order Management, and Manufacturing Systems
• Experience revolves around Oracle ERP - Implementation, Support and Upgrade - version 11.5.10.2, Release 12.0.6, Release 12.1.3, Release 12.2.4, 12.2.6 Oracle Fusion 20C & 20D: Inventory, Procurement.
• Well conversant with iProcurement, iSupplier, Oracle Finance Modules - GL, AR, AP, Cash Management, Oracle Supply Chain and Manufacturing Modules - OM, Shipping, INV, ASCP, BOM, WIP.
• Experience in end-to-end product development and implementation of a custom solution which seamlessly integrates PLM data to Oracle EBS.
• Experience in building multiple Custom Orchestration processes in Fusion Procurement according to the business requirement.
• Expertise in the vital business processes, which include Approval hierarchies, Drop-shipments and Order Promising.
• Experience in creating custom roles, building the logic for custom reports, Page customizations, FBDI conversions.
• Well versed with implementation documents, test scripts, and material.
• Extensive experience with documentation as per the AIM methodology.
• Involved in scoping and mapping of business requirements with Oracle SCM/Distribution solutions.
• Played key roles in various conference Room Pilots and User Acceptance Testing sessions.
• Hands on experience in all phases of Software Development Life Cycle. Involved in entire QA Life Cycle, which include Designing, Developing and Execution of the entire QA Process and Documentation of Test Strategies, Test Plans, Test Cases, Test Procedures and Test Scripts for ERP Applications, Web based and Client/Server applications.
• Vast Experience in Testing. Actively involved in Unit Testing, Functional Testing, Integration Testing and Regression Testing.

TECHNICAL SKILLS

Languages: SQL, PL/SQL

Oracle Applications: 11.5.10.2, 12.0.6, 12.1.3, 12.2.4, 12.2.6

Oracle Fusion 20C & 20D: Inventory, Procurement.

Tools: SQL Loader, TOAD, Putty, EDI, SOA, MSA, Mongo DB, BI Publisher.

Oracle Modules: Order Management (OM), Purchasing (PO), Inventory (INV), Bill of Materials (BOM), Work in Progress (WIP), iProcurement, iSupplier, Warehouse Management (WMS), General Ledger (GL), Accounts Receivables (AR), Accounts Payables(AP), Cash Management(CM), Fixed Assets(FA), and Oracle ASCP

PROFESSIONAL EXPERIENCE

Confidential, Little Rock, Arkansas

Lead Functional Consultant

Responsibilities:

• Involved in the Cloud AMS project as a Support Lead. This involves the ownership of critical issues and coordinating with stake holders to ensure that the client deadlines are effectively met.
• Worked on the development of various custom reports for the business, provided re-usable and feasible workarounds.
• Provided various Best Practice documents, FAQ documents to the business to smoothen the high priority business processes.
• Key role of reviewing and publishing various support documents such as best practices, relevant enhancements during upgrades.
• Worked with Oracle support on several issues, which include Critical production issues, Environment re-sizing evaluations, performance related issues.
• Vital role in the design of the various Sales order fulfillment flows, Global and Local sourcing rules, ATP rules.
• Developed various custom fulfillment flows and assignment rules, which include Manual reservation, Fulfillment set via EFF.
• Mapped the existing business efficiently into Fusion by suggesting and configuring certain Order transformation rules.
• Extensions, Task specific pause rules for high valued orders.
• Configured various Purchasing document approvals, Smart forms for restricted requisitioning.

Confidential, San Jose, CA

Lead Functional Consultant, Oracle

Responsibilities:

• As a Functional Consultant, was involved in implementing the SCM modules: PO, OM, AP and INV
• Performed Requirement and Gap analysis.
• Configurations and Setups in the modules - PO, OM, iProcurement, and INV
• Worked on two end-to-end implementations, one being a Business split and the other being an Entity acquisition on all phases of the component cycle from gathering requirements to Production deployment, including solution design, Unit and regression testing, assisting SIT’s &UAT.
• Extensively worked on the configurations of External Sales Order, Dropship, and Intercompany and CTO flows pertaining to the new business unit.
• Closely worked on the configurations of the Intercompany Transaction flow and the Shipping networks for 12 Source Destination combinations.
• Configured the Single node, 2 node and 3 node Intercompany flows for a manufacturing plant.
• Involved in configuration and setup of Third-party Logistics (3PL), MTS (Managed Transportation Systems) projects which has truckload (TL), LTL and parcel shipping logic as well as configured the put away rules in Oracle WMS.
• Experienced and managed a team of functional consultants by tracking and resolving issues using the Atlassian JIRA reporting tool.
• Preparing BR100, MD050, TE40, TE50, and CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation within the Oracle Application.
• Involved in Integration Testing of Micro services Architecture (MSA).
• Involved in as-is -> to-be process mapping for the Release 12.2.6 version.
• Performed all the setups for Order Management, Purchasing, Inventory and AP modules.
• Worked on the configuration and setups for Picking and Shipping rules for Oracle Mobile Supply Chain Application.
• Played a crucial role in gathering the requirements from the business users and key business owners in order to prepare Business Requirement documentation.
• Jointly worked with the technical resource to develop the custom reports and provided functional testing support.
• Was involved in end-to-end testing of the business flows in order to provide UAT signoff.
• Experience in knowledge transfer sessions and mentoring new members on the team.

Confidential, San Jose, CA

Oracle Senior SCM Consultant

Responsibilities:

• Solely responsible for handling the production issues related to P2P, OM, INV, BOM, ASCP, WIP, AP Modules.
• Responsible for designing the form Personalization for Purchase order to restrict business users while updating the Matching type option.
• Coordinated with technical team in configuring AME Setups for PO Approval.
• Extensively tested P2P cycle as part of AME solution deployment.
• Restricted suppliers from creating purchase orders upon failure to meet the business requirements.
• Actively worked with Oracle team on SRs for patch related issues and data fixes.
• Restricted items from being direct delivered while receiving against a purchase order.
• Responsible in clearing on-hand for an Inventory organization completely.
• Worked with technical team for developing interfaces with other legacy applications.
• Coordinated with Oracle Support, Creating SRs, attending OWC sessions, providing 24*7 support for critical production issues.
• Responsible for mass update of lead times in various organizations.
• Worked actively on creating sub-inventories, Locators and changing the existing sub-inventory accounts.
• Responsible for Mass update of item planers and buyers in different organizations.
• Collaborated with business super users and site controllers to understand the requirements for various businesses flows such as P2P, O2C etc. from SCM standpoint.
• Worked on critical areas viz. Order Management, Purchasing, Inventory, and Receivables.
• Coordination with team members and business users for documenting real time scenarios, documents, reporting requirements, designing and executing test scripts.
• Handled crucial enhancement / Configuration change tickets as per the business needs.
• Provided KT sessions to the users on complex business models and solutions.

Confidential, San Jose, CA

Oracle SCM Consultant

Responsibilities:

• Preparing Business Requirement Documents (BRD) with the business rules associated to archive the daily transactional data across different Operating units
• Preparing business test scripts with the business rules associated with it to test the data integrity of archived data.
• Performed all the setups for INV, OM, PO, Scheduling, Planning, Sourcing, BOM, WIP, and AR modules.
• Extensively worked on the configurations of Inventory Planning and Inventory accuracy methods for fast moving items.
• Used one ECO to setup a group of BOM changes to update multiple BOMs and Item Revisions.
• Configured the Defaulting rules, Processing constraints and Manual holds for the newly administered entity to support the existing Sales process.
• Worked on the RMA Process in the Oracle OM Module.
• Worked with the technical team by giving functional logic to minimize the material handling cost, by dynamically recommending the destination location for specific items while receiving in a scheduled report.
• Involved in the creation of custom menus and responsibilities to provide relevant data security for users across the business teams, adhering to the Sox compliance.
• Worked on the Implementation of SLA in Cost management with the Custom sources, driven towards a change in charging several global transactions.
• Closely worked with the technical team, by giving a logic of segregating the global transaction types which needed to be modified.
• Worked in Creation of Item Templates and applying multiple Item templates as per the business logic.
• Worked on all of the Product Information Management (PIM) setups like setting up of the Item Catalogs, Defining Item Catalog Categories, Managing Item Statuses, setting up Attributes and Functions, setting up Catalogs, Mapping Catalog Categories, Administering Business rules, setting up change categories and Types, setting up Item Structures, Setting up content management repositories, etc.
• Written TE 040 System Test Scripts for OM, Fulfillment, INV, BOM, WIP, Planning, GTM, PO, Service Contracts, Install Base, ASCP and BOM Modules.
• Worked on testing the OM, Fulfillment, INV, BOM, WIP, Planning, GTM, PO, Service Contracts, Install Base, ASCP and BOM
• Involved in the Testing of the Order Management, WIP and INV modules including developing Test Cases, Conducting UATs and CRPs as well as logging defects in the Mercury Quality Center tool.

Confidential, Burlingame, CA

Oracle Functional/Testing Consultant

Responsibilities:

• Extensively worked on the configuration of a custom source which imports and validates the PLM data and processes it seamlessly into Oracle Production after the derivation of certain rules.
• Dedicatedly worked on Product development and architecture design from scratch.
• Involved in the configuration of the Assignment module in the project, which is responsible for all the business rule validations and derivations.
• Extensively worked on a newly setup manufacturing facility, for the implementation of Inventory and Bills of Material modules.
• Configured multiple UOM conversions and Material Statuses which were critical for the business.
• Responsible for creating test scripts and performing Unit and regression testing of the Inventory and BOM modules.
• Migrated Items, Bills, Routings, Sourcing Rules and Approved Supplier Lists to Oracle from Arena PLM using the Adapter.
• Responsible for mapped the business requirements with the Product architecture.
• Part of product installation team as a coordinator between various stakeholders.
• Created User Manuals, Implementation guides and other support documents.

Confidential, Seattle, WA

Oracle Functional/Testing Consultant

Responsibilities:

• Involved in developing the Process flows for the Quote to Cash and Procure to Report modules.
• Worked on the OM, Scheduling, and Planning, Sourcing, WIP, Logistics, PO and INV module.
• Involved in the Functional Analysis of designing and developing a custom licensing module called e- licensing, which was primary designed to provide license keys for products sold and tie back to Install Base.
• Worked on the RMA Process in the Oracle OM Module.
• Purchasing - Worked on the configuration of the Purchasing module including the setups of the
• Approval hierarchies, Purchasing Options, Setting up Matching, etc.
• Customized the Requisition import process form I-Procurement to Purchasing.
• Designed a Streamlined process for Fulfillment flow.
• Worked on EDI Gateway on the configurations and setups for inbound Purchase Order, Outbound PO, Inbound Invoice, Outbound Invoice, etc.
• Worked on the EDI Formats EDI 810 Invoice inbounds, 850 Inbound Purchase Order, 843
• Inbound Response to RFQ, 856 shipping executions inbound and outbound.
• Conducted several sessions with key users to analyze business requirements and performed fit-gap analysis to map user requirements using AIM methodology
• Identify and finalize test case Inventory in Mercury Quality Center
• Test Cycles Planning and Reporting.
• Business Systems Testing
• Conduct Progression and Regression Testing
• Designed and Developed the Test Plan for testing of the System as wells as testing of the entire bolt on modules and custom RICEW components.

Confidential, SFO, CA

Oracle Business Analyst

Responsibilities:

• Worked on the entire Quote to Cash and Procure to pay process flow - setups and business process definition.
• Performed all the setups for Quoting, Scheduling, Planning, Sourcing, WIP, Logistics, Advance Pricing, Order Management, AR modules.
• Led the testing effort for the Order to Cash and Procure to Pay Modules.
• Development and implementation of Test cases, Test plans, Test data and Test scripts according to the requirements.
• Analyzed and helped in modifying the use cases using MS Visio and created the test cases based on them.
• Responsible for testing the setup items for OM, PO, INV, AR, AP, GL, FA. Cash Management, SLA, E-Business Tax, I-Expense module.
• Worked on the setups of the Quoting module - defining the quote statues, quote approval process; quote print process, customizing the quote to sales order flow, etc.
• Worked on the OM Module - setting up the drop ship process, back-to-back process, RMA process, IRISO process, defining the transaction types, defaulting rules, processing constraints, etc.
• Worked on the Release Management module - setting up the processing rules, shipment delivery rules, message categories and release management workbench and CUM workbench.
• Worked on the setups of I-Store module - setting up the B2B and B2C stores, catalogs, categories, shopping cart setups, save shopping cart functionality.

Confidential

Oracle Functional Consultant

Responsibilities:

• Provide functional expertise to Oracle Applications users comprising of modules: OM, Service Contracts, Install Base, Shipping and PO, INV Modules Meet with customers to understand their system and service requirements.
• Assist in the regression testing of Oracle Modules as required. Developing and modifying the reports as per the need did extensive study to Implement MRC