SUMMARY:

• IT Professional with 8+ years of experience 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 experience in Reports and writing Stored Procedures, Packages and Triggers.
• Experience in exception handling extensively for the ease of debugging and displaying the error messages in the application.
• Strong knowledge in Oracle Cursor management, Exception Handling and also experience in performance tuning (PL/SQL) using SQL Trace, ExplainPlan, TKProf, Indexing and Hints and Optimizing the oracle reports.
• Expertise in data modeling, Normalization, database design, data loading, data retrieval, modification, and archival techniques.
• Proficient in Oracle database creation, table space management, creating database links, schemas, profiles and roles, managing control, redo log and data files.
• Experience in 24/7 Production Database Support & Maintenance.
• 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.

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

PROFESSIONAL EXPERIENCE:

Confidential, Carmel, IN

Sr. Oracle PLSQL Developer

Roles & Responsibilities:

• Worked within the business intelligence team on existing project modules to identify where improvements need to be made in order to support new requirements and/or more efficiently support existing functionality.
• Developed validation module to validate the data in four levels. The validation module is a PL/SQL package consists of several functions completely code with Dynamic SQL.
• Developed a package to log all the errors in any of the function or procedure fails.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Developed Database Triggers to audit the sensitive data of the table along with user information and to enforce complex business rules.
• Developed SQL *Loader scripts to load data in the Staging tables.
• Wrote Procedures and database triggers for the validation of input data and to implement business rules.
• Developed several SQL reports for the Business Users to check the post processing rules.
• Extensively used TKPROF, EXPLAIN PLAN get the statistical data for the performance tuning of the SQL queries and stored procedures.
• Developed several functions such as identify the AFS treatment type, identify effective maturity, update last record indicator, delete month end data, BEEL calculation and Update amount for each product, identify latest status date for each inspection, transaction and risk rating code etc.
• Tested all PL/SQL code for logic correction and Coordinating the offshore team and Production Support for the current Application.
• Performed Unit testing on queries and reports.

Environment: ORACLE 11g (SQL, PL/SQL), SQL*Loader, PL/SQL Developer, UNIX Shell Scripts

Confidential, Oklahoma City, OK

Sr. Oracle PLSQL Developer

Roles & 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.
• 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

Confidential, Chesterfield, VA

Database Developer

Roles & 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 PL/SQL concepts like Bulk collect, PL/SQL 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 SQLHINTS whenever required for better performance of queries.

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

Confidential, Columbus, OH

Oracle Developer

Roles & Responsibilities:

• Requirements gathering from the existing applications and end users and work with the Architects and Tech Leads for architecting the product as per the business requirements
• Creating data mapping documents and business rule documents from source to target.
• Created technical design documents based on requirements from user cases and mapping documents for data migration.
• Coding (Oracle, PL/SQL, Advanced SQL), Unit testing the application on Oracle 11g database.
• Handled of errors by using Exception Handling.
• Suggest and implement various technical and performance improvements in the system.
• Rewrite the existing old PL/SQL packages into new oracle 11g database and utilize new features to improve the current application performance.
• DBMS developments include building data migration SQL scripts.
• Complete involvement in System Testing.
• Involved in writing Unit Test Cases by taking Business Rules as main objectives and as well as preparation of System Test Case documents which can be delivered to Clients.
• Created several external tables for the regular feed for application.
• Created/Modified UNIX scripts as needed for the current production system.
• Production support for the current application and fix/rewrite the PL/SQL code if any ticket assign from users.

Environment: ORACLE 11g (SQL, PL/SQL), SQL*Loader, PL/SQL Developer, UNIX Shell Scripts

Confidential, Pasadena, CA

PL/ SQL Developer

Roles & 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, PL/SQL 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 and refresh the data warehousing application on a daily basis.
• 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.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: Oracle8i/10g, SQL, PL/SQL, SQL*Plus, SQL*Loader, Java, Toad 9.5, Linux, UNIX

Confidential, Mountain View, CA

Oracle Developer

Roles & Responsibilities:

• Incorporated 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, Procedures and processes.
• Generated PL/SQL reporting and Unix Scripts to notify process failure/success.
• Also, involved in testing the data in addition to re-designing the database. Front end using Forms 4.5 and Reports 2.5.

Environment: ORACLE SQL, PL/SQL, SQL*Plus, Exp, Imp and Windows NT, Linux, Unix Shell scripting, Toad 9.5 etc

Confidential

Oracle Developer

Roles & Responsibilities:

• Involved in Gathering end user requirements, developed applications and different audit functionalities depending on the requirement acting for both system analysts and application developer.
• Composed user requirement documents, created technical specs and design documents for various projects.
• Generated complex SQL queries, sub-queries, co-related sub queries, dynamic SQL queries etc.
• Developed database objects like Tables, Views, Indexes, Synonyms and Sequences.
• Wrote packages, triggers, stored procedure and functions for the following modules products, catalogue, billing, shipping, rejected material, purchase orders and material receipts.
• PL/SQL coding for Exception Handling and duplicate data maintenance.
• Used Triggers in Customizing Error conditions.
• Developed UNIX Shell Scripts and PLSQL procedures to extract and load data for month-end batch processing.
• Programming using PL/SQL stored procedures, triggers, views, user-defined functions
• Involved in database design, normalization, de-normalization in building data warehouse and reporting systems.
• Worked with several control flow tasks, data flow tasks, transformations (derived column, lookup, merge join, conditional split, slowly changing dimensions, data conversion etc.) in PL/SQL packages.
• Used event handlers for event handling which includes on pre-execute, post execute and error.
• Involved in package logging in both standard and custom logging using customer stored procedure and tables.
• Created complex reports like table report, matrix report, cascading report, sub reports, drill down, drill through and chart reports using complex data set queries, stored procedures, views.
• Created Adhoc reports more often based on end user requirements export them in Excel.
• Performed daily DBA activities, security assignment, user setup, backup, restore.
• Generated and formatted reports using global variables, expressions and functions.
• Involved in developing parameterized reports using single values, multi values and cascading parameters.

Environment: Oracle 10g (SQL, PL/SQL), SQL *Loader, UTL FILE, Oracle forms 6i, oracle Reports 6i and UNIX shell Scripting, Oracle Developer