SUMMARY:

• Around 6 years of programming experience as an Oracle Developer wif Software Development Life Cycle (SDLC) performing detailed analysis, design, data modeling (Logical and Physical), and implementation of business applications using the oracle Relational Database Management System (RDBMS).
• Experience in Client - Server application development using Oracle 11g/10g/9i.
• Expertise in writing Stored Procedures, Triggers, Functions, Packages,Cursors using SQL and PL/SQL.
• Experience in using Oracle tools like SQL*Loader, SQL*Plus, TOAD, SQL * Navigator, SQL Developer and PLSQL Developer in very high volume data.
• Experience in database design using Normalization and E/R Diagrams.
• Experience in developing various data models using SQL Developer Data Modeler, ERwin and MS Visio.
• Experience in Performance Tuning and Optimization techniques of SQL query statements using Explain Plan, Hints, SQL*Trace and Tkprof.
• Experience in working wif Dynamic SQL, Ref Cursors, Bulk Collections and Exception Handling.
• Hands on experience in creating different kinds of partitions for VLDB.
• Used supplied packages to extend the functionality of PL/SQL programs such as DBMS SCHEDULER to schedule jobs, UTL FILE to read and write from database.
• Strong experience wif DATAPUMP utilities like EXPDP/IMPDP.
• Strong knowledge wif PL/SQL Wrapper to protect the PL/SQL procedures or packages.
• Experience in UNIX Shell Scripting, scheduling batch jobs using Crontab.
• Used Version Control Tools SVN, CVS and VSS.
• Proficient in designing and developing of Reports using Crystal Reports.

TECHNICAL SKILLS

Operating Systems: Windows XP/NT, Unix/Linux

Languages: SQL, PL/SQL, C, C++

Databases: Oracle 9i/10g/11g Toad, SQL Developer, PL/SQL Developer, SQL NavigatorJIRA, SQL Developer Data Modeler

Utilities: Import/Export, Sql Loader, External Table, Tkprof, Statspack, Profiler, EXPDP/IMPDP

Data Modeling tools: SQL Developer Data Modeler, ERwin and MS Visio

GUI: Developer 2000 (Forms 6i,Reports 6i)

Reporting Tools: Crystal Reports 9.0

Version Control: VSS, CVS, SVN

PROFESSIONAL EXPERIENCE

Confidential, VA Beach, VA

Sr. Oracle Developer

Responsibilities:

• Analyzed and overviewed the database design for better understanding the relations, associations and dependencies wifin the database.
• Created Logical and Physical Models using ERWIN.
• Create and maintain complex PL/SQL programs, packages, procedures, functions, cursors and triggers.
• Involved in creating database objects like tables, views, sequences, synonyms, and indexes.
• Loaded the data into database tables using SQL*loader from flat files.
• Created complex SQL Queries for reporting.
• Enforced Constraints on the tables to ensure data validations.
• Worked on user-defined and system defined exceptions to handle different types of errors like NO DATA FOUND, TOO MANY ROWS, and PRAGMA EXCEPTION INIT etc.
• Used Collections, Bulk Collections for handling large amount of data in PL/SQL
• Used PRAGMA AUTONOMUOS TRANSACTION to avoid mutating problem in database triggers.
• Created Indexes and partitioned the tables to improve the performance of the query.
• Used the Oracle IMPDP/EXPDP utilities for taking the backup of a particular partition data.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, SQL* TRACE, TKPROF and DBMS PROFILER.
• Scheduling batch jobs using the Crontab.
• Providing the support and maintenance of the application.

Environment: Oracle 11g, SQL, PL/SQL, SQL Developer, SQL*Loader, Windows XP, Linux, Crystal

Confidential, MA

Oracle Developer

Responsibilities:

• Designed and developed database packages, procedures, functions and triggers.
• Used features like bulk collect to process large amount of data in database.
• Improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL.
• Worked as a SQL developer to support business applications using Oracle SQL and PL and SQL.
• Created Tables, Indexes, views, Sequences, Synonyms and stored program units.
• Developed Unix Shell Scripts to automate backend jobs.
• Involved in analysis, design, coding and Testing.
• Built and maintained SQL scripts, indexes, reports and queries for data analysis and extraction.
• Involved in creating Database Design (Physical and logical) as per the requirement given by business.
• Gathered Statistics and Analyzed Tables and Indexes for Performance tuning.
• Extracted data from Flat files using SQL*LOADER.
• Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Made use of performance tuning utilities like explain plan, SQL Trace and dbms profiler to reduce the run time of complicated queries on Oracle 10g.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database. Created Partitions on the tables to improve the performance.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.

Environment: Oracle 10g, SQL Developer, SQL*Loader, UNIX, Shell Scripting.

Confidential

PL/SQL Developer

Responsibilities:

• Analyzed, developed Packages, Procedures and Functions as per the requirement
• Used Collections, Bulk Collections for handling large amount of data in PL/SQL.
• Created Indexes and partitioned the tables to improve the performance of the query.
• Optimizing Queries
• Used Oracle Pre Defined Packages DBMS SQL, UTL FILE.
• Involved in Import and Export of data, maintenance of Data Integrity.
• Created complex SQL Queries for reporting.
• Depending on the need developed many reports and forms using Reports 6i and Forms 6i.
• Used PL/SQL Collections (Nested Tables and Varrays) in complex backend packages.
• Performed debugging of the PL/SQL codes using the DBMS OUTPUT.
• Loading data into the database using SQL* Loader.
• Identifying requirement changes, analyzing the impact of the changes (scope control), and providing detailed assessments to the team lead.
• Providing the Support and Maintenance of the application.
• Reviewing and providing input into other developer designs.

Environment: Oracle 9i/10g, Toad, SQL*PLUS, PL/SQL Developer, Linux.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in the design, development and support of various modules pertaining to loan Organization, loan management and loan collections.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Writing PL/SQL Packages, Procedure, Functions, Triggers
• Used Collections, Bulk Collections for handling large amount of data in PL/SQL.
• Created Indexes and partitioned the tables to improve the performance of the query.
• Optimizing Queries.
• Worked on XML along wif PL/SQL to develop and modify web screens and forms.
• Used Oracle Pre Defined Packages DBMS SQL, UTL FILE.
• Providing the Support and Maintenance of the application.
• Reviewing and providing input into other developer designs.
• Created complex SQL Queries for reporting.
• Involved in performing periodic cold backup of the databases.
• Designed, developed and customized forms by using Oracle Forms 6i and Reports 6i.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application
• Performed debugging of the PL/SQL codes using the DBMS OUTPUT.

Environment: Oracle 9i, Toad, SQL*PLUS, PL/SQL Developer, Linux.