SUMMARY

• Over 7+ years of Programming experience as an Oracle PL/SQL Developer in Analysis, Design and implementation of Business Applications and development of client/server and multi tired applications using the Oracle Relational Database Management System(RDBMS).
• Involved in all phases of Software Development Life cycle including Analysis, Code development testing, implementation and maintenance.
• Strong exposure to writing simple and complex SQLS,PL/SQL Packages, Procedures and Functions triggers and materialized views to retrieve, manipulate and migrate complex data sets in Oracle Database.
• Implemented SQL Program to load data from Excel files, Flat files into oracle tables using utl file utilities and SQL loader.
• Good understanding of oracle Data Dictionary, Data flow diagrams and database normalization theory techniques entity relational modeling techniques.
• Proficient in applying Constraints and creating views, collections (nested tables and varrays), records, sequences and other Database objects indexes, synonyms using SQL and PL/SQL.
• Improve the performance of the slow SQL queries by implementing proper index; Used for all and Bulk collect to reduce the context switching between SQL and PL/SQL engines.
• Effectively made use of table partitioning, collections, Analytical functions.
• Expertise in Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• Proficient in making changes to the existing Database objects without impacting the other logic.
• Worked Closely with Project Management Team for Migrating Code from Lower Environment to Higher Environments.
• Actively Participated in Go - Live activities for critical B2C Applications.
• Extensively worked on Triaging Defects that are found during various Phases of Testing.
• Experience in the Client server application development using Oracle 11g/10g/9i, forms 9i/6i/, reports 10g/6i/6.0,PL/SQL, SQL*PLUS, TOAD, SQL*LOADER.
• Worked extensively on ref cursor, explicit cursor, External tables and collections.
• Highly skilled in Performance tuning - analyzing query plans and query tuning using the tools such as Explain plan and use hints whenever required.
• Experience in Oracle supplied packages dynamic SQL, Records, DBMS SQL, DBMS JOB, UTL FILE and Exception handling.
• Experience in UNIX shell scripting.
• Excellent analytical, problem solving, Communication and inter personal skills and interact with individuals at all levels.

TECHNICAL SKILLS

RDBMS: Oracle 8i/9i/10g/11g, SQL Server, MS Access.

Scripting: SQL, UNIX Shell Scripting and JavaScript.

GUI: Oracle Forms 6i/9i/10g and Reports 6i/9i/10g.

Languages: C, C++, PLSQL, HTML, UNIX Shell scripting, JSP.

Oracle Utilities: SQL Developer, SQL Navigator, TOAD, SQL plus, SQL*LOADER

Operating System: Red Hat Linux, HP UX, Microsoft Windows Server 2010

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

PL/SQL Developer

Responsibilities:

• Involved in gathering the requirements, Documenting and Built Complex queries using SQL.
• Involved in Developing/modifying pl/sql packages, procedures, functions, triggers, materialized views, sql scripts based on the business requirements.
• Involved in creation of tables, partitioning tables, join conditions, sequences, synonyms for business application development.
• Worked on like Oracle Cursor management ref cursor, collections like (nested tables, varrays ) for accessing complex data resulted from joining large number of tables.
• Worked on SQL*LOADER to load data from flat files obtained from various facilities every day.
• Created SQL*LOADER scripts to load data into temporary staging tables.
• Extensively used Bulk techniques (for all, Bulk collect) for better performance by reducing context switching between SQL and PL/SQL engines.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and eliminating the complexity of the large queries.
• Handled errors effectively using exception handling for debugging and displaying error messages in the application.
• Used Oracle packages like DBMS STATS to collect statistics of many different kinds as an aid to improve the performance.
• Worked closely with production support team to Troubleshoot and fix any production issues.
• Partitioned the fact tables and materialized views to enhance the performance.
• Involved in writing sql sub queries with join conditions, pl/sql scripts.
• Performed sql performance tuning using Explain plan, hints and TKPROF.
• Create UNIX shell scripts according to changing needs of the project and client requirements.
• Good understanding of database objects and ability to triage issues

Environment: - Oracle 10g, UNIX, SQL,PL/SQL, SQL LOADER, Unix shell script, PL/SQL Developer and TOAD.

Confidential, Detroit, Michigan

PL/SQL Developer

Responsibilities:

• Involved in gathering requirements, Documenting and review.
• Designed/developed/modified stored procedures, functions, packages, database triggers, constraints, indexes and sequences based on business requirements.
• Used %ROWTYPE and %TYPE to define data types based on row and column respectively.
• Used Utl file Packages for writing DBMS OUTPUT messages to file.
• Used control structures like if, case, for, while loops for standard pl/sql programming.
• Processed data using both implicit cursors and explicit cursors and their attributes.
• Written complex oracle sql queries with complexity using inner/outer joins, sub queries, union all and set operators.
• Extensively used Bulk techniques (for all, Bulk collect) for better performance by reducing context switching between SQL and PL/SQL engines.
• Optimizing PL/SQL code and SQL queries using Explain plan, indexes and Hints.
• Created scripts to create new tables, views, queries for new enhancements in the application using TOAD.
• Utilized SQL*LOADER to perform bulk data load into database tables from external data files.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying errors message in the application.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Created documentation for application.
• Created shell scripts to automate the execution of pl/sql sub programs.

Environment: - Java, Oracle 11g, SQL, PL/SQL, TOAD, SQL*LOADER, UNIX.

Confidential, MayField Village, Ohio

PL/SQL Developer

Responsibilities:

• Involved in full development cycle of planning, analysis, design Development, testing and implementation.
• Involved in programming, debugging, unit and system integration testing of modules.
• Performing code review/analysis in a team environment and subsequent code testing in DEV and SIT environment.
• Wrote UNIX shell scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base table.
• Used merge statement to select rows from one or more sources for update and insertion into one or more tables.
• Generated SQL scripts for creating tables, views, primary keys, indexes, constraints, sequences and synonyms.
• Developed and modified PL/SQL Packages, Procedures, functions as per customer requirement to make new enhancements or resolve problems.
• Experience in developing dynamic SQL and ref cursors and use of immediate Execute to run the SQL statements build during runtime.
• Experience in performance tuning using Explain plan and hints. Experience with Query optimization procedures using SQL advisors in Oracle 11g.
• Loaded data into database tables using SQL*LOADER from text and excel files.
• Experience in Developing/modifying PL/SQL packages, collections and Database triggers.
• Created indexes on the tables for faster retrieval of data to enhanced at a base performance.
• Tested, Documented and provided on call support for the applications.

Environment: - Java, Oracle 10g, SQL, PL/SQL, TOAD, SQL*LOADER, UNIX.

Confidential

PL/SQL Developer

Responsibilities:

• Developed/modified tables, views, materialized views, stored Procedures, packages and functions.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Write PL/SQL Database Triggers to implement the business rules in the application.
• Implemented all modules logic by using triggers and integrity constraints.
• Developed procedures using Dynamic SQL.
• Utilized SQL*LOADER to load flat files into database tables.
• Involved in handling the changes in compiling scripts according to the database changes.
• Performed SQL tuning using Explain plan, TKPROF, Hints and indexes.
• Wide knowledge in creating tables sequences, views.

Environment: Oracle 9i, 10g, sql * plus, pl/sql, windows 2000, TOAD.