SUPER RESUME
< Back
Edit this resume to make it your own!

Your Name

IT Computer Programmer / Analyst 1

Peoria, IL

your.email@example.com
111-222-3333
www.your-website.com

Summary

Broad spectrum of expertise on both PC/LAN and Mainframes environments. 
Skills in Object-Oriented Programming (OOP) Languages as well as legacy procedural coding. 
Talents include end-user analysis and design of various software systems, specifications for the 
conversion of computer systems, as well as extensive coding, testing, documentation, and training. 
Skill set includes internet/web technologies. 
Design, development, testing, debugging, and implementation of programs in several RDBMS 
environments both mainframe and PC/LAN network-based.

Work Experience

SQL Database Programmer

Sedona Technologies at Kone Inc., Moline, IL

Aug 2012Mar 2013

Sedona Technologies at Kone Inc (FKA Montgomery Elevator) 
Moline, IL - Aug 2012-Mar 2013 (Work remotely from Peoria) 
Kone Inc. is a manufacturer of elevators, escalators and  
electrically powered walkways based in Finland 
SQL Database Developer 
 
Developed SQL Scripting in SQL Server for use in SQL Server 
Reporting Services (SSRS). Translated Visual Basic for 
Applications (VBA) code in EXCEL spreadsheet reports into 
SQL Scripts for greater efficiency.  
 
Developed stored procedures with error-checking routines to 
validate SQL Server data inputs.  
 
Converted cloud-based JSON (XML-Like) data into MS ACCESS 
database using VISUAL BASIC code in both Visual Studio  
and Access Modules. 
 
Converted CSV-based data to text format and then to Access 
tables to be tested, verified and readied for transfer to 
the Kone SQL Server database.  
 
Developed Access-based database used to convert the data 
as well as tables, relationships, queries, reports. 
Developed ACCESS-based system to ease use of mapping  
tables and fields as well as managing the conversion and 
status of the project. 
 
Remote access to Kone Network through Nortel Client VPN 
and cable modem and Outlook Email.  
 
Environment: Windows XP Professional, MS Visual Studio,  
MS Office Products, EXCEL, ACCESS, Visual Basic, JSON, 
SQL Server Management Studio, Nortel VPN, MS Outlook

IT Quality Assurance Analyst (Contractor)

Property and Life Insurance Company, Springfield, IL

Sep 2010Oct 2011

Participated in the Horace Mann Educators Auto  
Property Modernization (APM) Project to automate 
the underwriting portion of insurance 
applications for clients. 
Understand state-specific insurance requirements 
and verify that Front-End Application, Front-End 
Reports and Back-end Mainframe conversion are all  
in agreement and meet those requirements.  
Communicate with management, other staff and  
offshore team (Syntel) to identify and fix defects 
as identified. 
Ran JCL and Mainframe programs to convert .Net 
Front-End data to Mainframe CICS-based system of 
record, confirming correct conversion, entering  
defects in the Mercury Quality Center software. 
Report to management of success/failure of conversion 
compared to APM Front-End and Reports using EXCEL 
spreadsheets and formulas for correspondence and  
status reporting. 
JCL Changes in Z/OS environment, programming in COBOL, 
EASYTRIEVE, DB2, VSAM. 
Worked closely with off-shore team of developers on hot 
fixes, before and after testing new enhancements  
and bug fixes. 
Used Quick Test Professional (QTP) to edit scripts and 
update data to match changes in software of the  
Horace Mann Auto Property application to insure  
smooth conversion of data for creation of test  
cases for Horace Mann business partners and to  
provide quality of end product and to perform  
efficient testing of those requirements. Data was 
loaded from EXCEL Spreadsheets.  
Devised improvements to current procedures and develops 
models of possible future configurations.  
Provided documentation to support the quality control 
process for system development/modification,  
testing, implementation, maintenance. 
 
Environment: Windows XP Professional, VB.Net.  
MS Office Products, Mercury Quality Center, VB Script, 
XML, Quick Test Professional (QTP), Excel, ISPF, Z/OS,  
COBOL, Easytrieve (EZtrieve), CICS, VSAM, DB2 
1

Independent Contractor

Hopedale Medical Complex, Hopedale, IL

Jun 2009Jul 2009

Provided Network-based technical end-user support 
Created/closed out problem tickets as problems  
occur/resolved  
Maintained individual user network accounts adding 
and deleting user accounts and resetting passwords  
as needed per management direction. 
Disabled accounts of terminated employees. 
Provide appropriate security to folders/directories 
to users and groups  
Provided end-user support in maintaining PC as well  
as printer and network connections. 
Helped trace phone lines for adding additional office 
phones, maintaining phone numbers and issues with 
voice mail.  
Maintained and replaced network backup tapes. 
Removed hard drives from old PC’s for proper disposal.  
Organizing the back room storage and network room.  
Various Miscellaneous tasks as needed 
(short-term employment supplementing existing staff)  
 
ENVIRONMENT: Windows XP Professional, MS Office Products, 
Windows Server 2003 and Active Directory

Programmer/Analyst

Tek Systems at State of Illinois - Dept of Children Family Services,

Nov 2006Jun 2008

MAINFRAME-BASED WORK 
 
Designed and performed data extract processes for  
DCFS Staff including detailed information on client  
(children) contact and purchase information. Designed 
reports and programs for System of Care data  
extraction using Easytrieve, JCL Procs, and File 
Parameter datasets.  
 
Worked with DCFS staff to extract data and develop  
reports to reconcile Dept of Healthcare and Family  
Services (HFS) claim payments data with DCFS payment 
claim data and payment adjustments.  
 
Maintained monthly extract process developed to allow 
auditors of the Infant Parent Institute (IPI) to verify 
the services performed on DCFS clients and verify the 
services performed match the payment claims made.IPI is 
a third-party vendor of DCFS and the State of IL.  
 
Mainframe maintenance duties as needed including data  
extracts from DB2 tables and conversions of data for 
analysis and summary. 
 
MS ACCESS-Based Systems with Visual Basic for Apps 
(including user interviews and database design) 
 
Psychiatric Hospital Reimbursement System (PHR) 
Database system reverse-engineered and re-designed 
from a failed system that was no longer in use.  
Used to track and reimburse payments to Psychiatric  
Hospitals in the State of Illinois that care for and 
treat DCFS children with mental Health issues. 
 
Fingerprint and Background Check Tracking System  
tracks the progress and records the results of finger 
print and background checks of staff having hands-on  
and/or face-to-face contact with DCFS kids. FABCT  
allows the end user to report the results to either  
the Dept of Human Services or the third party agency 
housing DCFS kids. System includes several reports 
and data management tools.  
 
Provider Maintenance Information (PMI)  
Maintain the current addresses of Providers used by 
local office to automate the production of payment 
vouchers to those providers, eliminating need for  
manual data entry. Converted original data from Excel 
spreadsheet to make the data more useful/easier to use. 
 
Mental Health Facility Audit (MHF)  
Designed to audit mental Health Facilities to insure 
they meet Illinois DCFS and federal standards for  
quality of care. Designed the database and reports 
based on interviews with users. 
 
ENVIRONMENT: IBM Z/OS, JCL, COBOL, DB2, IMS, ISPF, 
PANVALET, EASYTRIEVE, MS ACCESS, VISUAL BASICB FOR APPS

Information Technology Analyst II

Northern Technology Inc at Caterpillar Inc, Peoria, IL

Jul 2005Jul 2006

Applied System and/or infrastructure solutions to  
business/technical problems through the design,  
programming integration, debugging, testing and  
implementation of automated information technology 
systems and infrastructure components.  
 
Performed programming, development and system  
administration assignments working directly on 
application/technical problem identification and  
resolution, including off-hours support as needed. 
 
Assisted in the development of system modules and 
programs based on requirements gathered from 
customers/stake holders. 
 
Participated in integration testing and user acceptance 
of changes and worked with other staff in the  
interpretation of program specifications.  
 
Reviewed programming changes with senior staff to  
verify accuracy, tested and documented the changes. 
 
Upgraded JCL that uses GENTRAN from 6.1 to 6.3 for 
TBU and Dyersburg manufacturing plants. 
 
Implemented Work Station Code field conversion for  
individual manufacturing work stations from numeric to 
alpha-numeric data used in report distribution,  
identifying and analyzing system impact, altering CLIST 
panels to allow data entry, wrote QUIKJOB program for 
actual conversion, having this had minimized impact on 
the end users (saved thousands in dollars from an  
alternative approach of expanding the field) 
 
Converted Joliet MESL Interface and pull trigger  
programs for adaptation and use at TBU.  
 
Copied over Material Shortage JCL/Programs converting 
them over to TBU. 
 
Helped test/implement Part Multiple Prefix processing  
for TBU (field / database conversion). 
 
Converted Supply Chain Dashboard programs from Aurora 
plant and helped support Aurora manufacturing process. 
 
Trouble-shooting / fixing various reports on the 
mainframe, tracking down abends or creating new reports 
in either COBOL or QUIKJOB. 
 
Converted SAS programs to JCL Streams, QUIKJOB and COBOL 
comparing the results to the original program to insure 
consistency. 
 
Environment: IBM Z/OS, JCL, MS CLIENT/SERVER,  
ENTERPRISE COBOL, DB2, IMS, ISPF, CHANGE MAN, STROBE, 
EXPEDITER, ACCESS 2000, CRYSTAL REPORTS, QUIKJOB, SQL, 
TRMS, $SAVRS, VSAM

Factory Worker / Parts Inspection

Team Industrial Services, Taylor, MI

Jul 2004Jul 2005

Prepared automotive and other manufactured parts for  
inspection for cracks to prevent catastrophic failure.  
 
Assisted certified technicians with parts inspection 
process by penetration treatment and part magnification. 
 
Trained for and implemented Quality Assurance procedures 
and machine set-up. 
 
Set-Up Magnaflux machinery for parts inspection process 
and magnified parts using Magnaflux equipment. 
 
Unloaded client receivables and loaded client 
deliverables with fork lift truck.  
 
Other maintenance duties as necessary. 
(Note: This is NOT an Information Technology position)  
 
(Note: Due to lack of local jobs, moved from  
SE Michigan to Peoria, IL in July, 2005)

CONTRACTING OPPORTUNITIES

Various, Southeast Michigan Area

Jan 2000Dec 2003

Developed new programs and functionality for client’s 
Enterprise Resource Planning (ERP) Relational 
Database Management System making use of client/servers, 
Visual Basic and Cobol in a SCO-UNIX and WINDOWS  
environment. Wrote specs, coded, tested programs as 
per client requirements.  
 
Converted existing programs from the New Mexico  
Medicare system to meet standards for the Mississippi 
Envision Medicare System. Re-mapped programs as a  
result of changes in internal data processing and 
changes in program specifications. Developed new  
programs, made coding changes, unit tested and worked 
with client staff using program walkthroughs to insure 
programs meet client standards. Mainframe-based work 
using COBOL, DB2, SQL, ISPF, OS 390,including various 
Mainframe software tools.  
 
Updated Dental Clinic back-office support software 
written in COBOL with a GUI interface on a WINDOWS-based 
platform as well as on a SCO-UNIX (XENIX) platform.  
Designed and improved multiple programs to provide 
greater functionality and to add additional features. 
Worked with customers and customer service personnel 
to identify and solve bugs in existing production 
software. Used MULTI-EDIT and VI EDITOR to modify 
programs with ACUCOBOL as the compiler. Instrumental 
in the latest release of the COBOL-based latest 
WINDOWS and UNIX versions.  
 
Designed, developed, coded, tested changes to KMART’s 
Item Manager IMS database system to allow the  
consolidation of Pantry items from two different  
vendors to one (Supervalue to Fleming). Designed  
COBOL reports on MVS/TSO to identify items coming from 
two different distribution models (geographic area). 
Developed two programs using QUIKJOB to convert the 
database. Validated code and tested results of the  
new and existing programs of other team members. 
Mainframe IMS DB2 JCL environment.  
 
Designed, developed, coded, and implemented  
applications utilizing COBOL II, JCL and DB2 for Ford 
Credit’s Debt Manager product, a mainframe application 
by London Bridge. Developed and designed JCL and 
COBOL programs on an IBM 390 system according to user 
specifications to work with this product. Designed 
program specifications, worked with other team members 
to validate code and test results. Mainframe environment 
using IMS DB2 JCL CICS and various mainframe software.

Computer / Programmer Analyst II

St. John Providence Health System, Southfield, MI

Dec 1999Dec 2000

Developed and altered JCL and Cobol, SAS programs on IBM 390 System according to user 
specifications. Performed ad hoc data requests from various departments to provide decision support. Extracted data from an SMS database into BUNDL report files for raw data or pulled directly from DB2 tables. Converted data from SMS system into PC-based software products. Converted DYL280 JCL job streams into COBOL and SAS programs to replace obsolete software. Developed PC-based ACCESS databases for various functions and departments. (SMS is a software package acronym for Shared Medical Sub-System or Invision/Signature) 
(90% Mainframe-based, 10% PC/LAN/Client Server) 
 
TECHNICAL ENVIRONMENT: WINDOWS 95/98/NT, NOVELL NETWARE, SAS, IBM 390, SQL 
MS CLIENT/SERVER, COBOL, EXCEL, LOTUS, JCL, DB2, DYL280 
INTERNET EXPLORER, ISPF, ACCESS 97/2000, VISUAL BASIC

Senior Analyst (Programmer / Analyst Role)

Blue Cross Blue Shield of Michigan, Detroit, MI

May 1985Nov 1999

Developed and maintained several utilization review  
on-line data entry and reporting systems for facility and  
professional audits using MICROFOCUS COBOL or VISUAL BASIC  
on PC/LAN environment. Extracted the data from IBM Mainframe 
using either SAS or COBOL. Worked with users to determine  
proper format, offering suggestions, adding reports as  
necessary to resolve data issues, and designing the database. 
Was responsible for interviewing users, as well as developing 
and maintaining the database, copy books, and programs for  
these systems. Tested, debugged and trained users in the use 
of these systems and provided online documentation. Designed 
several database applications with ACCESS 97/2000 for various 
internal customers for a variety of applications. Developed 
several PC/LAN-based audit systems including interviews,  
analysis and reports using COBOL, Visual Basic and MS Access. 
 
TECHNICAL ENVIRONMENT: WINDOWS AND MAINFRAME, BANYAN VINES, 
SAS, MVS/TSO, IBM 370/390, MS CLIENT/SERVER,  
MICRO FOCUS WORKBENCH, COBOL (MAINFRAME AND PC), EXCEL, LOTUS, 
SPFPC, ISPF, MS ACCESS, VISUAL BASIC, JCL, CRYSTAL REPORTS, 
SOURCE SAFE, PANVALET, CLIST, IMS, DB2, SQL, ISAM, VSAM

Education

Master of Liberal in Interdisciplinary Technology

Eastern Michigan University, Ypsilanti, MI

19982001

Bachelor of Science in Business Administration

Central Michigan University, Mount Pleasant, MI

19781983

Associates in Computer Information Systems

Post-Graduate Schoolcraft College,

Skills

Too Many to mention - see resume - upd 06/17/2013
Resume Builder | Resume Templates | Resume Examples | About Us | Privacy Policy | Terms of Use | Help Articles | Contact Us
Super-Resume.com © 2013-2017