System Project

DIORIS RAFAEL ALVARADO

*** ****** ****, *******-***** NC 27105

email: ******@****.***, ******@*********.***

Phone: 336-***-****, C: 978-***-****

Profile:

An energetic achiever that has developed and Supported systems, Willing to take on challenges

of learning new technology. I have created ininnovating new system applications for

Goverment Agency, Hospitality Companies and Educational Institutions.

Provided support for an organization as a UNIX Systems Administrator.

SKILLS:

ORACLE- PRO-C/PL-SQL/SQL-form (5) years

UNIX (AIX) Shell (KS, BSH, CSH) (15) years,

INFORMIX-4gl/SQL/ESQL_C (15) years

C (15) years

PERL, Crystal forms (4) years

Certificate in Oracle Database Administration

JAVA Training

COBOL (4) years

EXPERIENCE:

The Adaptable Corp, Winston-Salem, NC Computer Instructor Dec-2007 to Present.

Provide training in computer literacy on different Microsoft tools.

Continue developing applications using PL/SQL and other ORACLE tools.

CATAPULT TECHNOLOGY CORP., Washington D.C, Programmer/Analyst Sep-2009 Dec-

2009

Provide support by analyzing problems on the system and making modifications to the

applications. The project also include the design, development and testing of new applications for

future releases.

Conduct system analysis and submit recommendations to improve system

efficiency and performance.

- Some of the tools used: Oracle-sql, Pl/Sql, C, PERL and UNIX (KS)

VIVA USA CONSULTANT, Winston-Salem, NC Programmer/Analyst Jul-2006 to Oct-2006

Design and support a pension system. Analyze the current system to enhance and add new

features. Also, provide support by fixing bugs and making modifications to the applications.

Trained new staff in INFORMIX-4GL, INFORMIX-SQL.

- Some of the tools used: PL/SQL, C++, and UNIX (KS)

COMPUTER SCIENCE CORP., Chicago, IL Programmer/Analyst Oct-2005 Dec-2005

Design and support reservation system. Provide support by fixing bugs and making

modifications to the application. The project also include the design, development and testing of

new applications for future releases.

- Some of the tools used: INFORMIX-4GL/E, SQL_C and UNIX (KS)

DLA CONSULTING ASSOCIATES, Lawrence, MA. Programmer Oct-2004 Jul-2005

Design and develop student record tracking systems for local School. Design to client's

specifications. The project included the analysis of the current system, design and development of

a database system and some applications to run all aspects of the school system

- Some of the tools used: Oracle-SQL PL/SQL, PERL

BLUE CROSS OF FLORIDA, Florida, Application Developer Sep-2002 Dec-2002

Developed an Insurance Medical systems application that sought to analyze, identify file type and

create standardized file formats to upload into a database system.

- Some of the tools used: Oracle-SQL, PL/SQL and a File Edit Scripting

VERIZON, Tampa Florida, Application Developer June-2000 Feb-2002

Developed a security systems application that sought to analyze, identify file type and create

standardized file formats to upload into a database system. The script program included the

following functionalities of the main driver for the security application system

Main driver would identify the file format

Break each line into records and fields

Create a standard file format

Generate SQL scripts depending on the file type

Run the SQL script to upload the data in to the database

Perform file maintenance

- Some of the tools used: C, ESQL-C, SQL, PERL and INFORMIX-4GL

Provide technical Assistance to other members of the team to develop other areas of the project.

Developed documentation for the Systems Administrators to maintain the security systems

application.

Develop an application to maintain an equipment database management system; involving the

manipulation of data from the inventory database, downloading it and prepare the information to

be transferred to another system for further processing.

- Some of the tools used: Oracle/PL-SQL/PRO*C and PERL (DBI)

HARVARD UNIVERSITY, Cambridge, MA, Database Application Developer Sept-1997 June-2000

Working under new release of the accounting system using INFORMIX-4GL/SQL, C, PERL and

UNIX tools. Duties included:

Redesign the current database to comply with the requirements specified by the new

school's accounting system

Analyzed each of the application of the accounting system

Identify changes and make the necessary adjustments. Most of the screens and reports

were developed to reflect the changes made in the applications and the database.

Assist staff with the installation and implementation of other database applications for a

newer version of INFORMIX.

Created and monitored the database (tuned, created indexes, etc.)

Wrote SQL scripts to improve efficiency of database and to monitor the integrity of the

data.

MASSACHUSETTS DEPT. OF REVENUE, Boston, MA, Database Specialist 1994-1996

Developed programs using COBOL, IQU to maintain RDBMS/DMS systems. Maintained

database for a Unisys system. Completed time-critical projects related to the unload/reload

program in preparations for the 1996 reorganization of a Case Tracking database to streamline

operational processing for revenue collections. Analyzed database schema and other software

tools such as the Database Editor (D.B.E.) and IQU and presented enhancement opportunities for

review.

- Some of the tools used: COBOL, Oracle, SQL Forms, SQL Plus, and Pro C

JOHN HANCOCK FINANCIAL SERVICES, Boston, MA, Programmer 1993

Recruited to administrate a project segment for updating a system application for a pension

system on an IBM mainframe using COBOL.

SHERATON CORPORATION, Braintree, MA, Computer Systems Analyst, 1987-1991

As team member on the development of Worldwide Reservation Systems, contributed to the

conversion to a new reservation system that would make the company more flexible and dynamic

when responding to client needs. Designed database applications and communication programs

for an NCR system. Developed and supervised documentation controls. Generated detailed

reporting for executive review.

- Some of the tools used: UNIX platform, C, SED AWK, BOURNE-Shell,

INFORMIX/ESQL/SQL/4GL

INTERNAL REVENUE SERVICE, Boston, MA, Programmer Analyst, 1983-1987

As project leader, analyzed, designed and implemented database applications. Conducted a

system study for a division of the Internal Revenue Service, made presentation of findings to

management committee. Trained new employees and supervised staff throughout all project

phases. Recognized with several awards for achievements and performance.

- Some of the tools used: UNIX platform, COBOL, C, INFORMIX and Bourne-Shell

EDUCATION:

UNIVERSITY OF MA 100+ Credit

Bachelor Degree in Management Information Systems

NORTHERN ESSEX COMMUNITY COLLEGE, Haverhill, MA.

Associate of Science in Computer Science

Contact this candidate