SUMMARY

• Over 8 years of experience with expertise as Oracle PL/SQL Developer in areas of application software development and maintenance in oracle environment using client/server.
• Involved in designing data migration process flow using Microsoft visio. Good understanding of star/snowflake schema design.
• Proficiency in using various Oracle utility tools SQL Plus, TOAD, PL/SQL Developer, SQL Navigator, SQL*Loader.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables, Collections (Nested Tables and Varray) in complex backend packages.
• Experience in performance tuning and Query optimization using Explain Plan, TKPROF, HINTS and SQL Trace utilities.
• Experience in tuning the application to optimize the cost and for higher efficiency.
• Experience with database objects like stored procedures, Stored functions, Packages, TYPE Objects, Triggers, cursors, REF cursors, parameterized cursors, Views, Materialized Views, PL/SQL collections and Database Link.
• Extensive Knowledge and Experience in transferring data between different sources like xls, csv, delimited text to Oracle databases using SQL Loader and External tables.
• Experience with Data flow diagrams, Data dictionary and Database normalization theory techniques, Entity relation modeling and design techniques.
• Involved in unit testing, systems integration testing and documented the same.
• Wrote complex SQL queries to extract data from various source tables of data warehouse.
• Effectively made use of Table Functions, Views, Sequences, Constraints, Indexes, Table Partitioning, Collections, Analytical functions.
• Used Bulk Collections and FORALL for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
• Experience in Oracle supplied packages (DBMS SQL, DBMS JOB, UTL FILE, DBMS LOB, DBMS SHEDULER, DBMS DDL) Dynamic SQL, Records, PL/SQL Tables and Exception Handling.
• Experience in performance tuning and Query optimization using Explain Plan, DBMS Profiler, HINTS, ADDM and AWR tools.
• Experience in tuning the application to optimize the cost and for higher efficiency.
• Team player with an aim of contributing towards the team's success. Possess good communication and inter - personal skills, able to adapt quickly to new technologies and environments.

TECHNICAL SKILLS

Databases: ORACLE 11g/10g/9i/8i, MS Access

Programming Skills: SQL, PL/SQL, UNIX Shell Programming

Operating Systems: UNIX, Linux, Windows

Tools: TOAD, PL/SQL Developer, SQL Developer.

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

Oracle PL/SQL Developer/ DBA

Responsibilities:

• Discussed and analyzed business functionality with the client and involved in requirement gathering.
• Involved in designing database architecture and technical documents for better understanding the relations, associations and dependencies within the application.
• Worked on Data Migration from legacy system to oracle 11g system.
• Involved in mapping of legacy system tables, columns to new data warehouse tables, columns.
• Wrote new packages to populate the data in new data warehouse.
• Worked on automation of reconciliation between legacy system and new data warehouse.
• Worked on Database Links and Bulk Collections to perform bulk data loads into database tables from upstream application.
• Designed and developed Oracle PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating Packages to meet business requirements.
• Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources.
• Created Materialized Views, tables, complex SQL queries, Correlated sub queries, Nested Queries, Views and Function Based Indexes for effective Business Application Development.
• Extensively used advanced features of PL/SQL like Ref Cursors, Collections (Nested table and Varray) and Dynamic SQL.
• Worked on Exception handling, to trouble-shoot PL/SQL code and to display the error messages in the application.
• Used Explain Plan, DBMS Profiler for tuning the PL/ SQL blocks
• Created indexes and used HINTS to direct the optimizer to choose an optimum query execution plan.
• Monitoring the schedules and timely escalations to the project management and client in case of any slippages.
• Performed unit test on the developed code to ensure that its bug free.
• Handled Production issues and managed the same in issue log.

Environment: Oracle 11g, Unix, PL/SQL, TOAD 9.1/10.5, VI editor, SQL, SQL loader.

Confidential, Peoria, IL

Oracle PL/SQL Developer

Responsibilities:

• Interacted with Business Analysts and Users in requirement gathering, built complex queries using SQL and wrote stored procedures using PL/SQL.
• Involved in the database design for better understanding the relations, associations and dependencies within the database.
• Designed Technical design document based on the business requirements.
• Worked on SQL*Loader and Bulk Collections to perform bulk data loads into database tables from external data files.
• Extensively used advanced features of PL/SQL like Ref Cursors, Collections (Nested table and Varray) and Dynamic SQL.
• Created Materialized Views, tables, complex SQL queries, Correlated sub queries, Nested Queries, Views and Function Based Indexes for effective Business Application Development
• Designed and developed Oracle PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating Packages to meet business requirements.
• Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources.
• Used Oracle packages like DBMS STATS to collect statistics of tables as an aid to improve the performance of application.
• Monitoring the schedules and timely escalations to the project management and client in case of any slippages.
• Worked on Exception handling, to trouble-shoot PL/SQL code and to display the error messages in the application.
• Used Explain Plan, SQL*TRACE, TKPROF for tuning the SQL statements by creating indexes and used HINTS to direct the optimizer to choose an optimum query execution plan.
• Performed unit test on the developed code to ensure that its bug free.
• Handled Production issues and managed the same in issue log.

Environment: Oracle 11g, Windows XP, PL/SQL, TOAD 9.1/10.5, VI editor, SQL loader.

Confidential, Fairlawn, OH

Oracle PL/SQL Developer

Responsibilities:

• Discussed and analyzed business functionality with the client and the developers.
• Involved in designing database architecture and technical documents for better understanding the relations, associations and dependencies within the application.
• Developed and modified PL/SQL packages, procedures, functions and Dynamic SQL as per customer requirement to make new enhancements or resolve problems.
• Wrote complex SQL queries to retrieve information from the databases depending on user requirement.
• Wrote Database triggers for audit and to implement complex business logic.
• Created Bitmap Indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
• Wrote control files and loaded the data into the Oracle database with SQL*Loader.
• Implemented Materialized View for extracting the data from remote database.
• Handled various Exceptions to trouble-shoot PL/SQL code.
• Coded Unix shell scripts to call SQL scripts and to manipulate the returned data.
• Developed test plan and unit test documents for all back end database modules.
• Extensively worked on Explain Plans and various HINTS for Performance tuning.

Environment: Oracle 10g, Windows XP, SQL, PL/SQL, SQL*Loader, PL/SQL Developer, TOAD, HP UNIX

Confidential, Winston Salem, NC

Oracle PL/SQL Developer

Responsibilities:

• Analyzed, designed, modeled, and implemented new database schemas.
• Monitoring Fragmentation, Row Chaining and High water marks.
• Generated SQL and PL/SQL Scripts to create stored procedures, functions, packages and database triggers.
• Designed competent PL/SQL programs using PL/SQL collections, Records types, and Object types.
• Good knowledge on joins, which are inner join, Left outer join and Hash join, Semi join.
• Involved in working on Oracle Pseudo columns like ROWID, ROWNUM, SYSDATE, SYSTEM TIMESTAMP, USER etc.
• Experience in working a variety of analytical functions, RANK, DENSERANK, LAG, LEAD, and PARTITION OVER.
• Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL.
• Enhanced it with creating exceptions for error handling. Created triggers for auditing purpose and created group, tabular and form reports.
• Implemented various UNIX scripts to generate the data in CSV format.
• Tuned several Oracle SQL statements using Explain Plan, Auto Trace utilities.
• Responsible for database design and development and Application Tuning.

Environment: Oracle 10g, PL/SQL and Windows XP, HP UNIX, Oracle SQL Developer, Putty.

Confidential, NY

Oracle PL/SQL Developer

Responsibilities:

• Analyzed the business requirements for the enhancements needed in the contract administration application and related policy modules.
• Documented the detailed requirements and prepared DLD for the new enhancements.
• Performed several DDL, DML and TCL operations.
• Created huge database packages with related functions and procedures.
• Created views by joining multiple cash flow tables to show output as a report to the user.
• Extensive PL/SQL programming including Development of new backend packages, procedures and functions to in corporate advanced modules.
• Worked on BULK COLLECT for bulk loading the data into various transaction tables.
• Used UTL FILE to load the data into oracle tables from FLAT, CSV and Text files.
• Added database triggers to some history tables of the database.
• Used file handling in Oracle to read and write into files associated with the modules.
• Refresh the development and test databases using export/import utilities.
• Provided 24*7 on call support to production environment.
• Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, Stored PROEDURES/FUNCTIONS/PACKAGES using SQL PLUS session in silent mode.
• Worked on inline and correlated sub queries based on business context.
• Implemented various customized Oracle reports using different techniques in Oracle SQL/PL-SQL.
• Extensive and in depth analysis of the problem tickets to dig out the root cause for the problems.
• Worked with the development team to design, develop, test and implement the application.

Environment: Oracle 9i, Windows XP/2000, PL/SQL, SQL*PLUS, HP UNIX.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in the Analysis, Design, Coding and Testing of the application.
• Gathered requirement from the business users, prepared design documents and unit test cases.
• Prepared program specification and development of PL/SQL packages, procedures and functions as required by the business users.
• Generated server side PL/SQL scripts for data manipulation and validation.
• Analyzed the existing method for data repository refresh and then developed a new package with tuned queries to improve the performance and reduce the time taken for the refresh.
• Created Materialized View for extracting the data from the remote databases.
• Wrote PL/SQL procedures to generate DDL scripts that created database objects dynamically based on user inputs.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Generated and maintained Keys, Constraints and Relationships between the tables for OLTP database.
• Used Bulk Collection types such as bulk collect and for all to reduce context switching between SQL and PL/SQL engine and vice versa.
• Maintained a series of UNIX shell scripts to manage batch order processing.
• Performed unit test on the developed code to ensure that its bug free.
• Fine Tuned SQL statements for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Trace sessions for Cost based and Rule based Optimization.

Environment: Oracle 8i, Windows NT/2000/XP, HP UNIX, SQL*Plus, PL/SQL, SQL*Loader.