SUMMARY

• Total IT: 10 + years of IT Experience including analysis, design, support and maintenance of Oracle Database systems on both UNIX and NT platforms.
• Oracle: 7 years of solid database experience on Oracle 10g/9i, PL/SQL, SQL*Loader, Physical database design, Logical database design, Gap Analysis, Data Exports & Imports, Inbound/Outbound Interfaces, Application Support, Performance Tuning, Oracle Tuning & Optimization.
• PL/SQL: 7 years of back - end programming experience using PL/SQL, SQL, T 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.
• Databases: Oracle 11g/10g/9i, MS Access 7.0.
• Data Cleansing: 6 years of Data Cleansing experience using PL/SQL, SQL Coding, UNIX Shell scripting.
• Knowledge of data modeling techniques includes virtually every flavor of Entity-Relationship (ER) modeling, Physical and Logical data modeling.
• Strong exposure in writing simple and complex SQL, PL/SQL Functions and Procedures, Packages, Triggers, Materialized views etc.
• 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

• Oracle 8i/9i/10g/11g
• SQL
• PL/SQL
• SQL*Plus
• SQL*Loader
• Erwin 3.5/4.0/4.1/7.1/7.2/7.3
• TOAD 7.6/8.0/9.1/9.5/10.1
• MS SQL Server 2000/2005
• Oracle Reports 9i/6i
• Crystal Reports XI
• XML
• Unix Shell Scripting
• CVS
• PVCS
• Windows 98/2000/XP
• Windows 2000/2003 server
• UNIX
• LINUX
• MS Office
• MS Visio.

PROFESSIONAL EXPERIENCE

Confidential, Parsippany, 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 requirement.
• Implemented complex SQL queries.
• Created views for better performance.
• Performed indexes for faster access of tables.
• Worked on Materialized Views and Query Rewrite.
• Wrote scripts to merge data from one system to another system.
• Used SQL*Loader to load data from flat files (excel/access) to Oracle database.
• Explain plan to improve database performance.
• Involved extensively in the analysis and tuning of the Application code (SQL).
• 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.

Confidential, NYC, NY

Pl/SQL Developer

Responsibilities:

• Gathered and analyzed business requirements from end users.
• Worked with applications specialists to understand the new data requirements.
• Collaborated with the DBA in creating tables required for the application.
• Used SQL*loader to load the data from the files provided by the interfacing applications.
• Wrote high level specifications and detailed specifications.
• PL/SQL Database triggers to implement business rules.
• Used ETL software to extract, transform and load needed data.
• Performed staging, and cleansing on data per requirement.
• Wrote PL/SQL Stored Procedures, Functions, Packages to implement Business Rules.
• Worked with DBA on logical and physical data models, and metadata repository.
• Trained analysts and developers in design tools and data modeling techniques.
• Extensively used SQL to create Insert programs for loading data.
• Modified existing procedures according to new enhancements.
• Performed data partitioning.
• Used explain plan to increase performance of SQL statements.
• Modified SQL statements to increase the overall performance as a part of performance tuning.
• Merged data from one database to another database.
• Created indexes as a part of tuning.
• Documented every phase like Technical specifications, source to target mappings, data models (using ERwin), UAT (tests cases and results), and release notes.
• Migrated enhancement from appropriate Dev Area to Test Areas/prod Areas.
• Issued Grants to the business users for appropriate DM tables to design their Universes.
• Wrote UNIX shell scripts to load data.
• Interacted with production support team regarding production issues.
• Documented and transferred knowledge regarding the various projects.
• Attended meeting with business analyst to get new requirements for the application.

Confidential, Chicago, IL

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 Metavance and Standby Databases.
• Wrote complex PL/SQL packages for Customer Interfaces, Payment Interfaces and Broker Commissions 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 Enterprise DataWarehouse.
• Created Test Cases, Technical Design Documents, Install Plans and worked with Release Engineering teams.
• Used ClearCase, ClearQuest, and Sharepoint for defect creation/resolution, documentation, development tracking and Code repository.
• Worked with BOXI universe and Webi Reports along with Discoverer reports.
• Collaborated with Data Warehouse Architect in writing SQL scripts, Shell Programs, Data Flows, and more.
• Worked with Oracle Forms 6i and Reports 6i.
• Supported development, test and the production databases.
• Used SQL Developer and TOAD to develop code.

Confidential, Edison, NJ

Oracle Developer

Responsibilities:

• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation.
• Involved in Database Design and development.
• Worked on SQL*Loader to Extract, Load and Transform data from varied data sources like Flat files and Oracle.
• Performed Data Upload for all static tables using SQL*Loader.
• Used extensively Export/Import Utilities for performing logical backups and transferring data between other Applications.
• Extracted huge volumes of data from legacy systems and uploaded into Oracle using SQL*Loader and PL/SQL.
• 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.
• Dropped and recreated the indexes on tables for performance improvements.
• Provided 24X7 Production Support of multiple database systems deployed on UNIX and NT platforms.
• Designed and developed UNIX Shell Scripts to handle pre and post session processes.
• 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.

Confidential, Jersey City, NJ

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.
• Created Bourne Shell scripts and Bash Shell Scripts for automating tasks as well as for creating extracts.
• 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.
• Implemented logical backup of the structures with the help of EXPORT utility.
• 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.
• Written shell scripts for rebuilding existing databases to keep up with the latest developments.
• Performed tuning for PL/SQL procedures and packages and modified code accordingly to improve performance.
• 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.
• 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.
• 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.

Confidential

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.

Confidential 

Consultant

Responsibilities:

• Integrated, implemented and developed web-based application. Migrate, prepare and execute test plans.
• Conducted software and business analysis and proposing technical best practices.
• Worked on database optimization of PL/SQL procedure and functions for web based reporting.