Post Job Free

Resume

Sign in

Cobol Data Analyst

Location:
Madison, WI
Posted:
January 18, 2022

Contact this candidate

Resume:

Kevin A. Hutchison

**** **** ****, *******, ** 53704

Cell 608-***-**** Home 608-***-**** E-Mail: adpymp@r.postjobfree.com

Objective

To solve business problems by creating effective software

Summary of Qualifications

A dedicated developer with 15+ years of experience in mainframe environments

Areas of Expertise

Technologies: COBOL II, CICS, SQL, JCL, DMexpress, SAS, REXX, DB2, Oracle, EZtrieve, Focus, Z/OS, Perl, IMS Office/Project/Access

Analysis: development/enhancement of complex processes to implement critical business needs

Problem Resolution: Lead abend/problem resolution team from 10/00 - 4/01, consistently volunteered for on-call and production support as an opportunity to learn business systems

Communication: Creation of complex business requirements and technical specifications using CMMI methodologies

Professional Experience and Accomplishments

Data Analyst June 2019 – February 2020

Certco, Inc.,

Fitchburg, WI

Responsibilities: Analysis, Coding/testing, problem resolution

Accomplishments:

Updated all accounting macro spreadsheets from 2010 to Office 365

Created SSIS Packages to handle data transfer to Margin Max

Various help desk requests

Software Engineer June 2016 – February 2019

National Guardian Life Insurance,

Madison, WI

Responsibilities: Analysis, Coding/testing, problem resolution on LifePRO policy management system

Accomplishments:

Wrote modules for Settlers’ conversion to NGL business.

Updated existing MS Access-based user databases, created python code to facilitate COBOL development

Responsible for data problem analysis and resolution

Senior MetaSolv Developer May, 2015 – February 2016

TDS, Madison, WI

Responsibilities: Analysis, Coding/testing, problem resolution on TDS distributed metasolv system

Accomplishments:

Created several new Gateway events to handle billing notification and to close physical plant tasks on a Metasolv provisioning system.

Refreshed test regions with production code in preparation for large scale project use

Analyzed and corrected production Web services based on problem requests.

Responsible for data problem analysis and resolution

Senior Developer/Analyst February, 2011 – May 2015

TDS, Madison, WI

Responsibilities: Analysis, Design, coding/testing, problem resolution on TDS mainframe

Accomplishments:

Designed process to store DISH customer data on TDS mainframe for DISH TV and Dishnet services on TDS Oracle tables to track representative compensation. Created entity relational table design using information from DISH technical representatives. Coordinated data file reception with technical resources to load activity files onto TDS Microfocus system. Provided support to reporting team creating load notification. Designed process to capture and load existing DISH data for continuity.

Ran team translating unsupported online modules to mainframe CICS used for TDS billing reference tables. Assigned developers modules to test, provided ongoing developer support, tracked project progress, ran weekly progress meetings, reviewed module function after unit test for defects, and coordinated communication of developers with TDS Clients. Provided analysis and support for CICS modules after project deployment.

Created billing portion of mainframe IPTV daily batch process to integrate data from Microsoft Mediaroom appliance onto TDS MARS-RPACS billing system. Created configurable Oracle tables to allow TDS clients to manage record loading after edit failures in conjunction with TDS clients.

Created batch process to edit Switch data files (2012 IE Nominee) using Syncsort DMExpress product. Designed process to convert EBCDIC data to ASCII hexadecimal for batch editing in DMExpress, then conversion back to EBCIDIC for upload to TDS Switches.

Analyzed Microfocus data file formats (fixed block, variable block, VSAM) and designed PERL scripts to fragment/reassemble large (>1gb) production files for comparison/editing on 32 bit Windows systems.

Mainframe Consultant October 2010 – February 2011

ETeam Inc., South Plainfield, NJ

Responsibilities: Service external clients (Deloitte Consulting, for the Delaware Department of Health and Human Services DCISII system), maintenance support on the existing COBOL mainframe system

Accomplishments:

Resolved existing production bugs in the DCISII Welfare eligibility system

Senior Programmer Analyst August 2004 – May 2010

Wisconsin Physicians Service/Tricare, Madison, WI

Responsibilities: Service internal clients, design business requirements and technical specifications, implement designs and specifications, code and test programs, provide on-call support, resolve client problem, participate in and manage team builds through Changeman on WPS mainframe.

Accomplishments:

Operated as department expert for electronic claims batch 835/837 processes (COBOL); designed architecture (837); managed initial implementations; supported and enhanced processes; maintained CICS-based 835 transaction viewer; implemented testing regimes to guarantee compliant transactions.

Created business requirements, wrote technical specifications, and performed changes to update patient physical exam benefit eligibility in the Medical Review Subsystem of the CICS Claims processing System.

Designed and created a process to determine patient eligibility for autism benefits in CICS. Ran design meetings, created process design documents, project development and implementation schedules.

Designed and created a COBOL batch process to take authorized claims and feed them into the CICS processing system with custom claim bypasses to avoid manual intervention.

Completed batch/CICS maintenance projects on the batch check writing system and the CICS-based claims processing system in COBOL/JCL/EZtrieve.

Wrote a client/server provider database with more than 100 users (VB6), a LAN-lookup utility in Ruby on Rails, and managed a Ruby on Rails Wiki to house latest department testing techniques and team knowledge, process documentation.

Programmer/Analyst February 1999 – August 2004

Great Lakes Higher Education Corporation, Madison, WI

Responsibilities: Service internal clients, design technical specifications, code test programs, provide on-call support, develop and implement business process improvements on GLHEC mainframe.

Accomplishments:

Designed and developed COBOL /SAS process for a business partner that included editing, loading alternative student loans and performing monetary disbursements.

Developed an annual percentage rate (APR) calculator in VB for application guarantee testing and a Commonline v4 file editor.

Developed a SQL-based SAS reporting process model to send reports/data files to lenders submitting consolidated applications, and to generate lender-specific outstanding LVC lists, according to servicing organization.

Developed SAS process to estimate borrower debt at repayment and print out loan disclosures based on borrower indebtedness.

For 10 months, led problem resolution team handling all guaranty production issues.

Postdoctoral Fellow March 1998 – January 1999

University of Wisconsin-Madison, Department of Biomolecular Chemistry

Responsibilities: Design, implement and interpret experiments and methodologies; manage laboratory resources including capital and human; author scientific reports

Postdoctoral Fellow October 1997 - March 1998

University of Illinois-Urbana Champaign, Department of Animal Sciences

Responsibilities: Design, implement and interpret experiments and methodologies; manage laboratory resources including capital and human; author scientific reports

Research Investigator May 1989 – September 1997

University of Michigan-Ann Arbor, Department of Pharmacology

Responsibilities: Design, implement and interpret experiments and methodologies; manage laboratory resources including capital and human; author scientific reports

Education and Training

Web Developer Certificate, Madison College, completed December 2002 with 4.0 GPA

Programmer/Analyst Associate’s Degree, Madison College, in progress, with 3.85 GPA

Ph.D., Biological Chemistry, University of Michigan-Ann Arbor, December, 1989



Contact this candidate