SUMMARY

• 10 + years of IT Experience including analysis, design, support and maintenance of Oracle Database systems on both UNIX and NT platforms.
• 7 years of back - end programming experience using PL/SQL, SQL, Stored Procedures, Functions, Cursors, Constraints, Triggers, Indexes (B-tree Index, Bitmap Index), Views, Materialized Views, Database Links, Export/Import Utilities, Ad-hoc queries using SQL.
• Strong exposure to SQL*Loader, Physical database design, Logical database design, Data Exports & Imports, Inbound/Outbound Interfaces, Application Support, Performance Tuning, Oracle Tuning & Optimization.
• Expert in Data Cleansing using PL/SQL, SQL Coding, UNIX Shell scripting.
• Vast Experience of data modeling techniques includes virtually every flavor of Entity-Relationship (ER) modeling, Dimensional modeling, Physical and Logical data modeling.
• Proficiency in using Analytical functions, UTL FILE and DBMS LOB packages.
• Experienced in environments requiring direct customer interaction during design specification, development, and acceptance testing and implementation phases
• Proficiency in solving issues after an application release in production.
• Capable in leading a team by providing them direction, knowledge transfer and assistance in work.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels.
• Ability to learn new technologies at rapid speed.
• Extensively usedOracledata warehousing features such as materialized views, bitmap indexes, Index Organized Tables, external tables etc.
• Hands on experienced in Tuning SQL Statements using Execution Plan, HINTS, TKPROF and Procedures for enhancing the load performance in various schemas across databases.
• Expert in Database Optimization by making use of various Performance Tuning techniques.
• Experienced in User Acceptance Testing (UAT), Unit testing, System testing, Integration testing, Development and Production.
• Ability to handle multiple tasks and demonstrate initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.
• Excellent written and oral communication skills with a result-oriented attitude.
• Proven ability to interface and coordinate with cross functional teams and cultures, analyze existing systems, wants and needs, design and implement database solutions.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, SQL*Plus, SQL*Loader, Unix Shell Scripting, CVS, PVCS

RDBMS: Oracle 8i/9i/10g/11g, MS SQL Server 2000/2005

Tools: MS Office, MS Visio, sql developer, Erwin 3.5/4.0, TOAD 7.6/8.0/9.1/9.5/10.1

Operating Systems: Windows 98/2000/XP, Windows 2000/2003 server, UNIX, LINUX

PROFESSIONAL EXPERIENCE

Confidential, Somerset, NJ

Sr. PL/SQL Developer

Responsibilities:

• Gathered requirements from business users and performed analysis.
• Reviewed and Analyzed Business Specification Documents.
• Extensively involved in the requirement analysis, development, writing test cases, and unit testing.
• Designed and created Database objects.
• Wrote PL/SQL procedures and packages as per ETL requirement.
• Created Materialized views for better reporting performance.
• Performed indexes for faster access of tables.
• Used SQL*Loader to load data from flat files (excel/access) to Oracle database.
• Optimized SQL statements and PL/SQL blocks by analyzing the execute plans and statistics of SQL statements and created and modified some Oracle Database objects to make sure all SQL statements could be executed in the most efficient ways.
• Explain plan to improve database performance.
• Increased performance by fine-tuning PL/SQL Procedures.
• Wrote shell scripts for scheduling jobs.
• Used PVCS for source code configuration management.
• Assisted in testing and deployment of the application.
• Documented every phase like Technical specifications, source to target mappings, data models (using Erwin), UAT (tests cases and results), and release notes.
• Attended meeting with business analyst to get new requirements for the application.
• Interacted with SME regarding business rules and documented them for different systems.
• Wrote PL/SQL Stored Procedures, Functions and Packages to implement Business Rules.
• Wrote Unix Scripts for event automation.
• Used Analytical functions in SQL to generate reports that gave details about number of records processed.
• Provided production support and played a major role in debugging errors during implementation and deployment.

Tools: & Technologies: Oracle 9i/10g, Toad 9.0, PL/SQL, SQL, UNIX shell scripting, SQL*Loader

Confidential, West Chester, PA

Pl/SQL Developer

Responsibilities:

• Gathered and analyzed requirements from business users.
• Created database objects like tables, synonyms, sequences and views.
• Edited procedures and functions for improved business requirements.
• Used SQL Loader to load data into the database coming from Ingres and Standby Databases.
• Wrote complex PL/SQL packages for Customer Interfaces, Payment Interfaces for Oracle Applications.
• Used Materialized Views, Hints, SQL Trace / TkProf, Indexes for query tuning and optimizations.
• Used BULK COLLECT, and External Tables for improving performance on the Oracle Database
• Created Test Cases, Technical Design Documents and Install Plans and worked with Release Engineering teams.
• Collaborated with Database Administrator in writing SQL scripts, Shell Programs, Data Flows, and more.
• Supported development, test and the production databases.
• Used SQL Developer and TOAD to develop code.

Tools: & Technologies: Oracle 9i, PL/SQL, SQLPLUS, Unix Shell scripts.

Confidential, Newark, DE

Pl/SQL Developer

Responsibilities:

• Worked with applications specialists to understand the new data requirements.
• Used SQL*loader to load the data from the files provided by the interfacing applications.
• PL/SQL Database triggers to implement business rules.
• Performed staging, and cleansing on data per requirement.
• Wrote PL/SQL Stored Procedures, Functions, Packages to implement Business Rules.
• Extensively used SQL to create Insert programs for loading data.
• Modified existing procedures according to new enhancements.
• Used explain plan to increase performance of SQL statements.
• Modified SQL statements to increase the overall performance as a part of performance tuning.
• Created indexes as a part of tuning.
• Migrated enhancement from appropriate Dev Area to Test Areas/prod Areas.
• Wrote UNIX shell scripts to load data.

Tools: & Technologies: Oracle 9i/10g, Toad 9.0, PL/SQL, SQLPLUS, Erwin, UNIX shell scripting, CVS

Confidential, Harrisburg, PA

Oracle Developer

Responsibilities:

• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation.
• Involved in Database modification Design and development.
• Wrote PL/SQL Stored Procedures, Functions, Packages to implement Business Rules.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export.
• Performed Data Conversions and Data Cleansing.
• Worked on Packages to encapsulate procedures and functions.
• Modified existing procedures according to new enhancements.
• Dropped and recreated the indexes on tables for performance improvements.
• Created and executed Crontab jobs.
• Involved in writing test scripts, unit testing, system testing and documentation.
• Performed performance tuning on Production, QA and Development Servers.

Tools: & Technologies: Oracle 9i, PL/SQL, SQL, HP UNIX Shell Scripting, Crontab

Confidential, Wilmington, DE

Oracle Developer

Responsibilities:

• Wrote stored procedures for application using PL/SQL.
• Created Functions, Triggers and procedures for implementing complex database intensive business rules.
• Managed tables, indexes, constraints, views, synonyms and stored program units.
• Wrote PL/SQL cursors for transaction processing.
• Implemented triggers, Created/Modified/Reviewed Procedures, Packages, functions and cursors based on the business rules.
• Written Queries for the management in the form of stored procedures and packages.
• Tuned SQL Queries for better performance.
• Developed & debugged PL/SQL.
• Created and Execute SQL optimization queries.
• Involved in analysis of new business requirements and major developments.
• Coded and debugged the stored Procedures, Packages and Views in Oracle Databases using SQL and PL/SQL, which were called by user-oriented application modules.
• Created indexes and partitions on various tables in order to enhance performance.
• Provided production support and played a major role in debugging errors during implementation and deployment.
• Modified code to maintain user jobs running on regular intervals performing data transfer from staging area to log tables.
• Created database objects like tables, views, synonyms, indexes, and sequences.
• Integrated, tested, debugged and implemented application systems.
• Extensively worked on client information stored in Oracle database using GUI interface.
• Extensively worked on the Database Triggers, Stored Procedures, Functions and Database Constraints.
• Wrote complex stored procedures and triggers and optimized for maximum performance.
• Wrote Unix Scripts for event automation.
• Used Analytical functions in SQL to generate reports that gave details about number of records processed.

Tools: & Technologies: Oracle PL/SQL, UNIX Shell Scripting, SQL*Plus, SQL*Loader, oracle 8i

Confidential, Alpharetta, GA

Sr.Consultant

Responsibilities:

• Reverse engineered database into Erwin repository.
• Designed and developed backend PL/SQL packages in database layer, stored procedures, functions and triggers using SQL*Plus.
• Created stored sub programs with dynamic SQL at both client and server side.
• Developed UNIX Shell Scripts and PL/SQL Procedures to extract and load data.
• Successfully developed complex queries, functions, store procedures and triggers using PL/SQL.
• Involved in table redesigning with implementation of partition table and partition indexes to make database faster and easier to maintain.
• Fine-tuned application logic for better performance.

Tools: & Technologies: Oracle 8i, PL/SQL, SQL * Plus, SQL Navigator, Erwin 4.1, Pro*C, Windows 2000