Oracle System

Suresh Joshi

***** ******* *** ****: 703-***-****

Herndon, VA 20170 ***********@***.***

SUMMARY

** ***** ********** ** *********** Technology field as Developer, Analyst,

Database Programmer, Project Leader. The experience includes:

Requirement gathering for new systems and conversions.

Database design using various versions of Oracle (10g, 9i, 8i, 7.x) and MS

Access.

Database creation and maintenance on Unix and Windows NT/2000 platform,

Unix scripting.

Installing and configuring Oracle Collaboration Suite 10g, creating users and

work spaces.

Design and Development of applications from scratch and conversions

including enhancements, coding, testing using Forms (10g, 9i, 6i, 4.5, 3) and

Reports (10g, 9i, 6i, 4, 2.5).

Design, enhancement, coding of SQL and PLSQL procedures, packages and

libraries.

Development, testing and improvements to Pro*C and Pro*Cobol programs

and conversion from Pro*C and Pro*Cobol to Oracle Reports.

Data migration from legacy systems to Oracle based systems.

Development, conversion and improvements to user interfaces in client server

and web mode.

Development of programming standards.

Project Monitoring in ISO 9000 environment.

TECHNICAL SKILLS

Proficient in following languages

SQL/PLSQL,

C

COBOL

Pro*C, Pro*Cobol

Unix scripting

Proficient in following databases

7,7.1,7.3,8i,9i,10g

MS Access

Tools and Utilities

Developer 2000, Toad, Oracle Forms and Reports 6i, 9i, Crystal Reports,

Oracle Application Server (OIAS) 9i, Oracle Collaboration Suite 10g

1 of 7

Suresh Joshi

13409 Parcher Ave Cell: 703-***-****

Herndon, VA 20170 ***********@***.***

Erwin

PVCS

Operating Systems

Windows 98, 2000, NT, XP

Unix (Sun Solaris and SCO)

BTOS

PROFESSIONAL EXPERIENCE

May 2008 – Current: PLSQL Programming.

Client: Department of Navy

Details: Department of Navy has its own criminal justice system

(DONCJIS). The crime data is obtained from the field reports and

fed into this system in the form of flat files. We are redesigning the

data input and validation checks as a part of bigger development

project for DONCJIS.

Responsibilities: Development and redesign of SQL/PLSQL programs for improved

performance and updates and to suit the changed requirements.

Environment: Oracle 10g, Sun Solaris servers, Oracle SQL Developer, Toad.

Jul 2007-Apr 2008t: Oracle Development

Client: Alcohol, Tobacco, Firearms & Explosives Bureau (ATF)

Details: ATF has an old system for Federal Licensing of Firearms. The

system has a front end of Oracle Forms and Reports (6i) and a

database using Oracle 9i. We are maintaining the system and

planning to upgrade it to oracle 10g.

Responsibilities: Maintenance of forms and Reports, Design of new Forms and

Reports.

Aug 2006-Jul 2007: Oracle Collaboration Suite 10g

Client: National Oceanic & Atmospheric Administration

(NOAA)

Details: We are working on a pilot project for using Oracle Collaboration

Suite 10g for Content Management. The previous attempts of using

this software on LINUX had to be abandoned because of some

internal problems. When successful, there are plans to make a large

number of documents to about 5000 users spread over a large

geographic area and also to implement hierarchy of privileges over

these documents.

Responsibilities: Installation and Configuration of Oracle Collaboration Suite 10g in

3 tier architecture. Creating and maintaining users and their

privileges. Creating and maintaining work areas and granting

2 of 7

Suresh Joshi

13409 Parcher Ave Cell: 703-***-****

Herndon, VA 20170 ***********@***.***

access to various users, transferring contents to proper folders.

User support.

Environment: Windows Server 2003

Aug 2004-Jul 2007: Communication Information System (CIS) Upgrade:

Client: National Oceanic & Atmospheric Administration

(NOAA)

Details: CIS-NWSAPP is the system which supports the automation of

Telecommunications Billing database for NOAA, and also

provides data to the main financial system of department of

commerce. This system needed upgrading because of new

technology and changed requirements. The new system is

developed to include and enhance all functions of the older version

and also to include several new requirements and security feature.

The new system will also be web enabled.

Responsibilities: Requirement analysis, study of existing system, design of new

system, database design, design of new interface between CIS and

main financial system, guiding development, technical lead, client

training and support.

Environment: Windows Server 2003, Windows XP Professional, Oracle 10g.,

Oracle Forms and Reports 9i.

Apr 2004 – Jul 2004: Contract Management and Tracking System (CMTS)

Client: Dept. of Army

Details: CMTS was developed to support the management and tracking of

different contracts and task orders issued under these contracts. It

helped the DOA executives to control the finances and personnel

working on different contracts. It also provided in depth financial

analysis of different contracts and help budgeting and forecasting.

The system co-operated with the existing system ECA, which

mainly dealt with the limited aspect of tracking of personnel on

contract. CMTS is Oracle based and uses Java in the front end. On

its completion it was used by multiple contracting offices of DOA.

Responsibilities: Requirement analysis, meetings with the client, system study,

design of database, design of interface between EAC and CMTS,

technical lead, customer training and support.

Environment: Oracle 9i, Unix, Java.

Nov 2003 – Mar 2004: CAMS Conversion Project:

Client: Dept. of Commerce.

Details: This was a conversion project for the Financial Accounting system

for the Dept of Commerce. The original system was developed

using Forms 3.0 and ran against Oracle 7 database on Unix

3 of 7

Suresh Joshi

13409 Parcher Ave Cell: 703-***-****

Herndon, VA 20170 ***********@***.***

platform. The system had high number of Forms and Reports. We

converted these forms and reports to 6i version against Oracle 8i

database and in the second phase they were redesigned and

converted to version 9i and web enabled.

Responsibilities: Conversion of Forms version 3.0 to Forms 6i using the Kumaran

conversion tool, changes to suit the GUI platform, testing and

monitoring the workflow.

Environment: Oracle 8i, 7i, Toad, Forms 6i, 3.0, Kumaran conversion tool, Sun

Unix.

June 2003-July 2003: Trusecure Inc.

Responsibilities: During this period I worked on the database for security audit and

certification. My work involved

modifying PLSQL procedures and packages..

Environment: Oracle 8i, Toad, SQL / PLSQL, Windows 2000.

4 of 7

Suresh Joshi

13409 Parcher Ave Cell: 703-***-****

Herndon, VA 20170 ***********@***.***

Mar 2000- Apr 2003: BTS (Bureau of Transportation Statistics)

Client: BTS (Bureau of Transportation Statistics)

Details: This system supported the collection of Financial and Operational

data from thousands of transporters in US. We started with a very

sketchy database, which was in MS Access and over a time

evolved the Oracle based system with client server and web-

deployed modes for collection and distribution of data.

Responsibilities: Requirement analysis by discussion with the users, study of the

existing system and database, Design of new Oracle database,

migration of data from old MS Access database, development of

Forms and Reports with PLSQL library for data entry,

development of extensive PLSQL procedures and packages for

validation of data, help to users to understand the potential of

Oracle based system and enhance the utility of the application,

quality checks and automation of some parts of the system, web

deployment of the application for data collection and distribution,

supported all users.

Environment: Windows NT, 2000, MS Access, Oracle 8i, Toad, SQL/PLSQL,

Forms 6i, Reports 6i, Oias9i.

Feb 99- Feb 2000: MSDE Student and Teacher Enrollment System

Client: Maryland State Department of Education

Details: This system was designed to automate and monitor the process of

enrollment of students and teachers for different courses offered by

the schools and colleges in the state of Maryland. The web user

loaded the data, triggered the validation process over the web, and

receive the results of validations and analytical reports over the

web.

Responsibilities: Study of requirement of users and the legacy Cobol system,

finding the shortcomings of the legacy system and possible

improvements with the new Oracle based system, meetings with

the user to formulate the design of new system, system design,

development of GUI standards, development of Forms and

Reports, development of extensive SQL and PL/SQL libraries for

the application, automation of the validation procedure on server,

web deployment of the application, installation and support at

client site.

Environment: Windows NT, Oracle 8.0.4, Forms 5.0, Reports 3.0, Oracle Web

Application server

5 of 7

Suresh Joshi

13409 Parcher Ave Cell: 703-***-****

Herndon, VA 20170 ***********@***.***

Feb 98- Dec 98: SERS (State Employees’ Retirement System)

Client: State Govt. of Pennsylvania.

Details: This was a Retirement Accounting System for employees of

Pennsylvania State. It maintained the retirement accounts and

details of contributions, deductions, withdrawals and benefits and

generates various reports.

Responsibilities: Improvements to Forms and Report, conversion from Forms 3.0 to

4.5 and from Pro*c reports to Oracle Reports 2.5, Pro*C and

Pro*Cobol programs, SQL/PLSQL procedures and packages to

support the changed requirements, development of new procedures

and tuning of the application, development of new Forms and

Reports, Unix scripting.

Nov 97- Jan 98: Warehouse Inventory System

Client: Dayton’s – Minneapolis

Details: This was an inventory control system for warehouse. It provided

for identification of material in a large warehouse, reservation for

shipments, requisitions and similar things for controlling the

inventory.

Responsibilities: Testing and debugging of the application, Unix scripting.

Environment: IBM Main frame, Unix, Windows 95, Pro*Cobol, Oracle 7.3,

Forms 4.5

Jan 96- Oct 97: APEX (Automated Proration Expert)

Client: Emirates Airlines, New Zealand Airlines, Continental Airlines

Details: This is a specialized product developed by Kale Consultants Pvt.

Ltd. (India) for handling the crucial part of Proration in an

Passenger Revenue Accounting (PRA) System for airlines. The

system works on the Airline ticket data. The revenue for each

ticket is distributed into different sectors and different airlines

serving on these sectors. This depends on the type of ticket and

also on the rules and regulations set by the IATA (International Air

Traffic Authority) and the mutual agreements between airlines

(SPA). APEX works on the ticket data entered into the PRA

system during every shift and returns the analysis to the main

accounting system. It can be coupled with existing system of

Passenger Revenue Accounting.

Responsibilities: Database design, development of Forms and Reports, conversion

of Forms and Reports from 3.0 to 4.5, development of libraries for

common use, development of module for data transfer from the

6 of 7

Suresh Joshi

13409 Parcher Ave Cell: 703-***-****

Herndon, VA 20170 ***********@***.***

host system, improvements to Pro*C code, Unix scripting for batch

jobs, application tuning.

Environment: Sun Solaris, Sun Unix, Windows 3.11, 95, Oracle 7.3, Forms 4.5,

reports 2.5, Pro*C.

Oct 95- Dec 95: Sales Invoicing and Analysis

Client: Industrial Electronic and Allied Products (India)

Details: This project was a conversion project. The original system was

developed using Oracle 6 and Forms 3.0. We converted it to

Oracle 7.1 and Forms 4.5 and Reports 2.5. It consists of

preparation of Sales Invoices and various analytical reports.

Responsibilities: System design, development of database, development of Forms

and reports.

Environment: Windows 3.11, 486, Oracle 7.1 Forms 4.5, Reports 2.5, SCO Unix

Education: Bachelors in Physics and Math. (University of Poona, India),

Grad. Cost & Works Accountant (equivalent to CPA) ICWAI

Calcutta (India),

Diploma in Software Technology (Inst. of Software Technology,

Poona, India)

Status in U.S.: U.S. Citizen

Security Clearance: Secret

7 of 7

Contact this candidate