SUMMARY

• 7+ years of extensive IT experience in 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 and SQL* Net.
• Extensive experience in application data modeling and building data warehouse architecture (Star & Snowflake schemas) and ER Diagrams using Erwin.
• Extensively worked in PL/SQL for creating stored procedures, clusters, packages, database triggers, exception handlers, cursors, cursor variables, ref-cursors and PL/SQL test cases.
• Extensively Worked on Oracle Database creation, Tablespace management, (Export & Import) Backup, Performance tuning, Tuning Init.ora file.
• Experience in working on Oracle Discoverer
• Creating OLAP Worksheets, Modifying OLAP Worksheets.
• Knowledge of data modeling techniques includes virtually every flavor of Entity-Relationship (ER) modeling, Physical and Logical data modeling.
• Strong exposure in writing simple and complex SQL, PL/SQL Functions and Procedures, Packages, Triggers, Materialized views etc.
• Proficiency in using Analytical functions, UTL FILE and DBMS LOB packages.
• Experienced in environments requiring direct customer interaction during design specification, development, and acceptance testing and implementation phases.
• Proficiency in solving issues after an application release in production.
• Capable in leading a team by providing them direction, knowledge transfer and assistance in work.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels.
• Ability to learn new technologies at rapid speed.
• Extensively usedOracledata warehousing features such as materialized views, bitmap indexes, Index Organized Tables, external tables etc.
• Hands on experienced in Tuning SQL Statements using Execution Plan, HINTS, TKPROF and Procedures for enhancing the load performance in various schemas across databases.
• Expert in Database Optimization by making use of various Performance Tuning techniques.
• Experienced in User Acceptance Testing (UAT), Unit testing, System testing, Integration testing, Development and Production.
• Ability to handle multiple tasks and demonstrate initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.
• Excellent written and oral communication skills with a result-oriented attitude.
• Proven ability to interface and coordinate with cross functional teams and cultures, analyze existing systems, wants and needs, design and implement database solutions.

TECHNICAL SKILLS

Programming: C, Java, SQL, PL/SQL, TCL, AWK, XML

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

Tools: SQL* Plus, Toad, SQL* Loader, SQL Developer, Oracle Developer, Oracle 10g XE, Text Pad, Erwin

Data Modelling: Dimensional Data Modelling, Star Schema Modelling, Snow-Flake Modelling, Fact and Dimensions Tables, Physical and Logical Data Modelling

Version Control: PVCS, Open Source CVS

Web Servers: Tomcat, IIS

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

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

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 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, 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, 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, Oracle 10gR2, 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.
• 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.
• 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, ERwin, Windows XP, UNIX.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Automated Shell scripts to pull and load data from operational resources into the Data Staging Area and Data Warehouse for business intelligence reporting
• Produced Scripts to cleanse source data, ETL process (Extract, Transform & Load) data with business rules, and built re-usable Mappings.
• Used Toad Pro for developing Stored Procedures as IDE to interact with the Oracle 9i/8i Database.
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Trace sessions
• Developed views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area.
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data from the Data repository using cursors and exception handling.
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Optimized critical queries to eliminate Full Table scans.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in Gathering and Analyzing Business requirements with product management for new release cycles
• Wrote Integrity Checks to clean erroneous data using PL/SQL procedure and Shell Scripts.
• Used Rational Unified Process in obtaining the generic code samples and determining the key processes.

Environment: SQL, SQL*Plus, PL/SQL, SQL*Loader, Export/ Import, Oracle Web Application Server, CVS, Toad, Oracle, Sun Solaris with Windows, XML