SUMMARY

• More than 7 years experience in positions of increasing responsibilities.
• Experienced in writing SQL statements, PL/SQL code for the database objects such as tables, views, indexes, sequences, procedures, functions, packages, and triggers
• Excellent experience and understanding of system development life cycle (SDLC) such as analysis, design, development, testing, implementation and support with exposure in database
• Extensive knowledge of Relational Database Management Systems (RDBMS)
• Extensively used indexes for fine tuning and optimizing SQL and PL/SQL queries
• Extensive experience in using cursors and ref - cursors for processing the data
• Applicable knowledge of Oracle tools like SQL*PLUS, SQL*Loader, export/import
• Experienced in performance tuning using explain plan
• Experienced in working with DB Links and creating materialized views
• Experienced in creating different kinds of partitions for managing large tables
• Excellent understanding of the relational and normalized databases
• Expertise in handling various errors using exceptions
• Extensive experience in application development of the database using TOAD
• Experienced in using the version control tool such as VSS (Visual source safe)
• Experienced in scheduling reports for maintaining up to date information and managing folders for sharing reports Expertise in using Oracle 9i/10g database and PL/SQL programming to develop stored procedures, packages and advanced features like function overloading, dynamic SQL, query optimizer, nested loops.
• Knowledge of database design, development and provision of customer support and implementation of applications using client/server systems
• Transferred data using FTP (File Transfer Protocol) and storing the back-ups of data using SCP (Secured Copy)
• Worked closely with the technical teams and DBAs for issues related to code changes, data fixes, and testing
• Documented business rules, functional and technical designs, test cases, and userguides.
• Possess excellent communication, interpersonal and technical skills
• Self-motivated with analytical, problem solving and presentation skills
• Excellent team player with the ability to work independently and interact with people at all levels

TECHNICAL SKILLS

Operating Systems: UNIX, DOS, Win 98/NT/2000/XP/Vista

Database: Oracle 8i/9i/10g

Languages: UNIX, Shell Scripting (Bourne, Korn), SQL, PL/SQL, C, C++, Java

Tools: SQL Plus, iSQLPlus, TOAD 8.5/9.0

Utilities: Vi Editor, SQL*Loader, SQL Developer, PL/SQL Developer, Explain Plan

GUI: Oracle Forms 9i/10g

PROFESSIONAL EXPERIENCE

Confidential, IL

PL/SQL Developer

Responsibilities:

• Gathering business requirements
• Creating database objects like tables, synonyms, sequences and views
• Created, edited procedures and functions to suite the improved business requirements
• Created records and nested tables in the procedures for handling of data
• Used SQL Loader to load data into the database coming from Knipper and FICO
• Used export/ import and expdp/impdp database utilities for data transfer
• Coded complex SQL queries to retrieve data from the database depending on the need
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors
• Made use of Sub query-Factoring (WITH clause) to make complex SQL statements simple and make them more efficient
• Using set operators in PL/SQL like Union, Union all, Intersect and Minus
• Performed exception handling for the procedures created
• Written and edited shell scripts to automate the execution of the procedures and report the results through e-mail
• Created indexes for faster retrieval and improved query performance
• Worked with performance tuning tools like Oracle optimizer, explain plan, hints to improve the database performance
• Support for the development, test and the production databases
• Used SQL plus and TOAD to develop database applications
• Documentation of the technical work done

Environment: Oracle 10g, Windows, PL/SQL, SQL Loader, Shell Scripting

Confidential, VA

PL/SQL Developer

Responsibilities:

• Requirement analysis and database design.
• Forward engineering and reverse engineering Object to Oracle database.
• Developed various complex business processes using procedures, functions and packages.
• Created schema objects like tables, indexes, views.
• Trouble shooting performance issues using Explain Plan.
• Creating users and privilege Management using roles and grants.
• Extensively used batch processing to load orders taken on the web to the back end order processing system using SQL Loader and oracle bulk binding statements like bulk collect, for all and multi table insert statements like insert all etc
• Provided support and troubleshooting to the existing application related to Oracle database, PL/SQL.
• Responsible for creating databases and creating database links.
• Creating database build scripts and preparing roll out plans.
• Testing and implementation.

Environment: Oracle 10g, PL/SQL, SQL*Loader, Toad.

Confidential, Dallas, TX

PL/SQL Developer

Responsibilities:

• Extraction of data from different flat files into Oracle Database using SQL* Loader.
• Gather Business rules from the end users that are to be incorporated into the system.
• Wrote PL/SQL Procedures, Functions and Triggers for insert, update, and delete transactions.
• Changed existing logic within the packages for optimum Performance.
• Tested the original and optimized codes thoroughly for failures before exporting to other environments.
• Created Shell Scripts for Regular backup, instance start and shutdown
• Involved in successfully upgrade of database from Oracle 8i to 9i.
• Creating and Maintaining of different levels of users with different levels of securities by creating User Roles and Privileges.
• Tuned SQL by using Explain Plan, Indexing and Hints.

Environment: Oracle 9i/8i, PL/SQL, TOAD, SQL*Loader, HTML, XML, Crystal Reports

Confidential

PL/SQL Developer

Responsibilities:

• Created database objects such as tables, views, indexes, sequences using Oracle8i
• Developed PL/SQL stored procedures, functions and packages in TOAD 8.0
• Created PL/SQL program units to include DML, DDL statements using dynamic SQL
• Fine tuned procedures for maximum efficiency in various schemas across databases using Oracle Hints, execution plan
• Trapped errors such as INVALID CURSOR, VALUE ERROR using exception handler
• Developed row level and statement level triggers for auditing tables in PL/SQL
• Created partitions on the tables to improve the performance
• Wrote complex SQL queries to retrieve information from the databases depending on the requirement
• Generated sequences that can be shared by multiple users to generate unique integers
• Implemented PL/SQL scripts in accordance with the necessary business rules and requirements
• Wrote complex queries involving multiple-joins to generate user reports
• Participated in the ongoing process enhancements and modification requests
• Coordinated with the offshore support team in resolving critical issues
• Tested, installed, documented and provided on call support for the applications

Environment: Oracle 9i, SQL, PL/SQL, SQL*Plus, PL/SQL Developer, TOAD 8.0, UNIX, Shell programming.

Confidential

PL/SQL Developer

Responsibilities:

• Designed module wise Oracle 9.0 database structure and its implementation on the client server
• Developed tables, views, stored procedures, functions, and user-defined data types
• Created table structures along with the triggers, indexes like bitmap and function based indexes
• Maintained the data integrity and security using constraints and database triggers
• Involved in programming database triggers for automatically updating the tables and views
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures
• Implemented table partitioning and sub-partitioning to improve performance and data management
• Troubleshoot performance issues within packages and stored procedures using explain plan and DBMS OUTPUT
• Responsible for tuning the application with the help of team members & Oracle support
• Improved the query performance using better joins and hints appropriately
• Developed packages, procedures and functions for complex reports
• Used SQL*Loader for loading the data into the tables from files
• Developed batch programs using UNIX shell scripts
• Participated in the design and code reviews and verified compliance with the project’s plan
• Documented the whole process flow, PL/SQL packages, locations and descriptions, and possible error messages.

Environment: Oracle 9i, SQL, PL/SQL, SQL Plus, SQL loader, UNIX.