MARK C. SANFORD

**** ****** **** ******

Westerville, Ohio 43081

Home Phone: 614-***-****

Skype: Mark.Sanford13

E-Mail: acu4da@r.postjobfree.com

TECHNICAL:

COBOL, JCL, DB2/SQL, CICS, IMS DB/DC, TELON, VSAM,

TSO/ISPF/MVS/CMS/VTAM platforms, MVS stored procedures,

XPEDITOR, DEBUGGER, CHANGEMAN, ENDEAVOR, IEBGENR,

IDCAMS(VSAM, ESDS, KSDS, RRDS, GDG, PDS), SYNCSORT, FILEAID, FTP,

SPUFI, QMF, EASYTRIEVE… and more

EDUCATION:

OHIO UNIVERSITY - Athens, Ohio

Bachelor Degree in Computer Science and Mathematics minor

Marcel Levien and Parks Foundation scholarships recipient all 4 years

Major GPA: 3.7, Overall GPA: 3.0

EXPERIENCE:

01/2015 - SEA Group Consulting, State of Illinois HFS Medicaid/Medicare, Springfield, Illinois.

Present

Mainframe Sr. Programmer Analyst in charge of maintenance and upgrades to the state of Illinois HFS Medicaid/Medicare on-line screens and data. HFS(Health and Family Services) uses 12 on-line(IMS DB/DC) screens for entering hospital claims data, retrieval, display, data corrections and then storage of the data back to IMS(or DB2 tables). Illinois hired me to upgrade all of the screens and COBOL programs to conform to HIPPA legislative compliance of state and federal mandated changes to health care. The prior system only allowed up to 65 different revenue lines to be stored on one claim and HIPPA required a mandatory 999 potential revenue lines to be stored on a claim in order to be compliant. Other duties included demos to the claims team using the TELON design prototype option to promote acceptance and pre-approval of screen changes. Documentation of all changes using VISIO flow charts(Data Flow, Process Flow), screen layout plotter(MFS) and EXCEL(Event-Response tables). Worked directly with the users

As 1st contact for our group to trouble-shoot problems, analyze concerns, identify errors/concerns, route concerns to appropriate programmer(s), document and track progress and timelines of these concerns back to the users(non-programmers).

COBOL, IMS DB/DC,DB2,CICS IBM Mainframe Environment

MVS/TSO/ISPF/CMS

PC based MFE(Micro Focus) COBOL

COBOL

IMS DB/DC

TELON

JCL

VSAM

FileManger(Fileaid)

Expediter/Debugger

BTS(batch terminal simulator)

Panvalette

DB2/SQL/SPUFI/QMF/DB2 Connect

Microsoft(WORD,EXCEL,POWERPOINT,VISIO flowchart)

06/2008 - Performance Mgt Consulting, Nationwide P&C Insurance, Columbus, Ohio.

09/2009

Sr. Programmer Analyst responsibilities included analysis, documentation, coding,

testing, debugging and implementation of mainframe homeowner insurance systems.

Responsible for updating rating factors and implementing program code changes with an

in-depth understanding and knowledge of the current system and the effects that those

changes can impact. Good communications and team working skills required.

Scheduled, promoted and implemented JCL/COBOL/DB2/CICS program changes using

Changeman software. Training and mentoring entry-level and contract programmers on

the homeowners(P&C) insurance processing system as well as in general programming

knowledge.

Cobol/CICS/DB2 Mainframe Environment

COBOL

DB2/SQL/SPUFI/QMF/DB2 Connect

CICS

JCL

VSAM

FileAid

Expediter

Changeman

11/2007 - Megasystems Consulting, Abercrombie and Fitch, Columbus, Ohio.

01/2008

Sr. Programmer Analyst responsible for analysis, documentation, coding, testing,

debugging and implementation of clothing retailer data systems. Responsible for taking

customer requests, documenting those changes, assigning projects and timeframes to

the Endeavor job schedules as well as programming, testing and implementing of

JCL/COBOL/DB2/CICS program changes to the mainframe retail sales system.

Cobol/CICS/DB2 Mainframe Environment

COBOL

DB2/SQL/SPUFI/QMF/DB2 Connect

CICS

JCL

VSAM

FileAid

Expediter

Endeavor job scheduler(Changeman)

10/2006 - Careworks Consulting, ODJFS(Ohio Department of Jobs and Family Services), Columbus, Ohio.

10/2007

Sr. Programmer Analyst responsible for analysis, documentation, coding, testing,

debugging and implementation of Ohio benefits calculation and issuance batch

programs as well as online data entry screens.

Cobol/CICS/DB2 Mainframe Environment

COBOL

TELON(CICS)

JCL

VSAM

Expediter(Debugger)

FileAid

SDMS job scheduler(Changeman)

Microsoft Office(Excel, Power Point, Access, Word, Visio)

DB2/SQL/SPUFI/QMF

TSO/ISPF, VM/MVS

06/2006 - Capital City Consulting, Nationwide Insurance – Customer Info(ECIF), Columbus, Ohio.

10/2006

Sr. Programmer Analyst responsible for analysis, documentation, coding, testing,

debugging and implementation of COBOL/DB2 development programs. ECIF receives

Change transactions to customer information from 35 different data systems and creates

An internet based search engine of all Nationwide customers company wide. New

Customers and customer information changes are pulled in from each system nightly

and used to add/update the customer DB2 tables that populate the search engine.

DB2 Mainframe Environment

COBOL

DB2/SQL/SPUFI/QMF

JCL

ChangeMan

IBM Debugger

FileAid

Microsoft Office(Excel, Power Point, Access, Word, Visio)

TSO/ISPF, VM/MVS

12/2004 - Computer Horizons, Prudential Insurance(Employee Benefits), Dubuque, Iowa.

02/2006

Sr. Programmer Analyst with sole responsibility for research, analysis, design, coding,

Testing, debugging and quality of ad hoc report requests. Dozens of daily requests for

Employee benefits information were received from 6 locations nationwide to be

Pulled off the IMS mainframe database and delivered within a 3 day deadline.

Requirements gathering and data research was acquired by conducting customer

Interviews by phone and E-mail, reference materials, record layouts, table layouts and

IMS online screens. Despite the high volume of data requests, the average report was

delivered in under one day. Task recording, tracking, updating and prioritizing had to

be revised closely and constantly. Dedication and long hours were required to keep

up with the large fluctuations in report requests. Designed, coded, tested, debugged

and implemented COBOL/DB2 development programs for the DBS to PRIDE

conversion project in times when data requests where slow.

IMS Mainframe Environment

COBOL

JCL

DB2/SQL/SPUFI/QMF

Focus

IBM Debugger

Easytrieve

FileAid

Microsoft Office(Excel, Power Point, Access, Word)

Endeavor

TSO/ISPF VM/MVS

11/1984 - Nationwide Insurance – Internal Audits(L&G, P&C, EDP, Security), Columbus, Ohio.

11/2004

Programmer analyst responsible for analysis, design, coding, testing and

Implementation of data retrieval programs of the corporate data systems. Once the data

Is retrieved it then must be broken down and organized into audit data reports that can

Be understood by non-technical customers. Production data retrieval, organization,

Report generation, delivery and customer feedback of highly sensitive audit

Information. Major audit findings deduced directly from these data reports are

reviewed by Nationwide cabinet members; therefore quality, accuracy and timeliness

of these reports is assured. Worked directly with L&G, P&C and IT audit groups as

well as Corporate Security and the Data Quality area to determine Customer data/report

requirements. Since Internal Audits must be able to access any data system in the

Nationwide Company on demand, a working knowledge of many systems must be kept

and/or be able to be researched out quickly.

On demand access to any production IMS/DB2 data system required

Fire, Auto, Life, Commercial, Claims, Underwriting, etc…

COBOL

JCL

Focus/ASSIST/EDG

FileAid

Microsoft Office(Excel, Power Point, Access, Word, Visio)

DB2/SQL/SPUFI/QMF

Sarbanes Oxley

Lotus Notes

TSO/ISPF VM/MVS

Minor: Assembler, FORTRAN, Pascal

Training: Web Developer(HTML, VBasic, VBscript, Java, JavaScript)

Nationwide Insurance – Fire Processing, Auto Processing, Underwriting, Columbus, Ohio

Sr. Programmer Analyst responsible assigning workloads and monitoring progress of

Entry-level programmers assigned to the “printed documents” team. Our team was

Responsible for the updating and maintaining changes to the over 600 programs that

Created printed documents(Applications, rate quotes, renewal letters, cancellation

Letters, Notice of cancellations, Policy declarations, Premium Notices, Billing

Statements, etc…) for each region and state. Coordinated the changes, assigned tasks

And set the deadlines for program transmittal into QA testing and production.

Designed the document form layouts and created the KODAK code to add the

documents to microfiche when required. Designed, coded, tested, debugged and

implemented program changes to documentation.

IMS Mainframe Environment

Lead programmer over document print programs

Training

Documentation

Project tracking

Assigning work loads

Setting deadlines

Monitoring work status of the team

COBOL

JCL

Focus

Panvalet

ASSIST

IBM Debugger

FileAid

Microsoft Office(Excel, Power Point, Access, Word)

Microfiche(Kodak)

DB2/SQL/SPUFI

Easytrieve

ChangeMan

TSO/ISPF VM/MVS

INTERESTS AND HOBBIES

United Way Lieutenant, Operation Feed Captain, Fire Warden,

Sports (golf, running, soccer, pool, basketball, darts and softball). First place finishes

In Corporate Challenge soccer, track and darts. 3rd place finish in billiards.

Contact this candidate