SUMMARY

• 8+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using Oracle Relational Database Management System (RDBMS).
• Extensive experience in working on SQL and PL/SQL Programming.
• Excellent experience in working on UNIX Shell Scripting.
• Excellent experience in working with multiple relation databases Oracle, DB2, Teradata & SQL Server.
• Expertise in Client - Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL*PLUS, TOAD and SQL*LOADER.
• Well versed with the dataset concepts like Functions, Indexes, Table Partitioning, Ref Cursor, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Good experience in Performance tuning of Database objects like Packages and Procedures.
• Developed complex database objects like Stored Procedures, Functions, Packages and Triggers.
• 3+ years of experience in Pro*C programming.
• Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and Clients.
• Involved in all phases of SDLC with timely delivery against aggressive deadlines in Finance, Banking, Manufacturing and Health sectors.
• Strong experience in Data warehouse concepts and principles Star Schema, Snowflake, Surrogate Keys, Normalization/De-Normalization.
• Worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Expertise in Dynamic SQL and Exception handling.
• Extensive experience with Business Intelligence Tools like Oracle Discoverer, Business Objects and XI Web Intelligence.
• Very good knowledge in FTP & SFTP setup in various UNIX and Linux environments.
• Extensively worked on monitoring tools like Control-M and Autosys.
• Good knowledge on logical and physical Data Modeling using Normalizing Techniques for designing database with Relational Technology on N-Tier Architecture.
• Very good knowledge in using version control tools like Subversion (SVN), Revision Control System (RCS) and Microsoft Visual Source Safe.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluation transformation.
• Involved in migrating flat files to Oracle and DB2.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Excellent Team Player to work in conjunction with testers (QA and offshore), developers and other team members in validation and testing of complex project scenarios and in the maintenance of Quality Standards of products.
• Strong Analytical and Problem Solving skills, Multi-Tasking abilities with proven experience in utilizing people and process knowledge to assist enterprises in making critical decision.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2005/2000, Sybase, DB2, Teradata

ETL Tools: Informatica 9.1.6/8.6.1/8.5.1 (Power Center)

Data Modeling: Erwin 8.1/7.3 and Visio 2007

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, IBM AIX, Sun Solaris, LINUX, Windows NT/95/98/2000/XP

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, Pro*C, C & C++, Java and XML

Tools: Oracle Forms & Reports, Toad, SQL*Loader, BMC Control-M, Autosys, Subversion, Revision Control System, Microsoft Visual Source Safe.

PROFESSIONAL EXPERIENCE

Confidential, WI

Sr. PL/SQL Developer

Responsibilities:

• Created and modified UNIX Shell Scripts according to the changing needs.
• Worked on SQL*Loader to load data from flat files obtained from various systems.
• 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 and queries for new enhancement in the application using TOAD.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Analyzed existing reporting platforms.
• Involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Partitioned the fact tables and materialized views to enhance the performance.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: s: Oracle 11g, SQL*Plus, TOAD, ER-WIN, SQL*Loader, BI Publisher, SQL Developer, UNIX, Windows XP

Confidential, NC

Sr. Oracle PL/SQL Developer

Responsibilities:

• Assisted Confidential lines of business with developing complaint and maintainable technology solutions that extend existing application functionality and offer new application features to help business maximize their revenue goals.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Created database objects like tables, indexes, views, packages and procedures using PL/SQL Developer.
• Delivered solutions that are reliable, easy to maintain and meet or exceed established performance measures.
• Used advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL.
• Partitioned tables to enhance the performance.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Worked with Oracle BI Publisher for generating reports from the warehouse data.
• Documenting technical design and reviewing with Lead/Team. Modifying code modules and compile build components in development environment.
• Loading data into oracle tables using SQL*Loader.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Performed SQL and PL/SQL Tuning and application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Developed materialized views for data replication in distributed environments.
• Created Packages and Procedures to automatically drop table indexes.
• Partitioned large tables using range partition technique.
• Worked on XML to modify/create interface between systems.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: s: Oracle 11g, SQL*Plus, TOAD, ER-WIN, SQL*Loader, BI Publisher, SQL Developer, Shell Scripts, UNIX, Windows XP.

Confidential, CA

Oracle PL/SQL Developer

Responsibilities:

• Coordinated with the front end design team to provide them 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.
• Wrote UNIX Shell Scripts to process files on daily basis like renaming the file, extracting data from the file, unzipping the file, removing 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 for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created stored procedures, functions and packages for moving data from staging area to data mart.
• Created scripts to create new tables, views and queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of data to enhance database performance.
• Extensively involved in using hints to direct the optimizer to choose and optimum query execution plan.
• Created PL/SQL scripts to extract data from operational databases into simple flat text files using UTL FILE package.
• Created database objects like tables, views, materialized views, procedures and packages using Oracle tools like TOAD, PL/SQL Developer and SQL*Plus.

Environment: s: Java, Oracle 10g/11g, SQL*Plus, TOAD, HTML, Oracle Forms 9i, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP.

Confidential, CA

Oracle PL/SQL Developer

Responsibilities:

• Coordinated with the front end design team to provide them 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.
• Wrote UNIX Shell Scripts to process files on daily basis like renaming the file, extracting data from the file, unzipping the file, removing 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 for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created stored procedures, functions and packages for moving data from staging area to data mart.
• Created scripts to create new tables, views and queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of data to enhance database performance.
• Extensively involved in using hints to direct the optimizer to choose and optimum query execution plan.
• Created database objects like tables, views, materialized views, procedures and packages using Oracle tools like TOAD, PL/SQL Developer and SQL*Plus

Environment: s: VB6, Java, Oracle 10g/11g, SQL*Plus, TOAD, HTML, Oracle Forms 9i, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP.

Confidential, PA

PL/SQL Developer

Responsibilities:

• Used Oracle JDeveloper to support JA Built complex queries using SQL and wrote stored procedures using PL/SQL in Various API’s like Java, .Net and Hierarchical databases like Oracle and Access.
• Developed and modified a number of Forms and for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
• Wrote Shell Scripts for Data Loading and DDL Scripts.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Performed Database Administrations of all database objects including tables, clusters, indexes, views, sequences, packages and procedures.
• Implemented 10g and upgraded the existing database from Oracle 9i to 10g.
• Involved in Logical & Physical Database Layout Design.
• Set-up and Design of Backup and Recovery Strategy for various databases.
• Performance tuning of Oracle Databases and User Applications.
• Used DTS Packages as ETL tool to load data into the staging tables.
• Provided user training and production support.
• Improved the performance of the application by rewriting the SQL queries.

Environment: s: Java, Oracle 9i/10g, SQL, PL/SQL, Forms 9i, Reports 9i, SQL*Loader, SQL Navigator, Crystal Reports, TOAD.

Confidential, IN

PL/SQL Developer

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Designed logical and physical data models for star and snowflakes schemas using ERWIN.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PLSQL procedures to create database objects dynamically based on user inputs.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Conducted several transition meetings with Development team.
• Involved in writing Functional and Technical documents.
• Designed Data Modeling, Design Specifications to analyze Dependencies.
• Created indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints for Rule based optimization.
• Created some Custom reports and forms for the end users to check the details and errors.

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

Confidential

Jr. 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. Involved in GUI designing using Oracle Developer 10g.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Written 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.
• Written validation packages using PL/SQL package. Used PL/SQL to validate data and to populate billing tables. Using Shell Scripting Perl/sh/awk.
• Used advanced Bulk technologies (FOR ALL, BULK COLLECT) to improve performance. Developed installation scripts for all the deliverables.
• Performed functional testing for different Oracle Forms application functionalities.
• Wrote heavy stored procedures using Dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.

Environment: s: Java, Oracle 9i/10g, SQL, PL/SQL, Forms 9i, Reports 9i, SQL*Loader, SQL Navigator, Crystal Reports, TOAD.