SUMMARY

• Having around 9 years of experience in application development using SQL, PL/SQL, and Oracle forms and reports
• Experience with multiple RDBMS including Oracle 11g/10g/9i/8i/8.x/7.x, Microsoft SQL Server 2000/7.0/6.5 and associated SQL Dialects such as Transact SQL (T - SQL), PL/SQL
• Proficient in creating packages, stored procedures, functions, views and triggers
• Experience in creating cursors, composite data types, collections and exception handling
• Data conversion from flat files to Oracle database using SQL* Loader and implementing Data-cleansing procedures
• Proficient in developing the Data mart in Star Schema and Snowflake Schema, Flat files and building the Data warehouse, Efficient in developing the Data model, OLTP/OLAP, ER Diagrams and organizing the data as per the Business requirements.
• Proficient in Design, Development and Transformation of Conceptual and Logical Data models into Physical Data models using Erwin.
• Experience in working with Forms and Reports for development and customizations as per client specifications
• Experienced in the development and deployment of Reports for Retail, Healthcare, Financial, Manufacturing, and Software companies. Defined, designed & developed the use of Reports by blending the financial knowledge of the client with the available technical know-how. Possesses excellent analytical skills
• Expertise in creating reports using XML publisher, creating and managing workbooks using Discoverer
• Experience in performance tuning & optimization of SQL statements using EXPLAIN PLAN, optimizer hints and TKPROOF utility
• Used bulk binding techniques like BULK COLLECT and FOR ALL to improve performance
• Extensively used inbuilt Oracle PL/SQL packages like UTL FILE, DBMS PIPE, XMLGEN, DBMS SQL, DBMS STATS in application development
• Experience in using tools like SQL * Plus, SQL developer, PL/SQL developer, TOAD
• Experienced in writing UNIX shell scripts for automating the process of data loading & Batch Processing
• Strong knowledge in object oriented programming using C++, JAVA, Pro*C, Clearcase and Clear quest
• Proficient knowledge in ETL processing using Informatica and Data Services tool
• Excellent communication, interpersonal and Versatile team player with problem solving skills

TECHNICAL SKILLS

Backend: Oracle 11g/10g/9i/8i, Database Enterprise Edition, Oracle 10g/9i Application Server

Frontend: Oracle Developer Suite 10g/9i/2000, FORMS Builder 10g/9i/6i/5.0/4.5/3.0 REPORTS Builder 10g/9i/6i/3.0, SQL * Loader, XML Publisher, Discoverer, QC

Programming: ORACLE PL/SQL 10g/9i/8.0/2.3/2.1, UNIX Shell Scripting, XML, HTML C/C++, JAVA, Websphere

Database: Oracle 8i/9i/10g/11g, MS Access 2000/2002, SQL server 2005

Third Party Tools: TOAD 9/8.6/7.5, PL/SQL Developer, SQL Navigator, Putty, Workflows, PC Anywhere, MS-Office 2000, Microsoft Visual Source Safe, Clear case, Clear quest

Operating System: Windows 98/2000/XP/NT, UNIX, PERL, OS X

PROFESSIONAL EXPERIENCE

Confidential, Peapack, NJ

Sr. Oracle PL/SQL developer

Responsibilities:

• Created materialized views on remote source database and automated scheduler of refreshing of materialized view on source side.
• Created the DB-Links pointing to the remote database to access the source materialized views.
• Created or Modified the Sequel Script (.sql file) to point to the current source.
• Extracted data from the source views by writing the procedures to load the data into staging tables.
• Created SQL Loader script generator application using UNIX shell scripting and PL/SQL.
• Created the tables and sequences for the experimental data load capture.
• Loaded the Contracts, Products, Customers & Sales data into the created tables using SQL Loader script
• Wrote Packages to store the business rules and exceptions and wrote PL/SQL code to load data from staging tables to the target schema.
• Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL. Enhanced it with creating exceptions for error handling.
• Written complex Oracle SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators.
• Database security by authenticating users, using logon triggers.
• Created indexes on tables and optimized procedure queries.
• Responsible for writing the functional and technical design documents and maintaining the documentation.
• Responsible for Unit, System and UAT testing the data and provided the test evidence reports.
• Involved in UAT testing, Bugs fixing and the code was sent to Production.
• Executed the test scripts in Quality Centre and raised the defects.
• Loading the data from source to target using Informatica mapping.

Environment: Oracle 9i/10g/11.2, PL/SQL, SQL*Plus, PL/SQL Developer 6.0, Toad 9.1, UNIX, Informatica power center tool 8.1.1, QC 10.0.

Confidential, NJ

Sr.Oracle PL/SQL Developer /Analyst

Responsibilities:

• Involved in analysis, design, coding, and implementation
• As a part of Data Mining team provided the data from the database to the Testing teams
• Written the SQL Queries to Data Retrieval Tool
• Upon the Requirement updated and modified the queries in the query tool
• In the process of converting the Accounts from NFS system to BOA system loaded the data from the flat files
• Need to develop the reports everyday from the database to check the accounts migration
• Extensively used inbuilt Oracle PL/SQL packages like UTL FILE, DBMS PIPE, DBMS SQL, DBMS STATS in application development
• Developed PL/SQL packages, procedures, functions, materialized views, SQL Scripts and triggers to populate the historic data in the tables applying business logic
• Extensively involved in writing SQL sub-queries with join conditions and PL/SQL scripts
• Involved in performance tuning of SQL queries and Created indexes on tables and optimizing Stored procedure queries
• Developed triggers for automatic updating of the tables and views
• Created group, tabular, and form reports
• Used UNIX scripting to automate the process by using CRONTAB.

Environment: Oracle 10g, SQL*PLUS, TOAD, SQL*LOADER, Forms 10g, Reports 10g, PL/SQL

Confidential, Detroit, MI

Oracle PL/SQL Developer

Responsibilities:

• Identified tables, Indexes, Stored Procedures, triggers, Constraints and Data types of the existing SQL Server database.
• Came up with the low level detailed design to re-create the objects to Oracle database.
• Implemented and fine tuned the detailed design to fit into the migration process.
• Created and managed primary data base objects such as Tables, Views, Indexes, Sequences, and Synonyms according to corresponding Data types
• Developed PL/SQL code to implement business rules through cursors, ref cursors, procedures, functions, and packages
• Migrated data from flat files to Oracle database using SQL*Loader
• Developed control files for SQL * Loader and PL/SQL scripts for Data Extraction/Transformation/Loading and Mapping, loading data into interface tables from different Legacy systems and validating the data.
• Developed Oracle PL/SQL programs for backend processing and exception handling
• Created PL/SQL stored procedures for database and application validations
• Modified and developed database triggers, cursors, procedures, functions and packages to meet business requirements
• Involved in performance tuning of SQL queries to decrease the execution time
• Created test cases PL/SQL procedures for migrated SQL and PL/SQL procedures
• Used cursor variables to pass query result sets between PL/SQL programs and client application
• Migrated the reports according to the requirement using Oracle Reports 10g
• Responsible for writing the technical documents and maintaining the documentation

Environment: Oracle 10g, SQL and PL/SQL, SQL * Loader, TOAD, SQL * Plus, Reports 10g,clearcase

Confidential, NYC, NY

Oracle PL/SQL Developer

Responsibilities:

• Actively participated in gathering Business Requirements and System Specification from system users.
• Based on partially filled reports which comes from CRM department Retrieved the customer data from database
• Referencing the CUSIP id retrieved the customer policy id, premium amount, policy start date, end date, policy interest rate
• Written the pl/sql procedures to retrieve the customer information by giving policy id, cusip id as parameters
• According to given reports, changed the insurance policy by calculating the interest. updated the policy interest rates by calculating the insurance rate then calculated the interest for next month
• Developed and updated the reports on different type of bonds like municipal bond, public financial bonds and insurance bonds
• Customized the reports with the new interest rates as per the business needs
• Developed and enhanced existing PL/SQL code extensively to suit changing needs
• Developed new reports using XML publisher in PDF format
• Used UTL FILE package in PL/SQL to read and write data in text files
• Wrote scripts to create tables, functions, procedures, ref cursors, triggers and packages
• Wrote shell scripts for automating the process of data loading and daily process
• Worked with DBA's to help them in data loading process, batch jobs and various administration tasks

Environment: Oracle 9i, SQL, PL/SQL, TOAD, SQL*Loader, Reports 6i, XML publisher, SQL * Plus, Unix, JAVA

Confidential, Memphis, TN

PL/SQL Developer

Responsibilities:

• Wrote PL/SQL scripts for creation of database tables with the necessary constraints
• Developed database row-level trigger for the audit table
• Developed database statement-level triggers for the employee attendance
• Created procedures, functions and packages to meet business requirements
• Used Indexes, explicit cursors in programs to implement the logic
• Used control structures like IF, CASE, FOR, WHILE loops in standard PL/SQL programming
• Exception handling and trapping predefined oracle errors through PL/SQL
• Created PL/SQL packages for easier application design and improved performance
• Created PL/SQL stored procedures for database and application validations
• Encapsulated PL/SQL procedures and functions in packages to organize application
• Created PL/SQL procedure and called from Forms 6i tool
• Created reports using Report 6i
• Provided user training and production support

Environment: Oracle 9i, SQL, PL/SQL, SQL*Plus, SQL*Loader, Forms 6i, Reports 6i, SQL * Loader

Confidential

Oracle Developer

Responsibilities:

• Gathering required data, data analysis and documentation of the plan
• Gathering data elements needed for analysis of the data, decoding flat file data and loading into database tables using SQL*Loader
• Responsible for data mapping from legacy system to Oracle
• Created database objects like tables, synonyms, sequences, views
• Developed various data exception reports and submitted to the client for data clean up
• Created materialized views, partitions, tables, views and indexes
• Involved in tuning and optimization of SQL statements
• Created/modified the procedures, functions and packages to support data conversion
• Used SQL hints and indexes to improve the performance of queries
• Modified the existing shell scripts to support conversion process
• Checked explain plan of the SQL queries to improve the performance
• Wrote shell scripts for automating the process of data loading and daily process

Environment: Oracle 8i, TOAD, SQL* Plus, PL/SQL, Import/Export Utility and Windows NT, Unix

Confidential

Oracle Developer

Responsibilities:

• Writing PL/SQL code for deleting data for employee records for previous data
• Involved in software requirement specification and technical design
• Performed Normalization and Logical Database Design
• Created of database links and accessing the data through SQL statements
• Created database, table spaces, user schemas, and assisted in database administration and maintenance
• Created Stored Procedures, Database Triggers, Functions and Packages to manipulate the database and to apply the business logic according to the user’s specifications
• Involved in developing various Forms, Reports, Procedures, Functions and the PL/SQL Libraries to support the GUI application

Environment: Oracle 8i, SQL, PL/SQL, Forms 4.5, Reports 3.0, TOAD, Designer 2000