Sales Project

OBJECTIVE:

To work in a challenging environment. Where, I can effectively contribute

my skill as an

Oracle Application Techno-Functional professional.

EXPERIENCE:

Having 4+ year of experience in Oracle Applications E-Business Suite

Release 11i & R12 with Specialization in Supply Chain Management (SCM),

Distribution, Logistics & Manufacturing Modules.

> Oracle Applications Techno-Functional Consultant with experience in

modules viz

Inventory (INV),

Purchase Order (PO),

Order Management (OM),

Field Logistics (FL),

Bills Of Material (BOM),

Work In Process (WIP),

Application Object Library (AOL),

XML Publisher Administrator.

PROFESSIONAL SUMMARY:

> Extensively involved in Analysis, Testing and Maintenance.

> Has good working experience in Toad, SQL*Plus, SQL Loader

> Has good experience in XML Publisher, Discoverer Administrator and

Discoverer Desktop, Business Intelligence.

> Oracle Developer 6i.

> Having full cycle implementation experience in Oracle Apps.

> Expertise in Data Conversion from Legacy System into Oracle Apps.

> Involved in Development of New Reports and Customization of Reports.

> Excellent Functional & Technical experience in Oracle Applications 11i

& R12

> Excellent Programming knowledge in Pl-SQL viz Procedures, Functions,

Packages and Triggers.

> Registration of Concurrent Programs and Value Sets in Oracle Apps.

EDUCATIONAL QUALIFICATION:

> Master of Business Administrator (Logistics & SCM) from Madras

University Chennai, India.

> Bachelor of Engineering from Anna University Chennai, India.

CAREER EXPERIANCE:

> Working as an Oracle Apps System Analyst for BIESSE Manufacturing Co.

Pvt. Ltd. In Bangalore, India since August 2014.

> Worked as an Oracle Apps IT Analyst for NCR Corporation India Pvt.

Ltd. In Delhi/NCR, India from May 2013-August 2014.

> Worked as an Oracle Apps Techno Functional Consultant (3 rd party NCR)

for Shakti IT Services Pvt. Ltd. In Delhi/NCR, India from Dec 2012-

May2013.

> Worked as an Oracle Apps Techno Functional Consultant for TAD

Consultancy Pvt. Ltd. In Chennai, India from Jun 2011-Dec 2012

AREA EXPERTISE

Operating System Win XP/2000

Language SQL, PL/SQL

Tools Report Builder 6i, XML Publisher, SQL Loader

and Toad.

Database Oracle 9i / 10g

Application Oracle Applications 11i & R12

TECHNO FUNCTIONAL SKILLS

* Experience in Different Type of Bills such as Standard, Model and

Optional class Bills.

* Excellent knowledge in Order to Cash Cycle (O2C).

* Functional knowledge in Standard, Drop Shipment, RMA and Back to Back

Sales Order.

* Excellent knowledge in Procure to Pay Cycle (P2P).

* Excellent Understanding of flow between applications.

* Excellent Knowledge in Understanding Multi-Org Structure.

* Configured Outside Processing (OSP) setups

* Registered the Concurrent Programs for Interfaces and Reports.

* Experience in Inventory Controls configuration

* Experience in triggers, procedures, functions and packages in PL/SQL.

* Experience in defining Responsibility, Employee, Buyer.

* Knowledge in Costing Methods and Costing Accounts.

* Experience in Developing Discoverer reports.

PROJECT DETAILS

PROJECT 1

Period: August 2014-March 2015

Project: R12 Implementation & Support Project

Environment: Inventory (INV), Order Management (OM), Purchase

Order (PO).

Role: System Analyst

RESPONSIBILITIES

* Worked in Booking and Shipping Notifications for Order Management.

* Configured Descriptive Flex Field.

* Knowledge in creating Price List for order item.

* Configured Sourcing Rule in Purchase Order.

* Worked in Item Status Attributes and Item Attribute Control.

* Done Form Personalization based on user requirements.

* Worked in Pick Release Rule based on user requirement.

* Worked in item default transactions.

* Configured Shipping Network.

* Configured restrict Sub inventory.

* Knowledge in MOAC Setups.

* Configured Purchase, Receiving and Shipping Parameters.

* Knowledge in Defaulting Rules in Order Management.

INTERFACES

* Developed Item Interface from Legacy System in to Oracle Apps.

* Developed On-hand Quantity Interface from legacy system in to

Oracle Apps.

REPORTS

* Customized On hand Quantity Detailed Report using XML Publisher.

* Developed Move Order Status Report.

PROJECT 2

Period: May 2013- August 2014

Project: R12 Implementation & Support Project

Environment: Field Logistics (FL), Inventory (INV), Order Management

(OM), Purchase Order (PO).

Role: IT Analyst

RESPONSIBILITIES

* Handled Issues in Internal Sales Order.

* Accounting Period End Close issues resolution.

* Resolved issues related to Move Order Transaction.

* Worked in Inventory Translations.

* Configured New Responsibilities as per the Requirement.

* Configured Organization parameters for the new organizations.

* Configured new OM Transaction Type as per the user requirement.

* Created Price list based on customer requirement.

* Debugged Issues in Drop ship & Back to Back Sales Order.

* Experience in Multi organization (MOAC).

* Configured Document types & Line Type.

* Debugged issues in Customer Hold.

* Handled Issues on RMA Sales Order and RMA Receipt.

INTERFACES

* Customized Requisition interface based on customer requirements.

* Developed Sales Order Interface from legacy system in to Oracle

Apps.

REPORTS

* Customized Sub-inventory quantities report using XML Publisher.

* Developed Sales Order Status Report.

PROJECT 3

Period: December 2012-May 2013

Project: R12 Implementation & Support Project

Environment: Inventory (INV), Order Management (OM), Purchase

Order (PO),

Field Logistics (FL).

Role: Techno Functional Consultant

RESPONSIBILITIES

* Serial Tracking for Orders to Pick/Delivery.

* Replenishment Org and Subinventory information and update.

* Dock to Dock (Warehouse LOV selection to be stickly at user level)

* Serial Tracking for ship confirmation.

* To add NCR PL Supplier User Management Responsibility

* Create Internal Sales Order (IOR) for US and shipping same.

* Receive Drop ship PO with actual part using EDI.

* Non-serial Tracking for Expected Receipt of Internal Sales Order

(IOR).

* Requisition Line update with substitute part (stock amount and

order plan).

* Create InterOrg Transfer for US and shipping same.

* Run Location Master (Replenishment Location).

INTERFACES

* Developed Item Category Interface from Legacy System in to Oracle

Apps.

* HSR (NCR_PL_PICK_SHIP_CONFIRM)

REPORTS

* Customized Purchase Order Detailed Reports.

* Developed error status report for Interfaces.

PROJECT 4

Period: March 2012- December 2012

Project: R12 Implementation & Support Project

Environment: Inventory (INV), Order Management (OM), Purchase Order

(PO), System Administrator (SA), XML Publisher

Administrator

Role: Techno Functional Consultant

RESPONSIBILITIES

* Loaded Item Price lists for Advanced Pricing.

* Worked on Item Validation Organization (IVO).

* Defined Sub inventories.

* Defined request groups.

* Registered concurrent programs.

* Defined Request Sets.

* Created Template for Inventory item.

* End to end support for Order to Cash (O2C) Cycle.

* Worked on Lot/Serial/Locator Controlled items.

* Configured Position and Supervisor Hierarchies.

* Have very good knowledge on Responsibility and Employee creation.

* Resolved issues related to Item Status Attributes.

* Accounting Period End Close support.

INTERFACES

* Customized PO interface based on customer requirements.

* Price List Automation.

REPORTS

* Developed Price Per Quantity for OSP Items.

* Developed Reserved Item Detailed Report.

PROJECT 5

Period: June 2011-March 2012

Project: 11i Implementation & Support projects

Environment: Inventory (INV), Bills Of Material (BOM), Work In

Process (WIP),

Application Object Library (AOL)

Role: Techno Functional Consultant

RESPONSIBILITIES

* Involved in Inventory Accounting period Opening.

* Configured BOM parameters.

* Understanding the various types and functionality of Bills.

* Knowledge in Common Bill and Copy Bill.

* Worked in updating the components in Bill Structure using MASS

CHANGES.

* Good knowledge in Reference Designators.

* Configured WIP Parameters.

* Experience in WIP supply types and its functionality.

* Experience in WIP Discrete jobs.

* Created new request group and attached to Custom responsibility.

* Debugged issues related to Inventory transactions.

* Handled Issues in Sub Inventory Transfers.

* Configured Organization parameters for the new organizations.

* Handled Issues in Min Max Planning.

INTERFACES

* Developed Bill of Material Interface.

* Developed WIP Interface.

REPORTS

* Developed WIP Job status Report.

* Developed BOM Substitute Item Report.

Contact this candidate