SUMMARY:

• 7 yearsof programming experience asOracle PL/SQLDeveloper in Analysis, Design and Implementation of applications using Oracle Relational Database Management System (RDBMS).
• Experience in all phases of theSDLC with timely delivery against aggressive deadlines.
• Good knowledge on logical and physicalDataModelingusingNormalizing techniques.
• Excellent technical and analytical skills with clear understanding of design goals of ERmodeling for OLTPand dimension modeling forOLAP.
• Experience in Client - Server application development using Oracle11g/10g/9i/8i, Pl/SQL, SQL*plus, Toadand SQL*loader.
• Specialized in Oracle storedProcedures, Functions, Packages, Triggers, Records, Arrays, Collections, Nested Tables, Views, Materialized views Cursors, REF Cursors and Exception handling
• Extensive experience in MS SQL Server 2008 … working with business intelligence SSIS (SQL Server Integration Services)
• Experience in Creating highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Look Up, For Each Loop, Multi Cast, Fuzzy Grouping, Script Components.
• Experience in scheduling Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.
• Transformed database objects from one server to others server using SSIS.
• Migrated XML scripts into SQL server 2008 forming sequenced tables.
• Experience in creatingIndexes, Table Partitioning, Collections, Materialized Views, Views and Constraints.
• Experience in creating database objects likeStored Procedures, Stored Functions, Packages, Type objects and Triggers using SQL and PL/SQL.
• Experience inOracle supplied packages, DynamicSQL, Records, PL/SQL Tables and ExceptionHandling.
• Extensively worked onCursors, Ref CursorandCollections.
• Experience with Oracle performance features such asQuery Optimizer, Execution PlansandIndexes.
• Experience withPerformance Tuningfor Oracle RDBMS usingExplain PlanandHints.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, UNIX Shell Scripting, Perl

Database: Oracle 10g/11g, MS SQL Server 2008

IDE Tools: TOAD, SQL Developer, PLSQL Developer

Database Tools: SQL Plus, SQL * Loader, SSIS

Operating Systems: Windows XP/7, SUN SOLARIS, IBM AIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Norfolk, VA

Oracle PL/SQL Developer

Responsibilities:

• Wrote PL/SQLstored procedures, functions and packagesfor moving data and load intoClaims Tables.
• Wrote sequences for automatic generation of unique keys to supportprimary and foreign key constraints in data conversions.
• Created PL/SQL programs using collections, record types, object types, with clause.
• Worked on Oracle pseudo columns like rowid, rownum, sysdate etc.
• Involved in working with implicit cursors, explicit cursors, ref cursors.
• Created and modifiedPL/SQLscriptsfor data conversions.
• Used advanced bulk techniques (for all, bulk collect) to improve performance.
• Used various Oracle PL/SQL collections varrays, nested table, associative arrays with index by binary integer.
• CreatedPackagesandProceduresto automatically drop table indexes and also to create indexes for the tables.
• Performed various SSIS tasks such as Conditional Split, Derived Column on the data retrieved,Performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse
• Extracted large volumes of data from different data sources and loaded the data into target data by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Designed SSIS Packages to transfer data between servers, load data into database, and archived data file from different DBMS using SQL enterprise manager on SQL server 2008 environment.
• Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions using SQL server
• Scheduled the jobs to streamline and automate cumbersome repeated tasks using SSIS.
• Developed, deployed and monitored SSIS packages. Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio
• Extensively used parallel hints during Sql optimization to fast up the sql process.
• Created database objects liketables, views, materialized views, procedures and packages.
• Handled errors usingexception handlingextensively for the ease of debugging and displaying the error messages in the application.
• Automated QualityCheck tasks by creating pl/sql procedures, cursors, functions and dynamic SQL.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL Server Integration Services (SSIS), Visual Studio 2008, MS SQL Server 2005, AIX, TOAD and SQL Developer

Confidential, Louisville, KY

Oracle PL/SQL Developer

Responsibilities:

• Worked with front end design team to provide them with necessary stored procedures and packages.
• Generated server side PL/SQL scripts for data manipulation and validation and created materializedviews for remote instances.
• DevelopedPL/SQL triggersfor automatic creation of primary keys.
• WrotePL/SQLstored procedures, functions and packagesfor moving data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancements in the application.
• Involved in data loading usingSql*Loader.
• Performedtuningand application tuning using explain plan, sql trace, tkprof.
• Involved in migrating database from Oracle9i to 10gdatabase.
• Involved in analysis, design and development phases of the project.
• Involved in architectural diagrams, processflows and documenting the whole system which includes data modeling.
• Involved in writing numerous pl/sql stored procedures, packages, functions and unix shell scripts.
• UsedBulk Collectionsfor performanceand easy retrieval of data, by reducing context switching between sql and pl/sql engines.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• Usedpragma autonomous transactionto avoid mutating problem in database trigger.
• Extensively used advanced PL/SQL features likerecords, tables, object typesand dynamic sql.
• Involved in the continuous enhancements and fixing of production problems.

Environment: Oracle 11g/10g, SQL, PL/SQL, Linux, AIX, SQL*Loader, TOAD

Confidential, Louisville, KY

Oracle PL/SQL Developer

Responsibilities:

• Involved in gathering requirements from end users.
• Created tables, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Createdviewsto facilitate easy interface implementation and enforce security oncriticalcustomer information.
• Created stored procedures and triggers to facilitate consistent data entry into the database.
• Created DatabaseTriggers for audit and validation.
• Involved in performance tuning using explain plan, sql trace and tkprof utilities.
• Created and manipulated storedprocedures, functions, packages and triggers.
• Wrote heavy storedprocedures using dynamicSql to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Involved in data conversion of MS Excel data into oracle tables using sql*loader.
• Involved in creating different complex joins according to user requirements.
• Extensively used materialized views, dynamic sql, cursors, bulk collections.
• Worked with sql*loader for bulk load processing.
• Developed backend interfaces using PL/SQL stored packages, procedures, functions, collections and triggers.
• Created integrity constraints and Database Triggers for the data validations.
• Tuned several Oracle SQL statements using explain plan, sql trace utilities.
• Worked on externalhints during the sql optimization to fast up the sql process.
• Worked on databasesecurity by authenticating users, using logon triggers.
• Wrote test cases and involved in unit testing.

Environment: Oracle 11g, Sql*Plus, Toad, Sql*Loader, AIX, Linux, PL/Sql Developer, Shell Scripts, Unix, Windows XP.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Designed logical and physical data models for star and snowflake schemas usingErwin.
• Developed and modifiedtriggers, packages, functionsandstored proceduresfor dataConversionsand PL/SQL procedures to create database objects dynamically based on user inputs.
• WroteSql, Pl/Sql, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Createdindexes on tables to improve the performance by eliminating the full table scans.
• Fine-tuned procedures/Sql queries for maximum efficiency in various databases using Oracle hints, Rule based optimization.

Environment: Oracle 9i, 10g, SQL*Plus, PL/SQL, Erwin 4.1, Windows 2000, Toad.