SUMMARY:

• 8+ years of IT experience as an Oracle PL/SQL developer with expertise in exhaustive analysis and development of PL/SQL stored procedures, functions, packages and triggers.
• Extensive Programming experience in designing reports using Reports 10g/9i/6i, Discoverer 10g/4i, XML Publisher and designed user interfaces with Forms 10g/9i/6i.
• Extensive working experience in database objects like creating tables, views, indexes, sequences, primary key, foreign keys and constraints
• Well versed in using Views, Materialized view, Synonyms, Indexes, Joins, Sub - queries, Merge statement, Ref cursor, Table Partitioning, Global Temporary Table.
• Extensively used Cursors, Ref Cursors, System Ref. Cursor, Exceptions and Anonymous blocks for generating reports
• Experienced with usage of SQL*Loader through shell scripts as well as independently
• Experienced in environments such as SQL*Plus, TOAD and SQL*Developer
• Experience in Performance Tuning, Optimization using HINTS, EXPLAIN PLAN, TKProf, DBMS PROFILER.
• Experienced with the ETL process of moving the data from the source systems to the data warehouse using external table, staging table.
• Good experience in UNIX Shell Scripting.
• Strong understanding of the Data Warehouse, Data model and RDBMS concepts.
• Excellent communication and interpersonal skills with the ability to manage responsibilities individually or as part of a team
• Demonstrated high learning ability with regard to new skills such as programming languages and application tools/software.

TECHNICAL SKILLS: 

Operating Systems: Windows 98/NT/2000/XP/2003, MS-DOS, UNIX

Languages: SQL, PL/SQL, Shell Scripting, XML, Delphi, C, C #, HTML

RDBMS: Oracle 9i/10g/11g, MS Access

GUI: Oracle Forms 6i/9i/10g, Oracle Reports 6i/9i/10g, Crystal Report, XML Publisher

Utilities: Toad, SQL*Plus, SQL*Loader, Tkprof, PUTTY, MS Office, WinSCP, SQL Developer, EditPlus, UltraCompare, HPSM.

PROFESSIONAL EXPERIENCE:

Confidential, Monroeville, PA

Oracle PL/SQL Developer

Responsibilities:

• Worked in development, testing and production environment using packages, stored procedures, functions.
• Supported the applications in production environment based on Oracle Forms, Reports, Oracle database and the UNIX server.
• Experienced in resolving the issues in production environment.
• Analyzed the specification to suggest the right solutions based on client requirements.
• Created the database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus and Toad.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays) and Error Handling.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Worked on Dynamic SQL and PL/SQL block in PL/SQL.
• Scheduled the jobs using Cron jobs, DBMS Scheduler.
• Modified the various existing packages, procedures, functions and triggers according to the new business needs.
• Developed triggers and packages to delete stored session data from various tables.
• Used SQL Loader and wrote control file scripts to load data from flat files to Oracle tables.
• Used merge statement, Global Temporary table extensively.
• Worked on SQL tuning using hints, explain plan, Tkprof.
• Created, modified and tested SQL scripts.
• Wrote various kinds of SQL queries involving Correlated Sub queries, UNION, Inner and Outer Joins
• Developed UNIX Shell Scripts to execute procedures and publish the files.

Environment: SQL, PL/SQL, Unix Shell Scripting (ksh), Oracle 10g, SQL*Plus, Oracle Forms, Oracle Report, SQL*Loader, Tkprof, PUTTY, Smar Term, EditPlus, UltraCompare, HPSM

Confidential, MI

Oracle PL/SQL Developer

Responsibilities:

• Designed, developed and tested software using Agile Methodology.
• Involved in daily stand up meeting and weekly demo for each sprint.
• Worked in development, testing and production environment using packages, stored procedures, functions.
• Developed application and database triggers, functions, procedures, and packages in PL/SQL, Oracle11g as back-end.
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL Developer.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), Table Partitioning and Error Handling.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Worked on Dynamic SQL and PL/SQL block in PL/SQL.
• Worked on modifying various existing packages, procedures, functions and triggers according to the new business needs.
• Used merge statement, Global Temporary table extensively.
• Developed triggers and packages to delete stored session data from various tables.
• Used SQL Loader, external tables to load data.
• Created, modified and tested SQL scripts.
• Wrote various kinds of SQL queries involving Correlated Sub queries, UNION, Inner and Outer Joins
• Involved in Performance Tuning.
• Developed UNIX Shell Scripts to execute procedures and publish the files.
• Have converted old data from Flat files to Oracle database Using SQL * Loader

Environment: SQL, PL/SQL, Oracle 11g, SQL*Plus, SQL*Loader, Tkprof, PUTTY, Unix Shell Scripting (ksh), VB.NET, Java, MS Office, Windows

Confidential, Goodlettsville, TN

Oracle PL/SQL Developer

Responsibilities:

• Analyzed the specification to suggest the right solutions based on client requirements
• Worked in development, testing and production environment using SQL, PL/SQL procedure, shell script.
• Developed application and database triggers, functions, procedures, and packages in PL/SQL, Oracle11g as back-end.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus and Toad.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), and Error Handling.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Worked on Dynamic SQL and PL/SQL block in PL/SQL.
• Worked on modifying various existing packages, procedures, functions and triggers according to the new business needs.
• Developed triggers and packages to delete stored session data from various tables.
• Used SQL Loader and wrote control file scripts to load data from flat files to Oracle tables.
• Used merge statement, Global Temporary table extensively.
• Worked on SQL tuning using hints, explain plan, Tkprof
• Created, modified and tested SQL scripts.
• Wrote various kinds of SQL queries involving Correlated Sub queries, UNION, Inner and Outer Joins
• Involved in Performance Tuning.
• Developed UNIX Shell Scripts to execute procedures and publish the files.

Environment: SQL, PL/SQL, Unix Shell Scripting (ksh), Oracle 11g, SQL*Plus, SQL*Loader, Tkprof, PUTTY, Java, MS Office, Windows XP

Confidential, Tampa, FL

Oracle PL/SQL Developer

Responsibilities:

• Worked with various functional experts to implement their functional knowledge into working procedures.
• Developed application and database triggers, functions, procedures, and packages in PL/SQL, Oracle11g as back-end.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus and PL/SQL Developer.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), and Error Handling.
• Worked on Dynamic SQL and PL/SQL block in PL/SQL.
• Worked on SQL tuning using hints, explain plan, Tkprof.
• Created, modified and tested SQL scripts.
• Wrote various kinds of SQL queries involving Correlated Sub queries, UNION, Inner and Outer Joins
• Involved in Performance Tuning.
• Have converted old data from Flat files to Oracle database Using SQL * Loader
• Wrote various kinds of SQL queries involving Correlated Sub queries, UNION and Inner & Outer Joins
• Developed UNIX Shell Scripts and PLSQL procedures to import and export data.

Environment: SQL, PL/SQL, Unix Shell Scripting, Oracle 11g, SQL*Plus, SQL*Loader, Tkprof, PUTTY, Crystal Report, MS Office, Windows XP

Confidential, Miami Beach, FL

Oracle PL/SQL Developer

Responsibilities:

• Interacting with the Business Users and Project Management for analyzing the business needs and develop Design Specification.
• Developed DDL Scripts for generating Tables, Views, and Functions etc.
• Added/Changed Tables, columns and triggers.
• Developed Views, PL/SQL procedures, functions, packages and Triggers.
• Strong analytical ability and experience in developing, testing and troubleshooting SQL Queries.
• Developed reports and modified the existing SQL reports using Reports 10g.
• Customize the reports using XML Publisher.
• Developed screens and reports using Oracle Forms 10g/Reports 10g.
• Helped the front end application developers with their queries using Forms 10g.
• Created Indexes to speed up the queries.
• Creation of Stored Procedures for Batch Processing.
• Skills and experience in a very-large-database environment
• Involved in Debugging troubleshooting Procedures, functions, packages, customizing the existing ones.
• Involved in debugging oracle problems like log files, process identification.
• Involved in Performance tuning using hints, explain plan, tkprof, dbms profiler.
• Developed SQL Loader scripts.
• Oracle-to-Oracle data loading using UNIX shell scripts and PL/SQL.
• Reporting on a weekly basis to the project manager.

Environment: SQL, PL/SQL, Unix Shell Scripting, Oracle 11g, Toad, SQL*Plus, SQL*Loader, Tkprof, PUTTY, MS Office, Win SCP, Microsoft Visio 2003, Windows 2000/XP, Oracle Forms 10g, Oracle Reports 10g, XML Publisher, SQL Developer

Confidential, Andover, MA

Oracle PL/SQL Developer

Responsibilities:

• Worked with various functional experts to implement their functional knowledge into working procedures.
• Developed application and database triggers, functions, procedures, and packages in PL/SQL, Oracle10g as back-end.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL Loader, SQL* Plus and PL/SQL.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), Table Partitioning and Error Handling.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Worked on User Exit, Dynamic SQL and PL/SQL block in PL/SQL.
• Created various Database triggers using PL/SQL.
• Involved in Performance Tuning.
• Have converted old data from Flat files to Oracle database Using SQL * Loader
• Developed screens and reports using Oracle Forms 10g/Reports 10g
• Designed and developed user interfaces for customers using Oracle 9i/10g Forms Builder.
• Wrote various kinds of SQL queries involving Correlated Sub queries, UNION, Inner and Outer Joins
• Developed UNIX Shell Scripts and PLSQL procedures to import and export data.

Environment: SQL, PL/SQL, Unix Shell Scripting, Oracle 10g, Toad, SQL*Plus, SQL*Loader, Tkprof, PUTTY, MS Office, Windows XP, Oracle Reports 10g, Oracle Forms 10g

Confidential, Alanta, GA

Oracle PL/SQL Developer

Responsibilities:

• Analyzed the Business requirements of the project by studying the Business Requirement Specification document.
• Interact with business analysts to develop modeling techniques
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Designed and implemented the interfaces for Sales Order information from legacy system to staging tables using SQL loader and wrote various procedures and function to perform validations to populate the data in the tables.
• Customized and developed Oracle Forms and Reports using Oracle Forms 6i and Reports 6i.
• Created Records, Tables, Objects, Collections (Nested Tables) and Error Handling.
• Created number of database Triggers using PL/SQL.
• Involved in Performance Tuning.
• Creation of database objects like Tables, Views, Procedures, Packages using Oracle tools like PL/SQL, SQL*Plus, SQL*Loader.
• Developed ad hoc reports using Discoverer 4i.
• Created business area, new custom folders, complex folders, summary folder, hierarchies, and item classes and list of values using Discoverer 4i.

Environment: Oracle 9i/10g, SQL, PL/SQL, Discoverer 4i, Oracle Forms 9i/6i, Reports 9i/6i, TOAD, SQL*Plus, UNIX