SUMMARY:

• Over 10 Years of experience in Oracle applications as an Oracle Techno Functional Consultant, Business System Analyst, Sr. Developer and Developer.
• SCM expertise in Oracle Applications(Apps) with Implementation, Upgradation, Testing and Post Production Support of Order Management (ONT), Inventory (INV), Purchasing (PO), Account Receivables (AR).
• Experience in using Application Implementation Methodology (AIM), business requirement gathering, understanding As - Is Process, Solution Designing, performing gap analysis, building RICE (Report, Interface, Conversion, Extension), Configuration & Setup of modules to CRP testing, end-user Training, UAT, Issue documentation, Production support.
• Expertise in Order To Cash, Procure To Pay Cycle, Configure to Order and Assemble to Order.
• Exposure in iStore, Bills of Material and Work in Process Modules.
• Experience in Quality Center, Remedy, Jira, Kintana and Clearcase.
• Experience in Oracle SQL Developer, SQL*Loader, Toad, Pl/Sql Developer.
• Worked on Oracle database versions 8i, 9i, 10g, and 11g.

PROFESSIONAL EXPERIENCE:

Business System Analyst

Confidential

Responsibilities:

• Research and analyze the new requirements in order to change the existing process. Design refresh orders created via RNT ( Confidential ) will be handled with the existing process.
• Getting the approval for low level design and proceed towards leading the team in construction and development phase.

Business System Analyst

Confidential

Responsibilities:

• Designed new custom form and loaded all Open Receipts / Credit memos and failed receipts for Credit card and Partners
• Once finance users took action on custom form, program will process the data and do the refund to consumer / write-off receipt and adjust the Credit memo accordingly.
• Configured system for SIT and UAT.

Business System Analyst

Confidential

Responsibilities:

• Research and Analyze the Country Specific business requirements to derive the full Order to Cash Cycle Flow.
• Implemented Cancellations interface for direct-to-consumer (D2C) between Confidential and Alipay payment system.
• Enhanced existing PO Interface and Finance interface to handle for Brazil ecommerce.
• Getting the approval for low level design and proceed towards leading the team in construction and development phase.

Business System Analyst

Confidential

Responsibilities:

• Responsible for developing a brand new capability to create a B2B stores through Oracle iSTORE module for Confidential . Store supports multiple currencies, customer & volume based discount, defaulting rules based on customers, and Credit limit based order volume control and support for multi language.
• Integrated Advance pricing module with iStore to use pricing formula based price.

Business System Analyst

Confidential

Responsibilities:

• Research and Analyze the Country Specific business requirements to derive the full Order to Cash Cycle Flow.
• Implementation on AR Invoice report for all the above mentioned EU countries in Multi Language.
• Implemented Invoice printing interface for direct-to-consumer (D2C) for Mexico using pl/sql package.
• Once Invoice generated, program will do Header level attachment and extract the invoice and send it to Wfactura (Third party system for printing invoice for Mexico government).
• B2B contact person will place order in iStore Module for getting Xcodes from Confidential, once order loaded into OM, will be placed on Hold. Hold will be released, once received the release signal from PDB.
• Configured system for CRP1, SIT and UAT.

Senior Developer

Confidential

Responsibilities:

• Configured Setups related to Order Management (Transaction Types, Shipping Parameter, Pick Release Rule, and Credit Check Rule).
• Implementation of Order Import custom program for across countries.
• Extensively worked on Back to Back Order process (Oracle R12) interface to external vendor application through Webmethods.
• Extensively worked on Order to Cash and Procure to Pay Cycle.
• Executed all the configurations to set up CRP, SIT and UAT in OM and PO Modules.
• Frequent interaction with Confidential for Identification of patches and rising SR for smooth functioning of modules.
• Implemented Shipment extract interface between Confidential and Verizon on daily basis after shipment in R12.
• Implemented Billing Reconciliation process between Confidential and Verizon on daily basis.

Senior Developer

Confidential

Responsibilities:

• Developed BOM and Item Category conversion program to convert the BOM and Item categories from legacy system.
• Legacy data is being loaded into staging table, after validation data it is inserted into interface table from interface table standard program load into base table.
• Involved in Production Deployment and Post Implementation Support.

Senior Developer

Confidential

Responsibilities:

• Involved in Requirement gathering, preparation of Functional and technical design documentation.
• Developed program for fetching item and BOM details and to generate flat file in 11.0.3.
• Developed program to fetch Open Sales Order / RMA and to generate flat file.
• Developed program to validate item exits in staging table of Oracle R12, validated records are inserted into interface table. Item Import standard program used to load the data from interface to base tables.
• Worked on Unit testing, SIT and UAT Testing.

Developer

Confidential

Responsibilities:

• Confidential is the official equipments provider to US police department especially for Confidential .
• The objective is to Replacement of Excel Warehouse Management processes and system with the Confidential G&PS Oracle R12 WMS processes and functionality.
• Developed a program for fetching the transaction details of various status of sales order in WMS Oracle R12.This program is also used to fetch the transaction details for Sub inventory transactions and Account alias receipt.
• Involved in SIT, Regression testing, Implementation and post Implementation Support.

Developer

Responsibilities:

• Confidential was dealing the Network equipment parts worldwide. Networks Oracle Application 11.03 instance is a Confidential which cover major three poles.
• The objective is to modify the existing buy/sell functionality in Oracle 11.0.3 to allow for a 2-way buy/sell transaction such that all export sales from MCEL are made through the M INC set-of-books.
• Enhanced the existing program to update PO/SO. Modified the existing program for ROHS alert.
• Involved in Unit testing, System Integration testing for various organizations.
• Involved in Implementation and post Implementation Support.

Production Support Lead

Responsibilities:

• have worked on production support of various Confidential applications like PSR, FCR, and GEMS Drop ship.
• Have worked on interfaces management, change management and problem management.
• Preparation of Root cause analysis (RCA) document for critical issues. Monitoring the batch job scheduled in UNIX environment.
• Worked with business to develop updated business policies based on issues resolved.

Mobile Tester

Responsibilities:

• This project includes testing various mobile handsets for Confidential.
• Worked as a handset (mobile) tester in a testing team, responsible for test case analysis, mobile testing using various test cases.
• Done manual testing for various vendors like Nokia, Samsung, Confidential and LG, learned how to use tool called “TEST QUEST”.