Robert Johnson

Senior Programmer Analyst

mailto:ada8gv@r.postjobfree.com

INFORMATION TECHNOLOGY BACKGROUND

20+ years’ experience as a programmer analyst with IBM mainframe information technology Programming analyst assignments included analysis, design, coding, testing, and implementation of general business (accounting, distribution, order entry) online and batch systems.

20+ years of experience doing Analysis and Development on Cobol/JCL/CICS/IMS/DB2 applications.

Analysis Skills: performed analysis, documentation, Data modeling and prototyping, and build of logical and physical target DBMs.

Data conversion skills: Prior to Bank of America, last 3 projects had data conversion from one platform to another. DB2 to VSAM or IMS to DB2 or Flat files to DB2.

SKILLS SUMMARY

Hardware: IBM Mainframe, IBM PC

Operating Systems: OS/390, MVS/XA/ESA,

Programming Languages: OS 390 COBOL, COBOL II/MVS, Enterprise COBOL, PL/1,

MF COBOL under Visual Studio.

Development Tools: TELON, IBM RDz, SQLDbx

Control Languages: JCL/PROC, CA7, CA11, RJE

TP Platforms: CICS, MQ-SERIES, IMS DC, TSO/E ISPF, CLIST

Database: DB2, IMS DB DL/I

Data Access: VSAM, GSAM, GDG, PS, XLS/CDF

Testing Software: InterTest, XPEDITER, SmartTest, IBM FM Debug, RDz Debug

Report Generators: TELON, Report Writer

Change Management: Endevor, Panvalet, ChangeMan CRISS

Utility/Other: SQLDBx, RDz, FileAID, IBM File Manager & FM DB2, Syncsort, IDCAMS, All OS utilities, DYL260, DYL280, Librarian, Princeton, BMC, Platinum

Office MS Office, Word, Excel, Project, VISIO

AAFES (Contractor) Dallas, TX DEC 18 to Date

Assigned as Lead Analyst and SME for developing of business requirements.

●Responsible for Lead analysis, design, coding, and implementation of TELON COBOL IMS DB2 online and batch programs.

●Assigned to Retail Financial receivables for Collections. Prepare SOW, WBS, and Specification Details. Requirements and understanding of legacy systems for development of web-based GUI’s for development of IMS transactions and batch programs.

●Coordinated Security access requests thru section POC for other analysts. This included defining and seeing thru to completion PCI and PII firewall access requests and implementation to production for projects.

●SQL design and analysis for support of performance improvements in DB2.

●Leading and mentoring assigned staff and individuals in technical solutions, contributing to AAFES technical standards updates meetings, providing production support and resolutions to performance issues and improvements to batch job run times.

●Installation: IBM 3090 MVS/ESA & Z/OS, Enterprise COBOL, VSAM, XPEDITER IMS, DB2 V9, TELON 5.0, UDB DB2 V9.0, IBM DB2 Utilities, IMS V10, ENDEVOR.

PROFESSIONAL EXPERIENCE

Bank of America Plano, TX Jul 17 to DEC 18

AVP for Consultant of Applications Design and Programming

●Responsible for Lead analysis, design, coding, and implementation of COBOL CICS, DB2 online and batch programs.

●Assigned to Financial Wealth Management Applications. Requirements and understanding of legacy systems for development of web-based UI’s for development of CICS & batch programs.

●SQL design and analysis for support of stored procedures changes and performance improvements in DB2.

●Leading and mentoring assigned staff and individuals in technical solutions.

●Installation: IBM MVS/ESA XA & Z/OS, Enterprise COBOL, VSAM,, DB2 V10, UDB DB2 V11.0, IBM DB2 Utilities, CICS, ENDEVOR.

Venture Solutions (Contractor) Ft Worth, TX Aug 16 to Jul 17

Assigned as Lead Analyst and developer of business applications.

●Responsible for Lead analysis, design, coding, and implementation of CICS COBOL VSAM online and batch programs.

●Assigned to Commercial Banking Escrow Statements Monthly and Y/E. Prepare SOW, WBS, and Specification

Details.

●EXSTREAM Dialogue form changes coordination of mapping logistics for monthly and Y/E statements.

●CICS screen modification as directed for Client proprietary account information.

●SQL design and analysis for support of performance improvements in DB2.

●Installation: IBM MVS/ESA XA & Z/OS, CICS, Enterprise COBOL, MF COBOL under Visual Studio, VSAM, ENDEVOR.

AAFES (Full Time Employee) Dallas, TX Nov 10 to Aug 16

Assigned as Lead Analyst and SME for developing of business requirements.

●Responsible for Lead analysis, design, coding, and implementation of TELON COBOL IMS DB2 online and batch programs.

●Assigned to Retail Financial receivables for Collections. Prepare SOW, WBS, and Specification Details. Requirements and understanding of legacy systems for development of web-based GUI’s for development of IMS transactions and batch programs.

●Coordinated Security access requests thru section POC for other analysts. This included defining and seeing thru to completion PCI and PII firewall access requests and implementation to production for projects.

●SQL design and analysis for support of performance improvements in DB2.

●Leading and mentoring assigned staff and individuals in technical solutions, contributing to AAFES technical standards updates meetings, providing production support and resolutions to performance issues and improvements to batch job run times.

●Installation: IBM 3090 MVS/ESA & Z/OS, Enterprise COBOL, VSAM, XPEDITER IMS, DB2 V9, TELON 5.0, UDB DB2 V9.0, IBM DB2 Utilities, IMS V10, ENDEVOR.

AAFES (CPU, Inc.) Dallas, TX Apr 05 to Nov 10

Lead Analyst and SME for development

●Responsible for analysis, design, coding, testing and implementation of TELON & Native COBOL IMS DB2 online and batch programs and Databases. Legacy systems analysis for reverse engineering to support web based transactions to access mainframe DB2 data.

●Assigned to Retail Financial receivables for Collections. Prepare SOW, WBS, and Specification Details. Requirements analysis. Compliance with all SDLC practices.

●Analysis and understanding of legacy systems for development of web-based GUI’s for development of IMS transactions and batch programs. SQL design and analysis for support of performance improvements in DB2. Mentoring developers in many technology areas. Coding programs to fill in where resources are short.

●IBM 3090 MVS/ESA & Z/OS, COBOL 390 & Enterprise COBOL, XPEDITER, IMS V10.0, DB2 V9.0, TELON 4.0, UDB DB2 V9.0, IBM DB2 Utilities, ENDEVOR.

Region 10 Educational Service Center (CPU, Inc.) Richardson, TX Mar 05 to Apr 05

Senior Analyst/Programmer

●Responsible for design and coding CICS screen changes and report program generation for Financial Budget Analysis Report for user PSR’s.

●IBM 3090 MVS/ESA/XA, COBOL 390, CICS, DB2, IBM DEBUG, IBM DB2 Utilities, ENDEVOR, ROSCOE

JPMorgan Chase Bank (CPU, Inc.) Dallas, TX May 03 to Mar 05

Business Analyst, Assistant Vice President

●Responsible for analysis, design, coding, and implementation of COBOL CICS DB2

VSAM online and batch programs.

●Built testable ETL versions for auto-population of DB2 data marts for planned and current projects in QA (pre-production) testing.

●Assigned to Treasury and Securities based systems for International and Domestic architecture. Prepare SDLC, CMM compliant, and PKS documents to support

analysis and Production Support and SIT.

●Analysis and understanding of legacy systems for development of web-based GUI’s for development of CICS transactions fed from MQ to host mainframe. SQL design and analysis for support of performance improvements in DB2.

●IBM 3090 MVS/ESA, COBOL 390, XPEDITER IMS, CICS, DB2, UDB DB2 V7.0, MQ Series, Test Director, IBM DB2 Utilities, ENDEVOR, BMC Striva ETL (Informatica),Princeton DB2 utilities, CDB utilities (BMC).

State of Illinois Child Support Enforcement(CSE) Springfield, IL Dec 02 to May 03

Senior Programmer Analyst

●Responsible for analysis and implementation of Medical Support Enhancement project.

●Provided DB2 DBA support for analysis of existing DB2 installation and perf tuning

Production Tables. Maintenance of test database environments.

●Provided DB2 table design overviews for State DBA staff.

●Coding and testing of DB2 IMS TELON programs.

●IBM 3090 MVS/ESA, TELON 2.1B, COBOL II, XPEDITER IMS, ENDEVOR,

IMS DB/DC, IMS DL/I, DB2 DBA.

J.C. Penneys (Abacus Technical Services), Dallas, TX May 02 to Dec 02

Senior Programmer Analyst

●Assisted development team with the analysis, design, coding, testing, and implementation of internet sales adjustment system that converted transaction messaging from IMS to MQ series.

●Assisted IMS technical support and MQ administration in applications testing and problem resolution

●Developed MQ transaction programs across multiple mainframes

●Performed in DB2 DBA functionality creating, modifying objects, performance analysis, index creation, granting of DBA authorization to plans and production.

●IBM 3090 MVS/ESA, MQ Series, IMS DB/DC, COBOL II/MVS, DB2, Telon, DB2 DBA.

Burlington Northern (CPU, Inc.), Topeka, KS Feb 01 to Apr 02

Senior Programmer Analyst

●Assisted development team with the analysis, design, coding, testing, and implementation of account posting and reconciliation changes to the revenue accounting system utilizing full System Development Life Cycle (SDLC).

●Assisted development team with the analysis, design, coding, testing, and implementation of mainframe customer inquiry system account that serviced Web and mid-tier applications with legacy TELON 2.1B, IMS and DB2 transactions utilizing MQ Series.

●IBM 3090 MVS/ESA, MQ Series, COBOL II/MVS, Xpediter, DB2, IMS DB/DC

Chase Manhattan Bank, Dallas, TX May 00 to Feb 01

●Assigned to the GIS Data Warehouse as Vice President management position to

oversee staff of 27 people, trained in New York and assisted in departmental

transition to Dallas, TX. Trained for Securities and monetary based systems and

international securities transaction processing. Assigned responsibilities of Infrastructure,

Views Reporting systems, & GIS Data Analysis/Development.

●Managed staff comprised of 19 employees and 8 contractors. Analysis and understanding of legacy batch, online CICS, and ETL systems, for development of web-based GUI’s for development of CICS transactions fed from MQ to host mainframe.

●Design and Coding of CICS online, batch reporting and ETL data population routines. PMP management, SDLC system development methodologies. Interaction with User support groups in New York and London.

●Maintenance of existing Legacy Systems along with development of new products for the GIS Warehouse. Full charge management responsibilities for staff.

● Reason for leaving: Left for family reasons.

● IBM 3090 MVS/ESA, ENDEAVOR, XPEDITER, CICS, DB2 Rel 6.0,

IBM MQ Series-Queue transaction processing, CDB Utilities(BMC) STRIVA,

MS-Project, MS-EXCEL, Timekeeper

Other Engagements Jun 86 to Oct 00

Senior Programmer Analyst/Programmer Analyst

●Assisted development teams in conversions, modifications, and operations of general business systems.

●Duties generally included analysis, design, coding, configuration, testing, and installation.

●IBM 3090, CICS, COBOL/II, DB2, IMS DB/DC, VSAM

Company

Skills

From

To

Chase Manhattan Bank, Dallas, TX

IBM 3090 MVS/ESA, MQ Series, CICS, COBOL II/MVS, Endevor, Xpediter, DB2

May 00

Oct 00

Burlington Northern (CPU, Inc.), Topeka, KS

IMS DB/DC DLI,COBOL II, DB2,Telon

Oct 97

May 00

State of Ill Child Support Enforcement(CPU, Inc), Springfield, Ill

IMS DC, COBOL II, IMS DB/DC,Telon

Sep 97

Oct 97

State of WI Child Support Enforcement (CPU, Inc.), Madison, WI

CICS,COBOL II,DB2, XPEDITER,TELON

Nov 94

Aug 97

J.C.Penney (CPU, Inc.), Plano, TX

IMS DC, COBOL II, DB2, DB2 DBA, Xpediter,Telon

Mar 94

Nov 94

ORYX Energy (CPU, Inc.), Plano TX

Telon,IMS DC, COBOL II DB2, SmartTest

Jun 92

Mar 94

Texaco ITD(CPU, Inc), Houston, TX

Telon,IMS DC, COBOL II, DB2, Xpediter

Sep 91

Jun 92

ORYX Energy (IMI Systems), Dallas TX

Telon,CICS, COBOL II, DB2, InterTest

Jan 91

Aug 91

Allergan Pharmaceuticals (CPU, Inc.),Irvine, CA

Telon,CICS, COBOL II, DB2, SmartTest

Jun 90

Dec 90

Price Waterhouse (DSI, Inc.), Dallas, TX

Telon,CICS, COBOL II, DB2, InterTest

Sep 89

May 90

Mobil Oil Company (CAP Gemini), Dallas, TX

Telon,IMS DC, COBOL, DB2, Telon

Aug 88

Sep 89

General Dynamics, Ft. Worth, TX

IMS DC, COBOL, DB2, Telon Test

Jun 86

Jul 88

Contact this candidate