Professional Summary:

• Quick learner with ability to master new concepts and applications.
• Worked in Manufacturing Process, Banking Information Systems, and Health Care Management domains on various applications.
• Strong knowledge of Extraction Transformation and Loading ETL processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Strong knowledge on Oracle Forms and Reports.
• Experienced in Tuning SQL and PL/SQL code for better performance with large volume of data.
• Experienced with DBA activities like granting and revoking privileges on database objects.
• Knowledgeable in client-server technology, GUI design, and Relational Database Management.
• Extensively worked on PL/SQL Object Types, Dynamic SQL, Collections, Autonomous transaction, Compound triggers, Materialized Views.
• Extensively used PL/SQL to build Oracle Packages, stored procedures, functions, triggers, cursors, ref cursors, views for processing data, enforcing referential integrity and needed business rules.
• Strong knowledge on oracle architecture and database design concepts like Normalization and ER Diagrams.
• Involved in Design, development, implementation, testing, support and documentation of business applications using Oracle technologies.
• Over 6 years of experience in the development of client/server and multi tired applications using Oracle Database, SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX.
• Worked in various levels of SDLC System Development Life Cycle which involves Analysis, Design, Development, Testing, Implementation and support with extensive exposure in database.
• Tested deliverables for conformance with requirements and specifications, including Unit, Module, Integration and System testing.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.

Technical Skills:

PROFESSIONAL EXPERIENCE:

Confidential

Oracle PL/SQL Developer

Description: Independent Health is a not-for-profit organization headquartered in Buffalo, New York. The company began operations in 1980 and has consistently been rated among the top health plans in the country for customer service and member satisfaction. Independent Health's comprehensive portfolio of product and service offerings include HMO, POS, PPO and EPO products, Medicare and Medicaid plans, traditional indemnity insurance, consumer-directed plans, coverage for self-funded employers, plus health savings account and pharmacy benefit management services

Responsibilities:

• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Upgraded Oracle 10g to 11g software in different environments for latest features and also tested databases.
• Creating new Forms Developer 2000 , Reports Reports 10g and writing back end procedures, function, trigger, packages PL/SQL .
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL Plus programs required to retrieve data using cursors and exception handling.
• Provide technical support for database maintenance and disaster recovery.

Environment: Oracle 10g/11g, Reports 10g/9i/6i, Forms 10g/9i/6i, Oracle applications 11i/12,BashShell, PL/SQL, SQL, Sun Solaris, OEM, SQL Loader.

Confidential

Oracle PL/SQL Developer

Description: One Shield is an insurance software and services provider to the property and casualty market. The One Shield team's extensive experience in the insurance market has led to a modern system that provides the tools, technology, and methodology to organize and execute our clients' automation strategies. With production implementations for personal, commercial, and specialty carriers, the Dragon system has proven its configurability and flexibility for our clients' unique needs.

Responsibilities:

• Involved in gathering requirements from Business Analysts and Subject Matter Experts SMEs .
• Prepared Low Level Design Documents.
• Translated business requirements into creation and alteration of database objects.
• Developed Stored Procedures, Functions and Packages.
• Prepared Unit Test Cases and executed the same.
• Imported business data to the database using SQL Loader.
• Created staging tables to store the de-normalized data from business.
• Developed sub-programs to process the data in staging tables to Database tables.
• Created database Triggers, Views, Sequences and Synonyms.
• Created Database triggers Audit triggers for making history of insertion, updating, deletion and all kind of Audit routine.
• Involved in all Analysis, Development, Testing, Tuning and Maintenance, as well as resolved problems during implementation.
• Tuning SQL queries in order to increase the performance related issues of the existing database packages functions.
• Involved in creating a new Database Schema and deployment of objects to SIT environment.

Environment: Oracle 11g, SQL, PL/SQL, SQL Loader, SQL Plus, Allround Automation PLSQL Developer 8.0.3, Tortoise SVN 1.7.7, Beyond Compare Scooter Software 3.1.11, Notepad , Windows7.

Confidential

Oracle Developer

Description: BMC Software offers custom consulting and managed services, as well as educational and support services designed to enable rapid deployment in and to increase knowledge of BMC Software solutions and products. Their cost-effective services help the customers to deploy new technology, optimize the applications, and enhance the ability to use the solutions and products in their environment.

Responsibilities:

• Developed Stored Procedures, Function and Packages for the Financial System.
• Setup, tested and implemented new descriptive flex fields in Oracle Financials.
• Used database triggers and PL/SQL for development of system.
• Extensively used PL/SQL to write Cursors for acquiring information to be used in calculations written in stored procedures.
• Created Korne Shell scripts which act as a wrapper for various tasks like - for executing the SQL Loader command lines, for refreshing the materialized views and for updating the Fact and the Dimension tables.
• Worked on various projects involving gap and map analysis, design and customization as per the business rules and worked on custom applications development involving.
• Load the data into Oracle 9i, Oracle High -Performance, scalable database. Change of Accounts, Currencies, Defining calendars, setup books and Multiorg setup.
• Design, development, testing and implementation of a custom billing System and order entry system. Implemented using Oracle 9i and Forms 6i.
• Developed forms to view payments, accept payments, view financial transactions, maintain and view cash assignments, view refunds, credit accounts, and transfer debit balances.
• Involved in Tuning Database Application performance using Explain Plan, tkprof, resolving lock contentions, identifying killing sessions.

Environment: Oracle Applications 9i, Oracle Database 9i, SQL, PL/SQL, UNIX, SQL Plus, Reports 6i, Forms 6i/4.5, SQL LOADER, TOAD, Discoverer 6i

Confidential

Role: Oracle Developer

Responsibilities:

• Created SQL scripts and written Procedures using PL/SQL to load data from flat files into new tables using both UTL and SQL Loader for different cases
• Explain Plan, TKPROF was used for checking the performance of queries
• Modified and updated existing custom forms to adapt to new database schema
• Created SQL scripts for conversion of legacy data including validations and then load it into the tables
• Developed SQL Loader programs PL/SQL scripts to load legacy data into Oracle Apps.
• Developed reports using Reports 6i.
• Developed PL/SQL programs for various modules to validate data while importing into oracle system.
• Participated in database development like creating PL/SQL triggers, packages, procedures function.
• Handling errors using Exceptions.
• Knowledge of Normalization, and data transfer, documentation, preventive maintenance, code review, automation, store procedures and triggers etc.
• Performed exception handling for data that did not conform to the required format.
• Responsible for making the merged data in turn available to other clients.
• Wrote UNIX scripts to automate loading files into database using error handling and notification.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Involved in developing packages for implementing business logic through procedures and functions.

Environment: ORACLE 7.x, Reports 6i, PL/SQL, SQL Loader, SQL.