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 teh 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 teh ease of debugging and displaying teh error messages in teh 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 teh 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 teh business rules in writing Oracle PL/SQL functions and procedures and Wrote Queries to retrieve data in XML format from teh 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 teh users to identify teh business requirements and integrated them into teh front end applications and coordinating teh Off - shore team.
• A Self-starter with a positive attitude, willingness to learn Confidential 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.

PROFESSIONAL EXPERIENCE

Confidential, Carmel, IN

Sr. Database Developer

Responsibilities:

• Involved in Requirement gathering from teh existing applications and end users and worked with teh Architects and Tech Leads for architecting teh product as per teh business requirements
• Created Confidential Tables, Indexes, Synonyms and Sequences needed as per Confidential requirements
• Created materialized views, Inline Views & normal views where business requirements needed
• Tune teh SQL queries and complex procedures to improve performance
• Created database triggers for data security & Consistency
• Developed procedures, functions and packages for Confidential 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 teh staging tables according to teh Clients requirements
• Implemented Advanced PLSQL Concepts for better performance of PLSQL Applications
• Developed and created various scenarios for testing teh code
• Debugged existing code for business logic issues.
• Production support for teh current application and fix/rewrite teh PL/SQL code if any ticket assign from users.

Confidential, OKC, OK

Sr. Database Developer

Responsibilities:

• Involved in Requirement gathering and writing Functional and Technical documents.
• Created Confidential Tables, Indexes, Synonyms and Sequences needed as per Confidential requirements.
• Created materialized views, Inline Views & normal views where business requirements needed.
• Tune teh SQL queries and complex procedures to improve performance.
• Created database triggers for data security & Consistency.
• Developed procedures, functions and packages for Confidential 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 teh staging tables according to teh 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 teh 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

Responsibilities:

• Involved in analyzing teh system and business.
• Tuned teh SQL Queries to improve teh system performance.
• Developed complex SQL queries for generating reports of various modules.
• Involved in analyzing and validating data migrations from teh old system to highly relational database system.
• Involved in writing complex queries for teh 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 teh Functions, Procedures and Triggers as per teh requirement
• Involved in Bug Fixing and Unit and Integration Testing.
• Involved in teh restructuring and fine tuning of teh existing SQL Queries according to teh Confidential 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

Database Developer

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 teh 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 teh users and troubleshooting teh problems involved with teh development of stored procedures, triggers and with teh privileges.
• Involved in developing scenarios for Unit, Integration testing to ensure dat all teh 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

Programmer Analyst

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 teh business rules.
• Developed Unix Kshell scripts to extract data from teh Production database & refresh teh 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 teh users and troubleshooting teh problems involved with teh development of stored procedures, triggers and with teh privileges.
• Involved in developing scenarios for Unit, Integration testing to ensure dat all teh 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

Software Engineer

Responsibilities:

• Incorporating all teh build rules, writing teh code using SQL*PLUS, PL/SQL.
• Used SQL* Loader to load data into different tables.
• Mapping Operational Repository to Business Repository elements and incorporating teh 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 teh tables.
• Based on teh user selection and finally storing teh output as a flat file for further processing for teh 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 teh performance tuning of teh programs, ETL Procedures and processes.
• Generated PL/SQL reporting and Unix Scripts to notify process failure/success.
• Also my role includes testing teh data in addition to re-designing teh database. Front end using Forms 4.5 and Reports 2.5.

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