PROFESSIONAL SUMMARY:

• Over 8 years of extensive IT experience in all aspects of Systems Development and complete Project Life Cycle in Oracle PL/SQL including requirements, Analysis, Design, Development, Testing and Implementation.
• Extensively worked in Client - Server application development using Oracle 8.0/8i, 9i, 10/g, PL/SQL and SQL *PLUS, Reports 2.5/3.0/6i and SQL* Net.
• Extensive experience in application data modeling and building data warehouse architecture (Star & Snowflake schemas) and ER Diagrams using Microsoft Visio, Erwin and IBM Rational Rose data modeler tool.
• Extensively worked in PL/SQL for creating stored procedures, clusters, packages, database triggers, exception handlers, cursors, cursor variables.
• Extensively Worked on Oracle Database creation, TableSpace management, (Export & Import) Backup, Performance tuning, Tuning Init.ora file.
• Working knowledge of SQL Trace, TK-Prof, Explain Plan, Pro*C, SQL Loader for performance tuning and database optimization.
• Extensively worked in writing PL/SQL stored procedures, database triggers, exception handlers and cursors and ref-cursors and PL/SQL test cases.
• Experienced in working with many complex SQL queries with joins, date functions, inline functions, cursors, ref cursors, collections, partition tables, external tables, materialized views, sub-queries and analytical queries to generate reports.
• Expert in maintaining data integrity using various constraints and database triggers.
• Expertise in data migration both within the (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:

Languages: C#, Java, XML

Databases: Oracle 9i/10gR2/11g, MS SQL Server 2000, MS Access

Tools: SQL* Plus, Toad, SQL* Loader, SQL Developer, Oracle DeveloperBusiness Objects XI R2, 3.1, Crystal Reports, MS Visio, Text PadErwin, Informatica 8.5

Version Control: PVCS, Open Source CVS

Web Technologies: HTML, CSS, XML, JavaScript

Web Servers: Tomcat, IIS

Operating Systems: UNIX, Solaris, Windows 95/2000/NT/XP

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, CT

Sr. PL/SQL Developer

Responsibilities:

• Actively participated in gathering and analyzing Business Requirements, Creating Directives, Data Analysis, Design, Development, Conversion, System Testing, Operational Readiness, Documentation, Production support issues.
• Created DDL Scripts using Forward Engineering in Erwin to create tables in Database and also used Reverse Engineering to create Data Models with already existing tables.
• Wrote Database Triggers, Functions and Stored Procedures using PL/SQL to enforce business rules.
• Designed STAR Schemas using Dimensional Modeling and created fact tables and dimensional tables.
• Created Stored Procedures, Functions to transform the data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
• Created multiple Web Intelligence reports using various Business Objects XI R2 functionalities
• Created different Logical data models and Physical data model using Erwin.
• Working extensively on SQL, PL/SQL to implement the logics to meet the business requirements.
• Extensively utilized PL/SQL Cursors, REF Cursors, Collections features to perform ETL load from multiple-feeds of source data.
• Extensively used UTL FILE an oracle built in function to transfer data from the source system to flat files to conversion staging area.
• Extensively used Indexes, Passing Hints and Partitions for better performance of queries.
• Tuned the application using EXPLAIN-PLAN, SQL-TRACE, TK-Prof utilities.
• Used oracle built in function DBMS SCHEDULER to run jobs in parallel to improve time-constrained performance.
• Responsible for automated UNIX Shell script jobs using Cron jobs.
• Created Cron Jobs to perform regular updates to the data warehouse database.
• Responsible for data conversion activity for System Integration and User acceptance testing.
• Involved in Production Support to resolve end-users data related report issues.

Environment: Oracle 9i, SQL, PL/SQL, Business Objects XI R2, TOAD, ERwin, Windows XP, UNIX, PVCS.

Confidential, Hartford, CT

PL/SQL Developer

Responsibilities:

• Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.
• Designed Physical and Logical Data model and Data flow diagrams.
• Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Tablespace.
• Involved in writing several Queries and Procedures.
• Built database objects like Tables and Views.
• Involved in the Database Design (Relational and Dimensional models) using ERwin.
• Defined both logical views and physical data structure using ERwin.
• Converted all Oracle ETL Packages to Informatica Mappings and created workflows/Sessions.
• Developed Informatica Mappings using various Transformations and PL/SQL Packages to extract, transformation and loading of data.
• Filtered and Loaded data from different formats of data sources into Database Tables.
• Extracted required data from the database tables and exported the data to different sources in different formats.
• Worked with several tools to access and perform several operations on database.
• Experience in Generating Reports.
• Developed Data entry, query and reports request screens and tuned the SQL queries.
• Used joins, indexes effectively in where clauses for Query optimization.
• Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.

Environment: Toad, SQL* Plus, SQL* Loader, Oracle 10g, MS SQL Server, Informatica 8.5, ERwin, Windows XP, UNIX.

Confidential, Wilmington, Delaware

PL/SQL Developer

Responsibilities:

• Involved in SDLC gathering requirements from end users.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Wrote Stored Procedures using PL/SQL and functions and procedure for common utilities,
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Developed Database Triggers for audit and validation purpose.
• Used pipelined functions for faster data accessibility.
• Writing validation packages using PL/SQL package.
• Used PL/SQL to validate data and to populate billing tables.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Developed Installation scripts for all the deliverables.
• Performed functional testing for the procedures and packages.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Involved in migrating database from oracle 9i to 10g database.

Environment: Oracle 9i/10g, SQL, PL/SQL, Toad, SQL*Loader, SQL Navigator, Caliber, CVS, Eclipse, Quality Center, Dimensions, Windows 2000 server

Confidential, Atlanta, GA

Oracle Pl/SQL Developer

Responsibilities:

• As a team member interact with Business Analysts, Data architect and client representatives for requirements gathering, research and solving client specific data issues.
• Involved in the Database Design Relational models using ERwin.
• Created different schemas and maintained schema objects.
• Created Data Mart with complete Start Schema for OLAP Reporting.
• Wrote PL/SQL Overloading Stored Procedures, Functions, Packages and Package Constructors to enforce Business rules
• Extensively used EXTERNAL TABLES for data conversion in staging area before loading the data into the respective dimensional tables and fact tables.
• Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions.
• Created control file scripts and used SQLLDR to load data into the staging table.
• Implemented complex Interface business rules using Oracle Database Triggers constructs.
• Utilized Partitions to fine-tune SQL data load.
• Extensively used INDEXES AND HINTS for better performance of queries.
• Optimized SQL and PL/SQL performance using Oracle utilities like Explain Plan, SQL-Trace Analysis and TK-Prof
• Extensively wrote UNIX Shell scripts to automate the data load from SQLLDR to staging table.
• Used Toad as an advanced SQL - PL/SQL editor. Built and tested scripts, PL/SQL packages, procedures, triggers, and functions. Creating and editing database tables, views, indexes, constraints, and users. Used for quick access to the Schema Browser.
• Involved in generating WebIntelligence Reports to satisfy Ad-Hoc request.
• Participating in code walk through and review sessions with the Development team and QA team.

Environment: Oracle 9i/10g, SQL, PL-SQL, CVS, TOAD, Microsoft Visual Studio, Business Objects XI 3.1, ERwin, Windows XP, UNIX.

Confidential

Jr. PL/SQL Server Developer

Responsibilities:

• Developing packages, procedures, functions, and triggers for the application.
• Using UNIX environment for performing the testing
• Performing the tests on the newly coded procedures and documenting the same.
• Writing technical documents using the functional specifications.
• Writing PL/SQL code using the technical and functional specifications.
• Creating Oracle objects like tables, types, packages, procedures and functions.
• Automated SQLLDR using shell scripting.
• Automated data fetch using UNIX shell script.
• Optimized the queries to improve the performance of the application.

Environment: Oracle 8.3, SQL * Plus, TOAD, SQL*Loader, Forms 4.5 & Reports3.0 and Windows 2000 professional, UNIX shell scripting.