SUMMARY

• Around 8+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, and maintenance with timely delivery against aggressive deadlines.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in Client - Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*DEVELOPER..
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Rewrite and Transportable tablespaces.
• Strong experience in Data warehouse concepts, ETL.
• Good knowledge on logical and physical Data Modeling using normalization Techniques.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables using range partition technique.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Cognos.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Databases: Oracle 7.x/8i/9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER 2000/2005/2008 , DB2/UDB, Teradata, SAP Tables and MS Access.

ETL Tools: Informatica (PowerCenter 5.1/6.2/7.1/8.6.1/9.1.0 , Power Mart 5.1, Power Connect/Powerexchange for SAP R/3, MainFrame and Oracle Change Data Capture (CDC), AB Initio 1.8 and SQL*Loader.

Reporting Tools: Business Objects Developer Suite 5.1/BO XIR2, Cognos Suite, Cognos Report Net 1.1MR2, Crystal Reports, Oracle Reports 2.5

Operating Systems: UNIX (Sun Solaris, LINUX, HP UNIX, AIX), Windows NT/98/95/2000 & Windows XP.

Data Modeling: Erwin 3.5.2,4.0

Languages/Utilities: SQL, PL/SQL, Unix shell scripts, Java, XML, C and Cobol.

Other Tools: AutoSys, Control-M, PVCS, WINCVS, Informatica Data Quality, B2B Data Transformation, Informatica Power Exchange Informatica 9.1.0 Developer/Analyst, TPump, Fast Load, BTEQ

PROFESSIONAL EXPERIENCE

Confidential - Pittsburgh, PA

Oracle PL/SQL Developer

Responsibilities:

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to process the files on a daily basis like renaming the file, extracting data from the file, unzipping the file and removing the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP

Confidential - Raleigh, NC

Sr. PL/SQL Developer

Responsibilities:

• Developed advanced PL/SQL Packages, Procedures, Triggers, Functions, Indexes and Collections to implement business logic using SQL Navigator.
• Generated server-side PL/SQL scripts for data manipulation and validation for remote instances.
• Involved in creating Unix Shell Scripting. Defragmentation of Tables, Partitioning, compressing and Indexes for improved performance and efficiency.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DBMS SQL and PL/SQL collections and used BULK binding involved in writing database procedures, packages and functions for the front end module.
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in System Development Life Cycle.
• Used principles of Normalization to improve the performance.
• Responsible for testing database program applications.
• Involved in ETL code using PL/SQL in order to meet requirements for Extract, Transformation, Cleaning and Loading of data from source to target data structures.
• Plans data integration process by developing common definitions of sourced data.
• Delivers data integration by implementing shared databases
• Filtered and Loaded data from different formats of data sources into database tables.
• Involved in the continuous enhancements and fixing of production problems.
• Worked closely with the Application Development teams to identify and implement continuous improvements and effective problem resolution strategies.
• Responsible for developing test plan procedures by coordinating with QA Analysts.
• Provided the Production and Technical support for the users.

Environment: Oracle 11g, 12c, SQL PLUS, PL/ SQL, SQL *Loader, TOAD, SQL Developer, Shell Scripts, UNIX, Pro*C, Windows XP, MS-Excel