SQL Database Programmer
Sedona Technologies at Kone Inc., Moline, IL
Aug 2012 – Mar 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 2010 – Oct 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
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
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
Hopedale Medical Complex, Hopedale, IL
Jun 2009 – Jul 2009
Provided Network-based technical end-user support
Created/closed out problem tickets as problems
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
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
Tek Systems at State of Illinois - Dept of Children Family Services,
Nov 2006 – Jun 2008
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
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 2005 – Jul 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
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
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 2004 – Jul 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)
Various, Southeast Michigan Area
Jan 2000 – Dec 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 1999 – Dec 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 1985 – Nov 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