Summary of Qualifications :

• Over Seven (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 Life Cycle (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. Hands on experience with REF Cursors and Dynamic SQL
• 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 of Crontab in UNIX environment for scheduling routine tasks
• 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
• Over 6 years of experience in developing ETL (Extraction, Transformation and Loading) procedures and Data Conversion Scripts using Pre-Stage, Stage, Pre-Target
• Used Informatica Power Center 8.6 in data warehousing projects
• 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
• Proficiency with Flex and JSP struts development
• Worked with the technical teams and DBAs for issues related to code changes, data fixes, and testing
• Possess excellent communication, interpersonal and presentation skills

Technical Competencies :

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 :

Role: Sr. Oracle PL/SQL Developer

Roles & 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
• Have good experience in ETL/Oracle environment as PL/SQL Developer using most of the Oracle related tools under UNIX and Windows environments.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time. Extensively used Informatica debugger to find out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Proficiently developed new Packages, Functions, and Stored Procedures 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 granted privileges 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 Explain Plan 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, Materialized Views, 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 UNIX platform
• 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

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

Role: Oracle PL/SQL Developer

Roles & 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
• Involved in ETL development for the data warehousing projects and created pre-stage, stage and target tables using transformations.
• 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
• Did query 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: Oracle 11g, HP-UX 11/11i, ERWIN 4.0, TOAD 9.6, ClearCase

Confidential, RI

Role: SQL Developer

Roles & 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
• Developed new and modified existing Packages , Procedures and Functions as 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 Dynamic SQL 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

Role: SQL Developer

Roles & 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

Role: SQL Developer

Roles & 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.