System Project

SRINIVASA VOLETI

(: 630-***-**** (Mobile)

abibrh@r.postjobfree.com

Summary

More than 15 years of application development experience as a Developer,

Systems Analyst, Module Lead using the following tools:

Oracle 11i SQL, PL/SQL

Pro*C, SQR

TOAD, TORA, SQuirreL

UNIX Shell Programming

Clear Case, PVCS, Object Cycle

Power Builder 9.0, PFC, Java, JSP, XML, JavaScript, HTML,

DB2 v8.0

IBM MainFrame, CICS, COBOL

Info Maker reporting tool

Oracle Forms/Reports (Developer 2000)

C, C++, Java, Pascal, COBOL, FORTRAN

Windows XP, 2000, NT

Unix ( HP, Solaris )

Education

Master's Degree in Computer Applications (M.C.A)

Certification

Oralce PL/SQL Certified Developer

Training

Java, Informatica, Business Objects

Significant Projects:

BlueSTAR for BlueCross BlueShield of Illinois.

HRIS application for Paychex Inc., NY.

Maintenance & Repairs module of Homerun application for GE-TIP, Devon

Reservation module of Homerun application for GE-TIP, Devon.

Billing System in Resource Allocation Monitoring and Project profitability

System (RAMPS) for Wipro Systems, Bangalore

Leap - Financial Analysis and Reporting System for GE - CIS/FSO.

Tour Reimbursement System for Cure Well Drugs Ltd., Madras.

Decision Support System for Cure Well Drugs Ltd., Madras.

Professional Experience

BlueCross BlueShield of Illinois, Chicago

Period: July 2005 - Till Date

Project: BlueSTAR

Environment: Oracle 11, SQL, PL/SQL, SQuirreL SQL Client, DB2

8.0, SQL,

PowerBuilder 9.0,PFC, PVCS, Windows

Xp, COBOL, CICS,

IBM MainFrame

Description:

The BlueSTAR system is a client/server based application that provides

Health Care Service Corporation employees with a graphical user interface

to accounts, billing, and membership data. This system gives employees

rapid, reliable, and up-to-date customer information in an on-line, real-

time environment.

Responsibilities:

Understanding the Business application

Analyzing the Business requirements

Developing Physical design ( Requirement Specifications)

Design and Developing User Interface screens using object oriented

features.

Developing database objects like Packages, Functions, Procedures, and

Triggers.

Used inner and outer joins and sub queries in SQLs

Tuning the SQL for better performance of the application process

Used PL/SQL features like cursors, records type, collections and object

type for better performance of the application.

Extract the data from one data base and Load into another data base

Writing unit test cases

Unit Test and System integrated testing.

Paychex Inc., Rochester, NY

Period: July 1999 - July 2005

Project: HRIS

Environment: Oracle 9i, SQL, PL/SQL, TOAD, TORA, PRO*C,

Unix Shell Programming

Clear Case, HP Unix and Sun Solaris

Power Builder 10.0, PFC, Java, JSP,

XML, HTML, JavaScript,

Object Cycle, Clear Case (Windows, Unix), Windows 2000

Description:

The HRIS Plan Admin System is a software application used for setting up

clients and their employees in Paychex 401(k) Record keeping, Section 125,

Workers Compensation and Unemployment Insurance products. HRIS system uses

GIANT (Generic Interface And Network Transport) System, to exchange data

between the 401(k) and Section 125 systems and the branch. GIANT enables

corporate 401(k) and Section 125 Specialists to code clients on the payroll

database for the 401(k) and Section 125 products. GIANT relieves the

Payroll Specialist of most of the coding tasks that were required to set up

clients on the 401(k) and Section 125 products in the past.

As a Programmer Analyst, the responsibilities included:

Understanding business application.

Writing Requirement Specifications based on business requirements.

Creating the project plan

Developing User Interface screens using Power Builder.

Writing Oracle database Triggers, Packages and Procedures and Functions

using SQL and PL/SQL

Used PL/SQL features like cursors, records and collections

Tuning the SQL to improve performance of the application process

Writing Unix shell programs job scheduling

Writing the processes using Pro*c

Developed Oracle functions to process XML files.

Extract and Load data using SQL Loader

Generating the Reports using the SQR reporting tool and Info Maker

Following Quality procedures setup by Paychex Inc.

GE-Transport International Pool Inc., Devon( USA )

Period : January 1998 - May 1999.

Project : Maintenance & Repairs of Homerun application

Environment : PowerBuilder 6.5, Oracle 7.3, SQL, PL/SQL, Windows NT4.0

and

Sun Solaris

Description :

Homerun is a client/server application developed for GE-TIP - an Industry

leader in the rent, lease and sale of Trailers, to serve its Operation's

function of the business. This module facilitates the maintenance and

repairs of trailer units. The system records a unit's damage, permits

standardized customer re-bill immediately, and aids the branch in tracking

the entire unit's repair process. Additionally, maintenance and warranties

will be automatically scheduled and recorded.

As a programmer analyst, the responsibilities included:

Analysis, Design, and coding of complete application.

Studying existing organization setup.

Interacting with Client to improve business functionality of the

application.

Developed database objects packages, procedures, functions and triggers

Developed user interface screens

Following the Quality procedures set up by Wipro and Client.

Delivered the code on time with out any rejections.

5. GE-Transport International Pool Inc., Devon( USA )

Period : September '97 -- December '97

Project : Reservation module of Homerun application

Environment : PowerBuilder 4.0, PowerTool, Oracle 7.3, SQL, PL/SQL,

Windows NT4.0, Sun Solaris

Description :

Homerun is a client/server application was developed for GE-TIP - an

Industry leader in the rent, lease and sale of Trailers, to serve its

Operation's function of the business. The Reservations module captures

trailer reservation information for customers when they call up to reserve

trailers. It is very tightly integrated with Lease and Rates modules and

also accesses Customer and Inventory modules.

As a programmer analyst, the responsibilities included:

Coding and formulating the basic design layout for the application.

Developed database objects packages, procedures, functions and triggers

Developed user interface screens

Following the Quality procedures set up by Wipro and Client.

On-site testing and implementation of the application.

Wipro Systems Limited, Bangalore

Period : March 1997 -- August '97

Project : Billing System

Environment : PowerBuilder 5.0, Oracle 7.3, SQL, PL/SQL, Windows NT4.0

and

SunSolaris

Description :

Billing System is one of the major modules in RAMPS (Resource Allocation

Monitoring and Project profitability System). RAMPS is a program of

projects which would enable monitoring of the business operations

This system mainly used to raise invoices based on the different services

provided by the Wipro Systems to the Clients. The Billing system would

address the following key features:

i) Centralized information on billing due/done at

assignment/group/department level

ii) Invoice preparation and printing/saving in other formats

iii) Accurate reconciliation of overseas allowance and invoice

iv) Reduce operation costs

v) Projections based on Planned Vs Actual business done

The system was able to utilize the full power of the application

development tool and still provide an easily maintainable open system.

As a programmer analyst, the responsibilities included:

Designed re-usable components

Interaction with users.

Developed database objects packages, procedures, functions and triggers

Developed user interface screens

Following the quality procedures set up by Wipro

Delivered the code on time with out any rejections.

GE Corporate, USA

Period : June 1996 - December 96

Project : LEAP - Financial Analysis and Reporting System

Environment : PowerBuilder 4.0/5.0, PowerTool, DBArtison, Sybase system

4.9.2,

MS-Excel, SQL, OLE, Windows 3.1, SunSolaris

Description :

Leap is a Financial Analysis and Reporting System developed for the

Corporate information Services, the IT arm of the global giant GE. This

Client/Server System was integrated with an existing Mainframe Ledger

Processing System; the data for analysis and reporting came from various

sources (Mainframe and Client P/Cs) and was integrated at the back-end

server

The Project also involved understanding of the Client Business, which was

in the area of Financial Accounting and establishing a smooth transfer of

data between the Mainframe system and Client Pcs through an MDI Gateway.

The idea of OLE also used extensively to tap the power of spreadsheet

applications, in this case MS-Excel. The system was thus able to utilize

the full power of the application development tool and still provide an

easily maintainable open system.

As a programmer analyst, the responsibilities included:

Understanding of the client business, which was in the area of Financial

Accounting

Developed database objects procedures, functions

Developed user interface screens

Establishing a smooth transfer of data between the Mainframe system and

client PCs through MDI gateway

Used the idea of OLE extensively to tap the power of spreadsheet

applications, in this case MS-Excel

Utilized the full power of the application development tool

Provided an easily maintainable open system

2. CureWell Drugs Ltd., Madras

Project : Tour Reimbursement System

Period : January 1996 - May 1996

Environment : PowerBuilder 4.0, PowerTool, Oracle 7.1, Windows 3.1, and

UNIX

Description :

TRS is a system designed to provide all information about all officially

approved tours connected with the affairs of the company including

Transfer, Leave Travels and other Official Tours. The system has been

divided into Three sub modules. Employee Classification module deals with

Employees category and applicable criteria for reimbursements made by the

Employee. Travel and Stay Information module deal with the expenses depend

on the mode of Travel (Road/Air/Sea), expenses of boarding and lodging

admissible on Tour. Travel expenses on Transfer module deals with the

details of reimbursements admissible to an Employee with respect to his

category at the time of commencement of his out-ward-journey from his

previous Head Quarters

As a programmer analyst, the responsibilities included:

Designing of the various re-usable components

Interaction with end-users

Developed database objects packages, procedures, functions and triggers

Developed user interface screens

Following Quality and ISO procedures set up within the organization.

User training and technical writing for manuals

1. CureWell Drugs Ltd., Madras

Project : Decision Support System

Period : June 1995 - December 1995

Environment : Power Builder 4.0, Oracle 7.1, Windows 3.1, and Unix

Description :

DSS used to supplement a manager's decision by providing necessary and

precise information, which will then be inferred to by the Manager. It

primarily supports queries related to various aspects of manufacturing

system such as Machine Utilization, Vender Analysis, Costing information

etc. The system is integration of data from various subsystems such as

inventory control system, production control system.

As a programmer analyst, the responsibilities included:

Designing of the various re-usable components

Interaction with end-users

Developed database objects packages, procedures, functions and triggers

Developed user interface screens

Following Quality and ISO procedures set up within the organization.

User training and technical writing for manuals

Contact this candidate