William A. Tate
Woodstock, Ga. 30188
adb728@r.postjobfree.com
www.linkedin.com/in/williamtatehl7
I am Disabled and can only work 100% remote and only Part Time.
My most current skills include analysis, design, coding and troubleshooting of enterprise-wide Version 2.3.1 and 2.4 HL7 interfaces and ELR Version 2.3.1 to 2.5.1 conversions. My analyst skills are in systems design, functional and technical writing, problem analysis and resolution and project management. Additional skills include analysis and data mapping of HL7 2.3 and 2.4 ADT and Clinical messages coming from the VA’s VistA system. I have worked with the eLink, Mirth Connect, Iguana(Chameleon), HL7KIT, Rhapsody and Qvera Interface Engines.
EDUCATION
AAS degree in Information Systems from Chicago City College.
Hartford Graduate Center: IMS Programming
Relational Methods: DB2/SQL Fundamentals
Kennesaw State University: C++ Programming
Coursera: Python for Informatics
Coursera: Interactive Programming in Python
Coursera: Programming Mobile Apps for Android Handheld Systems
Udemy: Automate the Boring Stuff with Python
HARDWARE/OPERATING SYSTEMS
IBM Mainframes: MVS, VSE, VM, OS/390, Z/OS
Intel PC: MS DOS, WINDOWS 3.1, 9X, NT, 2000, XP
LANGUAGES/DATABASES/INTERFACE ENGINES (level of expertise)
Orion Rhapsody (2 months), Interfaceware Iguana (moderate), eLink (proficient),
Python (moderate), HL7 (2.1 thru 2.5.1) (expert), COBOL (expert), CICS
(proficient), JCL (moderate), ADSPlus (proficient), HTML (proficient), IMS DB
(proficient), DB2/SQL (prior exposure), VSAM (proficient), Access (prior exposure),
Boston Workstation 7 (prior exposure)
PRODUCTIVITY TOOLS
TSO/ISPF, VM/CMS, ROSCOE, ICCF, SPM II, PANVALET, LIBRARIAN, ENDEVOR, vi, IDCAMS,
EXPEDITER, INTERTEST, MS Office, MS FrontPage, MS Visio, KORN shell, C shell, BMS-GT,
SYNCSORT, FileAid, Crystal Reports
CASE TOOLS
S-Designer, RoboCASE, EasyCASE, ER/Studio.
DESIGN METHODOLOGIES
CMM/CMMI
Mobil Oil Company's SYSTEM DEVELOPMENT METHODOLOGY.
CARA Corporation's SYSTEMS DEVELOPMENT STANDARDS.
APPLICATIONS
Patient Management, Patient Accounting, Interfaces, Order Entry, Inventory Control,
Accounts Receivable, Sales Analysis, Sales Reporting, Time Reporting, Project
Tracking, Credit Card Processing.
I have forty-eight years of Information Systems experience. Thirty of these have been in Healthcare IT. I have been an HL7 analyst, system designer, programmer/analyst and computer operator. I have performed full Life Cycle Development for both mainframe and client/server platforms. Served in a Project Management role for both package implementation and maintenance projects. Performed analysis, programming, problem analysis and resolution and production support for various legacy systems. Performed professional web site design and coding.
EMPLOYMENT EXPERIENCE
Freelance Consultant (LCA Software) April 2012 – Present
Performed various HL7 V2x Interface Development, Consulting, Data Analysis, Data
Mapping projects for clients in the USA and Russia such as: Created HL7 ADT messages
from an Excel spreadsheet; Created a Mirth channel to populate MySQL database rows from
HL7 ORU^R01 messages; Created HL7 messages from dBase III DBF tables; Consulted with a
medical billing Vendor (Boost Medical) about HL7 interfacing with their Practice
Management vendor (Care Cloud); Created a Mirth channel to produce ORM^O01 messages from
a MySQL database.
Orchestrate Healthcare January 2011 – November 2011
o Hawaii Department of Health (ORU Labs)
For the ELR project performed an eLink version 4.6 to Rhapsody conversion also
converting the incoming HL7 2.3.1 messages to 2.5.1 messages. Responsibilities included:
documenting the current eLink interfaces coding and testing the new Rhapsody versions of
those interfaces.
o St. Luke’s Health Systems, Boise ID (ORM ADT ORU)
Created Test Plans and unit tested 140+ Orion Rhapsody HL7 interfaces for a conversion
from Egate to Rhapsody. Created the test plans by reading the existing Monk code
and insured that the new Rhapsody code contained the same functionality and produced
the same results as the original Egate Monk code.
o VITL (Vermont Information Technology Leaders) (ORM ADT ORU)
Responsible for ensuring HL7 Data quality/integrity for messages from VITL’s various
(20+) providers. Created 50 “Before” and “After” HL7 messages for each provider by
splitting them out of an Excel spreadsheet and using them for comparison purposes.
Then created a report for each provider detailing any differences in the “Before” and
“After” messages.
Aetea Information Technology August 2010 – October 2010
o Alpha Systems (MDM)
Developed HL7 interfaces using the Iguana interface engine and custom Python scripts.
These interfaces extracted information from HL7 segments and created flat files used
to create TIFF files from the Information in a later process. Created custom Python
scripts to extract RTF files imbedded in HL7 messages and create native RTF documents.
Created Python scripts to embed RFT documents inside HL7 messages.
The Judge Group February 2010 – March 2010
o Quest Laboratories (ADT SIU)
The project was to accept ADT and SIU HL7 messages from various outside systems and
transform them into appropriate HL7 input messages for Quest’s web portal CARE360.
The tool used was Bridge Forward’s Clear Span HL7 mapper.
The Judge Group/The BITS Group March 2009 – July 2009
o Veterans Health Administration/3M Health Information Systems (ADT)
As a Senior Integration Consultant was responsible for analysis of patient ADT and
Insurance information in the VHA’s Vista system in preparation for the data migration
into the 3M Payment Manager System. Analysis included how much patient data could be
derived from existing Vista HL7 feeds and how much data would have to be derived from
other sources such as customized Mumps data file extractions. As part of the analysis
created artifacts such as an Interface Control Document detailing the information
contained in the HL7 messages and data mapping spreadsheets for use by 3M Integration
Engineers. As part of this effort created Unit Test plans for use by 3M and VHA
personnel to ensure that the data migrated contained valid information passed by Vista
into the 3M system.
TEK Systems September 2008 – January 2009
o Cancer Treatment Centers of America (various)
Acted as a technical resource for enterprise-wide IT interface initiatives. Designed,
developed, tested, deployed and supported standard and non-standard eLink HL7
interfaces. Created and maintained interface architecture and procedure documentation.
Provided 24x7 support of eLink interfaces. Also performed eLink System Administration
tasks such as adding new users with their security and creating automated alerts for
interfaces.
Micro Star Inc. April 2007 – October 2008
o Veterans Health Administration (RDS RDE ORU SPQ^TBR QRY^Q01)
As an HL7 Analyst was responsible for mapping of data from HL7 messages into
relational database schemas for Allergies, Vital Signs, Pharmacy and Lab domains as
part of the VHA’s Clinical Data Service II/Health Data Repository II (CDS II/HDR II)
project. Used TOAD tool to verify/extract HL7 messages from the Oracle database.
Created artifacts such as data analysis documents, Data mapping documents,
Requirements documents and Use Cases. Scheduled and facilitated JAD meetings between
the developers and the analysts. Performed an analysis of the Enterprise Exception
Logging Service (EELS) and created a Requirements document detailing the EELS
requirements for interacting with CDS II. As part of this effort created a PowerPoint
presentation describing EELS and presented it to the HDR II analyst staff. Performed
analysis and created a document detailing the differences between the HL7 Version 2.4
Standards manual and the VA’s Messaging Workbench (MWB) implementation of repeating
HL7 segments.
o Methodist Hospitals Gary, IN (various)
As an Interface Analyst was responsible for developing, maintaining, monitoring and
troubleshooting hospital-wide (ADT, Orders, Results, Pharmacy, Transcription, etc)
HL7 interfaces using the eLink interface engine. Responsibilities included providing
24x7 on-call support for multiple vendor systems interfaces. Wrote interface
specifications, including data mapping. Prepared test plans and performed integration
testing.
Comdyn Group July 2006 – Nov. 2006
o Blue Cross/Blue Shield of Tennessee (Vxx) Chattanooga, TN
Developed version 2.3.1 HL7 interfaces for Immunization Registry using a product
called EC Map. Wrote interface specifications, including data mapping. Prepared
test plans. Applied and tested upgrades to batch and CICS COBOL programs.
Premier Alliance Jan. 2006 – May 2006
o Bi-Lo Foods Greenville, SC
Developed Technical Specifications and coded new programs for Contract Cost Controls.
These programs were written in COBOL, CICS and processed VSAM KSDS files and DB2
databases. Also created/modified MVS JCL.
Modis June 2005 – Dec. 2005
o Certegy Card Services
Made enhancements to batch COBOL programs and MVS JCL for Certegy’s Credit Card
Processing system (BASE 2000). The system was written in COBOL and processed VSAM
datasets.
Micro Star Inc. May 2005 – June 2005
Developed Visual Basic scripts to automate workflows using a scripting tool called
Boston Workstation. Also received hands-on training on Cloverleaf Platform V and
Release 3.7.1.
Ecom Consultants/Jaywood Management March 2005 – April 2005
o University of Michigan Medical Center Ann Arbor, MI
Functioned as an extra resource to clear up a backlog of user requests. These
programs were written in COBOL and processed VSAM KSDS files.
Apex Systems Aug. 2004 – Dec. 2004
o Geico Macon, GA
Made enhancements to the mainframe Billing/Receivables system. This system was
written in COBOL, CICS, DB2 and VSAM. Also used MVS JCL.
Foundation Global June 2004 – Aug. 2004
o Computer Sciences Corporation Albany, New York
Functioned as an additional resource for a mainframe healthcare subsystem. This
subsystem was written in COBOL, CICS, VSAM.
TSYS May 2001 – April 2004
Programmed enhancements to a mainframe Credit Card Processing System. This system was
written in COBOL, CICS, VSAM, IMS/DB and DB2. CICS maps were coded with BMS-GT. The
system software included MVS, TSO/ISPF, ENDEVOR, Expeditor, FileAid, MVS JCL and MVS
utilities. Job duties included (SDLC): technical analysis of assigned program
modifications; technical design of the solution; coding, unit and integrated system
testing of the modifications; program, system and Operations documentation; database
design and modification where necessary (several projects included adding columns to
DB2 tables); weekly status reporting. Developed team productivity tools using Visual
Basic 6/Access.
COMFORCE (Brannon & Tully) May 2000 – April 2001
o BellSouth (Accenture)
Developed documentation and programmed enhancements to a legacy Check Processing
System. This system was written in COBOL II and IMS DB/DC. The system software
included MVS, TSO/ISPF, and MVS JCL. Responsible for enhancements and product
upgrades to a web-based time reporting system written in Java and JavaScript with
Korn shell and Perl scripts, processed Oracle 8i databases and ran on iPlanet web
server.
McKesson/HBOC Oct. 1999 – March 2000
Responsibilities included conversion from COBOL to COBOL II and Y2K remediation for a
customer who decided not to upgrade to the Y2K compliant version of the HBOC mainframe
healthcare products. The system software included MVS, TSO/ISPF, and MVS JCL. Made
modifications to COBOL programs and VSAM files for various HealthQuest 2000 Release 6
development projects, which included HL7 version 2.3 interfaces.
Matrix Resources Mar. 1998 - April 1999
o The Fredrick Group
The Fredrick group was responsible for maintenance and enhancement of the IBM
COPICS (MRP) package. Responsibilities included retrofitting customer modified
code into the latest release; conversion from COBOL to COBOL II; Y2K remediation
using IBM VISUALAGE COBOL FOR WINDOWS. Functioned as Project Leader supervising
the activities of three other contractors. COPICS was written in COBOL and processed
IMS/DB databases.
o Ceridian Employer Services
Responsible for enhancements to the Auto Router (Automated Output Routing) system.
This system was written in COBOL and processed both VSAM files and DB2 databases.
ADECCO Technical Services Oct. 1997 - Mar. 1998
o Georgia Power
Functioned as a backup to the regular programmer on the mainframe Rate Design system
while it was being replaced by a client/server system. Responsible for minor
enhancements.
eWebIT Solutions (MSI Solutions Group) June 1996 - Oct 1997
Responsibilities included developing customized interfaces in HL7 using MSI's Interface
Engine product called eLink. Configured Windows NT Server machines. Coded Transact SQL
code for both Sybase and SQL Server. Created SQL Server stored procedures. Created
UNIX C shell scripts. Created customized applications using Delphi 2. Designed and
implemented a financial system data repository that used SQL Server 6.5. This system
used VSAM files extracted from an IBM Mainframe. Performed Database Administration
functions for the SQL Server databases. The databases were designed using the RoboCase
Case Tool. Created eLink interfaces to populate the databases, extract data and produce
reports from the extracted data.