Oracle Management

SUMMARY

. About * years experience in Oracle Applications for manufacturing

implementation for few of the leading manufacturing companies.

. Experience in all the phases of System Development Life Cycle

(SDLC) - Analysis, Design, Development, Testing and documentation

of software applications.

. Experience in implementing and supporting Oracle applications,

which includes experience in ERP project life cycles like

customizations, and post implementation support.

. Worked extensively on PL/SQL, Reports6i, BI Publisher, UNIX Shell

Scripts, JAVA, HTML, Logical Apps, Forms 6i, Workflows, Forms

Personalization, and Oracle Alerts.

. Worked on various modules as: Order Management, Inventory, Bills of

Material, Oracle Configurator, Work in Process, Oracle Incentive

Compensation (OIC), Fixed Assets, Advanced Pricing, Service

Contracts, General Ledger, Accounts Receivables, Project

Accounting, HRMS etc.

. Experience in Operating Units Analysis and Functional aspects as in

designing, assigning organizations to OUs etc.

. Ability to work under pressure with the ability to meet deadlines

. Excellent analytical, communication, interpersonal and decision

making skills and is well motivated to rapidly acquire new skills

on the job

. A quick learner with an easy adaptability to new environments,

technology and people

. Ability to conceptualize and analyze a problem with ease

Education:

. Bachelor of Technology in Electronics and Computer Engineering (B.Tech-

ECM) from Sreenidhi Institute of Science and Technology affiliated to

Jawaharlal Nehru Technological University, Hyderabad

awards:

. Winner of SPOT Award for Oracle practice while working as an employee of

Infosys Technologies India Ltd

TECHNICAL EXPERTISE

Languages: PL/SQL, HTML, UNIX, JAVA, J2EE, XML, C, C++

RDBMS: Oracle 9i

Skills: Reports 6i, Reports 10g, BI Publisher, UNIX Shell Scripts, Logical

Apps, Forms 6i, Workflows, Oracle Alerts, and Forms Personalization

Front End / GUI: Oracle Applications (11.5.8, 11.5.9, 11.5.10 and R12)

Operating Systems: Windows, UNIX

Area of strength: Oracle Applications in Manufacturing, Financials, HRMS

and Service Contracts Module.

Modules In Detail: Order Management, Inventory, Bills of Material, Work in

Process, Fixed Assets, Oracle Configurator, Advanced Pricing, Service

Contracts, General Ledger, Oracle Incentive Compensation (OIC), Accounts

Receivables, Project Accounting, HRMS.

PROFESSIONAL EXPERIENCE

1. Client : Jostens, Minneapolis, Minnesota

Sep' 09 - Till now

Designation - Oracle Applications Consultant

Responsibilities:

. Responsible for understanding the requirements and providing the best

of solutions specifically in Order Management related modules, Oracle

Pricing, Bills of Material, Shipping, WIP etc.

. Worked on various enhancements that involved customizing

existing/developing new Forms, and development of packages,

procedures, triggers, Shell Scripts etc.

. Responsible for various Production support issues that involved quick

fixes.

. Worked on various technologies like Forms, PL/SQL, and UNIX etc.

. Currently involved in a big development project as a developer

2. Client : Datacard Group, Minnetonka, Minnesota

Oct' 07- Jan' 09

Designation - Programmer/Analyst

Responsibilities:

. Responsible for understanding the requirements from various users and

providing them with the best of solutions specifically in Order

Management related modules, Oracle Pricing, Service Contract modules

and Financials.

. Worked on various enhancements that involved customizing workflows,

Oracle Reports, Forms and customizations using Forms Personalization

and development of packages, procedures and reports using BI Publisher

(or XML Publisher).

. Responsible for various Production support issues that involved quick

fixes.

. Development also involved printing AR Invoices and AR Statements using

BI Publisher and printing Sales Order Acknowledgment reports and

Proforma Invoice Reports using Optio Technology, Bills of Material

module, and Service Contracts module, Fixed Assets, HRMS and

Inventory.

. Worked on various technologies like BI Publisher, Oracle Reports and

Forms, Forms Personalization, PL/SQL, Optio, Java, JSP etc.

Environment: Oracle Applications 11i

3. Client: Fisher Valves, U.S.A Apr'06 -

Apr'07

Infosys Technologies Ltd - Oracle Apps Developer

Fisher Valves, a part of Emerson Process Management is a leading U.S

manufacturer for flow meters, sensors etc. which implemented its

Manufacturing in Oracle Applications is located at Marshall Town, Toluca in

U.S.A

Responsibilities:

. Understanding system requirements and various users in the system and

performing as a team lead for a project of eight developers in the

implementation of all the RICE (Reports Interfaces Conversions and

Extensions) components for the Oracle Manufacturing module.

. Extensively performed data migration activities for BOM (Bills of

Material), HRMS, Customers, Item Attachments, Item Categories, Items,

Onhand and Routings.

. Built a real-time interface between Oracle and SMS (Shipping

Manifestation System), a third party tool for managing shipping

activities for Fisher Valves.

. Extensively worked on various Inbound and Outbound Interfaces,

Development of Forms and Reports, Customizations of Workflows, and

Forms Personalization.

. Implemented Oracle Incentive Compensation (OIC) module to calculate

and pay commissions to sales persons whose data is provided by OM

(Order Management).

. Functional experience in Operating units' design, assignment of

organizations, splitting of OUs etc.

Environment: Oracle Applications 11i, Oracle 9i

4. Client: Dietrich Standard Incorporation (DSI), U.S.A Jan'06

- Mar'07

Infosys Technologies Ltd - Oracle Apps Developer

DSI, a part of Emerson Process Management is a leading U.S manufacturer for

flow meters, sensors etc. which implemented its various modules like

Manufacturing, HRMS and Financials in Oracle Applications.

Responsibilities:

. Worked on the development of all the RICE components that includes

Reports, Interfaces, Conversions (Data Migrations) for various

components that include Sales Orders, Collection Plans, Sourcing Rules

and Assignments, Approved Supplier lists, Item Transaction Defaults,

Items and Categories, Customers, Payroll etc.

. Worked on various Extensions that included Logical Apps, Oracle Alerts

etc.

Environment: Oracle Applications 11i, Oracle 9i

5. Client: Micro Motion Incorporation (MMI), U.S.A Mar'04 -

Mar'06

Infosys Technologies Ltd - Oracle Apps Developer

MMI, a part of Emerson Process Management is a leading U.S manufacturer for

flow meters, sensors etc. which implemented its various modules in Oracle

Applications.

Responsibilities:

. Worked for the development of functional companions and Interfaces

between the legacy system Symphony and Oracle for Order Management

Module.

. Worked with Informatica (ETL Tool) for data loading scheme.

. Worked for the development of Interfaces for Oracle Quality Module for

Collection Plans and also on Data Migration into Collection Plans

which involved UNIX shell scripts and PL/SQL

. Worked on the development of all the RICE components that includes

Reports, Interfaces, Conversions (Data Migrations) for various

components that include Sales Orders, Collection Plans, Sourcing Rules

and Assignments, Approved Supplier lists, Item Transaction Defaults,

Items and Categories, Customers, Employees etc.

. Worked on various Extensions that included Logical Apps, Oracle Alerts

etc.

Environment: Oracle Applications 11i, Oracle 9i

6. Client: Rosemount Corporation, U.S.A Apr'05 -

Jul'05

Infosys Technologies Ltd - Oracle Apps Developer

Rosemount Corporation, a part of Emerson Process Management is a leading

U.S manufacturer for flow meters, sensors etc. which implemented its

various modules in Oracle Applications.

Responsibilities:

. Worked as a Team Lead guiding a project of four developers, which

involved implementation of Oracle Configurator Developer that included

developing various Functional Companions, Java Scripts and Development

of JSP Pages.

Environment: Oracle Applications 10g, 11i, Oracle 9i

7. Client: Emerson Process Management, U.S.A Oct'03 -

Aug'04

Infosys Technologies Ltd - Oracle Apps Developer

Emerson Process Management is a leading U.S manufacturer for flow meters,

sensors etc. which implemented its various modules in Oracle Applications.

Responsibilities:

. Worked on almost all kind of Production Support issues that involved

minor or major change requests and modifications to the existing

complex as well as simple interfaces, shell scripts and reports.

. Production support mainly involved the modules, GL, FA, HR, OM,

Advanced Pricing, AR, PA, Inventory, Bills of Material, and WIP etc.

Environment: Oracle Applications 11i, Oracle 9i

References are available upon request.

Contact this candidate