Oracle Project

Basha

Mail ID: *****.******@*****.***

Mobile: +917*********

Professional Summary

> Having 3+ years of experience in IT industry, as Oracle Applications

Technical Consultant

> Involved in Implementation & Supporting of Oracle Applications 11i/R12

projects, with hands-on experience on various Components.

> Worked in various Oracle Application Modules AP,PO, INV, and OM, among

others.

> Worked extensively on Business cycles like P2P and O2C.

> Expertise in RICE objects.

> Expertise in Application Object Library (AOL) Value sets, Descriptive

flex fields, Creating Executables, Registering Concurrent Programs,

menus, functions.

> Experience with Oracle Applications Suite and Other Utilities: TOAD,

SQL*Plus, SQL*Loader.

> Extensive Programming experience in Oracle 10g, SQL, PL/SQL

> Strong experience in developing and customizing Reports

using Oracle Reports.

> Having Experience in developing Form Customization and

Personalization.

> Extensively worked on AIM documents like MD070, MD120, and TE020.

> Experience on XML Publisher Reports.

> Having Knowledge on Oracle Application Framework (OAF).

> Excellent Team Player with effective communication skills, problem

solving, analytical and leadership skills, willingness to learn and

master a new technology quickly.

EDUCATION

B.E from Anna University Chennai with an Aggregate of 71.00%.

INDUSTRY EXPERIENCE

> Working as Associate Technical Consultant in Sonata Software, Hyderabad

from March 2013 to till date.

> Worked as Oracle Apps Technical Consultant in Reliant Global, Bangalore

since April 2011 to Feb 2013.

TECHNICAL SKILLS

> Database : Oracle 10g

> Tools : SQL * Loader, TOAD, Oracle Developer suite

9i/10g,

MS office2003/2010, SQL*Plus, XML Publisher

Reports.

> ERP TOOLS : Oracle EBS R12(12.1.3), SCM

modules (OM, INV,PO)

> LANGUAGES : SQL, PL/SQL

PROJECT #1

Project Name APRICORN Implementation Project

Client Apricorn, USA.

Duration Mar 2013 - Till Date

Technologies ERP : Oracle Applications R12 SCM

(INV, PO, OM,)

Languages : SQL, PL/SQL

Database : Oracle 10g

Tools : TOAD, XML/XML Publisher,

Developer suit 10g

Role : Team Member

Environment : Oracle Applications, SQL,

PL/SQL, Reports, SQL*Loader

PROJECT DETAILS

Apricorn, Inc. is a leader in the design and

manufacture of notebook storage products, utilities and accessories.

Founded in 1983, Apricorn began as a supplier of Apple interface products

and has since Expanded its product line to include third-part memory

modules, as well as a family of portable computing Peripheral solutions.

ROLES AND RESPONSIBILITES:

> Involved in Procure to pay (P2P) cycle.

> Involved in the development of Interfaces/ Conversions to import the

data from legacy system into oracle application base tables.

> Developed PL/SQL Packages, Procedures, and Functions.

> Involved in development of reports based on business requirements and

registered them in Oracle applications.

> Creation of Value sets in various Modules of the application.

> Defining Concurrent Programs and Attaching Concurrent Program to

Request Group.

Components:

> Involved on designing and developing technical documentations for

interfaces, Reports.

> Customized Returns By Region Report.

> Customized Printed Requisition Report.

> Customized standard orders by item detail report.

> Personalize the Forms as per client Requirement.

> Development of XML Reports.

> Worked on Item Interface in INV Module to upload Data from Legacy

System to Oracle Apps Base tables.

> Worked on Conversion.

PROJECT #2

Project Name Support & Enhancement

Client Astra IDL Ltd.

Duration Jan 2011- Feb 2013

Technologies ERP : Oracle Applications R12 (12.1.3)

Languages : SQL, PL/SQL

Database : Oracle 10g

Tools : R12, REPORTS 6i, XML Publisher

Role : Team Member as Developing Reports.

Module OM, PO, AP, AR, INV

Environment UNIX/LINUX

Oracle EBS, Toad, SQL * Plus

Project Description

Astra-IDL Limited is a joint venture between Astra AB, Sweden and IDL

Chemicals, India. Astra IDL commands a high market share in pharmaceutical

industry in India. Astra's operations are spanning at 16 locations in the

country. The ERP Implementation at Astra-IDL was taken up as an integral

part of total enterprise solutions being provided by Satyam, encompassing

finance and accounts, purchasing, inventory, production, sales and

distribution functions.

Responsibilities:

> Developed interfaces integrating with Oracle Modules IM, OM, PO, AP, AR.

> Designed and developed reports using combination of Report 6i and XML

publisher for modules like Purchasing and Order management.

> Writing Programs using SQL *loader to convert the data from legacy system

to Oracle Application base tables.

> Involved in customization of XML Reports and update the technical

documents accordingly.

> Used PL/SQL extensively in writing Procedures, functions, packages to

maintain referential integrity and to do complex updates and validations.

> Developed PL/SQL Packages, Procedures, and Functions.

Components:

> Worked on AP Interface in AP Module to upload Data from Legacy System

to Oracle Apps Base tables.

> Worked on GL Interface in GL Module to upload Data from Legacy System

to Oracle Apps Base tables

> Customized Customer Credit Balance Revaluation Report.

> Customized Invoice Aging Report.

> Custom The Check Status Report.

> Customized The Invoice Report Which Is Incomplete.

> Enabling DFF Features in Forms.

> Development of various reports in different modules using XML

Publisher and reports10g.

> Developed Out bound Interface to extract all Item Details into Legacy

system.

1. Project Details:

Client Visits Marketing Pvt. Ltd

Role Developer

Duration 5 Months

Team Size 4

Environment Software Database :Oracle 10G

Oracle, D2K Tools: Forms 9i/Reports9i

Description:

Purchased order system gives detailed information to purchase department in

the company. It maintains information about the products purchased by the

company, indents placed by the company, material suppliers, different taxes

fall under this products. It detail reports on purchase order entry,

suppliers master report, detail purchase order report. It interacts with

other module inventory control system.

Responsibilities:

. Developing Forms and Reports by using Forms9i and Reports9i

. Developing GUI Screens and Reports using Developer 2000.

. Developing Packages, Stored Procedures, Functions, Cursors and Views

etc.

. Involved in Code Reviews, Coding, Unit Testing, Supporting Testing

Personnel, Preparing Unit Test Cases for the Modules.

Contact this candidate