Objective:

• Over 5+ years of experience in System Analysis, Design and development of applications using Oracle 10g/9i/8i.
• Good understanding of the software development lifecycle (SDLC).
• Expertise in developing SQL, PL/SQL scripts in oracle distributed environment.
• Expertise in distributed query performance tuning by using EXPLAIN_PLAN, SQL Trace Utilities and hints provided by oracle.
• Possess strong programming knowledge in Oracle 10g/9i/8.x, PL/SQL, SQL*PLUS, SQL*LOADER.
• Expertise in Oracle Stored procedures, Packages, Functions, Cursors, Cursor Variables, Collections, Triggers, Native Dynamic SQL.
• Extensively used oracle tools like TOAD and SQL Navigator
• Designed and developed various applications using oracle products/tools for process automations software into database server using Crontab, UNIX shell scripts, PL/SQL packages, procedures and database triggers based on client/server and multi-tier technologies
• 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.
• Experience in data extraction, data migration and Data loading.
• Expertise in query optimization, debugging and application tuning.
• Experience in designing and developing application systems using oracle extensive suite during all phases of system development life cycle as well as data modeling (UML), design and maintenance.
• Ability to work in a team and Positive orientation to expand present knowledge base, Active team player with positive and forward-looking attitude.Strong analytical, interpersonal and communication skills.

Technical Skills:

• Programming Languages: SQL, PL/SQL, C, Korn Shell Script, PERL
• Relational Databases: ORACLE 10g/9i/8i, DB2, MY SQL
• DB Utilities: SQL*Loader, Export, Import
• Tools: TOAD, SQLPLUS, Forms Builder, Reports Builder, Schema Builder, Procedure Builder, Graphics Builder, UTL_File
• Operating Systems: Windows XP, UNIX, Linux
• Web Technologies: HTML, JavaScript

Professional Experience:

Confidential, Hopewell(NJ) Sep'10 - Jan'11
Developer
The Inter-Company (ICO) Trade Matching and Reconciliation Tool was created to assist finance users by systematically identifying contract level breaks and displaying the associated trade level details of these breaks between parties and their inter-companies. Previously a manually intensive process, the automation of this work enables finance users to more efficiently complete month end reconciliations. There were lots of files come from arctic on a daily basis and monthly files will come on month end. These files will be loaded into permanent tables through external tables.
We automate this process through autosys jobs in autosys server.

Responsibilities:

• Involved in loading data into permanent tables.
• Involved in UNIX scripts to automate load and scheduling batch jobs in autosys server.
• Involved in writing shell scripts.
• Familiar using hints, explain plan and sql trace for performance tuning.
• Involved in creating tables, views and external tables.
• Developed lot of PL/SQL stored procedures, functions, packages and triggers.
• Involved in using analytical functions in procedures for better performance.
• Optimized SQL queries to maximize the query performance as well as load performance.
• Involved in front end testing.

Confidential - NY Feb'09 - Jun'10
Oracle Developer
Pershing user's login via NetX-360 SSO enabled application to access brokerage application by passing user entitlement codes and user credentials. There are different types of users namely (Investment Advisors, Reps, Brokers, Region Managers, Area managers and Sponsors) login into FDx application to do their business for accounts that are associated with them. There were lots of nightly batch files coming over to FDx application from pershing, these files will be normalized using perl script and loaded into a temporary tables for nightly batch process. The data in some of the temp tables will directly loaded into permanent tables and some of the tmp tables will require java process to load data into permanent tables.

Responsibilities:

• Involved in preparing technical documentation and process flow diagrams
• Involved in manipulating raw file and converting data into a normalized file using perl script.
• Involved in loading normalized file into permanent tables.
• Involved in UNIX scripts to automate load and scheduling batch jobs in crontab
• Involved in setting up and configuring Web Sphere application server on a Unix OS.
• Involved in setting up and configuring IBM MQ Server on a Unix OS.
• Involved in applying fix packs for IBM Web Sphere application server.
• Developed lot of PL/SQL stored procedures, functions, packages and triggers
• Created control files for SQL Loader process, familiar with direct path loading
• Optimized SQL queries to maximize the query performance as well as load performance

Environment:
DB2 UDB, PERL, Oracle 10g ,Windows XP, Sun Solaris, Toad 8.6, IBM Web Sphere Application Server 6x, DB2 Control Center, Command Center, Sun JDK 1.3, Enterprise Java Beans(EJB), IBM MQ series, JSP and java script.

Confidential - NY Nov '07 - Dec'08
PL/SQL Developer

The project provides OLB users to access portfolio Information 24/7 through Online Brokerage System. This site allows OLB users to view account details like Balances, Positions, Transaction History, Realized and Unrealized gain losses, order management system for equities and Mutual Funds. Ability to access real time and delayed quotes, download OLB positions information, Admin Functionality and much more. On a daily basis files will transmit from back office to brokerage application database tier and I involved in loading those files namely customer, balance, positions and transactions into a temp tables using db utility commands and a script will trigger to process those data for next day business.

Responsibilities:

• Involved in preparing technical documentation for process flow and uml diagrams
• Created tables, global temp tables, views and Indexes
• Developed lot of PL/SQL stored procedures, functions, packages and triggers
• Created control files for SQL Loader process, familiar with direct path loading
• Optimized SQL queries to maximize the query performance as well as load performance
• Familiar using hints, explain plan and sql trace for performance tuning
• Loading unprocessed MQ messages into database temp table
• Working with DBA's to monitor database sessions
• WritingUNIX Shell Scripts to automate load process, Scheduling batch jobs in Crontab
• Created extensive event logging and exception handling for all of the processes

Environment:
Oracle 10g, Windows XP, Sun Solaris, IBM WebSphere Application Server 5x, Toad 8.6, Sun JDK 1.3, Enterprise Java Beans(EJB), IBM MQ series, JSP and java script.

Confidential (NJ)Dec '06 - Oct' 07
Oracle Developer

Confidential, a healthcare informatics joint venture of Quintiles Transnational Corp. and McKesson Corp., provides a broad array of information products and services to the healthcare industry, including sales targeting and compensation products; market research audits; healthcare profiles; comprehensive managed care offerings; primary market research; data integration, warehousing and mining; data analysis and consulting; direct mail; list services; disease management studies; clinical trial investigator targeting and protocol recruitment evaluation; healthcare outcomes; and cost/benefit analysis, among many others. Confidential is also the nation's leading provider of patient-centric longitudinal data, with dozens of products used by clients spanning the industry.

Responsibilities:

· Understanding the requirements using functional documents and client specified documents and prepare Technical Document.

• Preparing Flow, Sequence and Class diagrams using MS Visio
• Writing PL/SQL code using the technical and functional specifications
• Creating Oracle objects like Tables, Views, Procedures, Functions, Triggers, Packages.
• Writing PL/SQL Stored procedures, functions and packages using TOAD.
• Performance tuning, Optimized the queries to improve the performance of the application.
• Automated SQL Loader using shell scripting
• Automated custom reports using UNIX shell script
• Created Batch Jobs and UNIX Scripts to automate the process.

Environment:
Oracle 9i, Windows XP, IIS V6 Application Server, UNIX, Toad 8.6, SQL, PL/SQL, ASP.net, ADO.net and VB Scripts.

Confidential (NJ) Aug '05 - Nov '06
Programmer Analyst

This application provides solutions for medical practitioners for all specialties and all size locations, as well as medical billing companies, with the most user-friendly, cost-effective and cutting edge web based practice management system. This application is helping hundreds of physicians and medical billing companies through out the United States manage their businesses more effectively. Following are some of the features

• Complete streamlined patient appointment scheduling
• Detailed patient information
• Built in Claim and Coding rules engine interface
• Real-time electronic claim processing

Responsibilities:

• Involved in preparing process flows, Sequence and Class diagrams
• Developed PL/SQL code as per technical and functional specifications
• Created Oracle objects like Tables, Views, Procedures, Functions, Triggers, and Packages.
• Involved in writing PL/SQL Stored procedures, functions and packages using TOAD.
• Performance tuning, Optimized the queries to improve the performance of the application.
• Automated SQL Loader using shell scripting
• Automated custom reports using UNIX shell script

Environment:
Windows NT 4.0, Sun Solaris, Oracle 9i/8i, SQL*Loader, C, SQL, and PL/SQL.

Confidential Nov'04 to Jun'05
Junior Oracle Developer

Developed customized web based application for Medivison Eye care center to track patients, doctors and employer's information, this application captures patient's personal and their medical problems information and stores in database. This application generates several reports for doctors to see a specific patient's information and their history.

• Involved in creating database tables and views
• Involved in writing SQL queries for data retrieval
• Involved in developing PL/SQL packages, stored procedures & Functions
• Optimized SQL queries to reduce the database contention

Environment:
Oracle 8.0, Forms 6i, Reports 6i, Windows NT, C, SQL and PL/SQL.

Certification:
Oracle 9i Certified Associate SQL, PL/SQL programmer (OCA).

Education:
Bachelor of Science
Oracle PL/SQL Training Program