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