Post Job Free

Resume

Sign in

Service Analyst

Location:
Knoxville, TN, 37922
Posted:
March 09, 2010

Contact this candidate

Resume:

Technical Skills:

Languages: RPG II, RPG III, RPG IV, RPG ILE, RPG Free, SQL

Hardware: S/34, S/38, AS/400

Systems Software / Utilities: HATS, ALDON, HAWKEYE, TURNOVER, SUBFILES,

SDA, RLU.

Professional Experience

Clayton Homes/Vanderbilt Mortgage Finance, Knoxville, TN

March 2007 - October 2009

Sr. Programmer/Analyst

. Member of the HATS conversion committee.

. Designed, Coded, and implemented a New Document Control application

which automatically created the different Investor File "document

types" based on the posting date. This process affected all areas in

Vanderbilt. It replaced an application where the different document

types had to be created manually. The new process ran from ROBOT. All

the programs where created using Free format RPG with embedded SQL

statements, creation of SQL tables and indexes, Service Programs and

ILE Static binding.

. Replaced the existing IRS-1040 application and created a New process

Menu driven where the Users only had to call Operations to run it. No

programmer intervention was needed and the Users could run tests before

the final run. SQL tables were created, creation of binding

directories, service programs, free format RPG.

. Lead the first phase of a HATS implementation team where many of the

"Collection Application" Green screens where converted to GUI. This

effort was designed using SQL tables, programming on Free format RPG,

heavy use of service programs, stored procedures and activation groups.

These would later be used in the other phases of the project.

. Always worked on 8-10 concurrent projects modifying many RPG programs,

where I would convert to Free format RPG, modularize whenever possible,

create service programs when certain functions could be shared by other

programs, and update the program as much as possible while fixing the

specific problem.

Miami-Dade County/General Services Administration Dept. Miami, FL

Feb 2005 - Sept 2006

Sr. Programmer/Analyst

. Re-designed Miami-Dade's Retirees benefits plans following Government

mandated changes. Database files where converted to SQL tables.

Applications where modularized and ILE standards were introduced.

Service programs where created, Static binding, embedded SQL.

. Enhanced the Work Order application by rewriting the Unique Service

Ticket assigned to every county order. The maximum number for a service

ticket was approaching. I designed a new numbering system at random

based on a combination of Department/Area/Section and a Random #. Most

of the master files were changed to accommodate this field expansion.

As a result, hundreds of programs needed to be modified using RPG IV.

. Created New application to process Online office supplies orders

through the Web. SQL tables were created, ILE service programs, Static

binding was introduced. The whole process was programmed using ILE. I

was responsible for the back/end processing of the orders. The

front/end was developed in Visual Basic.

Computer Aid, Inc, Miami Lakes, FL

June 2004 - Feb 2005

Sr. Programmer/Analyst

. Created RPG IV programs for auditors concentrating in audit trails to

comply with the Sarbanes & Oxley act.

. Analysis of business processes and modification of many RPG IV programs

to conform with new regulations and standards.

Warner Brothers Publications, Miami, FL

Feb 2002 - April 2004

Sr. Programmer/Analyst

. Created different modules to upgrade the picking and packing programs

in the warehouse application. Many new RPG IV programs where designed,

coded, tested and implemented.

. Automated the End of Day closing procedure. Created several Control

Language programs to reconcile all financial applications. Automated

the A/R and A/P closing.

. Created New Ticket and Information request application. Users were

trained by departments and it became an instant success. All

programming was done using RPG IV.

Chase Manhattan Bank, Miami, FL

Oct 1997 - Jan 2002

Programmer/Analyst

. Analysis and programming for the Private Banking International software

which included a module for Foreign Exchange, a Securities module, a

Stock Exchange module, etc. Participated in the Y2K conversion team by

modifying hundreds of programs and screens to comply with standards

using RPG III and RPG IV.

. Participated in the EURO conversion project modifying many RPG programs

before the EURO was implemented as a new currency.

. Implemented the Y2K project in Jersey, Channel Islands and was

commended with honors for my dedication and hard work in the

programming efforts.

Renaissance Worldwide, Fort Lauderdale, FL

Nov 1991 - Aug 1997

Programmer/Analyst

. Developed profitability modules with report downloads to PC based

applications in RPG III for the Upper management at Sonny Broadcasting.

. Modified financial statements and accounts receivable programs which

had many unexpected results at Barclays Bank PLC using RPG III.

. Designed new custom forms and automated the UPS/Fedex labels for faster

shipping service and handling using RPG III.

. Modified entire billing application at PCA Healthcare Services using

RPG III. All the different billing plans had bugs and the billing

statements always had errors.

Education

1983-1987 Universidad Catolica Madre y Maestra Dominican Republic

Systems Engineering Technical degree

2002-2004 Miami-Dade College Miami,

Fl.

Associates in Arts

2004-2006 Florida International University Miami, Fl.

Bachelor in Finance



Contact this candidate