Oracle Developer&Oracle Technical Consultant

P. NAVEEN

Oracle Database Developer

E-Mail Id: ******.*********@*****.*** Mobile No: +91-960*******

CAREER OBJECTIVE:

Intend to build a career with leading organization and seeking a position to utilize my skills and

abilities towards the goals of the organization.

CAREER SUMMARY:

Having a relevant working experience of my in Database development.

•

Good implementation and has expertise in the Testing of SQL and PL/SQL Code.

•

Experience in Developing and Designing Queries Using Joins, Sub-queries, Hierarchical

•

Retrieval, Regular Expressions, Group Functions and Analytical Functions.

Experience in Creating and Managing Tables, Views, Indexes, Sequences and Synonyms.

•

Experience in writing the code for the Application-Level and Database-Level Triggers.

•

Constructive skill in Developing Stored Procedures, Functions, Packages, Application of Cursors

•

and Runtime Handling of Error Using Exceptions.

Experience in writing scripts Using UNIX Shell Programming.

•

Developed A Physical Data Model and Generated the DDL Script in TOAD Data Modeler 3.3.

•

Develop the code Logic in Oracle Forms.

•

Developed Forms Screens Used by Oracle Developer Suite for Forms Procedures,Functions

•

generate to End Products of Forms.

Worked on Forms Triggers and Built-in Packages,Alerts,Datablocks and Program Units By using

•

PLSQL Procedures and Functions.

Creating and Developing the Dynamic LOV’s,Programmatically Record Group Handling.

•

Developed MDI application with Multiple Window and Canvas Interfaces.

•

Good ability to quickly grasp New Concepts and Technologies possessing Problem solving Skills as

•

well as Hard working and above all a good Team player.

TECHNICAL SKILLLS:

Languages : SQL, PL/SQL, Linux Shell Scripting.

•

Databases : Oracle Database 10g.

•

Operating Systems : Oracle Enterprise LINUX 4/5, Microsoft Windows Family.

•

Development Tools : D2K 10g (Oracle Forms), SQL Developer, Toad DataModeler 3.3.

•

PROJECT EXPERIENCE:

Project Title : Payroll Online System

Page 1 of 3

Software : Oracle 10g

6 Months

Duration :

Role : Design and Coding

Team Size :4

Project Description:

The actual problem is to maintain different database for an organization whose main

purpose is to issue pay-slips for their employees every month working in various departments of the

organization, and maintain details of all the departments, employees with various grades, their

designations and address details.

In the manual system it is difficult to maintain data and generating different

reports according to requesting transaction. In the present system it is becoming difficult to issue pay-

slip for all the employee every month by manually going through the various record of the

organization. ie the manger have to go through all the records of the organization of various

departments of the and find out the employee working in a particular department and go through his

grade, and he have to check the employee leaves of that month, his earnings and his deductions along

with his pf and all other deduction including his IT and savings. So, to perform all these activities it is

becoming difficult the admin/manager every month.Hence in order to overcome the difficulties of the

organization the present system is automated to perform all the activities of the organization.

Responsibilities:

Actively participated in Database System Design, Coding and Implementation.

•

Designed the Physical Database Model and Generated the SQL/DDL Script for Oracle Database

•

10g Using Toad Data Modeler 3.3.

Involved in developing complex CHECK Constraints and User-defined Integrity TRIGGERS to

•

maintain the security and validity of data between Users at Design Level.

Actively Participated in Implementing and Testing of SQL and PL/SQL Code Using SQL*PLUS,

•

Created VIEWS from Multiple Tables and INDEXES to improve Performance.

•

Written the Queries Using Joins, Sub Queries, Set Operators, and Analytic Functions to access the

•

Data.

Developed Stored Procedures, Functions for Data Validations and Business Validations.

•

Developed Forms Screens Used by Oracle Developer Suite for Forms Procedures,Functions generate

•

to End Products of Forms.

Page 2 of 3

Creating Forms Triggers and Built-in Packages,Alerts,Datablocks and Program Units By using

•

PLSQL Procedures and Functions.

Creating and Developing the Dynamic LOV’s,Programmatically Record Group Handling.

•

Developed MDI application with Multiple Window and Canvas Interfaces.

•

Above responsible for providing 24 6 production support to the client.

•

EDUCATIONAL QUALIFICATION:

Bachelors Degree in Computer science from Joginapally B R Engineering College, Hyderabad in

•

2008-2012, affiliated to jawaharlal nehru technological university (J.N.T.U).

Intermediate from Board of Intermediate Education in Nalanda Junior College of science&Arts,

•

Guntur,in 2005-2007.

S.S.C from State Board of Secondary Education in ZP High School, Kubeer in 2004-2005.

•

PERSONAL DETAILS:

• Full Name : Puppala Naveen

• Linguistic Abilities : Telugu, Hindi and English

• Current Address : H.No:9-7-108, Maruthi nagar, Santhosh Nagar, Hyderabad, AP-500059.

•

DECLARATION:

I, hereby declare that all the information furnished above is true to the best of my knowledge and

belief.

PLACE: Hyderabad

DATE :

(P.NAVEEN)

Page 3 of 3

Contact this candidate