Uploaded File
add photo
Michael
m_varnell@hotmail.com
423-802-0771
9207 Berkshire Cir.
Chattanooga, TN 37401
DBA / Systems Analyst - COBOL
30 years experience W2
0
Recommendations
Average rating
23
Profile views
Summary

  • Over 30 years of IT experience in Life, Health, and Disability insurances, manufacturing, and government industries.
  • Over 20 years team lead and project management experience in systems analysis and design, database administration and financial systems.

Experience
Contract and employee Systems Analyst - COBOL
Information Technology
Apr 2001 - present
  • DB2, DB2 Utilities, Easytrieve, SQL Server, Access, UDB, Sybase Designed and developed Normative data summary sub system as part of the Market Analysis and Reporting system.
  • This included data mining and summarizing multiple years of claims data into a DB2 mini mart.
  • Team Lead Income and Billing system - Designed detail income reporting and balancing data mart for the Financing department.
  • System included posting balances to the corporate general ledger and conversion of two years of history data.
  • This system is part of the Financial Data Mart Designed and developed multiple data extracts for the Profitability Management Reporting project data mart.
  • The extracts were used by COGNOS to develop end user reports. Also developed several pricing models, based on SAS code, to extract data from the data mart and load into SQL Server tables for use with Access reporting.
  • Team lead for the Milliman provider reporting project.
  • Designed and created DB2 summary extracts for use with a third party grouping and reporting system. Also lead team to convert the extracts from MicroFocus COBOL to data stage.
  • Team Lead for the initial phase of the Financial Recovery of Overpayments system.
  • Continued as analyst on team after the initial installation. System is SQL server based .Net design with links into Facets. Set up Ondemand storage of letters generated by the system.
  • Responsible for maintenance of the Fraud and Abuse management system.
  • Third party system that utilizes an in-house DB2 mini mart created with COBOL programs.
  • Maintenance includes modifications to the mini mart extract and system extract SQL as well as new version testing and implementation.
  • Set up history reporting database and Access queries for data from the Customized Auditing System (CAS).
  • The third party system was removed from BCBST.
  • The historical data from two versions of the system was extracted into a SQL server database.
  • This project consisted of setting up a reporting database that was a merger of the data extract and creating views to allow necessary reporting to be performed.
SQL Server SQL Microfocus Cobol IMS FOCUS DB2 LUW DB2 Data Marts Data Mining System Analysis Auditing SAS Cobol
Remove Skill
Contract Systems Analyst and DB2 DBA - COBOL
Information Technology
Nov 1997 - Apr 2001
  • DB2, CICS, VSAM, Easytrieve Y2K system modifications - Determined and performed necessary maintenance on existing system to be able to continue processing into year 2000.
  • Team lead responsible for date aging DB2 tables and VSAM files to be used in large Y2K testing scenarios. Departmental DBA responsible for data maintenance, table design and development, data integrity, and system performance.
VSAM DBA DB2 Data Integrity Cobol CICS Database Design System Analysis
Remove Skill
Contract - Systems Analyst - IMS
Information Technology
Oct 1993 - Nov 1997
  • DB2, CICS, AMPS COBOL, COBOL, JCL, ACP Project Lead Friendly Screens - Designed and developed a claims and eligibility system for providers with a team of four other programmers.
  • Used IMS, DB2, CICS, AMPS COBOL. Systems Analyst - Amisys conversion. Designed and developed multiple interface programs with the state of Tennessee.
  • Lead team to create final documentation. Systems Analyst - Facets claims conversion. Designed and developed multiple interfaces during installation of new corporate wide insurance system.
  • Assisted with initial claims processing on new system and continued maintenance while converting additional lines of business.
DB2 Cobol System Analysis
Remove Skill
Systems Engineer - COBOL
Information Technology
Dec 1990 - Oct 1993
  • ACL, CICS, VSAM, JCL Maintained multiple systems for various insurance companies. Project Lead on multiple projects with team size varying from 1-5 persons. Promoted to Advanced Systems Engineer 04/1992 Completed the Technical Consulting Program 12/1992
  • Completed multiple consulting projects using varying technologies
JCL Cobol CICS VSAM Systems Engineering
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Business Data Processing
Chattanooga State Technical College 1978
Record has not been verified.
Certifications
Operations Certificate
Skills
Cobol
2021
28
System Analysis
2021
26
DB2
2021
22
Auditing
2021
18
SAS
2021
18
Data Marts
2021
15
Data Mining
2021
15
DB2 LUW
2021
15
FOCUS
2021
15
IMS
2021
15
Microfocus Cobol
2021
15
SQL
2021
15
SQL Server
2021
15
CICS
2001
6
VSAM
2001
6
Database Design
2001
4
Data Integrity
2001
3
DBA
2001
3
Systems Engineering
1993
3
JCL
1993
2
Project Management
0
1