SUMMARY:

Over 8 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/98/95./XP, UNIX.

• Extensive experience in the database analysis, development and maintenance of business applications using Oracle 10g, 9i, 8i, PL/SQL Developer.
• Extensive experience in analysis and design of database including ER Diagrams.
• Excellent understanding of the softwaredevelopment lifecycle (SDLC).
• Expertise in developing SQL, PL/SQL scripts in oracle distributed environment.
• Expertise in Oracle Stored subprograms, Packaged subprograms, Cursors, Cursor Variables, Collections, Triggers, Native Dynamic SQL.
• Expertise in distributed query performance tuning by using EXPLAIN_PLAN, SQL Trace and TKPROF Utilities, hints provided by oracle.
• Develop, test and maintainETLprocedures employing bothETLtoolsand custom PL/SQL.
• Participatedinthe development and maintenance of a Date Warehouse / Data Mart Routine Load Schedule.
• Expertise in RDBMS developmentincluding Oracle SQL, PL/SQL database backend programming with stored procedures, Functions and packages.
• Experience in Data migration Projects which uses SQL Loader, PL/SQL programming, coding Procedures, triggers and functions
• Expert in Export, Import and SQL*Loader Utilities.
• Expertise in writing OS level tools which interact with oracle by using UNIX korn shell scripting.
• Experience in data extraction, data migration and Data loading.
• Excellent communication and interpersonal skills, with the ability to manage responsibilities individually or as part of a team environment.
• Worked on Oracle Financials 11.03 for General Ledger, Accounts Payable.

TECHNICAL SKILLS:

Databases:Oracle 10g/9i/ 8i, SQL Server, Ms-Access

Languages:SQL, PL/SQL, Pro* C, C, C++, Java, HTML, XML

Tools:TOAD, SQL Navigator, SQL*Plus, SQL Loader ,SSIS

Operating systems:Windows XP/NT/2000/98/95,Windows vista, MS DOS, UNIX

Office Tools:MS Word, Excel, Power Point, Visio

Others:Object Oriented Designing Methodology, RDBMS Concepts

PROFESSIONAL EXPERIENCE:

Confidential, CA Apr 12 –Nov 12
Oracle PL/SQL Developer
Project: Finalization

The project involved in developing code on the request of Claims users, apart from this worked on various maintenance projects like Move money, Team connect, CMS etc.

Responsibilities

• Written procedures, functions for Finalization and other projects based on users request
• Worked on CMS file transfer, dealing with sending and receiving files with client’s information.
• Involved in the design and implementation of the process for loading the monthly loads coming from S & P into staging tables in the Oracle Database using Shell scripts and PL/SQL scripts.
• Worked with Team connect Interface team in fixing daily compare report issues by writing new code or updating the existing code.
• Prepared test case documentation for VPD (Virtual private database).
• Worked on Oracle forms in Move money project. Tested the changes in Forms for the code changes done in Move money project.
• Worked on MSR (Maintenance service request) dealing with the tickets raised by users and fixing them.
• Developed packages for processing data in the staging tables according to the Clients requirements
• Used Refcursors and Collections for accessing complex data resulted from joining of large number of tables.
• Optimized existing queries for better performance and less impact on database.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Worked on Enterprise service point, HP Quality center.

Confidential, NH May 11 –Dec 11
Oracle PL/SQL Developer
Project: IDMS Data Analysis
The project involved in data analysis of the DMV. The project includes Data Analysis, preparing Data Dictionary, preparing Reports of all the license holders in the state of NH.

Responsibilities

• Prepared a Data Dictionary report
• Extensively did Quality test plans and reviewed the Quality System Test Plan & Test cases
• Observed the Extract, Transform and Load process .
• Involved in Verifying the Unix Korn Shell wrappers to run various AbInitio Scripts
• Fine-tuned for performance and incorporate changes to complex PL/SQL procedure / Packages for updating the existing dimension tables using PL/SQL Developer on Oracle RDBMS
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD
• Conducted data analysis on various subsystems
• Develop Oracle PL/SQL triggers and procedures. Set up Oracle PL/SQL package to analyze the tables and indexes, records tables and rebuild indexes and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming and stored procedures.
• Tested data migration to ensure that integrity of data was not compromised.
• Created database objects, tables, indexes, writing procedures, SQL scripts
• Worked in Identifying and requirements and developing models according to the customer’s specifications and drafting detailed documentation for the same.
• Involved in Tuning SQL queries using Explain Plan andTkprof utility to improve performance of the queries.
• Involved in Extraction and loading of data in between the schemas using oracle Export and Import utilities.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc in different schemas.
• Created scripts to load the data into staging tables from other database using DBlinks.
• Created stored procedures with cursors to load the data from staging to analysis tables.
• Worked with various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Created reports with the help of Jasper
• Worked with UNIX shell scripts to load different Actimize instruments data in to analysis tables.
• Worked with SQL loader and control files to load the data in different schema tables.
• Involved in production support by efficiently debugging the production issues.
• Data Quality Monitoring:

Environment:
Oracle 10g/9i, SQL Developer, Win 2000/XP.

Confidential, FL Apr 09 ­-­ May 11 
Oracle PL/SQL Developer
Project: Share IT
The project involved in developing Medicare solutions for customers in Florida. The project includes Enrollment of members, generating Medicare bills and claims.

Responsibilities

• Designed, created and tested enhancements to a high performance OLTP client server system processing for both daily and scheduled financial transactions.
• Involved in designing Technical Design Documents based on health care Business requirements.
• Extensively used advanced PL/SQL concepts (e.g., varrays, PL/SQL tables, cursors, user defined object types, exception handling, database packages, nested tables) to manipulate data
• Wrote packages and procedures to move data from one table to another.
• Created indexes on tables to improve performance of the queries
• Used BULK COLLECT to fetch large volume data.
• Used Control – M a third party tool to schedule various others batch processing jobs.
• Involved in the performance tuning of various database queries. The queries retrieved data from different tables in multiple databases.
• Used EXECUTE IMMEDIATE to execute dynamic SQL.
• Used Explain Plan, TK Prof in tuning queries.
• Used analytical functions like LEAD, LAG.
• Raised Siebel exception using plsql packages.

Environment:
Oracle 10g/9i, SQL Navigator 5.5, Rational Clear case 7.0, Quality Center 9.2, UNIX, Win 2000/XP.

Confidential, NJ March 07 – Jan 09 
Oracle PL/SQL Developer
The project involved developing online tools and Web Applications for the financial advisors of the Company.

Responsibilities:

• Understanding Account Aggregation and Asset Classification, Bonds, Stock, Mutual Funds and other financial domain terminology.
• DesignedTechnical Design Documents based on business requirements and followed standards designed by the company.
• Involved in the design and implementation of the process for loading the monthly loads coming from S & P into staging tables in the Oracle Database using Shell scripts
• PL/SQL scripts.
• Developed packages for processing data in the staging tables according to the Clients requirements
• Wrote Packages, Stored procedures and functions for accessing, inserting, modifying and deleting data in the database from GUI.
• Used Refcursors and Collections for accessing complex data resulted from joining of large number of tables.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Optimized existing queries for better performance and less impact on database.
• Used Materialized views in places where the data does not change very frequently.
• Created various UNIX Shell Scripts for scheduling and loading process.
• Maintained the batch processes using Unix Shell Scripts.
• Validated customer credits and adjustments by writing procedures.
• Identified undefined accounts, invalid transaction and handled them through exceptions.

Environment: Oracle9i/10g, TOAD, SQL*Loader, WindowsXP, UNIX, Erwin.

Confidential, NY Aug 06 – Feb 07
Oracle PL/SQL Developer
The project involved maintaining customer information and ensuring efficient data retrieval as required for core decision making. Work involved writing Stored Procedures, Triggers and monitoring performance to ensure efficient data retrieval.

Responsibilities:

• Worked on requirement health care Documentation.
• Involved in Creation of database objects like tables, views, procedures, packages using Toad, SQL* Plus.
• Used Sql Loader for loading data from flat file to staging tables.
• Used Bulk Collect in Pl Sql block of code for loading data from staging tables to main tables.
• Used Explain Plan, TK Prof in tuning queries.
• Developed different procedures, packages and triggers in Toad.
• Designed and developed Oracle PL/SQL scripts for Data Import/Export.
• Worked on various backend packages with Procedures and Functions using PL/SQL.
• Wrote PL/SQL stored procedures, functions, packages as required in the health care system.

Environment: Oracle 10g/9i, SQL* Loader, TOAD, UNIX, Win 2000/XP.

Confidential, VA Apr 05 – July 06
Oracle PL/SQL Developer
The project was originally developed out of a need to have as much strategic information on-line to best assist managers in obtaining information at various levels. 

Responsibilities:

• Wrote several stored procedures/Triggers in Oracle (PL/SQL) for the Enterprise Portal Application and data merge.
• Worked extensively on various kinds of queries such as Sub-Queries, Correlated Sub-Queries, Dynamic SQL and Union Queries and concentrated much on Query tuning. Worked extensively on hierarchical queries.
• Worked on data migration from SQL Server to Oracle 9i.
• Involved in daily, weekly and Monthly load of data from Mainframe data set to Oracle database.
• Worked on Very Large Database Environment in terabytes. And tuned queries for performance.
• Extensively used ETL to load data from various flat files which involved both fixed width as well as delimited files.
• Developed and maintained lot of batch scripts in UNIX shell scripts, like scheduled data loading, Create, databases, Tuning and backup and Recovery.

Environment: 
Oracle9i, SQL*Plus, SQL*Loader, PL/SQL, SQL Server 2000, UNIX, Corn Shell script, 
Windows NT, UNIX.

Confidential Jan 03- Feb 05 
Oracle PL/SQL Developer
Confidential redesign application involves extensive use of Oracle queries and procedures for seamless application flow. This involves extensive rewrite of queries, procedures in Oracle 8i as the database, which involves multi-user and multiple development location.

Responsibilities:

• Written PL/SQL Stored Procedures, Functions and Packages and Triggers to implement business
• rules into the application.
• Used SQL*Loader to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Developed numerous programs using PL/SQL and many packages to do the validations as per requirements.
• Used Dynamic SQL (DBMS_SQL, DBMS_DDL) in function and procedure.
• Generate SQL Scripts and create views for reports.
• Used Toad to Extract and test the data in the database.
• Developed Database Triggers to enforce security.
• Involved in Data Extraction using UTL_FILES in PL/SQL.
• Prepare technical documents for all the programs developed & generated.
• Responsible in coding and debugging.

Environment: Oracle8i/9i, SQL, PL/SQL, SQL*Loader, Toad, Windows NT/XP

Education:
Bachelors Degree from Confidential University