EXPERIENCE SUMMARY:

• 8+ years of experience in analysis, design, documentation and development of custom applications using Oracle SQL and PL/SQL, working on various versions including Oracle Database 8i/9i/10g and 11g.
• Experience with all phases of the Software Development Life Cycle (SDLC) including analysis, Physical and Logical Design, Code Development, Testing, Implementing and Maintenance.
• Extensive knowledge of Relational Database Management Systems (RDBMS).
• Worked with oracle database development for 4+years in different projects.
• Proficient in developing SQL scripts, 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 of Crontab in UNIX environment for scheduling routine tasks.
• Experience with both Online Analytical Processing and Online Transactional Processing.
• 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.
• Experienced with agile and waterfall methodology.

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++, java script, XML, HTML, T-SQL, . NET.

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, MS Virtual SourceSafe, Informatica 9.5.1, Microsoft Visual Studio.

PROFESSIONAL EXPERIENCE:

Confidential, NY

PLSQL/ETL Developer

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.
• Helped in designing and building data models using Embarcadero-ER studio.
• Analyzed big data for genomics using PERL scripts.
• 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 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.
• Experienced developing oracle forms based on views, tables and procedures in tabular and form layouts.
• Experience in Exception handling and experienced in agile environment.
• 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.
• Worked with HTML development for the part of a project.
• Implemented SQL Cache dependency techniques in .NET for performance optimization.
• Extensively used TOAD for development and administration of various relational databases objects.
• Strong experience in Data Warehousing and ETL using Informatica Power Center 8.6.
• Proficiently used, created, and maintained various codes and SQL scripts on different branches of Clear Case (Version Control).
• Experience with Extreme Programming using Agile Methodologies.

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

Confidential, Providence, RI

Oracle PLSQL Developer

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 scripts queries and sub-queries using TOAD 9.6.
• Involved in creating Logical and Physical Models using ERWIN 4.0and Power Designer.
• 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 tuning 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.
• Used Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Maintaining different versions for DDL extract of schemas and applications files (version control) using Tortoise SVN.
• Coordinated with teammates while working with Java scripting and JSP.
• Attended daily walkthroughs, and status meetings.

Environment: Oracle11g, HP-UX 11/11i, ERWIN 4.0, TOAD 9.6, Tortoise SVN, Informatica Power Center 8.6.

Confidential, RI

PLSQL Developer

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 the 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.
• Used SQL*LOADER and UTIL file loader to upload bulk data by writing scripts for the Control file.
• 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, HTML, MS Visual SourceSafe 2005.

Confidential, Houston, Texas

PLSQL Developer

Responsibilities:

• Analyzed data to check for Data Integrity and Referential Integrity when loaded to source-staging tables.
• Created tables to capture errors and data that failed Validation Checks.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc in Staging and Destination schemas.
• Used direct path loading via SQL*Loader/ SQL INSERT statement, create table as select statements, table spaces, parallelized SQL statement execution where appropriate tables.
• Developed a package with stored procedures, functions and database triggers for transferring the date from Source to warehouse.
• Developed dynamic SQL used in procedures and function for the data extraction and loading process.
• Developed Informatica Mappings using various Transformations and PL/SQL Packages to extract, transformation and loading of data.
• Created dynamic procedures to drop and create Index for the Staging environment to facilitate faster loading of data.
• Used Toad Modeler to create the architect.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.
• Worked with DBA’s in setting up and refreshing the various Test Environments like DEV, IST and UAT.
• Collected all impacted modules from all developers and prepare the deployment script for production release.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid and invalid data into error tables.
• Involved in the database administration and creating objects such as database, users, and schema and table spaces.
• Used JavaScript for client side validations.

Environment: Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell script, TOAD, UNIX, Windows XP/2000.owb 10g, Javascript.

Confidential

PLSQL Developer

Responsibilities:

• Involved in the design and development of user interface (GUI) in Forms 4.5 and table design using Oracle.
• Developed various Business and ad-hoc Reports.
• Created Data Flow Diagram, Entity Relationship Diagram from Designer.
• Involved in writing PL/SQL Triggers, Procedures, Functions and Packages.
• Various stored procedures were written to achieve the back end functionality.
• Involved in Development, Testing, Implementation and .
• Involved in System Coding, Data conversion, Development and Implementation of External Tables to extract data from the flat files.
• Developed Functions & Procedures to manipulate the data and to load to the tables.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming, and Oracle Partitioning to extract data from large database.
• Created Database Triggers in PL/SQL to accommodate for data integrity and additional Referential Integrity.
• Migration from Oracle 9i to Oracle 10g.
• Developed KornShell Scripts to ingest data on a daily basis from external source (flat file).
• Involved in developing UNIX shell scripts required for maintaining and processing job.
• Involved in Package modifications to reflect the changes.
• Importing/Exporting data from/to different databases using utilities like SQL*Loader, Import/Export.
• Involved in export and import at schema level.
• Developed forms and reports using Forms 9i/10g and Reports 9i/10g
• Created Object Types in PL/SQL.
• Performed customization on existing Forms appearance, validation logic, and behavior and incorporating new functionalities for control purpose.
• Responsible for Analysis, Design, Development/Customization and Testing/debugging of the reports.

Environment: Oracle 9i, Sun Solaris 2.5, Server Manager, SQL* Plus, SQL*Loader and Developer 2000.