SUMMARY:

• 7+ years of experience as an Oracle PL/SQL Developer, System Analysis, Design, Development & Support of Oracle Database 11g/10g in Production, Staging, Development, and Testing Environments
• Experience with all phases of the S oftware D evelopment L ife C ycle(SDLC) including analysis, Physical and Logical Design, Code Development, Testing, Implementing and Maintenance
• Extensive knowledge of Relational Database Management Systems (RDBMS)
• Proficient in creating PL/SQL Packages, Procedures, Functions, Exceptions,Views, Triggers, Grants and Synonyms
• Experience in query level performance tuning using Explain Plan
• Experience in loading high volume data and Performance Tuning using Partitioning and Indexes for fine tuning and optimizing SQL and PL/SQL queries
• Extensive experience of Oracle tools like TOAD,SQL*PLUS, and PL/SQL Developer
• Experience in data loading from other databases and text files into Oracle database using SQL*Loader, Import/Export, Bulk Collect.
• Involved in developing various data models using MS VISIO
• Extensive experience in Exception Handling
• Experience in working with DB Links and Data Migration between different environments
• Experience in UNIX Shell Scripting and Knowledge ofCrontab in UNIX environment for scheduling routine tasks
• Hands on experience with REF Cursors and Dynamic SQL
• Experience in releasing the enhancements and code fixes into various environments through the process of Release Deployment
• Knowledge of Data Warehousing concepts like Star Schema and Snowflake Schema, and Data Marts used in relational and dimensional modeling
• Good experience in developing ETL (Extraction, Transformation and Loading) procedures and Data Conversion Scripts using Pre - Stage, Stage, Pre-Target and Target tables
• Designed and Developed Type 2 Slowly Changing Dimension (SCD) model using star schemas
• Knowledge of DBMS SCHEDULER, DBMS JOB, DBMS DATAPUMP, and UTL FILE packages
• Good understanding of the concept of Normalization
• Worked with the technical teams and DBAs for issues related to code changes, data fixes, and testing
• Possess excellent communication, interpersonal and presentation skills
• Excellent team player with the ability to work independently and interact with people at all level

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i, MS-Access XP, SQL Server

Environment: UNIX (Sun Solaris 5.8/5.9, HP-UX 11/11i, IBM AIX 5.2/5.3), Red Hat Enterprise Linux 3, Windows 2003/2000/XP/98

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

Tools: TOAD 9.0/9.6, SQL*Plus, PL/SQL Developer 7.1.5, Oracle Enterprise Manager, Vi Editor, Putty, MS VISIO 2000/2007, SQL*Loader, TKPROF, SQL*Navigator v.4.5, ClearCase, MS Virtual SourceSafe

PROFESSIONAL EXPERIENCE:

Confidential, NY

Responsibilities:

• Involved in different phases of SDLC for all the new modules including Physical and Logical Design, Code Development, Testing, Implementing and Maintenance
• Involved in creating Logical and Physical Models using MS VISIO 2007
• Good experience in developing ETL (Extraction, Transformation and Loading) procedures and Data Conversion Scripts using Pre-Stage, Stage, Pre-Target and Target tables
• Developed Type 2 Slowly Changing Dimension (SCD) model using star schemas.
• Proficiently developed new Packages, Functions, and StoredProcedures using PL/SQL as well as modified the existing ones as per the user requirement
• Extensively created Tables, Indexes, Views, and Sequences for the new modules
• Experience in Exception handling
• Created synonyms and grantedprivileges on schema objects for other users to be able to share and access content
• Worked extensively with advanced features of PL/SQL like record and table types
• Experience in using ExplainPlan for query level performance tuning
• Involved in periodic Performance Tuning and Unit Testing of the PL/SQL code by using appropriate joins, indexes, and partitions
• Analyzed the tables periodically to improve query response time
• Coordinated with the offshore support team in resolving critical issues during the Production Run
• Worked with DBAs to analyze performance as well as during table space and schema lock issues
• Performed Data Migration between different environments using DB Links
• Used other features like PL/SQL Wrapper, Hints, MaterializedViews, and ERR$ Tables
• Created standalone procedures using Dynamic SQL and cursors to migrate data within the same database
• Extensive experience of promoting the new initiatives, enhancements and code fixes to various DEV and QA environments through the Deployment Process using UNIXplatform
• Extensively used TOAD for development and administration of various relational databases objects
• Proficiently used, created, and maintained various codes and scripts on different branches of ClearCase (Version Control)
• Created and maintained documents and log reports for various modules including Release History on SharePoint
• Actively participated in periodic status meetings and conference calls

Environment: Oracle10g, UNIX (Sun Solaris 5.8/5.9), TOAD 9.6, MS Visio 2007, HTML, Clear case

Confidential, Providence, RI

Responsibilities:

• Actively Participated in different phases of SDLC
• Designed and Developed Type 2 Slowly Changing Dimension (SCD) model using star schemas.
• Extensively involved in writing SQL queries and sub-queries using TOAD 9.6
• Involved in creating Logical and Physical Models using ERWIN 4.0
• Developed Packages, Functions, and Stored Procedures using PL/SQL and maintained the scripts for various data feeds
• Created Indexes and Sequences for faster retrieval of the product information and enhance the database performance
• Used Database Triggers for saving previous data when insertion, updating and deletion on the tables
• Wrote DDL Scripts to create new database objects like tables, views, and synonyms
• Wrote extensive Exception handling procedures to handle exceptions
• Data loading from other databases and text files into Oracle database using SQL*Loader
• Applicable knowledge of granting privileges on schema objects for other users to be able to share content
• Worked with advanced features of PL/SQL like record types and Dynamic SQL
• Used overloading feature of procedures, functions inside package
• Used Explain plan for Tuning the SQL statements
• Didquery performance using joins, indexes, partitions and hints appropriately
• Used the Crontab in UNIX for Automatic Tasks like loading data into Tables, Importing and Exporting data
• Wrote UNIX shell scripts to transfer and manage data within the database
• Involved in debugging, Tuning and Unit Testing of the PL/SQL code
• Attended daily walkthroughs, and status meetings

Environment: Oracle11g, HP-UX 11/11i, ERWIN 4.0, TOAD 9.6, ClearCase

Confidential, RI

Responsibilities:

• Was involved in design, development, test and maintenance of Credit Scoring Application
• Involved with all phases of SDLC for creating Credit Report Application
• Created Logical and Physical Models using ER/STUDIO 7.5
• Involved in Data Analysis and requirements gathering to develop and design documents
• Created DDL scripts to create, alter tables, views, synonyms and sequences
• Developednew and modified existing Packages, Procedures and Functionsas per the user requirements
• Created Triggers to implement business requirements
• Worked on trouble shooting of PL/SQL code using Exception handling
• Developed standalone procedures for specific tasks using DynamicSQL and Cursors
• Experience with handling huge volumes of data
• Involved in improving query response time by creating partitioning on tables
• Shared content with fellow developers by granting them privileges on schema objects as well as creating synonyms for objects on different schemas
• Experience with using Explain Plan for tuning complex queries
• Wrote SQL queries to perform Data Validation and Data Integrity testing
• Used TOAD 9.0.1 for the development of stored program units for Oracle databases
• Created and maintained documents and log sheets related to the database requirement, accessible to the whole team
• Participated in weekly status meetings and presentations
• Actively participated through the whole life cycle of the project

Environment: Oracle 10g, Windows XP, IBM-AIX 5.2/5.3, TOAD 9.0, ER/STUDIO 7.5, MS Visual SourceSafe 2005\

Confidential, Memphis, TN

Responsibilities:

• Active participation in the System Study, Physical Designing and Development of database
• Involved in creating technical documentation and Data Models using MS VISIO 2000
• Wrote DDL Scripts to create new database objects like tables, indexes, views, and synonyms
• Created and modified stored programs in the form of Packages, Procedures, and Functions for implementing the database intensive business rules
• Used database trigger for making history of insertion, updating, deletion and all kind of audit routines
• Worked on complex SQL queries and sub queries on the testing servers for performance tuning
• Worked on User-defined and System defined exceptions to handle different types of errors like NO DATA FOUND, TOO MANY ROWS
• Used SQL* LOADER to load data from CSV files into the database
• Wrote small Linux Shell Scripts for automated jobs
• Generated various reports using MS Excel XP
• Monitored Alert Log Report and System Error Logs
• Assisted in code reviewing and testing
• Participated in the ongoing process enhancements and modification requests
• Responsible for maintaining the documents for business analysts

Environment: Oracle 10g, Red Hat Enterprise Linux 3, Windows NT/XP, SQL*PLUS, MS VISIO 2000, MS Visual SourceSafe 6.

Confidential

Responsibilities:

• Involved in design and development of the database design.
• Involved in Bulk loading of data from non-Oracle data sources using SQL * Loader.
• Participated in system analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, procedures and packages.
• Developed Shell and PL/SQL scripting for regular maintenance and production support to load the data in regular intervals.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Involved in the design, development, testing and maintenance.
• Troubleshot production problems and worked effectively with other team members to identify and address problems.
• Provided input into project plans for database projects providing timelines and resources required. Involved in SQL tuning using SQL-Trace, Explain plan utilities.
• Responsible writing UNIX Shell scripts.

Environment: Oracle 9i, Sql*Loader, Pl/Sql, Toad, UNIX Shell Scripting.