Project Analyst

Resume of

DANIEL PIMENTEL

EXECUTIVE HIGHLIGHTS

. Seasoned IS professional with 20 + years of design, analysis, and

programming experience. His solid technical background coupled with

excellent communication skills are adaptable to all technical and user

environments.

. Lead programming experience.

. 5 years of insurance industry experience, and 5 years of financial

industry experience.

PROJECT EXPERIENCE

TSi

Client: US Bank

Dec 2008 to May 2010

. Main responsibilities as Analyst/Programmer were programming the On-line

collections module for the Credit card system.

. Project involved in:

. Onn-line collections. Changed COBOL II programs to include new business

requirements for on-line processes.

Environment: Credit Card; IBM Mainframe; COBOL II; CICS; DB2; Debug;

Endevor and FILE-AID.

Client: SIRVA

Aug 2007 to Oct 2008

. Involved as Analyst/Programmer duplicating batch and on-line processes

for a new company within the group.

. Project involved in:

. Moving Services. Changed COBOL II programs, CICS screens and JCL procs to

include new company in all batch and on-line processes. Designed new DB2

tables in order to elominate tables in COBOL II programs.

Environment: Moving Services; IBM Mainframe; COBOL II; CICS; DB2; Endevor;

FILE-AID; JCL and XPEDITER.

Client: AON

Jun 2006 to Jun 2007

. Main responsibilities as Analyst/Programmer were the re-engineering of

Claims system from IMS to DB2.

. Project involved in:

. Claims. Changed IMS statements to DB2 calls in several COBOL II programs.

Created new COBOL II-CICS programs to use new DB2 tables.

. Environment: Healthcare; Mainframe; COBOL II; CICS; DB2; FILE-AID; IMS;

JCL; Librarian and XPEDITER.

Client: College of DuPage

Jan 2006 to Jun 2006

. Main responsibilities as Analyst/Programmer for a major College.

. Projects involved in:

. Students Resource. Changed VSAM files layouts and DB2 tables to include

prevoius courses taken by students in College of Dupage; designed new

CICS screens and COBOL II programs to include such information. Also

created a batch process to update DB2 tables and VSAM files with records

coming from Darwin system (courses taken by students at any College in

the US) .

. Courses Data Base. Included new columns in DB2 tables to create previous

mandatory courses that must be taken before taking any given course.

Developed new CICS screens and COBOL II programs to see course's

predecessors chain.

. Environment: Education; Mainframe; COBOL II; CICS; DB2; FILE-AID; JCL; MQ

Series; XPEDITER.

Client: Caremark

Jun 2005 to Dec 2005

. Involved in the programming of various applications for Prescribing.

. Project involved in:

. Prescribing. Modified DB2 Tables to include new columns and COBOL II

programs to use those new columns. All input/output GUI screens were

written in Java.

. Environment: Health Care Insurance; Mainframe; COBOL II; CICS; DB2; FILE-

AID (DB2);

JCL; MQ Series; VSAM and XPEDITER.

Client: State Of West Virginia. Department of Healthcare and Human

Resources

Jan 2005 to Jun 2005

. Main responsibilities as Analyst/Programmer: Involved in maintenance to

MMIS System.

. Projects involved in:

. Daily Cycle. Changed formulas and processes to meet HIPAA regulations

that were hard coded in parms and COBOL II programs, also changed JCL to

read files from Unisys.

. Medicare Cards. Changed several COBOL II programs to select new DB2

tables.

. Elegibility. Maintenance to several COBOL II-CICS programs to select new

DB2 tables and new business rules.

. Environment: Government; Mainframe; COBOL II; CICS; DB2; FILE-AID (DB2);

IMS; JCL; Platinum and XPEDITER.

Client: State Of Florida. Department of Corrections.

July 2004 to Dec 2004

. Analyst/Programmer for the re-engineering of ASI system from IMS to DB2

data base.

. Project involved in:

. ASI Conversion. VSAM files and IMS calls were changed to SQL statements

in several COBOL II programs, both batch and on-line. Created subroutines

that update DB2 tables in order to avoid code while converting from DLI

to DB2 reducing the number of programs that update data bases from 33 to

6. Created test specifications and guide lines for testers, DBAs and IT

people.

. Environment: Government; Mainframe; COBOL II; CICS; DB2; IMS; FILE-AID

(DB2); JCL and XPEDITER.

Client: AFLAC

March 2003 to June 2004

. Main responsibilities as a Project Leader for Modernization of Legacy

Systems project were design batch and on-line modules; set up meetings

with users and IT people; track Projects till the end. He was in charge

of six Analyst Programmers and one tester.

. Main responsibilities as Analyst Programmer for HIPAA project were to

create HIPAA transactions for Claims System and then to MQ Series server.

. Projects involved in:

. Modernization of Legacy Systems. Eliminated VSAM files and change them to

DB2 tables. Data Normalization had to be done to design new DB2 tables;

hard coded tables were eliminated from working-storage COBOL II programs.

Eliminated Easy Thrieve programs and changed them to COBOL II because all

of them were going to select DB2 tables and needed SQL statements. Added

a new voice IVR module so CICS programs could send messages by voice in

Call Center application. Created a new step in Daily Cycle to validate

data coming from MQ Series messages. Eliminated production abends in

different CICS regions for Call Center and Claims sytems.

. HIPAA. Added new module to Daily Cycle in order to send policies that

were asked to have an electronic response to HIPAA system. That was a

Batch process that needed to gather data from eight DB2 Tables to a flat

MF file, then via TFP that file was sent to MQ Series as a transaction

message. Modified DB2 Tables to include new columns; modified CICS Maps

and COBOL II programs to use those new columns.

. Environment: Healthcare; Mainframe; COBOL II; CICS; DB2; VSAM; FILE-AID;

MQ Series; JCL and XPEDITER.

CIBER

Client: HIGHMARK BLUE CROSS BLUE SHIELD

Aug 2001 to Jan 2003

. Analyst/Programmer for Reimbursement, Claims and HIPAA Systems.

. Projects involved in:

. Reimbursement. Modified CICS Maps, COBOL programms and JCL Procs for

normal maintenance purposes because new polices would not be added to IMS

data base only to DB2 tables; also renewals were deleted from IMS data

base and inserted into DB2 tables.

. Claims. Modified CICS Maps, COBOL and Easy Thrieve programms, and JCL

Procs to match users' new requirements; a lot of programms had

compilation errors because they had old COBOL statements and were changed

to new COBOL II statements.

. HIPAA. Added new module to Daily Cycle in order to send policies that

were asked to have an electronic response to HIPAA system. That was a

Batch process that needed to gather data from IMS data base and DB2

Tables to a flat MF file, then via TFP that file was sent to MQ Series as

a transaction message.

. Environment: Health Care Insurance (HIPAA); Mainframe; COBOL; COBOL II;

CICS; DB2; VSAM; IMS; ENDEVOR; FILE-AID (DB2); EASY THRIEVE +; JCL and

XPEDITER.

SUN LIFE FINANCIAL

Aug 2000 to July 2001

. Analyst/Programmer for the New Products System. Functions Included

changing files and maps, programming, testing and documenting. Involved

in all system life cycle phases.

. Projects involved in:

. New Products. Modified CICS Maps, COBOL II programms and JCL Procs for

normal maintenance. Every time a new product was approved a lot of

maintenance had to be done because all logic was hard coded in diferent

programs, even the same calculations and formulas were repeated in

several programs. Changed a CICS application that needed 7 screens to add

a row into a DB2 table to use only 3 screens, also that table was re-

designed.

. Environment: Financial; Mainframe; COBOL II; CICS; VSAM; DB2; JCL; SMART

TEST; INSYNC; FILE AID (DB2); ENDEVOR; MVS; Visual Basic.

INTERIM TECHNOLOGY

Client: AMERICAN NATIONAL BANK

July 97 to March 2000

. Analyst/Programmer for the Cash Manager System. Functions included

changing files and maps, Programming, testing and documenting for the

2000 year implications.

. Projects involved in:

. Cash Manager System. Modified the following to include new century fields

and logic.

CICS Maps, COBOL II programs (reports, layouts and logic), VSAM, GDGs

and Flat

files' layouts.

JCL. Modified several procs to include new SORT fields and record

length in DCB

parameters. Also modified PARM statements and control records.

. Environment: Banking; Mainframe; COBOL; COBOL II; CICS; DB2; EASY

THRIEVE+; JCL; IMS; MVS; PANVALET; VSAM and XPEDITER.

SOFTWARE EXPERIENCE yrs, last used

Yrs, last used

Industries: Banking 5 yrs, Financial 1 yrs,

10 01

Government 1 yrs, Health Care 5 yrs,

05 07

Retail 3 yrs, Warehousing 1 yrs,

00 90

Platforms: MVS 12 yrs, UNIX 1 yrs,

07 00

Languages: COBOL 20 yrs, COBOL II 7 yrs,

10 10

DL/I 4 yrs, JCL 15 yrs,

05 10

PL/I 2 yrs, SQL 6 yrs,

97 10

Databases: DB2 8 yrs, IDMS 6 yrs,

10 10

IMS 4 yrs, VSAM 15 yrs,

07 10

Communications: ADSO 6 yrs, CICS 10 yrs,

03 10

Testing Tools: SMART TEST 1 yrs, XPEDITER 5 yrs,

03 10

Methodologies: System's Life Cycle 22 yrs,

07

Other Software: ABEND AID 3 yrs, EASY THRIEVE + 4 yrs,

10 04

ENDEVOR 3 yrs, FILE AID 3 yrs,

10 10

INSYNC 1 yrs, MQ SERIES 3 yrs,

03 05

MS OFFICE 7 yrs, MVS 15 yrs,

10 10

PANVALET 2 yrs, QMF 8 yrs,

03 10

SPUFI 8 yrs, TSO/ISPF 15 yrs,

10 10

EDUCATION

Certificate in ICM of MEXICO, Mexico City (Associated degree).

CONTACT INFO

670 Hearth Lane

Carol Stream, IL

Phone: 630-***-**** or 630-***-****

email: abl0tx@r.postjobfree.com

Contact this candidate