SUMMARY

• Over 16 years of experience in Oracle Development and Maintenance.
• More than 5 years of Progressive Technical/Management - level Experience as Technical Lead, worked with several key positions including Developers, Systems Analyst, Quality Assurance, Compliance and Production Control.
• Extensively worked on Production Support, Maintenance and Development.
• Technically very strong in Oracle Database, SQL, PL/SQL, SQL*Loader, Developer Suite (Forms/ Reports)
• Strong Experience in building Stored Procedures, Functions, Packages, Database Triggers, Exception Handling, Sequences, Complex Views and Materialized Views (static/dynamic), External Tables, Nested Tables, Pl/Sql tables using PL/SQL.
• Experience Analyzing and Altering Execution Plan, Understanding Statistics, Identifying bad SQL Statements and Tuning the Programs by Reconstructing/Restructuring SQL, PL/SQL Program, Using Indexes and Hints.
• Experience working with Explain Plan, AutoTrace and TKProf to see Execution Plans, Statistics and dbms profiler for profiling pl/sql block to identify bad lines in the program.
• Extensively worked on both OLTP and OLTP Systems, Data warehouse, Data Marts and Reports.
• Experience in Data Modeling using Oracle Designer, Identifying the Entities, Attributes, Normalization Process, Relationship between Entities, Creating both Logical and Physical Data Model using ERWIN.
• Good understanding of Reverse Engineering to extract Data Model from and exiting database model.
• Expertise in designing and developing graphical user interface (GUI) screens using Oracle tools Developer Suite and maintaining Oracle databases.
• Experience working on Web and Client/Server Technology on Windows and UNIX Operating Systems.
• Strong Experience in Designing and Development of Client Server and Web Based Applications.
• Good Working Knowledge in MS SQL Server, Shell Scripting.
• Expertise in Functional Requirements Analysis and Implementation with excellent work ethics coupled with positive user interaction and team spirit. Can work in demanding time schedule and have good written and oral communication skills.
• Motivated self-starter with excellent technical skills, committed team player with strong communication skills, proven analytical skills and a strong ability to learn concepts quickly and dynamic ability to work independently to deliver on time with high efficiency.

TECHNICAL SKILLS

Databases: Oracle v6.0/7.x/8i/9i,10g,11g,12c, MS-Sql Server, DB2

Languages: SQL, SQL*PLUS, PL/SQL, XML, MS SQL, T-SQL, Unix Shell Scriting

Database Tools: TOAD, SQL* LOADER, SQL*PLUS, SQL Developer, SQL Navigator

Packages: Oracle Developer Suite (Forms/Reports)

Other Tools: Ewrin, PVCS, TFS, Test Director, Starteam, FormScape

PROFESSIONAL EXPERIENCE

Confidential, Lawrenceville NJ

Sr. Oracle Developer / Technical Lead

Environment: Oracle 10g/11g, Oracle Developer Suite, MS Sql Server, .Net, HP QC, Starteam, Unix, Windows7, TFS.

Responsibilities:

• Led the offshore and onsite team and served as the single point of contact for all the requests from the Professional Services.
• Understanding Business Requirements and Flow, meetings with Project Managers and QA Specialists for analyzing the Functional Requirements.
• Involved in the Design, Review, Development, Testing, Implementation and release of Rxplus/PPI Programs.
• Working on coding business requirements to support web applications.
• Front End Application is developed in Oracle Forms10g using advanced features like lov’s, record groups, property classes, editors, alerts, making extensive use of pl/sql blocks and program units, for many different layout formats.
• Created reports using Pl/Sql in delimited Text Files, Oracle Reports Builder for IConnect Program with many report formats including master/datail, group left, group above, matrix layout.
• Used standard procedures to read delimited text files, parse, validate and load data into oracle database.
• Created pl/sql programs for data migration, extensively worked on loading data from flat files to Oracle database using Sql Loader Utility by both convention and direct method.
• Used UTL File Option to create Text files and Spreadsheets on Server.
• Wrote Unix Shell Scripts for Processing Jobs and to ftp files from server.
• Excellent Knowledge in Analyzing/Altering Explain Plan, Ability to Identify Potential Inefficient Queries and working on Performance Tuning of the SQL Queries and PL/SQL programs.
• Extensively used Explain Plan, Auto Trace and TkProf for understanding oracle execution plan.
• Created Stored Procedures, Functions, Packages and Database Triggers.
• Created External Tables, Global Temporary Tables, Database Tables, Views, Pl/Sql Tables, Record Types for Programs as required.
• Extensively worked on Cursors, ref Cursors, Nested Conditional Statements, Co-Related Subqueries, Exception/Error Handling while developing complex applications.
• Worked on creating Sequences, Join Conditions with multiple tables and Views.
• Worked on Production to Support Programs, Did a bunch of Data Fixes as Maintenance.
• Created Backend Process for many programs to collect data from files, validate and create orders and letters.

Confidential, Wilmington DE

Sr. Oracle Developer

Environment: Oracle 11g, DataStage, Unix, WindowsXP, CARS, SDLC

Responsibilities:

• Understanding Business Requirements and working with different system groups .
• Involved in the Design, Review, Development, Testing, Implementation of PODS Application.
• Worked exclusively in Design of Datawarehouse, Data Marts and Reporting Requirements.
• Excellent Knowledge in Analyzing/Altering Explain Plan, Ability to Identify Potential Inefficient Queries and working on Performance Tuning of the SQL Queries and PL/SQL programs.
• Extensively used Explain Plan, Auto Trace and TkProf for understanding oracle execution plan.
• Created Stored Procedures, Functions, Packages and Database Triggers.
• Created External Tables, Global Temporary Tables, Database Tables, Views, Record Types, Cursors, ref Cursors, Nested Conditional Statements, Co-Related Subqueries, Exception/Error Handling while developing complex applications.
• Worked on Production to Support Programs, Did a bunch of Data Fixes as Maintenance.

Confidential, Yardley PA

Sr. Oracle Developer

Environment: Oracle 10g/11g, Seibel CRM, .Net, Developer Suite, Erwin, HP QC, Starteam, Unix, WindowsXP

Responsibilities:

• Understanding Business Requirements and Flow, meetings with Project Managers and QA Specialists for analyzing the Functional Requirements.
• Involved in the Design, Review, Development, Testing, Implementation and release of Rxplus/PPI Programs.
• Involved in Design of Datawarehouse, Data Marts and Reporting Requirements.
• Good understanding of OLAP Schema, Cube, Dimentions and ETL Process.
• Used standard procedures to read delimited text files, parse, validate and load data into oracle database.
• Created pl/sql programs for data migration, Extensively worked on loading data from flat files to Oracle database using Sql Loader Utility by both convention and direct method.
• Used UTL File Option to create Text files and Spreadsheets on Server.
• Wrote Unix Shell Scripts for Processing Jobs and to ftp files from server.
• Excellent Knowledge in Analyzing/Altering Explain Plan, Ability to Identify Potential Inefficient Queries and working on Performance Tuning of the SQL Queries and PL/SQL programs.
• Extensively used Explain Plan, Auto Trace and TkProf for understanding oracle execution plan.
• Created Stored Procedures, Functions, Packages and Database Triggers.
• Created External Tables, Global Temporary Tables, Database Tables, Views, Pl/Sql Tables, Record Types for Programs as required.
• Extensively worked on Cursors, ref Cursors, Nested Conditional Statements, Co-Related Subqueries, Exception/Error Handling while developing complex applications.
• Worked on creating Sequences, Join Conditions with multiple tables and Views.
• Worked on Production to Support Programs, Did a bunch of Data Fixes as Maintenance.
• Created more than 50 reports using Pl/Sql in delimited Text Files and Spread Sheets, Reports Builder for Rxplus and PPI Programs in Datawarehouse with many report formats including master/datail, group left, group above, matrix layout.
• Front End Application is developed in Oracle Forms using advanced features like lov’s, record groups, property classes, editors, alerts, making extensive use of pl/sql blocks and program units, for many different layout formats.
• Created Backend Process for many programs to collect data from files, validate and create orders and letters.
• Involved in Quality Assurance, testing the database and application.