Cobol Data Analyst
Resume:
Kevin A. Hutchison
**** **** ****, *******, ** 53704
Cell 608-***-**** Home 608-***-**** E-Mail: ***************@*****.***
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