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 software development 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.
• Extensively used oracle tools like TOAD and SQL Navigator.
• Data Manipulation was completely done using Pro * C where as Tuxedo was used as the Middleware.
• Wrote stored procedures/triggers, ESQL (Pro*C/C++) programs for database operations in Oracle.
• Designed and developed different reports for TRS using Pro*C and SQR.
• Expertise in RDBMS development including 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.

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, NH

Oracle PL/SQL Developer

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 in corporate 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 and Tkprof 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

Oralce PL/SQL Developer

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

Oracle PL/SQL Developer

Responsibilities:

• Understanding Account Aggregation and Asset Classification, Bonds, Stock, Mutual Funds and other financial domain terminology.
• Designed Technical 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 and 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

Oracle PL/SQL Developer

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

Oralce PL/SQL Developer

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

Oracle PL/SQL Developer

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.