SUMMARY

• 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.
• Experience in UNIX shell scripting automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources.
• Experience with XML scripting to add and remove/changing tables, adding and removing indexes, defining and changing subscription set.
• 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.
• Expert in PL/SQL Programming Language
• Project and Time Management
• Design, Development and Migration of Applications
• Analytical and Trouble shooting Skills
• Process Performance Tuning
• Coordinating several tasks simultaneously & Work efficiently under pressure
• Working as a team member as well as independently

TECHNICAL SKILLS

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

Programming Skills: SQL, PL/SQL, UNIX Shell Programming, XML Scripting.

Operating Systems: UNIX, Linux, Windows

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

PROFESSIONAL EXPERIENCE

Confidential, Atlanta GA

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, and 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.

Confidential, Milwaukee, WI

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, Sacramento CA

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, Richmond VA

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.