SUMMARY

• 7+ years of experience with expertise as Oracle SQL / PL/SQL Developer in areas of Application software development and maintenance in Oracle environment.
• Programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System.
• Experience in Software Development Life Cycle (SDLC) which includes requirement gathering, designing, implementing and testing.
• Experience in Oracle SQL and PL/SQL including all database objects:
• Stored procedures, Stored functions, Packages, TYPE Objects, Triggers, cursors, REF cursors, Parameterized cursors, Views, Materialized Views,PL/SQL collections.
• Developed Complex database objects using Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience in working in an Agile Team.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• DBMS developments include building data migration scripts using Oracle SQL*LOADER.
• Extensive experience in Database query tuning, Performance tuning of Reports and troubleshooting Oracle Application issues on OLTP and DSS systems.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Excellent problem solving skills with a strong technical background. Creative, adaptive and result - oriented professional with avidness to learn. Proficient at working as a team player with an aim of contributing towards the team's success.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i

Languages: SQL, PL/SQL

Database Tools: SQL*PLUS, SQL Developer, VI Editor

Operating System: Windows 7/XP/2000/98, UNIX

Project Management Tools: Methodologies: SDLC, Modeling Tools: MS Visio 2010, MS Office 2010

Other Tools and Web Application: HTML,CSS,JAVASCRIPT

Data Utilities: SQL Loader,Explain Plan, Tkprof

PROFESSIONAL EXPERIENCE

Confidential

Oracle 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.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Created change control documentation.
• Developed User screens using HTML/DHTML, Forms. .
• Optimized the queries to improve the performance of the application.
• Worked on improving the Performance of SQL queries by extensive usage of Explain plan and various hints and indexes.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Involved in Performance tuning of complex queries.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 10g/11g, SQL*Plus, SQL*Loader, SQL Developer, UNIX, Windows XP

Confidential

JR. PL/SQL Developer

Responsibilities:

• Designed and developed a custom database (Tables, Views, Functions, Procedures, and Packages).
• Created Stored Procedures, functions and Packages in Oracle 9i using SQL and PL/SQL for the Audit Trail using Oracle 9i as backend.
• Used Bulk binding/for all with save exception, dynamic Sql, dbms packages, plsql collections and Sql MERGE.
• Worked with autonomous transaction, global temporary tables, ref cursors and analytical functions and regular expressions.
• Used triggers to maintain history tables and log maintenance users.
• DBMS developments include building data migration scripts using Oracle SQL*LOADER.
• Optimized the queries to improve the performance of the application.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages. Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
• Worked on improving the Performance of SQL queries by extensive usage of Explain plan and various hints and indexes.
• Wrote scripts for creating tables, Indexes, Grants and Synonyms in different schemas and made modifications for the existing tables as per business logic.
• Developing back-end PL/SQL packages, building UNIX shell scripts for data migration & batch processing.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created change control documentation.
• Involved in Performance tuning of complex queries.
• Suggested and Implemented indexes for faster retrieval of data in Weekly and Monthly Metrics reports.

Environment: Oracle 10g/11g, SQL, PL/SQL,SQL NAVIGATOR, UNIX.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked as Oracle Developer for developing PL/SQL code for Oracle Interfaces and Reports.
• Worked with Functional Team for gathering the business requirements. The development and customization was done according to these requirements.
• Written effective SQL queries for extracting data as per business requirements.
• Developed various custom reports in different formats using Oracle Reports Builder, which helped Business Users in analyzing the data.
• Developed PL/SQL code as per the project requirement including Functions, Stored Procedures, Packages, Cursors, Triggers and Views.
• Developed server side PL/SQL Packages, procedures and functions that are used in
• Developed Lookup tables using SQL queries and analytical functions.
• Developed back out scripts for various change requests throughout the application.
• Generating DDL files to create new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges by incorporating business standards throughout the files.
• Participated in design sessions where decisions are made involving the transformation from source to target.
• Developed and Documented Test Cases and unit test results.
• Provided production support for various different defects in the code.
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plan and Trace sessions for Cost based and Rule based Optimization.
• Wrote Several SQL scripts to populate data in to the various staging tables from various data warehouse tables.
• Was responsible for creating and modifying the PL/SQL stored procedures, functions and packages, which load data from temp tables to interface tables and do data validations.
• Created indexes to improve performance of SQL and PL/SQL scripts.
• Used Oracle Trace and Explain Plan utilities to catch the poor performing queries and analyze their execution plans.
• Performed Unit Testing on developed code.
• Responsible for preparing technical and user documentation of the customizations.

Environment: Oracle 10g/11g, PLSQL Developer SQL*LOADER, UNIX, MS Visio, MS Excel

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked as Oracle Developer for developing PL/SQL code for Oracle Interfaces and Reports.
• Worked with Functional Team for gathering the business requirements. The development and customization was done according to these requirements.
• Written effective SQL queries for extracting data as per business requirements.
• Developed various custom reports in different formats using Oracle Reports Builder, which helped Business Users in analyzing the data.
• Developed PL/SQL code as per the project requirement including Functions, Stored Procedures, Packages, Cursors, Triggers, Views.
• Performed Data Analysis on legacy system data before loading into Oracle database.
• Developed and maintained SQL Loader Scripts for loading data from legacy systems to Oracle database.
• Was responsible for creating and modifying the PL/SQL stored procedures, functions and packages, which load data from temp tables to interface tables and do data validations.
• Developed customized screens using forms 6i at the front-end.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages. Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
• Implemented performance tuning with incorporating indexes, partitioning, temporary tables and parallel wherever required for improved performance.
• Created indexes to improve performance of SQL and PL/SQL scripts.
• Used Oracle Trace and Explain Plan utilities to catch the poor performing queries and analyze their execution plans.
• Performed Unit Testing on developed code.
• Responsible for preparing technical and user documentation of the customizations

Environment: Oracle 9i, SQL, PL/SQL, SQL* Loader, TOAD, Windows XP, UNIX