Engineer Data

William J. Schuster

WORK HISTORY

Conversion Interface Development and Test Analyst, Novant Health

February 2013 - September 2013 (Contract); Fort Mill, SC

. Analysis, development, and testing of Conversion interfaces to Epic EHR

for Dictaphone documents, Tsystem documents, DMS results, Xcelera

results, and Muse results and URLs.

Tools used: Epic Enterprise Suite, HL7 transmission protocol

Interface Development and Test Analyst, St. Vincent Health

March 2011 - January 2013 (Contract); Indianapolis, IN

. Analysis, development, and testing of new ConnectR interfaces to and from

Allscripts EHR for ADT, registration/scheduling, lab orders/results,

radiology orders/results, vaccinations, charges, and documents.

. Enhancement and testing for ConnectR interfaces to and from Allscripts

EHR.

Tools used: IDX ConnectR, Allscripts EHR, HL7 transmission protocol

Interface Development and Test Analyst, Legacy Health System (LHS)

June 2009 - November 2010 (Contract); Portland, OR

. Analysis, Epic Bridges configuration, testing and HL7 interface

specification development for 66 standard interface feeds including lab

orders/results, radiology orders/results (for 12 ancillary systems and

Epic Radiant outbound), diet orders, ADT (with 2 full outbound feeds and

2 limited inbound feeds), transcriptions, vaccinations, charges, ADS, and

providers.

. Post-go-live training for interfaces.

. Coordinated Epic, LHS interface development, and LHS business analyst

teams for interface programming, testing and implementation.

. Assistance with HL7 conversion documentation and testing.

. Assistance with Cloverleaf translation development.

Tools used: Epic Enterprise Suite, HL7 transmission protocol, Cloverleaf,

Pyxis, Cerner Millennium, GE IDX LastWord, GE Muse

Interface and Data Conversion Analyst, Palo Alto Medical Foundation

October 2006 - April 2009 (Contract); Sunnyvale, CA

. Analysis and HL7 interface specification development for 3 non-standard

Epic Sutter Healthcare real-time interfaces (Pathology Results,

Transcription, and Scans/Document Links) and 30 HL7 EMR record data

conversions (both one-time and ongoing conversion interfaces - including

Allergy, Diagnosis, Lab/Other Results, Pharmacy, Transcription,

Immunization, Vital Signs, Scans/Document Links, and custom feeds) for

the Camino Medical Group Epic conversion project.

. Successful implementation with a conversion error rate of 0.5% out of

28.5 million HL7 transactions. 90% of which were duplicates, warnings,

designed/expected or otherwise quickly resolved and we completed prior to

go-live for a significant final error rate of 0.05%.

. Responsible for all clinical data interface test planning and lead for

test executions.

. Post-go-live support and training for interfaces.

. Coordinated Epic, Sutter, affiliate, vendor and ancillary business and

development teams for programming, testing, implementation and

standardization.

Tools used: Epic Enterprise Suite, HL7 transmission protocol, Interface

Explorer, ICChart

System Analyst, Cleveland Clinic Florida

June 2006 - June 2007 (Contract); Weston, FL

. Resolution of Bridges interface errors for lab and radiology order

results, hospital registration (ADT) and ambulatory

scheduling/registration (Cadence).

. Updated and/or assisted with updates of provider (SER), lab results

(LRR), lab result tree, lab order (EAP), patient record (EPT), pharmacy

(PHR), letter template and preference list records in EpicCare.

Tools used: Epic Enterprise Suite, HL7 transmission protocol, Signature

Lead Pharmacy and Interface Test Engineer/Analyst, Kaiser Permanente

National and Northwest

January 2005 - February 2006 (Contract); Oakland, CA and Portland, OR

. Responsible for development and execution of all Northwest territory

outpatient and inpatient test cases involving pharmacy ancillary

interfaces (Bridges) and workflow, including medication orders,

formulary, inventory and dispensing (EpicRx),

admissions/discharges/demographics (ADT/ED/L&D), scheduling (Cadence),

health information management (HIM) and billing (Resolute/HB).

. Developed and executed regression sets for each project.

. Assisted with training and mentoring of other testers on system and

workflow test teams.

. Coordinated test data and software requirements for interface and

workflow testing.

. Additional supervision, development and analysis of inpatient ADT,

transcription and Lab testing.

Regression and Lead Ancillary Interface Test Engineer, Kaiser Permanente

Colorado

November 2004 - January 2005 (Contract); Aurora, CO

. Develop, refine and execute new and regression testing for pharmacy, EKG,

scanning and transcription interfaces, as well as assist with production

support.

. Develop and implement production support workflow for Epic pharmacy

issues focusing mainly on newly developed refill authorization request

functionality.

. Continue with all responsibilities listed under Lead Data Migration Test

Engineer/Analyst as necessary, plus assist with the Kaiser/Exempla OpTime

module.

Lead Data Migration Test Engineer/Analyst, Kaiser Permanente Colorado

July 2004 - November 2004 (Contract); Aurora, CO

. Lead data migration tester for conversion from IBM CIS to Epic Chronicles

database in both Hyperspace and UNIX text environments.

. Reduced total test time for each data set per cycle to 1/40th or less

than initial estimates by adding full data load automated comparisons and

targeted test samples to a reduced set of random sample manual testing.

. Responsible for validating data testing requirements for 8 data

conversion sets with business personnel, as well as advising on the most

useful test methodologies for data testing under a strict deadline.

. Managed teams of 3-15 testers during manual data validation.

. Develop test procedures for both manual and automated data testing in all

import data conversion sets (both delimited and HL7 interface imports),

write necessary data comparisons (in TextPad, Access and Excel), and

develop extract KB-SQL from Chronicles.

. Assist with integrated workflow and system testing, and updating test

cases as necessary in Kaiser Epic environment (Cadence, Prelude, EpicCare

Ambulatory).

Tools used: Epic Enterprise Suite, Pyxis, IBM CIS, KB-SQL 4.2, HL7

transmission protocol, Mercury TestDirector, Microsoft Access, Kaiser

software

Global Systems Test Developer, Lipper Analytical Services

July 2003 - December 2003 (Contract); Denver, CO

. Successfully led manual and automated testing for one data feed project

and one database application upgrade project.

. Resolved project requirement and data issues with developers, project

managers, product managers, business analysts and users, requiring a high

degree of familiarity with mutual fund reporting, analysis, and

performance data.

. Test case preparation consisted of 50-60% developing Transact-SQL

scripts, plus at least 5% VBA (Excel) development.

. Improved the accuracy and speed of existing test processes at least 15-

20% by developing test cases fully implemented within Sybase.

. Assistant tester for several other application, calculation engine and

data feed projects involving both manual and automation testing.

Tools used: Sybase 11 Transact-SQL, VBA (Excel), SQL Programmer 9, TextPad

4.5, Rational Test Suite 2002 (Clear Quest, Requisite Pro, Robot, Test

Manager), Rational Rose 2002, Microsoft Access, Lipper software

Sales and Support Data Conversion Specialist, Advanced Digital Information

Corp (ADIC)

June 2002 - May 2003 (Contract); Englewood, CO

. Data entry, conversion and quality assurance of contracts, accounts,

customer records and service requests for tape backup hardware/software

vendor.

. Oracle Applications functional testing (11i Beta testing site), process

improvement, training, advising management on technical Oracle

Applications concerns, and Oracle and Windows error resolution.

. Coordinated with Finance, Logistics and ADIC Product Tech Support.

Tools used: Oracle Applications 11i (Customer Relationship Management,

Financial Management, and Supply Chain Management), Remedy Action Request

System 4

Senior SGML Editor (EPS II), Information Handling Services (IHS)/CCH Inc

December 1999 - April 2001 (Contract - direct hire in May 2000); Englewood,

CO

. SGML tagging, conversion, scanning and editing of US government aviation

and financial regulations and related documents, with some Adobe

interactive form creation and data entry.

. Average production rate was 161% of the 18.5 pages/hour expected for a

Lead Editor (EPS III), which was largely a result of programming new

macros and improving the efficiency of existing macros to increase

editorial quality and production rate.

Tools used: SGML, MultiEdit 8, CMACW, Adobe Acrobat, IHS software

Software Tester, Intessera Technologies Group

March 1999 - May 1999 (Contract); Englewood, CO

. Functionality and load testing for a database interface application.

Tools used: Intessera software

SGML Editor (EPS I), Information Handling Services (IHS)

April 1998 - August 1998 (Temporary Contract); Englewood, CO

. SGML tagging, conversion, scanning and editing of US government worldwide

trade regulations and related documents.

Tools used: SGML, MultiEdit 7, Adobe Acrobat, IHS software

Quality Assurance Technician, Outsource Technologies Inc

October 1997 - January 1998; Aurora, CO

. Quality assurance and control for computer asset returns and custom-built

PCs, including creating asset return work instructions and 100% accurate

quality control for asset returns.

Tools used: Outsource software

CERTIFICATIONS

Epic 2014 Interface Administrator (Bridges)

May 2009

Epic 2014 Identity Administrator

March 2010

Epic 2014 Chronicles Install Utilities

April 2010

Epic 2014 Hyperspace Configuration

April 2010

Epic 2014 Chronicles Non-Programmer

April 2010

EDUCATION

Certificate of Advanced Study in Database Administration

November 2004

University College, University of Denver, Denver, CO (3.9/4.0 GPA)

Master of Computer Information Systems

June 2001

University College, University of Denver, Denver, CO (3.9/4.0 GPA)

Certificate of Advanced Study in Computer Programming

November 1999

University College, University of Denver, Denver, CO (3.9/4.0 GPA)

BA in Liberal Studies, Focus in Chemistry, Emphasis in Biology

July 1997

Northern Arizona University, Flagstaff, AZ

Contact this candidate