LUIS PAREDES

acru57@r.postjobfree.com

623-***-****

SUMMARY:

1Over 20 years experience as an information Systems professional with intensive physical and logical

database experience. Experience includes working with Cobol, DB2, CICS and IMS DB/DC

programming experience.

2Developed and maintained online and batch systems. Proven project leadership ability and

experience in directing several programmer / analysts engaged in the development,

implementation and maintenance of sophisticated computer applications.

3Extensive experience in design, analysis and programming of multiple projects, testing/debugging,

and providing trouble-shooting resolutions.

4Ability to think independently to develop new systems solutions and procedures.

Demonstrated experience in problem-solving techniques with administrative information systems.

5Ability to plan and organize day-to-day workload on short and long term projects. Ability to evaluate

workload and available resources and adjust schedules and priorities, as required.

6Ability to observe and make recommendations regarding performance of assigned staff. Ability to

train departmental staff on use of modern administrative information systems.

7Detailed technical knowledge of current IBM mainframe hardware and support software, including

Z/OS, COBOL, DB2, and CICS.

8Areas of experience: Finance, Mortgages, Account Payable/Receivable, Healthcare, Billing,

Inventory, Manufacturing, Order Entry, Accounting, Defense, Deposits, Electronics, Checking &

Savings

9Exposed to DBA processes doing program specification block (PSB) loading Data Base, Estimating

physical database size, Determining on-line data retention requirements Troubleshooting and

resolving database design problems and Supporting Application developers in designing efficient

access to database.

13Experience with SQL statements and relational database (DB2)

14Find the System Requirements Definition the principal phase is to define the user needs, problems

and objectives to be realized by some proposed solutions, identify the project scope, analyze the

current system,

TECHNICAL SKILLS:

Languages: MACPAC, PC/CS, COBOL, COBOLII, COBOL3, PROCUREMENT/D, IMS DB/DC, IMS

DL/I, IMS CHKP/XRST, IMS/EXPERT, BMP, BTS, XPEDITER, VSAM, IDCAMS, GSAM, DATA/EXPERT,

LAN, SDSF, TSO/ISPF, PANVELET, LIBRARIAN, ROSCOE, CLIST, MRP, ASSEMBLER, RPGII, SCRIPT,

SMARTTEST, JCL, IDMS ADS/O, SAS, VIASOFT, TRANSFORM/IMS, CICS, DB2, VISUALAGE

GENERATOR

Hardware: IBM 3090, 308X, 303X IBM 370/360 SERIES OS/MVS/XA, IBM PC & COMPATIBLES,

BORROUGH/4700, OS/MVS/SP

EXPERIENCE:

03/12 Present NORTHROP GRUMMAN COMPANY, SANTA FE, NM.

Title: Sr. Programmer/Analyst

Development several On-line CICS, DB2, application programs with the respective screens for the

conversion from the Integrated System Development (ISD2) to Automated System Program Eligibility

Network (ASPEN).

The cases and clients that are converted need to be flagged in ISD2 as part of each wave interim

conversion to prevent workers from updating any data associated with them. After a client has been

converted to ASPEN there should be no further activity for that client in ISD2 including benefit issuance,

eligibility determination, notice generation, or changes to any data for the client or the cases which

contain that client.

Tools used are DB2, SQL, Cobol II, ISPF/TSO, JCL, Smart Test, Spufi, Platinum, File-Aid, IBM 3090

platform, CICS transactions, relational data bases, cemt, cics, ims/db/dc.

EXPERIENCE:

07/07 12/11 EDWARD JONES FINANCIAL SERVICES, TEMPE, AZ

Title: Sr. Programmer/Analyst

1Responsible for tracking automated and manual transfer from or to another firm, using the

automated customer account transfer system (ACATS).

2Cobol development On-line and batch CICS, DB2 applications, designed the screens format for the

Insurance/Annuities Transfer System.

3Supported and handle all types of transfers pending, in process, incomplete with the respective On-

line screens.

4Mentor new consultants with less experience and Assisted team members as needed.

Tools used are DB2, SQL, Cobol II, ISPF/TSO, bts, IBM390, JCL, Work Bench, Expediter, Sufi, Platinum,

File-Aid, IBM 3090 platform, CICS transactions, relational data bases.

01/07 04/07 INFOCROSSING HEALTHCARE SERVICES, PHOENIX, AZ

Title: Sr. Programmer/Analyst

1Development of Cobol on-line and batch CICS applications for CMS Q/Care System

2Supported the heavy use of VSAM files for the changes manage care plan

3Created, stored and retrieved records of members, providers diagnostic procedures for quality

health care plan. The information in these records interacts with other files to form an integrated

processing system.

Tools used are: Cobol, Endevor, Trace Master, IBM 3090 platform, CICS transactions, BMS, VSAM,

JCL ISPF/TSO.

06/06 12/06 BLUE CROSS of CALIFORNIA, WOODLAND HILLS, CA

Title: Sr. Programmer/Analyst

1Implemented changes for Corporate Individual Right System (CIRS) and supported the WGS 2.0

Membership and Billing Projects. The screen message format service indicated the business

users that a particular member has an alternate mailing address present in the DB2 table which is

identified using the URL provided to them.

2Incorporated several IMS correspondences Cobol applications that override the member mailing

address when it is found in the CIRS DB2 table.

3Dclgen DB2 tables, declared cursors, fetch, inserted db2 columns, Mapping the DB2 tables and the

hierarchical IMS data base record.

Tools used are: DB2, SQL, Spufi, Cobol II, IMS/DB/DC, MFS, XPEDITER, IBM390 procs, Changeman,

BTS, MID/MOD,relational and hierarchical data bases.

01/06 04/06 FEDERAL EXPRESS, COLORADO SPRINGS, COLORADO

Title: Sr. Programmer/Analyst

1Responsible for the CFAN Fusion Conversion Project of several DB2 and CICS programs. Cobol

development and maintenance.

2Implemented the shipment Dclgen DB2 tables, declared cursors, fetch, and inserted db2 columns,

depending on the data requirements of the model or program. Mapping these old TFMS tables to

the new tables.

Tools used are: DB2, SQL, Cobol II, ISPF/TSO, XPEDITER, BTS, IBM390, JCL, ISPF/TSO, SPUFI,

BMS, CICS,transaction.

03/05 12/05 UNION PACIFIC RAIL ROAD, OMAHA, NEBRASKA

Title: Sr. Programmer/Analyst

1Supported the Payroll/Bank Teradata Systems with the development and maintenance of On-line

batch applications in IMS DB/DC Cobol-390, image copy form several data bases, program

specification block, jobstreams. The process is extremely structure with the data quality in data

bases as well with the generation data group created every day. Wrote and enhanced more than

ten compare applications to facilitate the necessary data for the users.

Tools used are: IMS expert, Smarttest, File-aid, Data mapping, JCL, ISPF/TSO procs, EXPEDITER,

BTS,Hierarchical data bases

07/04 01/05 BLUE CROSS of CALIFORNIA, WOODLAND HILLS, CA

Title: Sr. Programmer/Analyst

Participated in the development and maintenance of the Wellpoint Health Nertworks Claims Systems.

Processing On-line and Batch Transactions in the Check Write System with the Navigation

DatabasesTechnical Design, Analysis, Specifications, Test plan, unit/system test and implementation of

the Project.

Tools used are: Changeman, Expediter, IMS/Expert, PSB'S, MFS, BTS, Cobol-II, Cobol 3, VSAM,

FILE-AID, ISPF/TSO, MID/MOD, JCL procs.

06/03 04/04 FEDERAL EXPRESS, COLORADO SPRINGS, COLORADO

Title: Sr. Programmer/Analyst

2Performed a technical role in development design deliverable of new screens and several On-line

COBOL programs with IMS/DB/DC languages Checkpoint Restart in the CER/CERPS Project.

3Developed several new conversion On-line and batch COBOL-II IMS/DB/DC programs, all the

segments were reformatted in the conversion of the data bases, Created the PBSs for On-line

applications.

4Mentor new team member in group training exercises and test case analysis of cer/cerps project.

Tools used are: CMS, alternate pcbs, Data mapping, view record layout, IMS/expert, EXPEDITER,

MVS,File-Aid, SPF/TSO, JCL, procs, bts.

09/02 01/03 UNION PACIFIC RAIL ROAD, OMAHA, NEBRASKA

Title: Sr. Programmer/Analyst

1Development On-line and batch programs in DB2 and IMS languages for the GE Business to

Business Project. Finding the requirements with the user community, designing the screens,

coding and testing theDB2 and IMS On-line applications.

2Conducted structured analysis and design of the existing subroutines to be converted from Cobol to

Cobol-II.

3Created DB2 tables to process the relational data bases.

Tools used are: SQL SPUFI Platinum, LAN, File-Aid, VIASOFT, Expediter, Data mapping, Smarttest,

ISPF/TSO, JCL, procs.

11/96 - 04/02 AMERICAN EXPRESS AZ

Title: Programmer/Analyst

1Responsible for maintenance of the Service Interface Retrieval Network (SIREN). This allows the

user community to create cases with unique numbers for each case, and interface with the

establishment service and letter facility for the Cardholder.

2Supported Service On-line Financial Adjustment (SOFA), which processes On-line adjustments and

interface with Card Members, Establishment Services, and the internal American Express Ledger

for Corporate Card Members.

3Communicated with the user group representatives of Siren/Sofa system to develop and support all

the IMS On-line/batch data base requirements to be converted with VisualAge generator.

4Defined business requirements developed detail designs wrote the specs necessary for the

programs and screens programming code unit testing for the Siren/Sofa system improvements to

support all the IMS On-line and batch applications. Performed analysis/design of the DB2 tables

and on-line programs for the rewrite of the Siren/Sofa System using DB2 SQL and VisualAge

generator products. painted the screens, Defined data modules easily to maintain with VisualAge

generator in several dimensions and views diagrams by functional area and related data

structured in VisualAge generator for the physical and logical data bases. Analysis and design

phases of data migration in visual age generator with sql stamens which identify rules of how the

data will be transmitted from the Local Area Network (LAN) to the new system.

5Converted several segments in the data bases processed by Siren/Sofa systems, the records were

Extracted sequentially with the get next function and replace the data converted in the data base.

6Create psbs.

Additional Employment upon Request.

EDUCATION:

Lehman College Mathematics - New York State University

Contact this candidate