PROFESSIONAL SUMMARY:

• Oracle Expert having over 6 + years of experience in developing medium to large - scale web applications.Actively participated in all phases of application development including the design, analysis, coding and implementation.A team player and self-starter who is capable of adapting quickly to emerging technologies
• Experience in developing applications using Oracle and Data Warehouse tools
• Expert in coding complex ETL procedures using PL/SQL and used SQL*Loader extensively
• Possesses excellent analytical, programming and communication skills

SKILLS PROFILE:

Operating Systems: Windows 2000/XP and UNIX

Languages: SQL, PL/SQL

RDBMS: Oracle 8i/9i/10g/11g, MS-Access

CRM: Salesforce

Other Tools: SQL * Loader, TOAD, SQL * Station,AUTOSYS, SecureFXSecureCRT, Rational Clearcase, Rational Clearquestand Visual SourceSafe

PROFESSIONAL EXPERIENCE:

Confidential, HuntValley, MD

Database Administrator/Analyst

Responsibilities:

• Worked extensively on Stored Procedures, Functions and Packages in Oracle 11g using SQL andPL/SQL
• Actively involved in requirements gathering, high level design, detail design and code review meetings
• Worked closely with business owners to make sure the requirements are converted correctly to functional specifications and the correct logic was implemented in the technical design documents and code
• Used SQL*Loader extensively to load the various data files into the database staging tables and then perform the transformations on those tables.
• Worked on the design and development of caching process which is critical for the end users to access their data on a daily basis
• Designed and developed the archival process so that the essential data is retained in the database tables for the business users to access at a faster pace
• Involved in design of Extraction, Transformation and Loading (ETL) of the data in the data warehouse for Oracle 11g database
• Created complex stored procedures and functions using PL/SQL
• Designed and developed complex procedures to handle errors and exceptions at both application and database level using PL/SQL

Environment: Oracle 11g, PL/SQL, TOAD, Windows XP, SQL*Loader, MS Visual Studio, UNIX, SQL*Plus, SQL server, AUTOSYS

Confidential, Rockville, MD

Database Programmer/Analyst

Responsibilities:

• Involved in designing and structuring of book management, product catalog and proposal generation modules
• Worked extensively on Stored Procedures, Functions and Packages in Oracle 11g using PL/SQL
• Actively involved in requirements gathering, high level design, detail design and code review meetings
• Worked closely with business owners to make sure the requirements are converted correctly to functional specifications and the correct logic was implemented in the technical design documents and code
• Used SQL*Loader extensively to load the various data files into the database staging tables and then perform the transformations on those tables.
• Involved in the release coordination and deployment activities of the project
• Worked on the design and development of book caching process which is critical for the brokers to access their data on a daily basis
• Involved in design of Extraction, Transformation and Loading (ETL) of the data in the data warehouse for Oracle 11g database
• Worked extensively on SQL Performance Tuning and Code Optimization
• Involved in the design and implementation of multi-threaded processing during ingestion process

Environment: Oracle 11g, PL/SQL, TOAD, Windows XP, SQL*Loader, MS Visual Studio, UNIX, SQL*Plus

Confidential, Southfield, MI

Programmer/Analyst

Responsibilities:

• Participated in analysis and design phases of the project in finalizing the user requirements, functional requirements and technical requirements
• Designed and created logical model for the modules using ERWIN
• Participated in all phases of Performance Metrics project from gathering user requirements to implementation
• Developed ETL routines to migrate the data on a daily basis from production system to vehicle reporting system
• Used SQL*Loader extensively to load the various format data files into the database tables and further use these to validate the extract files
• Developed the count engine for On-Demand application to allow dealers to get the counts of customers by category, make, model, mileage, model year and zip codes while placing an online order
• Developed reports for offer usage details, promo usage details, coupon usage details and service count details by business center, dom, district and dealer
• Developed the billing and credit routines in PL/SQL and automated these to run on a schedule through DBMS JOB package
• Developed the module in PL/SQL to hold the consumer control group for performance metrics project to see the response rate differences between the actual mailed and control group consumers
• Designed and developed complex procedures to handle errors and exceptions at both application and database level using PL/SQL and shell scripts
• Wrote the extract program to generate the XML and DTD files with consumer details by order, which the dealers target for their business, using PL/SQL and automate the process using Unix shell scripts
• Developed the buy/sell module to handle the dealers’ buy/sell process so that the new dealer has the consumer assigned to him in the consumer database as soon as the transaction takes place

Confidential, Southfield, MI

Programmer/Analyst

Responsibilities:

• Designed and developed complex procedures to handle errors and exceptions at both application and database level using PL/SQL and shell scripts
• Wrote the extract program to populate the files with the consumer details, which the dealers target for their business, using PL/SQL and automate the process using Unix shell scriptsWrote complex shell scripts to automate data loading from flat files into Oracle database
• Wrote shell scripts to automate data loading from flat files into Oracle database
• Involved in performance tuning exercise of the long running queries
• Developed the stored procedures and functions for dealer level order and reporting details

Environment: ORACLE 10g, PL/SQL, Microsoft Visual Interdev 6.0, TOAD, ERWIN, UNIX and Windows XP

Confidential

Programmer/Analyst

Responsibilities:

• Participated in the design and development of the project
• Studied user requirements and functional specifications
• Upgraded Older Version Forms and Reports to Forms 6.0/Reports6.0
• Developed interface screens for data entry and data validations using Forms 6.0
• Created complex stored procedures and functions using PL/SQL
• Designed and developed complex procedures to handle errors and exceptions at both application and database level using PL/SQL and shell scripts
• Developed reports for transaction details, item details, stock availability and fast/slow/non-moving stocks using Reports 6.0
• Wrote complex shell scripts to automate data loading from flat files into Oracle database
• Extracted the data from legacy systems into production database using SQL*Loader and Pro*C
• Grant the necessary system and object privileges to the respective users and roles.
• Used export and import utilities for logical backups.

Environment: Oracle 8i, C, Forms 6.0, Reports 6.0 and UNIX