Manager Analyst
Resume:
John C Griffin
Springfield, IL 62701
217-***-**** (home)
217-***-**** (cell)
Technical Expertise
Hardware: IBM 30XX, IBM 360/370/390, DEC 2060
Operating Systems: MVS, OS, VM, DOS, DOS/VSE, OS/390, z/OS
Programming Languages: COBOL II, COBOL, PL/1, REXX, Microfocus
COBOL, Easytrieve, SAS, SQL, SQL/DS, DLI
Data Management/Database: DB2, Oracle 7, IMS DB/DC, TOTAL
Software, Tools and Utilities: APS, APS 3.1 Client Server, XMenu, CICS, MFS,
VSAM, Dialog Manager, XPEDITER, BTS, ISPF, TSO,
Endevor, Panvalet, BMP, FileAid, Librarian, MSA
Payroll, MSA Accounts Payable, Telon, Tesseract, MQ
Series, Animator, QMF, SPUFI, MVS Utilities, IBM
Utilities, Smarttest, BMP, CA-Verify, CA-Intertest,
Changeman, JCL, PROCS, Control-M
Applications: Transportation, Payroll/HR, Government, Health Care,
Chemical, Manufacturing, Order Entry, Home/Auto
Insurance, Oil, Telephone, Securities, Utilities, Child
Support
Professional Experience
07/07 – 06/08 FedEx – Memphis, TN
Consultant – Analyst/Programmer
• Wrote and modified programs for an HR/Payroll and EEOC systems.
The changes for the Payroll system were for 401K matching amounts,
percents and limits. The changes for EEOC were for new EEOC race
codes, surveys and breakdown counting reporting for minorities.
• Programs were written in COBOL II, IMS DB/DC, MFS and DB2.
• Testing was using File Aid, SPUFI, QMF and Endevor.
Technical Environment: COBOL II, IMS DB/DC, DB2, File Aid, SPUFI, QMF, Endevor, MFS, z/OS
12/06 – 04/07 State of California – Sacramento, CA
Consultant – Analyst/Programmer
• Wrote specs for and made changes to MediCal programs.
Modifications were for HIPAA National Provider Identifiers. Provider
IDs went from nine to ten characters.
• Changes also included file organization.
• Programs were written in COBOL II.
• Changes were for VSAM and CICS programs.
• Testing was using File Aid, CA-Intertest and Endevor.
Technical Environment: COBOL II, VSAM, CICS, File Aid, CA-Intertest, Endevor, z/OS
04/06 – 10/06 WPS – Madison, WI
Consultant – Analyst/Programmer
• Wrote conversion and upload programs for enterprise db2 tables. The
data was for health insurance claim process Enterprise system.
• Programs were written in COBOL II and DB2.
• Testing tools were File Aid, SPUFI, QMF and Changeman.
Technical Environment: COBOL II, DB2, File Aid, SPUFI, QMF, Changeman, z/OS
10/05 – 04/06 Ashland – Lexington, KY
Consultant – Analyst/Programmer
• Wrote programs and made enhancements for the Payroll and HR
systems. Programs were online programs to input tax accruals for
companies and control final pay date processing for terminated
employees.
• Programs were written in PL/1 IMS DB/DC, MFS and DB2.
• Testing tools used were File Aid, QMF and ENDEVOR.
Technical Environment: PL/1 IMS DB/DC, MFS, DB2, File Aid, QMF, ENDEVOR, OS/390
07/04 – 03/05 Columbia House – Terre Haute, IN
Consultant – Analyst/Programmer
• Wrote comparison programs for data migration from mainframe to
UDB file servers.
• Report comparison programs were written in SAS to have each field
from matching files side by side to show their values and high lighting
fields that were different.
• Report files were FTP to servers for view.
• Changed and wrote PL/1 programs for data cleansing for data
migration project.
• Testing tools used were CA-Verify, CA-Intertest and File Aid. System
is a DB/2, CICS, VSAM, and PL1.
Technical Environment: SAS, FTP, PL/1, CA-Verify, CA-Intertest, File Aid, DB/2, CICS, VSAM, PL/1, OS/390
05/04 – 07/04 Humana – Louisville, KY
Consultant – Analyst/Programmer
• Worked with team to modify Humana's customers NDM out bound
files to eliminate social security numbers and replace the social
security number with another.
• The system is a DB2, COBOL system.
• Testing tools used were SPUFI, File Aid and Smart Test.
Technical Environment: COBOL, DB2, SPUFI, File Aid, Smart Test, OS/390
11/03 – 03/04 Columbia House – Terre Haute, IN
Consultant – Analyst/Programmer
• Worked with team to incorporate Canadian system into US system for
order entry, shipping, invoicing and accounts receivables for video,
DVD, CD and record systems.
• Worked with analysts to further define specifications and to modify
programs and test modifications.
• All modifications were for PL/1 online CICS programs.
• Testing tools used were CA-Verify, CA-Intertest and File Aid.
• System is a DB/2, CICS, VSAM PL/1 system.
Technical Environment: DB2, CICS, VSAM PL/1, CA-Verify, CA-Intertest, File Aid, OS/390
07/01 – 07/03 State of Illinois – Springfield, IL
Consultant – Analyst/Programmer
• Wrote and modified programs for Child Support Enforcement system.
• Modified programs to update court scheduling dockets, court
appearance notifications, foster care for custodial control, and case
worker assignments alphabetically for case functions.
• Generated test cases and tested for new and requirements and
modifications.
• Systems were written in COBOL II and TELON and databases for
IMS DB/DC and DB2.
• Tools used were File Aid, SPUFI, QMF and ENDEVOR.
Technical Environment: COBOL II, TELON, IMS DB/DC, DB2, File Aid, SPUFI, QMF, ENDEVOR, MVS
10/00 – 07/01 Liberty Mutual – Portsmouth, NH
Consultant – Analyst/Programmer
• Wrote system specifications and programmed an online Auto and
Home Owner Policy system.
• For the Auto Policy system, enhancements were for business quotes
and endorsements. The auto enhancements were for rating, coverage,
comprehensive, collision, uninsured, accident and deductible
information.
• For the Home Owner Policy system, enhancements were for types of
construction, heating and dwelling. Modifications were also made for
home owner liability coverage, deductibles and miscellaneous
coverage.
• Systems were written in PL/1, COBOL II and TELON and databases
for IMS DB/DC and DB2.
• Tools used were File Aid, SPUFI, QMF and ENDEVOR.
Technical Environment: PL/1, COBOL II, TELON, IMS DB/DC, MFS, DB2, FileAid, SPUFI, QMF, ENDEVOR,
MVS
10/99 – 10/00 Wendy’s – Columbus, OH
Consultant – Analyst/Programmer
• Wrote programs for Accounts Receivable system.
• Programs were for billing control, invoicing and aging.
• Systems were written in COBOL II and databases for VSAM and
DB2.
• Tools used were File Aid, SPUFI, QMF and ENDEVOR.
Technical Environment: COBOL II, DB2, File Aid, VSAM, SPUFI, QMF, ENDEVOR, MVS
06/98 – 08/99 US Sprint – Kansas City, MO
Consultant – Analyst/Programmer
1 Wrote programs for a Configuration System (like ENDEVOR).
2 Programs were for checking programs in and out, moving to different
test regions and migrating to production.
3 Systems were written in PL/1, Rexx and VSAM.
4 Tools used were File Aid.
Technical Environment: PL/1, Rexx, Dialog Manager, Clist, MVS and File Aid
10/97 – 06/98 Blue Cross Blue Shield – Columbia, SC
Consultant – Analyst/Programmer
1 Wrote programs for new insurance settlement claims processing
regions.
2 Programs were for including new regions into claim processing system
3 Systems were written in APS COBOL, COBOL II, Easytrieve, IMS
DB/DC, DLI, DB2, SQL and VSAM.
4 Tools used were File Aid, SPUFI, QMF, and ENDEVOR.
Technical Environment: APS COBOL, COBOL II, MVS, IMS DB/DC, DLI, DB2, ENDEVOR, Expediter and File Aid
07/96 – 10/97 JP Morgan – Bear, DE
Consultant – Analyst/Programmer
1 Wrote programs for Securities Underwrites system.
2 Programs were for a back office processing system.
3 Systems were written in APS COBOL, COBOL II, CICS, DB2, SQL
and VSAM.
4 Tools used were File Aid, SPUFI, QMF, Control-M and ENDEVOR.
Technical Environment: APS COBOL, MVS, DB2, ENDEVOR, Expediter, Control-M and File Aid
10/95 – 06/96 US Able – Little Rock, AR
Consultant – Analyst/Programmer
1 Wrote programs for Health Insurance Claims processing package.
2 Programs were for updating and inquiry of processing claims.
3 Systems were written in APS COBOL, CICS, DB2, SQL and VSAM.
4 Tools used were File Aid, SPUFI, QMF, and ENDEVOR.
Technical Environment: APS COBOL, MVS, DB2, ENDEVOR, Expediter and File Aid
01/95 – 10/95 Pacific Bell – San Ramon, CA
Consultant – Analyst/Programmer
1 Wrote programs for Commercial Customer Number Order system.
2 Programs were for increasing ordering banks of phone numbers and
maintaining.
3 Systems were written in PL/1, Rexx, Dialog Manager and Oracle 7.
4 Tools used were File Aid, SPUFI, and QMF.
Technical Environment: PL/1, Rexx, Oracle 7, MVS, Dialog Manager and File Aid
11/93 – 01/95 Southern Pacific – San Francisco, CA
Consultant – Analyst/Programmer
1 Wrote programs for Railroad Routing system.
2 Programs were for enhancing routing and pricing.
3 Systems were written in APS COBOL, DB2, SQL, IMS DB/DC DLI.
4 Tools used were File Aid, SPUFI, and QMF.
Technical Environment: APS COBOL, DB2, IMS DB/DC MFS, MVS, SPUFI, QMF and File Aid
02/93 – 11/93 California Workers Comp – San Francisco, CA
Consultant – Analyst/Programmer
1 Wrote programs for state Workers Comp system.
2 Programs were conversion programs from MVS sequential processing
system to DB2 processing.
3 Systems were written in COBOL II, DB2, SQL and MVS.
4 Tools used were File Aid, SPUFI, and QMF.
Technical Environment: COBOL II, DB2, SQL, MVS, QMF, SPUFI and File Aid
10/91 – 01/93 IBM – Charlotte, NC
Consultant – Analyst/Programmer
1 Designed and wrote programs for on-line Maintenance Scheduling
system for DBAs.
2 Programs were to identify applications, owners, and contacts, schedule
maintenance for IMS DB/DC, DB2 and SQL/DS environments.
3 Systems were written in Rexx, SQL/DS and Dialog Manager.
4 Tools used were File Aid, QMF
Technical Environment: Rexx, SQL/DS, Dialog Manager and VM
02/91 – 09/91 Texaco – Houston, TX
Consultant – Analyst/Programmer
1 Designed and wrote programs for on-line Capital
Appropriations/Expenditures and Employee Absentee systems.
2 Programs were to update and maintain expenditures and employee
absence.
3 Systems were written in Rexx, DB2, SQL, MVS and Dialog Manager.
4 Tools used were File Aid, QMF
Technical Environment: Rexx, DB2, Dialog Manager and MVS
10/90 – 01//91 ATT – Kansas City, MO
Consultant – Analyst/Programmer
1 Wrote programs for a Switching and Routing system.
2 Programs were to update and maintain switching and routing.
3 Systems were written in COBOL II, DB2, SQL, MVS, IMS DB/DC
and DLI.
4 Tools used were File Aid, QMF, SPUFI
Technical Environment: COBOL II, DB2, IMS DB/DC and MVS
10/87 – 10/90 Hoechst Celanese – Dallas, TX
Consultant – Analyst/Programmer
1 Designed and wrote programs for on-line Customer Ordering Pricing
system.
2 Programs were to build orders, pricing, data lookup, instructions,
contacts, confirmation and price modifications.
3 Systems were written in PL/1, IMS DB/DC, DLI, MFS and MVS.
4 Tools used were File Aid
Technical Environment: PL/1, IMS DB/DC and MVS
01/83 – 10/87 Exxon – Houston, TX
Consultant – Analyst/Programmer
1 Designed and wrote programs for on-line Employee Relations system.
2 Programs were to build disability, education, EEO, job service,
military, dependents, medical, thrift, annuity, salary and budgets.
3 Systems were written in PL/1, IMS DB/DC, DLI, MFS and MVS.
4 Tools used were File Aid
Technical Environment: PL/1, IMS DB/DC and MVS
05/81 – 12/82 National Supplies – Houston, TX
Consultant – Analyst/Programmer
1 Designed and wrote programs for an Inventory management system.
2 Programs were to generate forecast order quantities, optimum reorder
points, surplus identification, surplus sourcing, vendor returns,
inventory reassignment, forecast sales/production and ABC
identification.
3 Systems were written in PL/1, COBOL, VSAM and MVS.
4 Tools used were File Aid
Technical Environment: PL/1, COBOL, VSAM and MVS
01/75 – 05/81 Cameron Group – San Francisco, CA
Consultant – Analyst/Programmer
• Designed and wrote programs for Dayton Power and Light, Intersil,
Fairchild Camera, FMC, Stromberg Carson and Anheuser-Busch.
• For Dayton Power and Light, programming was for the Tracking
Commercial Customer gas Allocation Use system.
• For Intersil, programming conversion was from IBM COBOL to DEC
COBOL.
• For FMC, programming was for the Project Cost Variance system to
track costs and variances for building projects.
• For Fairchild Camera, programming was for the MSA Payroll system
for year end.
• For Stromberg Carlson, programming conversion was from ALC to
PL/1.
• For Anheuser-Busch programming was for the Liquid and packaging
Requirements system and MSA Payroll system for tracking packaging
requirements and payroll modifications.
• Systems were written in PL/1, COBOL, COBOL II, TOTAL and
VSAM.
Technical Environment: PL/1, COBOL, COBOL II, TOTAL MSA Payroll, VSAM and MVS
01/69 – 12/74 Systec – Kansas City, MO
Analyst/Programmer
1 Designed and wrote programs for Kansas City Railroad systems
system.
2 Programs were for freight bills, collections, rate increases, inventory
control, payroll audits, disbursements, account receivables, payables,
general ledger and billing.
3 Systems were written in COBOL, VSAM and MVS
4 Tools used were File Aid
Technical Environment: COBOL, VSAM and MVS
10/64 – 12/68 Gustin-Bacon – Kansas City, MO
Analyst/Programmer
1 Designed and wrote programs for Gustin-Bacon systems.
2 Programs were for cost standards, production and sales.
3 Systems were written in PL/1 and DOS .
4 Tools used were File Aid
Technical Environment: PL/1 and DOS
References: Available upon request
Contact this candidate