SUMMARY:

• 7+ years of IT Experience, which includes experience as a Business Analyst/Functional Consultant with specialization in Order Management, Procurement 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.8
• Well conversant with Oracle Finance Modules - GL, AR, AP, Cash Management, Oracle Supply Chain and Manufacturing Modules - OM, Shipping, INV, ASCP, BOM, WIP, Demand Management.
• Extensive experience with Configuring Oracle Application modules as well as understanding the underlying schema, with insight into converting user requirements into functional and technical specifications.
• Responsible for testing of the functionality of Oracle ERP Application.
• Extensive experience with documentation as per the AIM methodology.
• Involved in scoping and mapping of business requirements of clients for Oracle SCM/Distribution solutions.
• Involved in Conference Room Pilots and User Acceptance Testing.
• Responsibilities also include building, testing & development as per Business Requirements.
• Hands on experience with all phases of Software Development Life Cycle. Involved in entire QA Life Cycle, which includes Designing, Developing and Execution of the entire QA Process and Documentation of Test Strategy, Test Plans, Test Cases, Test Procedures and Test Scripts for ERP Applications, Web based and Client/Server applications.
• Experience in Testing 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.8

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

Oracle Modules: Order Management (OM), Purchasing (PO), Inventory (INV), Bill of Materials (BOM), Work in Progress (WIP), i-procurement, Warehouse Management (WMS), General Ledger (GL), Accounts Receivables (AR), Accounts Payables(AP), Cash Management(CM), Fixed Assets(FA) and Oracle Mobile Supply Chain Application (MSCA)

PROFESSIONAL EXPERIENCE:

Confidential, Huntersville, NC

Oracle Functional Consultant

Responsibilities:

• As a Functional Consultant, was involved in implementing the SCM modules: OM, AR, WMS, PO, AP, GL and INV
• Performed Requirement and Gap analysis.
• Configurations and Setups in the modules - OM, WMS, Shipping and PO, INV
• Worked on Auto Lock Box process for Confidential of New York.
• Worked on Revenue Recognition setups in Oracle AR Module
• 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.
• Experience in working with tools like JIRA, Qtest
• Involved End-to-End testing for business process using all application tiers.
• Preparing BR100, MD050, TE40, TE50, and CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation within the Oracle Application.
• Implemented EDI standards for 3PL between Transplace and ATD. Messages used were 850, 204, 945, 210 and 214.
• Involved in Integration Testing of Micro services Architecture (MSA).
• Involved in as-is -> to-be process mapping for the Release 12.2.8 version.
• Performed all the setups for Order Management, AR, Warehouse Management, Purchasing, 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.

Confidential, Burlington, MA

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 OM, PO, Scheduling, Planning, Sourcing, WIP, Logistics, AR and INV modules.
• Used one ECO to setup a group of BOM changes to update multiple BOMs and Item Revisions.
• Worked on the RMA Process in the Oracle OM Module.
• Worked on the EDI 810 Invoice inbound, 850 Inbound Purchase Order, 843 Inbound Response to RFQ, 856 shipping executions inbound and outbound.
• 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
• Tested a patch that we had applied for the GTM Integration with Oracle EBS
• 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, 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, San Francisco, CA

Oracle Functional Consultant

Responsibilities:

• Was involved in the design and development of new enhancements
• Provided Information to User leads about new enhancements / features
• Analyzed scope and available features and Business requirements.
• Translated business user requirements into functional and technical design documents/specifications.
• Performed all of the setups and configurations for GL, AR, AP, OM, Scheduling, Planning, Sourcing, WIP, Logistics, Shipping and PO, INV Modules.
• Worked on customizing as well as developing new Workflow processes.
• Providing necessary Training to User Leads and Users on Enhancements
• Worked on testing of the 11.5.10 instance from end to end including enhancements and extensions.
• Worked on Setting up Auto Lock Box in AR.
• Worked on rectifying error transactions in Auto Lock Box Interface Table.
• Developed test scripts for testing the order to cash process
• Tested several patches that were applied to the 11.5.10 instance for functionality as well as performance.
• Worked on setting up multiple reporting currencies (MRC) in the 11.5.10 instance.