Oracle Sql

DEEPALI U. TAMBEKAR

Master in Computer Management.

**** ******* ******** ** ***# 12205, Atlanta, GA, 30338 USA, Cell: 404-483-

7511

Email Id: *******.********@***-*.***

CAREER SUMMARY

. Total 7 years of experience as a Oracle PLSQL Developer .

. Expertise in writing Functions, Procedures, Packages and Database

Triggers using PL/SQL.

. Experience in Application System Administration activities like value

sets, managing concurrent programs.

. Expertise in Design and development of interface and conversion programs

to integrate Oracle Applications modules to import data from various

sources using PL/SQL and SQL*Loader ( For modules - AR, AP)

. Expertise in maintenance of tables, indexes, views and optimizing

queries.

. Involved in designing Technical Documents like MD070.

. Experienced on Unix and Windows operating environment

. Experience in understanding business requirements for analysis, detailed

design, database design, development & support of applications.

. Very good understanding of the PLSQL concepts and also Apps 11i table

structure and the data relationships.

. Knowledge of complete software development life cycle including

Requirement Analysis, Design, Development, Implementation and Testing.

Good working experience with end users.

. Great learning skills to adapt the rapid changing technologies and

implementing the same at work.

. Excellent interpersonal skills, ability to interact with people at all

levels with good communication and presentation skills.

TECHNICAL SKILLS

ERP : Oracle Applications 11i.

ERP Modules : Receivables (AR), Payables (AP),

HRMS

Operating Systems : Windows, UNIX

Languages : C, SQL, PL/SQL, C++

Databases : Oracle,Ms Access

Tools/Utilities : TOAD, SQL*Loader, SQL *Plus

GUI Tools : Reports 6i

EXPERIENCE PROFILE

Client : Universal Technical Services, Atlanta Date :

1st Oct 2007 to 28 Feb 2011

Role : Oracle Applications Consultant

Location: Atlanta, GA.

Responsibilities:

. Responsible for data Conversion from legacy to Oracle Applications.

. Worked on Vendor conversion (Include Vendor, Sites, Contacts) in AP

Module.

. Involved in Conversion of Customers in AR Module from the Legacy

System.

. Developed packages specifications & packages body, Stored Procedures,

cursors using PL/SQL,

. Created and Registered concurrent executables and concurrent programs.

. Developed & modified custom reports in AR and AR modules using the

reports 6i builder.

. Developed various outbound process to send flat file from Oracle

Applications to external system using UTL file package.

. Developed various Inbound process.

Environment: Oracle Apps 11.5.10, UNIX, Oracle 9i, Reports 6i, TOAD,

SQL*Loader, PL/SQL, SQL*Plus, AR, AP

Client : Vikvin Consultants, India. Date:-10-March 2003 to

25- July 2004

Role : Oracle Apps Developer.

Location: Pune, India.

Responsibilities:

. Involved in the conversion of legacy Employees in HRMS their Phone &

address.

. Involved in writing packages specifications & packages body, Stored

Procedures, cursors using PL/SQL.

. Standard APIs were used to create Employee their phone & Address.

. Design & Development of custom reports using Reports 6i as per user

requirements.

Environment: Oracle Applications 11.i, Oracle 8i (SQL, PL/SQL), TOAD, Sql

Loader.

Client : Tech Soft, India Date: 1 Jan 2000

to 25 Feb 2003

Role : PLSQL Developer

Location: Pune, India.

Responsibilities:

0. Wrote Event Triggers, PL/SQL Code for Reports for Client Validations.

1. Wrote Database procedures, Packages, functions to handle data

manipulations and Computations on Server.

2. Creating reports like customer details, Customer Sites Detail, High

Doller check listing report, sales order Report.

3. Designed and developed Oracle Monthly Reports.

4. Involved in writing Unix Shell scripts.

5. Developed Database Objects - triggers, Packages, Procedures and

functions.

Environment: Oracle 8i, SQL*PLUS, PL/SQL, Reports 6i.

Contact this candidate