SUMMARY

• 7 +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, Sacramento, CA

Sr. Oracle Developer

Responsibilities:

• 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.
• Wrote high-level specifications and detailed specifications.
• Wrote PL/SQL Database triggers to implement business rules.
• Used ETL software to extract, transform and load needed data.
• 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.
• 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.

Environment: Oracle 10g,11g, Toad 9.0, PL/SQL, SQL, ERwin, UNIX, BODI

Confidential, Rancho Cordova, CA

Sr. Oracle Developer

Responsibilities:

• Supported development, test and the production databases.
• Used SQL Developer and TOAD to develop code.
• Gathered and analyzed requirements from business users.
• Created database objects like tables, synonyms, sequences and views.
• Created, 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.
• Worked with Oracle Forms 6i and Reports 6i.
• 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.

Environment: Oracle 9i/10g, Toad 9.0, PL/SQL, SQL, UNIX.

Confidential - Richmond, VA

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 oracle discoverer for run the query conformation.
• Get the time estimation from oracle discoverer.
• Building Execute Dash boards and BI Portals.
• Creating Rational Work Sheets
• 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, Parsipanny - 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, Norwalk, CT

Oracle PL/SQL Developer

Responsibilities:

• System Appreciation - Understanding the whole system.
• Held business requirement discussions with the client and documented the changes.
• Involved as a part of team in designing the logical & physical model for database tables using Power Designer 12.
• Used SQL Loader to load huge test data from various sources in PL-SQL.
• Generated SQL scripts and deployed database including installation.
• Schedule Backup Strategy full weekly database backups, daily differential & hourly log Backups.
• Developed procedures to create ad-hoc reports to be displayed in GUI.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL Loader.
• Developed forms using Forms 6i based on business requirements.
• Wrote Database Triggers, Stored Procedures using PL/SQL.
• Fine-tuned the queries using various performance tuning features in Oracle such as using Optimizer hints.
• Written complex SQL statements using joins, sub queries and correlated sub queries.

Environment: Oracle 9i PL/SQL, COBOL, SQL*Loader, TOAD, DB2, BMC, PLATINUM, UNIX, Windows XP, Mercury Quality Center, MS Office, MS Visio, Forms 6i, MS Project, Test Director.