SUMMARY

• My strengths are coding and testing COBOL programs dat utilize IMS DB and DB2 databases.
• me consider myself to be detail oriented and thorough in my coding and testing.
• me have worked on Confidential mainframes throughout my career and me feel comfortable with my JCL coding skills as well.

TECHNICAL SKILLS

Hardware Environment: OS/390 - MVS environment on an Mainframe

Languages: COBOL2, COBOL3

Software: IMS DB, DB2, QMF, SQL, SPUFI, OS/VS JCL, TSO/ISPF, ENDEVOR, EXPEDITER, FTP, MICROSOFT WORD, EXPLORER, WINDOWS

PROFESSIONAL EXPERIENCE

Confidential, Farmington Hills, MI

Programmer Analyst

Responsibilities:

• Applied modifications to COBOL/DB2 programs by replacing DATACOM calls with new DB2 tables, renaming the old DATACOM fields to the new DB2 fields, modifying PROCS in order to accommodate DB2, and tested the COBOL program changes using XPEDITER and batch jobs. (Credit Collection system)
• Designed, coded, tested, created test plans, PROCS, DOCS and JCL for new development COBOL Report and Conversion programs dat use DB2 and flat files.
• These programs were tested using XPEDITER and batch jobs. (Tax system)
• Converted a COBOL batch program’s me/O VSAM file processing to be compatible in a CICS environment. (Tax system)
• Assisted in correcting production problems. (Billing system)

Confidential, Detroit, MI

Programmer Analyst

Responsibilities:

• Applied modifications to COBOL/DB2 legacy programs dat support Confidential ’s National Provider Identification number conversion by adding logic dat writes a record for each level of IMS
• Provider segments sequentially retrieved and separating each field of each segments with tildes.
• These files would then be FTP to BCN further down in the systems process.
• Coded COBOL/DB2 programs dat report on BCN Provider number errors by inserting the errors detected into a DB2 table and then submitting an Email, via an Email JCL step to the support team stating so.
• Coded a FTP PROC dat transferred a file of classified BCN information to a BCN server.
• Assisted team-members with the creation of TEST JCL, testing of batch programs, and testing BMC-Checkpoint-Restart code.
• Tested COBOL programs using Expediter’s Code Coverage option, reported the test results/cases in test grids, and updated the corresponding, Documentation (PROSE), JCL, PROCS, and PARMS .

Confidential, Livonia, MI

Programmer Analyst

Responsibilities:

• Coded and tested legacy COBOL IMS batch programs by converting the processing dat accesses IMS databases to the new associated DB2 tables including the coding of multiple DB2 Cursors, DB2 UPDATE and DB2 DELETE processing.
• Assisted a colleague in the touch-point testing (via Expediter) of the COMMON MODS modules.
• These COBOL modules access IMS and the new DB2 tables.
• me also helped in coordinating the test data between the driver program and the TEST DB2 tables.
• Created a document for the Confidential Coordination of Benefits group containing examples of procedures dat me used in setting up user TSO-ID prefixed DB2 test tables.
• The document consisted of samples of JCL used to load and unload DB2 test tables, program screen prints of COBOL imbedded DB2 Cursor/UPDATE/DELETE calls, and screen prints of Expediter on-line debugging file allocation datasets.

Confidential, Southfield, MI

Software Engineer

Responsibilities:

• Designed, coded, tested and implemented CICS programs using COBOL2, DB2, DB2 Stored Procedures and DATACOM for the Front End Billing System.
• These programs maintained DB2 tables dat would be used by the Billing Systems Cycle process.
• Applied maintenance to IDEAL programs and there corresponding screens for the Front End Billing System.
• The IDEAL programs updated control values to production DATACOM databases dat would be used by the Billing Systems Cycle process.
• Led testing for integrating DB2 from the TEST IDEAL region to the PRODUCTION IDEAL region.
• Participated in a weekly rotation for on-call support of the Billing System.

Confidential, Troy, MI

Systems Developer

Responsibilities:

• Designed, coded, tested and applied maintenance modifications and new development dat supported the Merchandise Order Processing System and its sub-systems.
• Designed, coded, tested and implemented IMS DB and DB2 programs using COBOL, COBOL2 and QUICKJOB which included maintenance of VSAM files, data validation, status of merchandise items, store restrictions, user requested reports, discrepancy reports (as requested) and the correction of production problems.
• Updated or created PROCS accordingly.
• Provided daily on-call systems support to ensure timely execution and completion of jobs for the Merchandise Order Processing System and its sub-systems.
• Gained DB2 experience utilizing SPUFI, batch DB2 Utilities, including executing batch SQL queries for production inquiries and new development of COBOL programs, loading and altering of DB2 tables.
• Responsible for a one-time recreation of the production IMS Competitive Price Database with the resolve of eliminating millions of out dated segments.
• Wrote a COBOL program dat created alerts in the form of letters to stores, notifying of low stock levels for selected critical items.
• Participated in Confidential ’s Y2K efforts consisting of baseline, regression, future and touch point testing of third-party modified COBOL programs.
• Served as a Confidential Subject Matter Expert to interface with contractors hired for the Y2K effort.
• Developed a QUICKJOB program to layout IMS segment in its hierarchical sequence.
• Other groups throughout Confidential adopted the program for segment verification.
• Developed and maintained IMS DC COBOL programs and their MFS screens.

Confidential, Dearborn, MI

Programmer Analyst

Responsibilities:

• Designed, coded and tested COBOL batch programs dat updated VSAM files.

Confidential, Wayne, MI

Computer Programmer

Responsibilities:

• Designed, coded and tested multiple batch COBOL report programs dat accessed VSAM files for the Transportation system.
• Designed, coded and tested Confidential optical scanner programs for the Testing Services area dat would score booklet and single page tests.
• me also assembled a document dat detailed how to operate the Optical Scanner for the Operations team.
• Worked as a Computer Operator for two years with the following responsibilities monitoring the master console, hanging tapes, mounting disks, operating Card Readers, high speed printers and running system backups.
• me also printed special forms including testing special forms, paychecks and report cards.