TECHNICAL SKILLS:

SOFTWARE: OS/MVS, COBOL II, COBOL, ALC, PCS, DYL280, DYL260

ACCESS: REXX, EZTRIEVE, MARKIV, Command - Level Confidential

METHODS: DB2/SQL, SPUFI, QMF, DLI (IMS), VSAM DBS (McCormack and Dodge), MSA, INSCI, ISA, ADABASENatural, Confidential A/R, Confidential P/R, Confidential AllTax

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• I worked on the Vehicle Service Contract System.
• Coded both batch and Confidential programs.
• This is a “Home Grown” system written using native Confidential and also interfacing with a web-based system used at all the dealerships.
• The Confidential programs were executed via a stored procedure invoked by the client server transaction.
• The SQL Server database and the DB2 mainframe database are kept in sync via these programs. baeASED SYTEMb
• Also, numerous batch programs were developed and maintained.

Senior Applications Developer

Confidential

Responsibilities:

• I have worked exclusively on the Payroll System.
• I have been working at the Studio for more than 15 years and therefore it would be difficult to list all the projects I have participated in.
• Most recently I assisted in converting a “Home Grown” Payroll System to a new Cloud Based Package (Workday).
• Basically I have run the entire gauntlet while here at WB (maintenance, new development). Most of my work here has been in the Confidential arena, although I have written many batch programs.
• I have interrogated all Confidential programs which ABEND for any reason.
• I then identify the reason for the abend and eliminated it.
• I am involved in tuning SQL statements and cursors to be more efficient.
• Adding specific indices to DB2 tables so that cursors within the programs will not perform any table scans, and will execute in a sub-second time frame.
• I have re-engineered numerous programs to use TSQ properly in order to page in a more dynamic efficient manner. Have coded, tested and implemented Time clock Staging System.
• This is an on-line method of updating “time clock/department” table with new departments. This system has both on-line and batch components.
• The system was written using COBOL and Confidential . The maps were coded using GTB/BMS; all files within this system are DB2 tables.
• Also, I have modified numerous Confidential and BATCH programs associated with the Payroll System.

Consultant

Confidential

Responsibilities:

• I have coded, tested and implemented a Receivables Allocation
• System (PROFORMA). This system has both on-line and batch components. The system was written using COBOL and Confidential .
• The maps were coded using BMS, all files within this system are DB2 tables. Some Confidential programs manage multiple TSQ simultaneously.
• I have coded, tested and implemented an Invoice Billing History System using Command - Level Confidential .
• All maps were coded using Native BMS, all files within this system are DB2 tables.
• I have also been required to code numerous batch programs using DB2 tables and VSAM files. Also coded PROCS and JCL members.
• Implementation of General Ledger System ( Confidential upgrade.
• This has involved writing conversion programs to modify the existing files and DB2 tables to be Confidential compliant.
• Also modified all the current JCL and PROC members.
• Made all the changes necessary to implement the on-line system and make it Confidential compliant.
• Responsible for testing all on-line and batch programs in preparation for Quality Assurance review.
• This system is written entirely in COBOLII and Confidential .

Consultant

Confidential

Responsibilities:

• Implemented the Customer Satisfaction System.
• This system is written in COBOLII and ADABAS/Natural, it has both on-line and batch functions.
• Coded both on-line and batch programs using COBOLII/ Confidential .
• All screens were coded using native BMS (in some cases it was necessary to use SDF2 to make modifications to existing Confidential maps).
• SQL was used extensively in conjunction with DB2 tables and ADABAS files.
• Confidential was used as a debugging tool for batch and Confidential programs.
• I also made modifications to many Natural programs and implemented a new Reporting system for the Customer Satisfaction System.

Consultant

Confidential

Responsibilities:

• coding numerous on-line Confidential programs.
• Coded a data conversion program to allow the transition from the current Data-Entry/Batch system, to a complete on-line update system.
• Solely responsibility for performing maintenance on existing programs and coded new batch report programs.
• The maps were all generated using SDF2.
• Research and development on an on-line table management system utilizing Confidential, COBOL II, and DB2. Interest was used extensively to test all Confidential programs.

Consultant

Confidential

Responsibilities:

• This preposting ended up being 12 programs: it basically prepares the raw data for input into MSA system.
• Interfaced directly with the user, wrote the specs and succeeded in increasing productivity.
• Upon completion began to make enhancement to the Manufacturing System: converting COBOL and MARKIV programs to COBOL II, and in the process re-wrote JCL and Procs. Also maintained on-line Confidential programs in conjunction with the manufacturing system.

Consultant

Confidential

Responsibilities:

• Originally contracted to convert DOS to MVS. Converted programs from COBOL, ALC, DYL260, and DYL280 to COBOL II.
• Converted all JCL to MVS format. Consequently, moved to the Financial Group to assist with the implementation of some DBS (i.e. McCormack & Dodge packages: A.P, G/L, A/R, and C/M). Worked with the implementation of A/P.
• Wrote all the conversion programs for the implementation of A/P 5.3.2 and a substantial portion of the JCL.
• Assisted with the installation of Millennium (the DBS on-line system which drives all the Confidential programs. DB2 was used extensively in conjunction with the conversion programs.

Consultant

Confidential

Responsibilities:

• Worked primarily on Confidential Payroll System.
• Coded many new programs while maintaining existing one. Extensive user interface. Installed TAO/E-MAIL system.
• Coded a batch system to extract mail from the mainframe database and then transferred each piece of mail to a PC at the appropriate store.
• All programs were written using command-level Confidential .