Developer System

Title:Lead Customer Support Specialist Springer

****@*******.***

Document

Source below

NAME: dsouza, jonathan

ADDRESS: **** ******** ****

ADDRESS2:

CITY: Bay Area

STATE: CA

ZIP: 94010

CANDIDATE ID: 2258087

US CITIZENSHIP: US

Citizen

EDUCATION: Bachelor Degree

EXPERIENCE: 5

WILL RELOCATE: Yes -

JOB WANTED: Any

RATE NEEDED: Open

TELEPHONE: 650-***-****

EMAIL: ****@*******.***

HOMEPAGE:

HOTTEST SKILLS: perl/cgi =5+ yrs, pl/sql =5+ yrs, oracle development =5+ yrs

REVISION: 24-OCT-01

YOE: 5

RESUME:

Objective

To pursue a career in Web development with my sound knowledge and skills in PERL/CGI and

Object Oriented Programming.

Experience Summary

Around six (6) years working on Web (CGI/PERL/HTML/JavaScript) and RDBMS (Oracle 7.x/8.x)

application development life cycle with focus on system study, design, development and

implementation. Developed applications encompassing various industries like Information

Technology (IT), automobile manufacturing, and pharmaceutical. Familiar with Java

programming (swing, jdbc).

Technical Summary

Operating Systems : UNIX (Solaris 2.8, Sun OS 5.6, HP-UX 11.x), Windows NT / 2000 / 95

Internet Tools : CGI/PERL/HTML/DHTML/JavaScript

Web Server : Apache, IIS, Oracle Application Server

RDBMS : Oracle 7.x/8.x, SQL Server, RedBrick (32) Data Warehouse

GUI Tools : Oracle Developer 6i, Oracle Designer 6i

Programming Tools : PL/SQL, C, Pro*C, Java (swing, jdbc)

Tools & Utilities : TOAD, SQL*PLUS, SQL*Loader

Data Warehouse Tools : Brio Query Analyzer, Informatica

Hardware : Sun Ultra Sparc 20, Ultra 5,Ultra 10, E10k, E450, Sun Ultra-80 Sparc

Professional Experience - Major Projects (in reverse chronological order)

September 2000

till dateSr. Web Programmer

Majordomo Vantive Data Synchronization for Network Appliance, Sunnyvale, CA.

Majordomo Vantive data synchronization is a backend process developed using PERL and

Oracle 8.x. This is an automated process and was developed to synchronize the data between

two different tools used by Network Appliance, namely, Majordomo and Vantive. The Perl

modules used in this process are DBI.pm and DBD-Oracle.pm modules.

Also, involved in enhancing an existing process of generating the new bugs script by

getting the new bugs information into the Oracle database instead of a text file by

writing a Perl script and a PL/SQL trigger. Enhancement of PERL modules for maintaining

the database usernames and passwords, sending an email by using Object Oriented

methodologies, such as bless function which is widely used in object oriented code. This

methodology includes object-oriented analysis (OOA) & object-oriented design (OOD).

Responsibilities: Analysis, design, development, testing and implementation of

application systems, fine tuning some of the existing processes with focus on performance

enhancement by using object oriented concepts, writing PERL scripts and modules, bug

fixing, analysis and design of the database tables, PL/SQL scripts such as triggers,

stored procedures and packages.

Environment: Sun Ultra - 80 Sparc, Sun OS 5.6, CGI/PERL 5.004, Oracle 8.x, Windows NT

March 2000

till August 2000Sr. System Developer

Product Data Management for Cisco Systems Inc

., San Jose, CA.

Product Data Management is a web based system developed using PERL (using oraperl.pm

module), HTML, JavaScript, Forms 6.0, designer 6i and Oracle 7.x. This module is a part of

Repair Implementation process developed for the planning department of Cisco Systems Inc.

This module provides a valuable aid for the product analyst to analyze and assign an

attribute to the new part or to an acquisition. Once the part has been analyzed, then the

analysis details are passed on to the planning team.

Responsibilities: Analysis and design of the database tables using designer 6i, writing

PERL scripts using Oraperl module, writing PL/SQL scripts such as Package and stored

procedures, developing user friendly screens using Forms 6.0, thorough testing of the

programs with focus on performance enhancement.

Environment: E450, HP-UX 10.2, PERL, Designer 6i, Forms 6.0, Oracle 7.x, Windows 2000

October 99

till February 2000Team LeaderConsultative Selling for Hewlett Packard, Mountain View, CA.

Web based system developed using HTML, JavaScript, PERL, SQL Server and RedBrick (32)

Data Warehouse, provides a valuable aid for the Customer Support department of Hewlett

Packard. This system mines the data based on the given conditions from one or more servers

and the Data Warehouse and then generates an Output file from where the data will be

converted into HTML forms. The Perl modules used in this process are DBI.pm and DBD-

ODBC.pm modules.

Also, involved in enhancement of PERL modules for maintaining the database usernames and

passwords by using data structures and object oriented methodologies, such as bless

function which is widely used in object oriented code.

Responsibilities: Writing PERL scripts and modules, Analysis of Database (Existing &

Proposed), writing SQL scripts using SQL Server, Procedures and Functions, Analysis of

database tables, thorough testing of the programs with focus on performance enhancement.

Environment: E10k, HP-UX 10.2, CGI/PERL/HTML/JavaScript, SQL Server, RedBrick (32) Data

Warehouse, Windows NT

December 98

till September 99Project Leader

Pharmaceutical Distributors System for Pharmadeal Pharmaceutical Distributors, India

This system was developed using Unix/PERL/Oracle (PL/SQL), Designer 2000 and Developer

2000. This system is a fully automated system, which automates the stock maintenance of

goods receipts and goods issued of Pharmadeal Pharmaceutical Distributors. It also

automates the placements of the purchase orders, receiving the sales orders and goods

returns. The user can query the information regarding any item about its current status.

Responsibilities: Analysis of Database (Existing & Proposed) using oracle application

tool, writing Perl scripts, SQL scripts using PL/SQL, procedures and functions in a

package, thorough testing of the scripts with the primary consideration being performance.

Environment: Sun Ultra 5, Solaris 2.x, PERL/Oracle 8.x, PL/SQL, Designer 2000, Developer

2000, Windows NT

May 98

till November 98System Developer

Payroll system for Cosmic Technologies, India

Developed using Oracle 8.0 as backend, Designer 2000 and Developer 2000 as its front-end

tool. This system was developed to fully automate the Payroll process of Cosmic

technologies, India.

Responsibilities: Involved in system study (including user requirement study and

functional specification), design (including block diagrams, DFD, C coding, PLSQL and ER

diagrams), create of tables, constraints, procedures and triggers, forms and report

formats design, testing and implementation at the client location (including system

installation, acceptance testing, and training). Involved extensively in requirement

study, functional specification documentation, creating of process flow and testing of

modules.

Environment: Oracle 8.0 (PL/SQL), Developer 2000 (Form 4.5, Report 2.5), Designer 2000

under Windows NT.

August 97

till February 98System Developer

Purchase Journal/Purchase Journal Expenses (Accounting module) for Brakes India Ltd.,

India

The Purchase Journal/Purchase Journal Expenses system has been developed for Accounts

department of Brakes India Ltd. to account for the purchased items and subsequently make

payments to the suppliers. The tools used in this system were Oracle v 8.x, Developer 2000

and Designer 2000.

Responsibilities: System study (including user requirements study & functional

specification), design (including block diagrams, DFD and ER diagrams), creation of

tables, constraints, procedures and triggers, form and report design, testing of the

system and implementation at the client location (including system installation Acceptance

testing, and training). Involved extensively in form and report design and testing.

Environment: Oracle 7.x (PL/SQL), Developer 2000 (Forms 4.5, Reports 2.5), Designer 2000

under Windows NT.

January 97

till July 97System DeveloperStores System for Brakes India Ltd

., Madras, India

The Stores System was developed to computerize the various functionality of the Stores

department. This system was developed using Oracle as its backend, Designer 2000 and

Developer 2000 as its front-end tool. This system includes Challan number generation,

Goods Inward number generation, Reports, etc.

The Reports generated by the system gives complete details regarding the Receipt and

Issues of the items for a particular month based on Supplier wise, Product wise, etc. One

of the important report is to give day to day status of the stock position of all the

critical items to the top management.

Responsibilities: Involved in system study (including user requirements study, functional

specification), design (including block diagrams, DFD and ER diagrams), creation of

tables, constraints, procedures and triggers, form and report format design, testing of

the system and implementation at the client site (including system installation,

acceptance testing, and training). Involved extensively in system study, design and

testing.

Environment: Oracle 7.x (PL/SQL), Developer 2000, Designer 2000 under Windows NT.

July 96

till December 96System Developer

Purchase Order System for Brakes India Ltd

., Madras, India

The Purchase Order System provides a valuable aid for the commercial department of the

company. This system fully automates the Purchase Orders based on the requirements from

the respective user departments of Brakes India Ltd. This system also provides queries

based on any information and gives reports according to the needs of the user.

Responsibilities: System analysis, design, development, testing and implementation at

site.

Environment: Oracle 7.x, PL/SQL, Developer 2000 under Windows 95.

January 96

till June 96System Developer

Personnel Information System for Brakes India Ltd

., Madras, India

The Personnel Information System provides a valuable aid for the personal as well as

official details of each employee employed in the company. The system incorporates

different types of reports such as Blood details, Seniority report, Progression details,

Educational qualification details, Retirement details, Training details, etc. This system

also provides queries based on any information and gives reports according to the needs of

the user.

Responsibilities: System analysis, design, development, testing and implementation at

site.

Environment: Oracle 7.x, PL/SQL, Developer 2000 under Windows 95.

Education: Master of Computer Applications,

University of Madras.

Contact this candidate