Oracle Management

PROFESSIONAL SUMMARY

. AROUND ** YEARS OF ORACLE ERP EXPERIENCE IN IT INCLUDING

CUSTOMIZATIONS, TESTING, SUPPORT AND IMPLEMENTATION OF ORACLE

APPLICATIONS.

. Functional experience in configuration, setup, unit and integration

testing of Oracle Order Management, Shipping, Purchasing, Inventory,

Bills of Material, Work In Process, Warehouse Management and designed

solutions for meeting gaps in client requirement and application.

. Good knowledge on MSCA, WMS Application integrated to Order Management

Application.

. Experience in planning, testing for upgrades, preparation of test

plans, test scripts, test cases, training the end users in testing,

identification of super users for testing

. Excellent command over functional aspects including implementation and

customizations.

. Good knowledge in requirements study, design and development of oracle

applications.

. Configuring the application based on solution design, performed gap

analysis and designed workaround solutions. Excellent knowledge on

Functional Analysis, Implementation and Legacy conversions.

. Excellent business and interpersonal skills, Aggressive Team Player

with positive attitude, and Goal Oriented.

TECHNICAL EXPERIENCE

ERP: ORACLE APPLICATIONS R12, ORACLE EBS 11I (11.5.9, 11.5.10) -

MANUFACTURING AND DISTRIBUTION MODULES.

Process Flows: Order to Cash(O2C) Cycle, Procure To Pay(P2P) Cycle

Modules: Order Management, Shipping, Inventory, Purchasing, Bill of

Material, Work In Process, Warehouse Management System, MSCA.

Databases: Oracle 9i, PL/SQL

Operating System: Windows XP and Windows 7

CERTIFICATIONS

Oracle certified in Oracle Inventory module.

PROFESSIONAL EXPERIENCE

JAN 2013 - PRESENT

Sr. Oracle Business Systems Analyst, Xerox Corporation, Webster, NY

Project Name: Order Fulfillment Delivery

Xerox Corporation is a global company engaged in developing, manufacturing,

marketing, servicing and financing a complete range of document equipment,

software, solutions and services. The Company's products include printing

and publishing systems, digital multi-function devices and digital copiers,

laser and solid ink printers, fax machines, document-management software

and supplies.

Responsibilities:

. Identifying the functional specs, preparing the documentation setups

and maintaining Business Requirement Documents, Setup Documents

(BR100) and System Requirement documents(SRD).

. Define order transaction type setups for all types of order process

flows and map it with legacy system transaction types.

. Define the order reservation process rules and setup custom

substitution rules.

. Define the ATO confirguration item BOMs and import orders against new

configurations.

. Setup new production lines and printers for all reports in Oracle WMS.

. Creating Inter-org transfer setups for different different

CLCs(Carrier Logistic Center) in Inventory Oracle.

. Providing the suggestions/options of the best way to implement their

need in Oracle Applications with the SOX approval.

. Extensively worked on preparing test scenarios, test scripts on

different applications to help the users for better understanding the

application

. Work with Business team to carry out Functional testing, integration

testing and volume testing.

. Work with Business team in User Acceptance testing with end users in

the warehouse.

. Prepare user training documents and conduct user training sessions on

the new changes implemented in Oracle instance.

. Facilitate the onsite-offshore co-ordination during design and all the

phases of project schedule.

Environment: Oracle Apps R12 in Inventory, Purchasing, Order Management,

Shipping, WMS, MSCA, Bill of Materials and Work in Progress, Oracle 9i

Jan 2012 to Jan 2013

Oracle Business Analyst, Xerox Corporation, Webster, NY

Project Name: Vendor Managed Inventory

Responsibilities:

. Understanding the client's business process and mapping into Oracle

Applications accordingly

. Identifying the functional specifications, preparing the documentation

setups and maintaining Business Requirement Documents (BRD100) and SRD

documents.

. Define Sub inventories and locators to handle Vendor Managed Inventory

from NIPPON supplier.

. Define Blanket Purchase Agreement and Approved Supplier List setups

for all VMI items.

. Identify a custom process to import the Inventory using Secure

FTP(SFTP) process into Oracle.

. Work with NIPPON system to setup the SFTP process and provide the

access to external system to drop the Inventory files into Oracle

server drop box.

. Prepare test plans and carry out Functional testing and integration

testing with NIPPON system.

. Import Inventory files into Oracle VMI sub inventories and test the

item import to check whether the inventory got loaded with owning

party.

. Work with Business team to complete User Acceptance Testing with end

users.

. Prepare user training documents and conduct user training sessions on

the VMI changes.

Environment: Oracle Apps 11i(11.5.10) in Inventory, Purchasing, Order

Management, Oracle 9i

Oct 2009 to Dec 11

Oracle Business Analyst, Xerox Corporation, Webster, NY

Project Name: Spares Order Fulfillment

Responsibilities:

. Mainly responsible for mapping the client's business process in the

modules of Oracle Inventory and Order Management.

. Responsible for the setups for purchasing (PO), Order Management (OM),

Bill of Materials (BOM) with the SOX approval.

. Setting up shipping networks to enable Inter Organization Transfers.

. Prepare System Requirement Documents (SRD) for the new requirements.

. Preparing Test Cases for the new functional requirements.

. Mapped complex outbound logistics requirement on Order Management.

. Drop ship Functionality was setup to enable the OM team to ship the

goods directly to Customers from Supplier warehouse.

. Worked with Web methods EDI team to complete ASN receiving testing for

Dropship orders.

. Responding to functional assistance tickets from the business users,

problem analysis and resolution in Post implementation support.

. Production Support Analyzing and resolving implementation issues.

Environment: Oracle Apps 11i(11.5.10) in Inventory, Purchasing, Order

Management, Shipping, WMS, MSCA,BOM and WIP.

Jun 07 to Oct 09

Oracle Functional Analyst, Xerox Corporation, Hyderabad, AP, INDIA

Responsibilities:

. To resolve functional issues related to Order fulfillment application.

. Coordinate with end users and Business Team members for quick

resolution of the issues.

. Test fix scripts provided by Development team in test instances and

approve them for migrating to production.

. Organizing a conference call with Business teams once a week and

discuss all the critical issues and perform root cause analysis.

. Resolve pending transactions at each month end to enable smooth

month/quarter and year end closings.

. User Support in troubleshooting both application and business process

issues

. Proactive monitoring of critical jobs on daily basis and fix the

problems if found any.

. Maintain a stable and accurate Oracle Applications production instance

that meets the Users needs

. Testing the application on major releases and changes.

. Accommodate all the scheduled outages planned for application

maintenance and upgrades.

. Prepare and Maintain application documents as and when required.

Environment: Oracle Apps 11i(11.5.10) in Inventory, Purchasing, Order

Management, Shipping, WMS, MSCA, Bill of Materials and Work in Progress,

Oracle 9i

July 05 - May 07

Sr. Production Support Functional Analyst, Merial Pharmaceuticals, Hyd,

India

Responsibilities:

. Support End users in solving their regular day-to-day problems in the

Oracle Applications 11i OM, INV and Purchasing.

. Handle Production Support Group issues related to Oracle Inventory,

Oracle Purchasing and Oracle Order Management Modules.

. Responsible for support and monitoring activities.

. Provide training to end users so that the process issues can be

resolved at end user end.

. Prepare training documentation and application maintenance documents.

. Perform root cause analysis and provide a permanent solution for

reoccurring issues.

. Involved in implementation setups for items in item master

organization.

Environment: Oracle Apps 11i(11.5.9) in Inventory, Purchasing, Order

Management, Shipping.

Aug 04 to Jun 05

Role: Production Support Analyst, Aurobindo Pharma, Hyd, India

Responsibilities:

. Offshore support for Oracle Order Management, Inventory and

Purchasing Modules.

. Resolving the issues logged in by the end users encountered in day to

day

. Interact with end users to bring out solutions for the better

performance of the application.

. Resolve all the issues raised in Purchasing receipts and provide a

solution.

. Worked on issues related to pick release, pick confirm and deliveries.

. Material Procurement through using Inventory planning.

. Prepare user training and application maintenance documents.

Environment: Oracle Apps 11i in Inventory, Purchasing, Order Management,

Shipping

EDUCATION

BACHELORS IN TECHNOLOGY

JNTU University, Hyderabad, India

CONTACT

EMAIL ID: ************@*****.***

Contact this candidate