Experience Summary :

• Over 13+ years of experience in analysis, design, development, implementation and support of applications under various software platforms.
• Experience in Health Care, Automobile, Banking, Telecom and Human Resource industries.
• Experience in managing Oracle 9i / 10g/ 11g databases and provided PL/SQL Developer support for application development and maintenance.
• Experience in the development of backend procedures, functions, triggers, packages using Oracle PL/SQL under HP Unix.
• Experience in the tuning of SQL queries as well as PL/SQL program units.
• Experience in data extraction and migration of data from legacy systems using sql*loader and data pump and external table utilities.
• Experience in implementing and maintaining database security (create and maintain users and roles, assigning privileges etc.,).
• Experience in the development of UNIX shell scripting.
• Experience in resolving database connectivity issues.
• Experience in the development of reports using Crystal Reports.
• Knowledge in Backup and Recovery operations.
• Experience in the development of client server technologies using VB 6.0 and Visual Foxpro 5.0.
• Experience in the development of web technologies using ASP, C#, Java Script etc.,
• Experience in the development of stored procedures using MS SQL Server 7.0/2000 as a backend and crystal reports developer.

Education

• Bachelors degree in Computer science
• Oracle 9i Database Administrator Certified Professional.

Technical Skills

Operating Systems:

HP Unix, HP MPE-IX, Linux and Windows

Languages:

SQL, PL/SQL, UNIX, Shell Scripting C, C++, C#, Pascal, Cobol.

Databases:

Oracle 8i / 9i / 10g, SQL Server 7/2000/2005

Reporting Tool:

Crystal Reports 8.5

GUI and web tools:

VB 5.0, Visual Foxpro, ASP 3.0, ASP.NET

Tools & Utilities:

SQL*Loader, RMAN, Data Pump, Statspack, Sql Developer, Toad

Project Details

Project:

Subscriber Usage Management

Client:

Confidential,Reston, VA

Duration:

Aug 2010 to Till Date

Environment:

Oracle 11g Release 2 RAC, PL/SQL, Sun Solaris

Team Size:

8

Role:

Developer DBA

Project Description

The subscriber usage management is to deal with the customer usage data on both cable services and wireless. The usage data is received through a clients proprietary product called Fusion Works, and then, it will be parsed, validated and finally it will be committed into the database tables for further processing like enrichment and rating.

Role as a Developer DBA

Database analysis and design.

Tablespace sizing.

Configuring job classes under RAC environment.

Test / QA / Production Schema deployments.

Monitoring gather schema statistics using scheduler jobs.

Tuning several processes like enrichment, subscriber maintenance which has performance issues.

Developing and trouble shooting existing enrichment and subscriber update processes.

Developing, deploying and tuning of ETL procedures for several other parts of the business, which deals with reporting.

Managing table partitions using scheduler jobs.

Work with other development team members to trouble shoot peformance bottlenecks using AWR reports.

Monitoring the tablespace usage periodically.

Data migration using data pump and sql loader utilities.

Project:

MEDICAID

Client:

Confidential,Frankfort, KY
For Kentucky State Govt. Medicaid Project.

Duration:

Nov 2008 to August 2010

Environment:

Oracle 10g PL/SQL, HP UNIX, , data pump

Team Size:

12

Role:

PL/SQL Developer

Project Description

The system which I extensively worked with KY state project is Provider subsystem. The system has various functionalities ranging from enrolling a provider to terminating , extending contracts of providers.

Role as a PL/SQL Developer

Database analysis and design.

Developed triggers for auditing data changes through front-end application.

Developed packaged procedures and functions

• For provider welcome letter generation module for the newly enrolled providers, and the data will be picked up by another letter generation application for further process.
• For calling external java routines for certain specific functionalities of this system.
• To validate the dates between every provider contracts and report whether any overlapping date ranges found there.
• For maintaining termination and extension of existing medicaid and non-medicaid contracts.
• For maintaining daily, weekly and monthly jobs for enrollment processing.

Tuning of SQL queries and PL/SQL program units for performance reasons.

Maintenance and monitoring of table spaces, data file etc.

Implement and maintain database security (create and maintain users and roles, assign privileges).

Creating table spaces, tables, indexes, and rebuilding indexes.

Using data pump utility to export and import of data to flat files and vice versa.

Project:

MEDICAID

Client:

Confidential,Flint, MI

Duration:

March 2006 to Sep 2008

Environment:

Oracle 10g PL/SQL, HP UNIX

Team Size:

7

Role:

PL/SQL Developer

Project description

This Wisconsin portal has various capabilities like registering users by themselves, resetting their passwords, creating clerks and assigning their roles, uploading and downloading files and so on. Apart from that, it has links to various sub systems like providers, claims, prior-Authorization, Eligibility etc.,

Role as a PL/SQL Developer :

Developed triggers for maintaining audit information for every panel’s data change.

Responsible for creating packaged procedures and functions

• For registering users and generating pin numbers for their welcome letter generation process.
• For a front end page, which is making use of a wizard for navigating predefined panels on it for the enrollment of providers.
• For certain modules which is used to retrieve claims, Prior-Authorization information and display those information on the portal.

Coordinating with other developers in refining the performance of SQL and PL/SQL program units.

Creating and managing tablespaces.

Implement and maintain database security (create and maintain users and roles, assign privileges)

Responsible for rebuilding indexes and reorganization of tablespaces.

Responsible for import / export of data using data pump.

Project:

Budget and Accounts Payable

Client:

Confidential,Taif, KSA

Duration:

Dec 2004 – Nov 2005

Environment:

PL/SQL, HP UNIX, Oracle 9i

Team Size:

4

Role:

PL/SQL Developer

Project Description:

Confidential,will keep track of all the Purchase requisitions, purchase orders for both inventory and capital equipment items. The Accounts payable deals with the settlement of bills for the above transactions. The payment of every bills are specified under a predefined General Ledger code available in the system.

Contribution :

Responsible for physical data base design by creating databases and maintaining tablespaces.

Coordinate with team members for the development of stored procedures using PL/SQL

Uploading master table data using SQL * Loader from the text data files.

Creating materialized views for their various reporting modules and maintaining it.

Monitoring and tuning performance using STATSPACK and TKPROF utilities.

Configuring Oracle Net to establish client server connections.

Project:

Materials Management System

Client :

Confidential,Taif, KSA.

Duration:

Oct 2003 – Jan-2005

Environment:

PL/SQL, HP UNIX, Oracle 9i

Team Size:

4

Role:

PL/SQL Developer

Project Description:
The system deals with various activities of an inventory management like Supply Requisitions, Issues, Purchase Requests, Quotations, Purchase Orders, Receiving Items with various units of measurements and expiry dates, Returning of defective items etc., Apart from that, it has a process for physical count of all the stock items at the end of every financial year.
Contribution :

Responsible for creating databases for regular OLTP process as well as for week end data movement of history data to another history database, creating users and managing tablespaces.

Monitoring and resolving contention by proper proactive tuning.

Rebuilding indexes and reorganization of tablespaces.

Refining SQL written by developers to improve query performance.

Responsible for writing stored procedures using PL/SQL for certain week end process to post the data in the history databases.

Responsible for writing PL/SQL procedures for an year end inventory count process.

Responsible for writing materialized views and maintaining it.

Monitoring and resolving contention by proper tuning using STATSPACK and TKPROF.

Project: Billing Certificate Client : Confidential,Taif, KSA. Duration: Mar 2003 – Oct 2003 Environment:

PL/SQL, HP UNIX, Oracle 9i

Team Size:

5

Role:

PL/SQL Developer

Project Description:
This is a conversion project for the hospital’s Personal Information System written using a legacy Congnos development product called Power House under the HP 3000 MPE/ix environment. This system was developed using a team of 4 application developers and I’ve co-ordinated in that team as a PL/SQL developer.

Contribution :

• Responsible for creating database, creating users and managing tablespaces.
• Responsible for loading data from the text files using SQL* Loader, the data was extracted from the legacy HP-3000 Image database.
• Configuring Oracle Net to establish client server connections.
• Co-ordinating with the developers in tuning SQL queries for performance reasons.
• Co-ordinated with developers in the development of PL/SQL packages, triggers and Functions which is utilized by the developers from their front-end application.
• Monitoring regular hot backup.
• Responsible for rebuilding indexes and reorganization of tablespaces.
• Used STATSPACK and TKPROF for monitoring and tuning database.

Project: Data Audit Client:

Confidential,Taif, KSA.

Duration:

Nov 2002 – Feb 2003

Environment:

PL/SQL, HP UNIX, Oracle 9i

Team Size:

3

Role:

PL/SQL Developer

Project Description:
The Al Hada Military Hospital has a patient registration system developed in HP COBOL under MPE/ix OS. There is another system which deals with the Laboratory of this hospital developed in Delphi with backend database Oracle 9i. Every time the Patient Registration system will transfer data of the registration and admission to the Laboratory system. This data audit was developed in order to ensure the data consistency between those two systems. This will report the missing patient registrations and admissions between those two systems.

Contribution :

Co-ordinated with the developers working under HP-3000 Mainframe COBOL to get the data extracted from their Image database for this process.

Responsible for creating database and users. Creating and managing tablespaces.

Responsible for writing procedures to migrate data using SQL*Loader to database tables from the HP-3000 Mainframe Image Database.

Developed a PL/SQL package which consists of procedures and functions to deal the data auditing tasks.

Written SQL formatting procedures which is used to create those reports under a spool file to print.

Scheduled the job using Job Scheduler in HP 9000 UX, to run at a specified interval everyday.

Project:

Confidential,

Client :

Confidential,Houston, TX, USA

Duration:

May 2001 – to November 2001

Environment:

Windows2000, Visual Basic 6.0, ADO,
DCOM, MTS, vbscript, JavaScript,
Crystal Reports 8.0, SQL Server 2000.

Team Size:

4

Role :

Analyst Programmer

Project Description
Confidential, is a three-tier web-based application that is developed for Complete solutions Inc., to assist in the recruiting and placement of IT Consultants in all over the United States.

Contribution

Developed over 15 MIS reports using Crystal Reports 8.0.

Done automatic mailing modules for inter-office correspondence while any kind of changes in the work order, timesheet entries, commission informations etc., Done mailing modules to remind consultants if they fail to enter time sheets.

Written stored procedures in SQL server 2000 to perform the necessary operations like extracting the regular and overtimes done by the consultants, making necessary changes to identify active and inactive consultants, calculating vacation details at the time of committing timesheet transactions.
Project:

Call Center Application

Client:

Confidential,MI, USA

Duration:

July 2000 to May 2001

Environment:

Visual Basic 6.0, Crystal Reports 8.0, DCOM,
MTS, MS-Access 2000, eChange Man

Team Size:

2

Role:

Analyst Programmer

Project Description
This application supports taking surveys, from the dealers of Daimler Chrysler automobiles after conducting technical seminars for their dealers in all over US and Hawai. Apart from the telephonic surveys, the system is capable of receiving surveys by fax.

Contribution

• Design and Development of front-end screens. Developed a component to pick the customers information based upon the time of the particular zone. Also, the component has the ability to automatically postpone the survey depending upon the availability of the customers.
• Developed screens to classify the comments as positive and negative. So, at the time of generation of the reports, it will be grouped into two categories.

Project:

PTR Reports

Client:

Confidential,Auburn Hills, MI, USA

Duration:

July 2000 to February 2001

Environment:

Visual Basic 6.0, DCOM, MTS, MS Access 2000, Adobe, Postscript, eChange Man

Team Size:

2

Role:

Analyst Programmer

Project Description
This system deals with the analysis of sales statistical surveys conducted by Daimler Chrysler automobiles. It consists of information like the sales experience by their dealers, the customer\'s feed back during the sales process, feedback during the test drive, vehicle loan arrangements, delivery process, after contacts with the customers etc.,
Contribution

• Design and development of user interfaces and components to extract survey data and data for drawing graphs. Deployed components into MTS.
• The system makes use of a third party ActiveX component provided by HP for downloading the statistical data from the HP Image Database.

Project:

Express Change (Foreign Exchange Application)

Client :

Confidential,Phoenix, AZ, USA

Duration:

May 2000 to July 2000

Environment :

Visual Basic 6.0, Crystal Reports 7.0, DCOM, MTS, SQL Server 6.5, Visual SourceSafe under Windows NT 4.0

Team Size:

10

Role:

Analyst Programmer

Project Description
It supports the Foreign Exchange Business services of American Express Bank all over this world. The system deals with the transactions of Currencies and Financial papers (i.e., Traveler’s checks, both AMEX and Non-AMEX).The system was developed to work for multiple branches of AMEX and with Multi currency features. For each and every currencies, it has the information about their exchange, buy and sell rates. Cashiers did the up-to-date rate changes in their existing system by using the counter rate maintenance module of this application.

Contribution

Development of Report modules using Crystal Report 7.0 and

developing backend procedures using SQL Server 6.

. Done bug fixing of their existing reports and stored procedures. I’ve developed the reports like Foreign Paper bought, Foreign Paper sold, Clearing Transactions, Checks Bought, Checks Sold, Direct Debit/Credit report, Paid FES invoice/Credit Note by till, Wholesale Notes transactions, Daily transactions summary etc.,

Project:

Yeeta (E-Mailing Application)

Client :

Confidential, (Chennai, India)

Duration:

December, 1999 to April, 2000

Environment:

Visual Basic 6.0, Crystal Reports 7.0, DCOM, MTS, MS SQL Server 7.0, Visual SourceSafe under windows NT 4.0.

Team Size:

7

Role:

Analyst Programmer

Project Description
The main feature of this product is “Shared In-Box” i.e., more than one user can access and send mails of a particular Inbox. Other features of this product are as follows
Threading and Aging of incoming messages, Customer information maintenance, Knowledge base, Templates, Multi select replies, Auto response, Import / Export of mail, Multiple accounts handling

Contribution

Development of components to do threading & aging of incoming messages, and to identify whether an incoming message is belonging to a new thread or a part of already existing thread, the aging of the threads will be calculated using the threads open date & time and current date & time.

Developed another component called “Address book” to keep all mailing addresses and other personal information. The report component is used to provide desired reports for the end users.