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, 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:

• Instead of ATO models, Sales models will be received from Confidential .
• Research and analyze the new requirements in order to change the existing process.
• Design refresh orders created via 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 Confidential .
• B2B contact person will place order in iStore Module for getting Confidential 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 Oracle Corporation for Identification of patches and rising SR for smooth functioning of modules.
• Implemented Shipment extract interface between Confidential and Confidential on daily basis after shipment in R12.
• Implemented Billing Reconciliation process between Confidential and Confidential 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.