PL/SQL Developer Resume

OBJECTIVES

To seek a competitive and challenging career opportunity in IT Firm, that utilizes my skills and knowledge and at the same time provides challenging opportunities for learning and growth.

SUMMARY

Having 3+ years of IT experience in the field of oracle in pl/sql development.
Main responsibilities include understanding of client requirements & develop solutions.
Experience on pl/sql programming in Oracle 10g/11g relational and object relational database.
Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers, cursor, bulk collect using SQL and PL/SQL with OOPS concept.
Working on Oracle OLAP and hands on experience in SQL tuning/Re - writing SQLs in an alternate better way.
Written SQL queries for DML operations, Sub queries, JOIN and queries optimization.
Effectively made use ofTable Functions, Indexes, Collections, Analytical functions.
Create the objects like tables, synonyms, sequences and views.
Experience on SQL *PLUS, TOAD tools.
Knowledge on UNIX.
Ability to be an effective team player and work under time constraints.

TECHNICAL SKILLS

Operating System: Windows 98/NT/2000, Linux.

Language: SQL, PL/SQL.

RDBMS: ORACLE.

TOOLS: SQL * PLUS, TOAD.

PROFESSIONAL EXPERIENCE

Confidential

PL/SQL Developer

Responsibilities:

Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
Developed PL/SQL triggers and master tables for automatic creation of primary keys.
Created PL/SQL stored procedures, functions and packages.
Creating of new tables, views, queries for new enhancement in the application using TOAD.
Retrieving data set in bulk using pl/sql tables.
Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad and SQL* plus.
Extensively used bulk collection in PL/SQL objects for improving the performing.
Created records, tables, collections (nested tables and arrays) for improving Query performance.
Identify suitable business scenario in the existing application and suggest/implement back end procedure implementation.
Must be very comfortable in generating/understanding query plan and identify deficiency in query execution, suggesting, implementing changes for better performance.
Hands on experience in SQL tuning/Re-writing SQLs in an alternate better way and queries optimization.

Confidential

PL/SQL Developer

Responsibilities:

DML operation on tables, views, procedures and packages using oracle tools like Toad and SQL* plus.
Working with Unix OS and shell scripting.
Identify performance bottlenecks in PLSQL procedure and eliminate by alternate implementation.
Developed PL/SQL triggers and master tables for automatic creation of primary keys.
Extensively used bulk collection in PL/SQL objects for improving the performing.
Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
Used Bulk Collections for better performance and easy retrieval of data.
Created records, collections (nested tables and arrays) for improving Query performance.
Good knowledge in Analytical Functions and Notification,FUNCTION,PROCEDURE,PACKAGE,OOPS