SUMMARY

• Over 7 years of extensive experience as an oracle PL/SQL Developer.
• Extensive experience in application data modeling and building data warehouse architecture (Star & Snowflake schemas) using Erwin and IBM Rational Rose data modeler tool.
• Excellent knowledge of domains including financial, communication, pharmaceutical and health care industry.
• Experienced in working with Oracle (7, 8i, 9i, 10g, 11g), DB2, MS SQL Server 2000/2005/2008 , Sybase databases on various platforms like UNIX (Solaris, AIX), Linux (RHEL, Fedora, and SUSE) and Microsoft NT/2000/2003 Server.
• Proficient in PL/SQL, writing stored procedures and custom routines.
• Involved in all stages of Software Development Life Cycle.
• Expertise in developing strategies for Data Cleansing & Migration from various operational sources into data warehouse & data marts using Oracle PL/SQL.
• Expertise in Data Warehouse programming and fulfillment of data warehouse project tasks such as data extraction, cleansing, transforming and loading.
• Extensively worked in writing PL/SQL stored procedures, database triggers, exception handlers and cursors and ref - cursors and PL/SQL test cases.
• Expert in maintaining data integrity using various constraints and database triggers.
• Expertise in data migration projects with both ( target - source ) same database as well as with heterogeneous databases.
• Proficient in interpersonal relations, team lead skills, project management, communication, outsourcing partner teamwork and organization with excellent communication and presentation skills.

TECHNICAL SKILLS

• Toad
• Oracle developer tools
• DB Artisan
• Oracle 11g/10g/9i/8i/8.x/7.x
• MS SQL server 2000/2005/2008
• SQL
• PL/SQL
• T-SQL
• SQL*Plus
• Star Schema/Snowflake Schema Modeling
• Unix Shell Scripting
• Windows 98/2000/NT/XP
• AIX5L
• MS Office.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Oracle PL/SQL Developer

Responsibilities:

• Analyzed the existing Access System and re-designed it in Oracle 10g by developing data validation and load processes using PL/SQL Stored Procedures, Functions, and Triggers to enhance and improve functionality requested by business for reducing manual processing time.
• Studied the Data Requirements and the impact analysis on the exiting schema and participated in data profiling, cleansing and migration.
• Defined Data Definitions, and created target tables in the database.
• Mapping the source and target databases by studying the specifications and analyzing the required transforms.
• Interpreted the requirements and assisted in creating different models making use of ERwin tool.
• Assisted in architecture and design of the data model in ERwin by working with the architect.
• Analyzed the functional specifications provided by the Data Architect and created matching technical specifications.
• Optimized and modified the existing Triggers, complex Stored Procedures, and Functions.
• Wrote Oracle PL/SQL Stored Procedures, Functions, Triggers, and Packages and managed Oracle
• Cursors and performed Exception Handling.
• Used SQL*Loader to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary tables into base tables.
• Used Dynamic SQL (DBMS SQL, DBMS DDL) in Functions and Procedures.
• Served as a Liaison between the business users and the software development team.
• Involved in all the phases of Software Development Life Cycle(SDLC) throughout the project life cycle and developed periodic reports using Oracle Reports 9i and screens using Oracle Forms 9i.
• Developed Oracle Forms, SQL scripts, PL/SQL Stored Procedures and Functions to provide additional capabilities.
• Assisted the testing team in developing the Test Plan, Test Cases and Test Scenarios to be used in testing.
• Was involved in ETL production support and prepared the Operational documents and troubles
• Shooting documents as per production requirements.

Confidential, Stamford, CT

Oracle PL/SQL Developer

Responsibilities:

• Analyzed existing logical data model (LDM) and made appropriate changes to make it compatible with business logic.
• Created normalized Physical Data Model (PDM) for the OLTP application using IBM Rational Rose Data Modeler.
• Identified important tables to apply Oracle Virtual Private Database (VPD) security policies to those tables.
• Wrote complex PL/SQL codes (functions, procedures, triggers) to support the application and to enhance application functionality.
• Involved in data model reviews with internal data architect, business analysts and business users and explained the data model in depth to make sure it’s in sync with business requirements.
• Defined data migration policies and documented detailed source to target mapping for data migration from existing Sybase database to target Oracle 10g database.
• Identified source systems, their connectivity, related tables and fields and ensure that data is suitable for mapping.
• Analyzed different options for heterogeneous database connectivity and defined policies for dealing with different source databases with ETL team.
• Worked with cross functional teams and prepared detailed design documents for production phase of current application decommission and building a new application.

Confidential, Overland Park, KS

Oracle PL/SQL Developer

Responsibilities:

• Conducted meetings with DBAs for preparing the database table layouts.
• Prepared the Technical Design according to the business requirements.
• Involved in identification of Facts, Measures and Dimensions.
• Created dimensions model star schemas using Kimball’s methodology schema using ERwin.
• Supported in building and maintaining Data marts, Fact Tables, Dimensions and joined them to extract meaningful data.
• Generated Surrogate IDs for the dimensions in the fact table for indexed and faster access of data.
• Created data definition language (DDL) script for creation of tables in databases.
• Created various stored procedures for removing the indexes before the data is loaded, rebuilt the indexes after the load has been completed.
• Wrote PL/SQL statements and stored procedures in Oracle for extracting as well as writing data.
• Wrote T-SQL code for maintaining existing application.
• Performed SQL tuning using STATSPACK and AWR reports.
• Created partition tables / indexes and materialized views to enhance performance.
• Loaded data into the database tables.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings.

Confidential, NYC, NY

Oracle PL/SQL Developer

Responsibilities:

• Reverse engineered the database structure from the existing application.
• Analyzed the database schema structure.
• Studied the data requirements and the impact analysis on the exiting schema.
• Analyzed the requirements and created the dimension model using ERwin.
• Defined data definitions, and created target tables in the database.
• Built some complex queries using SQL and wrote stored procedures using PL/SQL.
• Extensively worked in creating database triggers, exception handlers, and cursors.
• Mapping the source and target databases by studying the specifications and analyzing the required transforms.
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.
• Identified / documented data sources and transformation rules required to populate and maintain data warehouse content.
• Identified source systems, their connectivity, related tables and fields and ensured that the data was suitable for mapping.
• Created the Logical / Physical model of the DW tables using ERwin.
• Wrote PL/SQL Stored Procedures, Functions and Packages and Triggers to implement business rules into the application.
• Involved in Data Loading and Data Migration. Used SQL*Loader to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Developed numerous programs using PL/SQL and many packages to do the validations as per requirements.
• Created and maintained Database Objects (Tables, Views, Indexes, Sequences, Database triggers, Stored procedures etc).

Confidential, Memphis, TN

Oracle PL/SQL Developer

Responsibilities:

• The complete study of the in-house requirements for the data warehouse
• Analyzed the DW project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analyzed.
• Defined the PKs and FKs for the Entities, after providing the choices for primary key.
• Created the super type/subtype and surrogate key tables to map the required dimensions.
• Defined the relationships and cardinalities between different entities.
• Created dimensions model star schemas using Kimball methodology and designed them using Rational Rose Data Modeler.
• Created the physical databases.
• Provided 24 x 7 application supports.
• Created surrogate key tables to map the required dimensions.
• Developed various PL/SQL stored procedures, functions, packages and optimized SQL queries.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries.