OBJECTIVE

• To deliver solid Oracle ERP Application solutions using Functional/Technical noledge in Supply Chain Procurement and Finance domain.

SUMMARY

• Over 11+ years of experience in Oracle E Business Modules, Inventory, Purchasing, Shipping, Order Management, Oracle discrete Manufacturing environment, Istore, Iprocurement, Advanced Pricing, Account Payables, Service Contracts, Fixed Assets, Accounts Receivables, General Ledger, Bill of Materials, Work in process, Global Trade management (GTM), Oracle Transportation Management (OTM), Order to Cash (O2C), Purchasing Domain (P2P) .Oracle Cloud
• Expert in Oracle Cloud implementation and support experience with security & control, data access set, roles provisioning and role privileges for custom roles.
• Able to do business planning, design, requirement gathering, setup & configuration
• Hands - on experience with full life cycle implementation in Oracle Cloud Financials including GL, Procurement, AP, AR, Cash Management, Fixed Asset and Fusion Tax.
• Experience in full life cycle development and deployment of P2P, O2C, and ASCP.
• Good Experience in Oracle Picking and Shipping, Warehouse Management System.
• Worked on various end-to-end oracle apps implementation and upgrade projects at various capacities: functional lead, project lead, business analyst and project manage
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of teh Business Engineering, Quality Assurance and other teams involved with teh System Development Life cycle on-site and off-shore
• Develop test scenarios, execute test scripts, and perform testing across products and interfaces

TECHNICAL SKILLS

ERP Applications: Oracle Applications (11.0.3, 11.5.10), Oracle ASCP, Oracle Forecasting and Distribution, Order Management and Shipping Execution (OM), Purchasing (PO), Inventory Management (INV), Oracle CRM, Oracle iProcurement, Oracle iSupplier, Bill of Materials (BOM), Warehouse Management (WMS), GL, AR, AP, CM, FA. Oracle Application Order to Cash and Procure to Pay Cycle

Database Management Systems: Oracle Database 10g, 9i, 8i, 7.3Access

Operating System: UNIX, Linux and WindowsMicrosoft office Suite (MS Projects 2003, Power Point, Excel and MS-Word)Configuration

Quest Platforms & Tools used: Toad, Sql, Pl/Sql, Sql*Loader, VISIO, XML, Oracle Discoverer, Oracle Forms and Reports, Perl and Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential

Oracle SCM Functional Lead

Responsibilities:

• Collaborated with Stakeholders, Business andSubject matter experts to gain a full understanding of current Supply Chain, Financ and Procurement business process.
• Created MD50 functional documents for Commodity Manager, ASN, Aging Report, FTZ, Demand and Usage Report, PO Receipt Report.
• Conducted regular meetings with business to determine teh best sourcing strategies among various avaliable such as Min -Max Planning, ReorderPoint, Vendor Managed Inventory (VMI) and Consigned Vendor Managed Inventory (CVMI) and also worked on Sourcing rule scenarios, OSP BOM, Drop Ship Cycle, IR/ISO process
• Modified teh ASN report received from teh supplier to include 4 new columns such as Country of Origin, Bar Code Label, Freight Terms and Buyer. Demand and Usage report to include input parameters such as Demand Date, Usage Date, and Multiple Organization, Po receipt report to include CVMI column, iSupplier portal.
• Conducted meetings with business to make changes to teh iSupplierportal.
• Worked closely with business on testing Shipment file, Admissions, Physical inventory for teh Foreign Trade Zone project, different Sourcing rule scenarios, OSP and also providing different solutions as a Functional Lead.
• Helped teh team to do teh production cutover planning
• Involved is defect resolution process and solved teh defects within defined SLA.
• Develop teh Test Strategy and Test Plans, Test scenarios. Manage test exit criteria, reporting and signoffs for all testing cycles UAT testing and tan moving to production.

Environment: Oracle Apps EBS Order to Cash Cycle version 12.2.6, Procure to Pay, Order Management, Inventory, AR,AP,WIP, BOM, ASCP, Manufacturing

Confidential, Denver -CO

Oracle Functional Lead

Responsibilities:

• Interacted with teh Business users, and SMEs to get a better understanding of teh Arrow Business Processes
• Conducted CRP0 sessions for Inventory, Purchasing, Receivables, and Payables modules.
• Conducted CRP1 sessions which highlights teh customization in Back to Back order cycle, Drop ship cycle, Service Contracts, Sales Order header and line level zoom form, Quote Header and line level Zoom form
• Did teh delta setups and created BR100 documents for SCM and Finance modules
• Involved thoroughly in SIT (Smoke testing, Sanity check and Integration testing) for SCM and finance domain such as Drop Ship cycle, Back to Back, Quote to Order EBS, ATO cycle, B2B EDI. Created Order from MWS Quote and progressed it to closure, Service Contract to Order cycle, International order creation and integration to Trade sphere, Integration of sales order with WMS, Creating modifier through template and manually, Modifier application on sales order lines, RMA flow, Create & Update Price Lists
• Involved is defect resolution process and solved teh defects within defined SLA
• Develop teh Test Strategy and Test Plans, Test scenarios. Manage test exit criteria, reporting and signoffs for all testing cycles (SIT, UAT testing)
• Worked on EDI 850 which generates teh Purchase Order for EDI enabled supplier also it generates ASN 856 which send teh communication to teh receiving party of teh upcoming goods.
• Worked on AP invoice (810) EDI which is send to teh buyer to receive payments.
• Worked closely with teh implementation partner to create a detailed cut over plan

Environment: Oracle Apps EBS Quote to Cash Cycle version 12.2.6, Procure to Pay, Order Management, Inventory, WIP, BOM, ASCP, WMS, EDI

Confidential, San Clemente, CA

Oracle Implementation Lead

Responsibilities:

• Gatheird User requirements, Functional requirements interacted with teh Business users, Project Manager and SMEs to get a better understanding of teh ICU Business Processes.
• Worked as a lead in R12 implementation, integrations and complex solutions for rollouts in 4 countries (Canada, Latin America, Spain and US) wherein Confidential is acquiring Hospira Infusion Systems.
• Created Test Scripts, SRS documents, Validation Plan, Risk Assessment and FDA document.
• Determined GxP impacted scenarios and rated them as Medium, Low risk after conducting sessions with teh business and quality team.
• Worked on EDI 940 used to instruct remote warehouses to ship orders it has information such as Delivery id,Item description,quantities,Ship to information, bill to information.
• Teh EDI 945 Warehouse Shipping Advice document can be used by teh warehouse to report a reason for a change in teh shipping date, a reason products were cut from a shipment, and product substitution information.
• Teh EDI 856 transaction is more commonly called teh EDI Advance Ship Notice or EDI ASN. Shipment level information such as tracking numbers and carrier information
• Teh EDI 850 generally provides teh same information you would find in a paper Purchase Order (PO) document, including: Item, prices and quantities ordered.
• Worked on EDI 855 Purchase Order Acnoledgement is an EDI transaction set normally sent by a seller to a buyer in response to an EDI 850 Purchase Order. In addition to confirming teh receipt of a new order, teh document tells teh buyer if teh purchase order was accepted, required changes, or was rejected.
• Teh EDI 810 Invoice transaction set is teh electronic version of teh paper-based invoice document. It is typically sent in response to an EDI 850 Purchase Order as a request for payment once teh goods has shipped or services are provided.
• Tested all teh above EDI functionalities thoroughly by testing them in SIT and UAT and also coordination with teh 3PL’s such as Movianto,Shipbob, XPOlogistic, Nippon express in Spain, Canada, US, Latam America countries.
• Coordinated with teh 3PL’s by setting up meetings and testing teh functionalities and also fixed various issues.
• Reviewed teh BR100 for Order Management,Inventory and Purchasing by working closely with teh implementation partner and configured teh SIT and UAT environments.
• Executed all teh projects using Agile methodology.
• Tested various scenarios and also wrote detailed test scripts in limited time
• Worked on Screening DEA License, Customer Pharma License, Warehouse license, Denied Party list, Good and bad Supplier, Party name and Address in Global Trade Management system.
• Develop teh Test Strategy and Test Plans. Manage test exit criteria, reporting and signoffs for all testing cycles.
• Work on key processes and elements including planning and scheduling, inventory replenishment, purchase order processes, requisition/PO approval process, internal order/sales order process (IR/ISO). Well versed with teh Complete Supply Chain Planning Overview, Replenishment process, Consumables Imported process, created WIP discrete jobs for over labelling items.
• Supported business in SIT,UAT, Go-live and post production support and also resolved teh corresponding issues.

Environment: Oracle Apps EBS Order to Cash Cycle version 12.2.4, Procure to Pay, Order Management, EDI, Inventory, WIP, BOM, ASCP, Accounts Payables, Account Receivables, Demantra, GTM

Confidential, Atlanta -GA

Oracle Functional Consultant

Responsibilities:

• Played multiple roles in teh project including dat of a business analyst, process lead and release management to support global business solutions for client.
• Perform Application Support for ERP enabled Businesses within agreed SLAs. This involves investigating P1 and P2 tickets for floor planning and settlement areas.
• Monitored B2B processes on weekly basis.
• Responsible for fixing all teh AR Auto invoice errors and AP invoices which is rejected and on hold.
• Work closely with internal/external customers to resolve billing issues/disputes with excellent customer service.
• Troubleshooting and fixing teh issues in Order management application -Tax code, Customer credit check, Backordering, Return Material Authorization Issues Provide guidance and support teh users in their efforts to become proficient in teh use of teh applications.
• Worked on teh supporting Business-to-Business (B2B) processes and Customer, which are Electronic Data Interchange (EDI) enabled.
• Analysis of outstanding Accounts Receivable, weekly/ monthly trend reporting to leadership.

Environment: Oracle Apps EBSOrder Management, Accounts receivables, Accounts Payables, Purchasing modules version 12.1.3.

Confidential, Chicago, IL

Oracle Solution Architect

Responsibilities:

• Confidential technologies acquired Motorola in 2014 with an agreement stating we need to convert all teh components from Motorola environment (Trilogy) to Confidential environment (Merlin).
• Conducted meeting with stakeholder, Client Architect to understand teh AS-IS process and recommended teh TO BE process
• Worked to setup teh Order Management, Inventory modules and document teh corresponding BR100.
• Created MD50s for Decommissioning project of Motorola.
• Recommended APIs to cancel Purchase orders, Sales orders, and requisitions.
• Worked on Agile methodology.
• Recommended manual methods to delete teh sourcing rules attached to teh sourcing assignment and Internal Requisition.
• Coordinating with offshore development team in API development-Unit test
• Created test scenarios, test plan and test cases.

Environment: Oracle Apps EBSOrder Management, Purchasing and Account Payables modules version 12.1.3.

Confidential, Charlotte NC

Oracle Supply Chain Consultant

Responsibilities:

• Review business process and determine teh requirement. Examine those requirements and determine teh Oracle prerequisites.
• Map requirement to Oracle Application and determine teh gaps.
• Prepare AS IS and TO BE process documents.
• Perform all teh Organization setups for Inventory, Order management and Purchasing Modules and documented teh corresponding BR100.
• Worked on creating teh data load in all teh instance including production for Item Category, On hand inventory and BPA for Tyler, Vidalia, Trenton and Forth Smith.
• Developed an inbound interface (loading data into staging table) and outbound interface (Truck load details are sent to third party system which stores teh inventory for IR) using XML data along with Mapping of fields between Oracle and NASS (third party system).
• Worked on different EDI functionalities, which involved 3PL and Solved EDI regarding issues.
• Documentation - Preparation of MD50, testing and filling up teh unit test plan for teh above interfaces.
• Worked on resolving huge volume of AP invoices which are rejected and on hold invoices in Accounts payables.
• Conducted CRP /SIT/UAT sessions with business users.

Environment: Oracle Apps EBSInventory, Purchasing, Fixed Asset, iProcurement and Account Payables modules version 12.1.3. Data Base 11G, Serena Dimensions Version Control (PVCS), Kintana Migration Tool (PPM).

Confidential, Houston, TX

Oracle Implementation Lead

Responsibilities:

• Implement new COA structure as decided by Confidential for their operations in Singapore, Taiwan, China and Malaysia. SCM (Purchasing, Inventory), finance (Account Payables, General Ledger), I-Procurement, Cash Management will be used.
• Providing estimation for teh different phases of SDLC cycle.
• Capturing functional/technical details of Oracle Applications R12.1.1 ERP (Enterprise Resource Planning) and documenting teh same.
• Conversion of Master and Transaction data using Open Interfaces/ API. (Master Item conversions, Item category, Item On hand and AP Invoices).
• Worked on EDI Mapping and functionalities such as 850,855,810.
• Identifying existing Customized Oracle Reports Components of Inventory (Material balance, Report Stock in stock out, Summary of material balance, Inventory transfer, Goods issued) and Account Payables and accordingly did teh changes based on COA Impact (Chart of Account) in those Reports.
• Provide end-to-end customer support which includes issue identification, implementing teh fix in test instance, unit testing, following up with users for UAT approvals.

Environment: Oracle Apps EBSGL, AP, Purchasing, IProcurement and Cash management modules version 12.1.3. Data Base 10G.

Confidential, Atlanta, Georgia

Oracle EBS Techno Functional Consultant

Responsibilities:

• Documented functional testing (Rifle shot testing) and tested it for all teh modules (AP and AR) in each instance ( CORP, UK, CMS).
• Documented teh high-level architecture diagram, which shows teh integration of all teh modules in CMS.
• Recognized all teh application forms and reports, which were impacted due to extended patches in CMS, UK and CORP instance.
• Document requirements and actively participate in design, configuration and testing of Oracle implementation and its integration with other projects while providing support to teh existing Release 11i implementation and in teh near future - Upgrade to R12.
• Tested all teh application forms, reports, AP Invoice Interface,PO interface interface,Customer Extract interface in AR module after teh extended patches were applied in all teh instance.
• Testing evidences were captured and saved, example: Output and Log file for each program was saved in all teh iterations.
• Teh performance benchmark provided by teh client was matched to teh performance of teh program run in teh upgraded instance and it was almost teh same.
• Traceability matrix was maintained which acts as single source of truth for all teh components.
• Issue tracker was maintained to capture teh issues encountered during teh testing and resolution was recorded against it.

Environment: Oracle Apps EBSAR, AP, POin 11i (11.5.10.2) version, Oracle 9i, Oracle 11g, Oracle Report Builder (6i), Version Control (PVCS)

Confidential, San Jose

IT Analyst

Responsibilities:

• Involved in pilot study of project, provided teh detail input for performance tuning /Load testing and created Deep Dive Reports.
• Interacted with teh application team to understand teh whole functionality and gather teh required details such as scope of teh project, data load user load, databases impacted, upstream and downstream dependencies.
• Completely responsible in determining if teh project was assigned for Performance Tuning or Load testing.
• Created an ATO (Assemble to Order) sample Order dat gets successfully created, booked, pick released, Ship Confirmed and invoiced.
• Assisted teh development team to generate load of 5000 order lines after creating a sample order for both QTC/BV instance to see teh performance of Replicate Cycle update program (running in SJ) as well as Cycle update program (running in QTC/BV).
• Involved in a lot of stress testing to find out teh performance of teh Order Management as to whether it could handle load of 5000 orders within teh SLA.
• Well versed with teh complete Cisco Order to Cash Process.
• Enhancements to teh EDI 820 process, which transfers teh formatted output, file to teh bank.
• Worked on Performance Tuning of SQL queries using EXPLAIN PLAN utility.

Environment: Oracle Apps EBS OM, AP, O2Cin 11i (11.5.10.2) version, Data Base 9i.

Confidential, Arizona

Oracle Techno Functional Consultant

Responsibilities:

• Involved in all phases of SDLC (Planning, Design, Development, Testing, Production, Release, Support and Upgrade) for a couple of interfaces between SE system and Oracle system.
• Prepared System Required Documents (SRD) based on Business required Documents (BRD).
• Interacted with Business users as well as Functional Lead to understand teh AS-IS process and suggested on teh TO-BE process (Gap Analysis).
• Documented teh high-level business flow for integration between SE, Oracle and Biztalk.
• Sat with teh business in deciding teh sequence of interfaces like Auto invoice, Credit Memo, Receipt’s, 1099S, GL interface.
• Performed various Data mapping exercise between SE columns and Oracle columns worked as a system analyst to identity teh columns in SE (source system), mapped them to teh Oracle columns for teh Auto invoice standard program, and documented in Microsoft Visio.
• Created PL/SQL packages to load teh Invoices created in Service Engine (a Legacy System) to Oracle Accounts Receivables using teh Auto Invoice Import Program.
• Coordinated with teh QA team in preparing test scripts, test scenarios and conducted User Acceptance Testing (UAT) to confirm adherence to teh formulated Business Requirements.

Environment: Oracle Apps EBS Accounts Receivables, Purchasing, General Ledger in 11i (11.5.10.2) version, Data Base 9i, SQL Server 2005, Biz Talk, Service Engine, PVCS, Mercury Quality Center 9.0.