Oracle apps Technical

Oracle Apps Technical Consultant

Jagan Mohan Reddy Email:**********.***@*****.***

Mobile: +91-727*******.

Professional Summary:

Having 3+ years of experience in design, development, Personalization, and implementation of

Oracle Applications 11i&R12.

Experience in developing Technical design document based on Functional requirements.

Familiar with modules like PO,INV, OM,AP,AR and GL

Having good exposure in Procure to Pay Cycle (p2p) and Order to cash Cycle (o2c).

Expertise on development of Interfaces, Conversions, Reports and UTL_FILE Packages.

Having good exposure on development of XML Publisher Reports.

Expertise in development of PL/SQL Stored Procedures, SQL*Loader

Expertise in Creation of Value Sets and Concurrent Programs.

Expertise on usage of oracle tools and other Utilities like TOAD, SQL*Plus, Winscp, UTL

Files and SQL * Loader.

Good Knowledge in OAF.

Strong knowledge on SQL and PL/SQL.

Good team player having good communication skills and flexible for learning new technologies.

Professional Experience:

Currently working with Mahindra Sathyam, Pune as Oracle Apps Technical consultant

from June 2011 to Till Date.

Worked with Bothtree, Hyderabad as Associate Consultant from June 2009 to May 2011.

Education:

B.Tech from JNT University, Anantapur in 2009.

Technical Skills:

ERP : Oracle Applications 11i and R12

Modules : PO, AP, GL, OM, INV, AR

Operating Platforms : Windows NT/ 2000/XP

DBMS/RDBMS : Oracle 9i & 10g

Languages : SQL, PL/SQL

Developer 2000 (Forms 6i & Reports 6i), Report

GUI : Builder 10g,

Xml Publishers

Tools & Utilities : TOAD, SQL*Loader, FND_LOAD

Project Details:

Project #1

Client : Kinetic Concepts INC, USA

Software : Oracle Applications R12, Oracle10g, Report Builder10g, TOAD.

Role : Team Member.

Organization : Mahindra Sathyam

Project type : Implementation& Support

Period : June 2011 to Till Date.

Description:

Kinetic Concepts Inc is a worldwide provider of advanced healing technologies that

makes a difference for patients, caregivers and providers. They employ nearly 7,000 people

dedicated to developing the best innovations and providing the best service and clinical support in

over 20 nations. In accounting prospective their business can be broadly classified into 2 divisions.

Direct Sales (OM) – The products being sold to the customers.

Rent out (Service) – The customers would be charged for utilizing the products over the period of

time and KCI would be the sole owner of rent out products provided to the customers.

Responsibilities:

• Given support for interfaces and data conversions, Reports and XML Reports.

• Working with testing team and conducting complete testing of the Issue and developing according to

the standards

• Document preparation like technical designs, unit test scripts and review documents.

• Responsible for internal review of code and Unit test.

• Created Control Files for SQL Loader to load data from Text Files.

• Followed the coding and development standards to debug the code rapidly.

• Prepared the Setup document, Detail technical specification before delivering the Component.

• Deliverables:

• Designed and Developed Standard Purchase Order XML Report.

• Developed Sales Order Detail Report.

Developed item-conversion to upload item details from legacy system into oracle Application

base table.

Project #2

Client : Cisco Systems, Inc.

Organization : Both tree

Project type : Oracle Applications Support

Role : Team Member.

Period : Aug 2010 to May 2011.

Description:

Cisco Systems routes packets and routs competitors with equal efficiency. Dominating the

market for IP-based networking equipment, the company provides routers and switches used to direct

data, voice, and video traffic. Other products include remote access servers, IP telephony equipment,

optical networking components, Internet conferencing systems, set-top boxes, and network service and

security systems. It sells its products primarily to large enterprises and telecommunications service

providers.

Responsibilities:

Involved in the customization of the Reports and Interfaces

• Supporting client in various ERP issues.

Involved in Enhancement of existing reports and developing new reports

Creating Technical specification documents for reports and Interfaces.

Creation of value sets for various modules of the application.

Involved in Code Development and customization of interfaces

Resolving various issues which got raised in different steps of the development.

Project #3

Client : Pixel Works, USA

Role : Team Member.

Organization : Both tree

Project type : Implementation& Support

Period : June 2009 to July 2010.

Description:

Pixel works is a semiconductor company that designs, develops and markets system-on-

chip semiconductors and software for the advanced display industry, including advanced

televisions, multimedia projectors and LCD panels. System-on-chip semiconductors provide

the "intelligence" for these new types of displays and devices by processing and optimizing

video and computer graphic signals to produce high-quality images.

Responsibilities:

• Creation of Value sets in various modules of the application.

• Defining Concurrent Programs and Executables.

Developing Technical design document based on Functional requirements.

• Worked on PL/SQL Procedures and Packages as part of Development.

• Developed reports and interfaces as per client requirements.

Contact this candidate