Strong desire to master emerging technologies
September 2000 – Present
Programmer/Analyst
Center for Health Evaluation and Outcome Sciences,
St. Paul’s Hospital
Vancouver, BC, Canada
Environment:
SQL, Visual Studio 6, Visual Basic 6, ADO, MS Access, Windows NT Server, OpenIngres,
4GL, Ingres Relational database, OpenROAD, MS Office.
Responsibilities:
Perform ongoing analysis, design, development, testing, and implementation for a variety
of medical database systems related to cardiac and surgery patients. Design and build, populate,
test and normalize various databases. The medical databases provide a growing repository of
information for purposes of research and analysis.
Current projects include sole responsibility for new interfaces to the Marquette and Quinton
Hemodynamic Monitors as well as to the Diagnostic Catheterization Booking system.
The Marquette interface captures data from cardiac surgery procedures via the hemodynamic
monitor and associated MUSE database. The information is used to populate the cardiac registries
database (ingres) on the NT server. The application will replace the current manual entry of
information by medical technicians during the procedure. The interface is being developed in
Visual Basic 6 and OpenIngres 4GL, as an NT client.
The Quinton interface is the same in nature as Marquette, only it captures information from
Quinton equipment.
The interface to the Diagnostic Catheterization Booking system allows consolidation of waiting
list information with the cardiac registry database. The interface is being developed in Visual
Basic 6 and interfaces with a local Access and remote (ingres) database, as an NT client.
June 2000 – September 2000
Consultant (contract)
Boeing Aerospace
Seattle, WA, USA
Environment:
SQL, COBOL VS/II/75, JCL, VSAM, TSO/ISPF, IDMS, DB2, FILEAID, endevor, MVS, Word, Excel,
Windows 98.
Responsibilities:
Perform analysis and develop program upgrade specifications for assigned modules to accommodate
an upgrade to several Legacy HR Systems. Perform coding changes, develop testing plans, and test
upgrades to various assigned modules.
The purpose of the project was to accommodate a union split and various Engineering Job Classification
changes. Several hundred modules within seven Legacy COBOL Systems were identified as requiring
changes. The project involved Some 60+ Consultants, came in under budget, and was completed within a
tight deadline.
January 2000 – April 2000
Consultant
Roche Diagnostic Corporation
Indianapolis, IN, USA
Environment:
Oracle, UNIX, Windows NT, SQL, ADO, DAO, Visual Basic 6, Visual Studio 6, FTP, MS Access, VBA,
MS Office 97/2000.
Responsibilities:
Develop detailed requirements and design for two components of a Laboratory Pricing System.
Code, debug, and test components as well as facilitate knowledge transfer to staff.
The Database Synchronization component enables bi-directional synchronization of the information
on the server with any client based (Access) Database. The application, usually residing on a laptop,
can Sync-up over an Internet dial-up or network connection. The component also facilitates
transparent remote upgrading of the client software application. The component was developed with
VB 6 and ADO.
The Proposal/Contract component provides a means for Sales Personnel to generate highly detailed
and specifically targeted Proposals and Contracts in a matter of minutes while interviewing a Client
regarding their specific needs. The component replaces a manual process that had previously consumed
several days and standardizes the process, enhancing legal considerations. The component was
developed with VB 6/VBA and utilizes the objects exposed by MS Office for document generation and
management.
April 1998 - January 2000
Consultant (contract)
Boeing Aerospace
Phoenix, AZ, USA
Environment:
Oracle, PL/SQL, SQL, COBOL VS/II/75, JCL, VSAM, TSO/ISPF, IDMS, FILEAID, IDCAMS, SYNCSORT, UNIX,
Oracle Data browser, endevor, MVS, OS/390, Word, Excel, Visio Professional, Windows NT, ABC Flowchart,
FTP, ZIP, PC DOS.
Responsibilities:
Participate with Management and multi-disciplined teams in the analysis and preparation of detailed process
designs and program specifications for an Accounting and Cost Reporting System.
Develop, debug, test, validate, and implement assigned areas of new production system. Handle assigned
Change Management. Modify, and test portions of existing production system to insure compatibility.
Participate in Audit of completed project with Users to ensure system is performing to functional
requirements.
February 1997 - April 1998
Senior Programmer/Analyst
Canada Life Financial Corporation
Regina, SK, Canada
Environment:
COBOL VS/II/75, JCL, VSAM, TSO/ISPF, FILEAID, IDCAMS, SYNCSORT, REXX, DB2, SQL, CICS, PVCS, Lotus
Approach, QMF, SPUFI, COMPAREX, PCM/SMS, MVS, OS/390, RAMIS, INFOPAC, Lotus Suite, Visio Professional,
Windows 95/3.1, FTP, ZIP, PC DOS, Word Perfect.
Responsibilities:
Primary support for Claims Admin system problem resolution. Respond to and resolve any user or
performance problems related to the CICS region on-line COBOL programs, often involving emergency
analysis, ad-hoc coding, and fix implementation.
Primary On-call support for Claims system batch workday. Respond to and resolve abends and
contentions within two hour window. A.M. resolution of root cause involving batch workday ESP
rescheduling, or code changes within JCL procs and/or COBOL programs.
Analysis/Coding related to new procs and programs, enhancements, and routine maintenance as driven
by business imperatives. Perform a wide variety of analysis, coding, debugging, and performance
tuning related to all aspects of our legacy systems. This most often involves JCL, SQL, and COBOL
program changes designed to dove-tail neatly within the existing systems structure composed of a
combination of Insurance claims administration, accounting and reporting. Assist/mentor recent grads
and peers within areas of experience on Mainframe and PC applications and utilities.
System upgrade testing for OS/390 and CPU. Design and code JCL procs that utilize existing
production programs and system utilities. Follow-up related to exposed problems such as, recompile,
relink, and test dynamic subs from VS to II conversion.
Team member for Legacy systems conversion to AS/400. Perform analysis related to existing data
structures and data conversion requirements. Documentation and coding of ESP, JCL, and COBOL programs
to be used during conversion runs.
PVCS(version manager) Administrator for SQL Windows Team. Work with developers to design project and
promotion structure Requirements. Design, implement and administer projects and developer permissions
within LAN based environment.
September 1996 - February 1997
Programmer/Analyst
Canada Life Financial Corporation
Responsibilities:
User setup, configuration, and problem resolution for Claims Admin. System. Maintenance and problem
resolution for InfoPac reporting system. Assist senior programmers with routine program maintenance.
Assist senior programmers with batch workday problem resolution. Train for support of on-line regions
and batch workday.
Relevant Education:
University of Regina
Certificate in Data Processing
- Business Application Programming
- Systems Analysis
- Software Productivity Tools
Courses and self-taught skills:
Visual Basic 4/5/6, Microsoft Access, ADO, DAO, HTML, Macromedia Flash 4, Fireworks, NetObjects Fusion,
Adobe Photoshop, ODBC, Front Page, Paintshop Pro, Gif Animator, Web Graphics, Astound Dynamite, Corel Suite,
Quattro Pro, True Space, Visual Cafe for Java.
References:
Available upon request.