PROFESSIONAL SUMMARY:

• Around 9 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System(RDBMS)
• Strong Experience in Interface programs to import data from legacy systems and excellent skills in writing PL/SQL stored procedures, functions, packages, triggers and cursors.
• Proficient in Oracle Tools such as TOAD 10.6, SQL * Loader, Oracle SQL Developer and Oracle utilities like DBMS PIPE, UTL FILE, Exp, Imp and Data pump.
• Extensively worked in Reports and writing Stored Procedures, Packages and Database Triggers
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application. Handled Production issues with high pace and efficiency. Optimized existing queries for better performance and less impact on database.
• Strong knowledge in Oracle Cursor management, Exception Handling and also experience in performance tuning (PL/SQL) using SQL Trace, Explain Plan, TkProf, Indexing and Hints and Optimizing the oracle reports.
• Used Ref cursors and Collections, Bulk Collect and Bulk Binding for accessing huge volume of data.
• Expertise in data modeling, Normalization, database design, data loading, data retrieval, modification, and archival techniques
• Implemented the business rules in writing Oracle PL/SQL functions and procedures and Wrote Queries to retrieve data in XML format from the tables.
• Proficient in Oracle database creation, table space management, creating database links, schemas, profiles and roles, managing control, redo log and data files
• 24/7 Production Database Support & Maintenance
• Worked with the users to identify the business requirements and integrated them into the front end applications and coordinating the Off-shore team.
• A Self-starter with a positive attitude, willingness to learn new concepts and accept challenges.
• Excellent analytical and problem solving skills and can work independently
• In addition to excellent technical abilities possesses strong oral and written communications skills, analytical and interpersonal skills.

TECHNICAL SKILLS:

Operating Systems: Windows XP/NT/2000, 98/95/Vista, DOS, Solaris 10, Unix, Linux.

Database: Oracle 11g,10g, 9i, 8i, 7.x, MS Access and SQL Server 2000,2005.

Programming languages: ANSI C, C++, SQL, PL/SQL programming.

Database Tools: Toad, PLSQL Developer, SQL Navigator, SQL Tools, Erwin.

Utilities: UTL FILE, DBMS PIPE, Exp, Imp and Data pump.

Web Technologies: HTML, XML.

Script Languages: Shell, Perl scripting.

Others: Object Oriented Designing Methodology, UML, RDBMS Concepts, and ETL.

WORK EXPERIENCE:

Confidential, Carmel, IN

Project: AutoVIN

Sr. Database Developer

AutoVIN is a Vehicle Inspection Company bought by Confidential . AutoVIN, the Automated Vehicle Information Network, provides professional field information services. AutoVIN's services include vehicle condition reporting, inventory verification auditing, program compliance auditing and facility inspections. Using the latest in handheld computing and following standardized inspection and auditing procedures, highly trained AutoVIN personnel electronically record all information right in the field, eliminating errors and omissions and reducing the amount of time taken to process critical information. At AutoVIN all field assignments are dispatched directly to the Field Representative's handheld computer based on the location and status of the assignment. Completed assignments are uploaded each business day. And customer management reports are automatically generated and delivered via the Internet.

Responsibilities:

• Involved in Requirement gathering from the existing applications and end users and worked with the Architects and Tech Leads for architecting the product as per the business requirements
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements
• Created materialized views, Inline Views & normal views where business requirements needed
• Tune the SQL queries and complex procedures to improve performance
• Created database triggers for data security & Consistency
• Developed procedures, functions and packages for new requirements
• Developed SQL*loader scripts to load data from various forms of flat files into staging tables in Oracle database using shell scripts
• Developed packages for processing data in the staging tables according to the Clients requirements
• Implemented Advanced PLSQL Concepts for better performance of PLSQL Applications
• Developed and created various scenarios for testing the code
• Debugged existing code for business logic issues.
• Production support for the current application and fix/rewrite the PL/SQL code if any ticket assign from users.

Confidential , OKC, OK

Sr. Database Developer

Confidential is one of the top 10 public independent oil and gas producers based in the United States. It is one of the world's leading independent oil and gas exploration and Production Company. Devon also owns gas pipelines facilities in many of their producing areas. Devon's operations are focused primarily in the United States and Canada. The company's portfolio of oil and gas properties provides stable, environmentally responsible production and a platform for future growth.

Responsibilities:

• Involved in Requirement gathering and writing Functional and Technical documents.
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements.
• Created materialized views, Inline Views & normal views where business requirements needed.
• Tune the SQL queries and complex procedures to improve performance.
• Created database triggers for data security & Consistency.
• Developed procedures, functions and packages for new requirements.
• Developed SQL*loader scripts to load data from various forms of flat files into staging tables in Oracle database using shell scripts.
• Developed packages for processing data in the staging tables according to the Clients requirements.
• Implemented Advanced PLSQL Concepts for better performance of PLSQL Applications.
• Extracted Transformed and Loaded (ETL) data source database to data warehouse system.
• Developed and created various scenarios for testing the code.
• Debugged existing code for business logic issues.
• Used UTL FILE package for writing DBMS OUTPUT messages to file.

Environment: Oracle11g, SQL, PL/SQL, SQL*Plus, SQL*Loader, Java, SQL Navigator, Sub Version, Mercury Quality Control, UNIX, JIRA

Confidential, VA

Database Developer

Confidential is extended Warranty Company, indirectly supports many vendors like ‘Bestbuy”, “Walmart” and many more.

Responsibilities:

• Involved in analyzing the system and business.
• Tuned the SQL Queries to improve the system performance.
• Developed complex SQL queries for generating reports of various modules.
• Involved in analyzing and validating data migrations from the old system to highly relational database system.
• Involved in writing complex queries for the project as required using Toad and Oracle SQL Developer.
• Used Advanced PLSQL concepts like Bulk collect, plsql tables and Dynamic SQL for DML operations for better performance.
• Used SQL*LOADER for loading full and delta files of candidate details.
• Used oracle XML Functions in SQL Queries to generate data in hierarchal structure.
• Modified and Debug the Functions, Procedures and Triggers as per the requirement
• Involved in Bug Fixing and Unit and Integration Testing.
• Involved in the restructuring and fine tuning of the existing SQL Queries according to the new requirement.
• Used SQL HINTS when ever required for better performance of queries.

Environment: Oracle 11g/10g, Toad, Oracle SQL Developer, SQL*LOADER, UNIX, Windows XP.

Confidential, OH

SMB-P2 (Small and Medium Business Portal Integration – Phase 2)

Database Developer

SMB – P2 converge Small and Medium Business Telecom (TC), Broadband (BB) and Wireless Non-Hybrid (Stand Alone Wireless) online customers of Verizon onto one platform where they can view and manage all their Accounts and Services using MyBusiness (MB) application.

Responsibilities:

• Involved in requirement gathering, High level and Detail level design documentation.
• Developed shell scripts for validating and processing day-to-day data files and applying them to application tables.
• Developed, modified, and optimized complex queries for data retrieval and modification.
• Optimized and Tuned SQL Queries by running Explain plans.
• Used advanced PLSQL concepts like Bulk collect, plsql tables and Dynamic SQL for DML operations for better performance.
• Extensively used UTL FILE, DBMS XMLGen for creating flat files and XML files.
• Created tables with complex constraints applicable to the business rules.
• Created tables, Tablespaces, schemas, views, packages, stored procedures, triggers, functions etc using TOAD.
• Wrote control files for data loading using SQL*Loader.
• Wrote UNIX shell scripts for automating regular data loading jobs.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
• Involved in developing scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
• Benchmarked data loads on different environments.
• Monitoring data staging, processing and loading jobs.
• Involved in Production support and Maintenance.

Environment: Oracle9i/10g, SQL, PL/SQL, SQL*Plus, SQL*Loader, Java, SQL

Confidential, Pasadena, CA

NCMD - Smart Desk

Programmer Analyst

Confidential has always been to improve the health of the community, as well as the health of our members. For nearly 60 years, Kaiser has shown commitment to this through a variety of programs and activities. Smart Desk is Confidential s Customer care call center application which enables customer care representative to handle processing of new customers, Insurance Claims, renewals, ID card productions, etc.

Responsibilities:

• Interacted with Business Analysts and Users in requirement gathering.
• Responsible for writing and modification of PL/SQL stored procedure, functions, packages and Database triggers.
• Translated user requirements into data flows, detail technical specifications and database requirements
• Developed, modified, and optimized complex queries for data retrieval and modification.
• Optimized and Tuned SQL Queries by running Explain plans.
• Used advanced PLSQL concepts like Bulk collect, plsql tables and Dynamic SQL for DML operations for better performance.
• Created tables with complex constraints applicable to the business rules.
• Developed Unix Kshell scripts to extract data from the Production database & refresh the data warehousing application on a daily basis.
• Created tables, Tablespaces, schemas, views, packages, stored procedures, triggers, functions etc using TOAD.
• Extracted Transformed and Loaded (ETL) data source database to data warehouse system.
• Involved in writing Perl Scripts for populating data on to WebPages.
• Wrote control files for data loading using SQL*Loader.
• Wrote UNIX shell scripts for automating regular data loading jobs.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
• Involved in developing scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: Oracle8i/10g, SQL, PL/SQL, SQL*Plus, SQL*Loader, Perl, .Net, Java, Toad, Clear Case, AIX-UNIX

Confidential

Credit Information System

Software Engineer

The system has centralized database to maintain all relevant information regarding Credit Information. The transaction data will be ported to this centralized database from the branches either through data import or through manual entry. The system allows the user to generate various kinds of reports and queries.

Responsibilities:

• Incorporating all the build rules, writing the code using SQL*PLUS, PL/SQL.
• Used SQL* Loader to load data into different tables.
• Mapping Operational Repository to Business Repository elements and incorporating the build rules.
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers.
• Extensively used PL/SQL to extract data from different tables with 20 Million records in some of the tables.
• Based on the user selection and finally storing the output as a flat file for further processing for the next module.
• Extensively used SQL & PL/SQL in reports. Cardinalities and Joins were used.
• Incorporated validation rules for promotion history table and updating tables.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Generated PL/SQL reporting and Unix Scripts to notify process failure/success.
• Also my role includes testing the data in addition to re-designing the database. Front end using Forms 4.5 and Reports 2.5.

Environment: PL/SQL, SQL*Plus, Exp, Imp and Windows NT.