Six Sigma Medical

Qun Yu

**** **** ****** ****

Arlington Heights, Illinois 60004

Home: 847-***-****

Cell: 773-***-****

abhvcs@r.postjobfree.com

Summary

Skilled and reliable professional with more than eight years of experience

related to information technology in health care industry; particular

expertise in Cerner Command Language (CCL), creation of customized reports,

data modeling, and front and back end support for Cerner Millennium.

o Knowledgeable about processes and work flow in medical industry; able to

create reports that facilitate completion of tasks.

o Able to summarize data to provide detailed and useful information that

helps managers visualize progress and gain "big picture" viewpoint.

o In-depth familiarity with numerous modules of Cerner system; able to

quickly learn additional systems such as Epic.

o Solid understanding of database technologies, data warehousing, system

architecture, and data analysis.

Programming Languages, Platforms,

and Packages

Cerner: Cerner Command Language (CCL), Cerner

Millennium

Languages: SQL, Java, HTML, XML, CSS, JavaScript, JQuery

Database: Relational Database, PostgreSQL, MySQL, Oracle,

Microsoft Access

Platforms: UNIX (VMS, AIX, Solaris), Windows (NT, 2000,

XP), Linux, DOS

Network Protocols: TCP/IP, UDP, HTTP, FTP

Six Sigma Methodologies: VOC, QFD, CTQ, FMEA,

Scorecard, Gage R&R

Professional Experience

Northwestern Memorial Hospital (NMH)

Chicago, Illinois ( 2007-Present

Data Analytics Architect - Clinical Systems Patient Care Core Team

o Designed and developed Cerner Millennium Core applications, including

customized reports and MPages, using Cerner Command Language (CCL).

o Played key role in cross-disciplinary patient care team of 25 and subset

of six that focused on CCL; mentored new team members and familiarized

them with common reports.

o Implemented CCL reports, requisitions, dot phrases, smart templates,

Genview, MPages, customized tables, and Prompt and Layout builder.

o Developed expertise in Cerner Millennium data models across various

applications including Orders, PharmNet, Surginet, Scheduling, Profit,

Person Management, Charges and Radnet.

o Functioned as critical Cerner resource during design process of data

marts for Medical Enterprise Data Warehouse (EDW) leveraging knowledge of

SQL and Oracle database schema.

o Used comment table expression (CTE) to generate comprehensive SQL reports

utilizing data from EDW tables on SQL Server 2008.

o Supported several applications on back end, leveraging technical

understanding, application support experience, and clinical background.

o Managed code upgrade during transition to Cerner Millennium,

troubleshooting go-live issues and testing customized features.

o Participated in design, development testing, and go-live procedures of

new enhancements and applications for PharmNet, including implementation

of Advance Dispense Routing for pharmacy and automatic robot (Talyst);

liaised between pharmacy and information systems department and supported

integration of Talyst with PharmNet system.

o Managed integration of hardware and software in pharmacy department of

new facility, Prentice Women's Hospital, handling go-live tasks such as

ensuring functionality of printing systems.

o Earned recognition for implementing lab order requisition for paper

saving processes.

Qun Yu

Page 2

Advocate HealthCare

Chicago, Illinois ( 2006-2007

Application Analyst - Cerner Core Application Team

o Developed Cerner Millennium Core applications; customized reports and

Genview using CCL.

o Provided back end technical support for orders, documentation, and

PowerChart.

o Developed clean up script to delete the rows in the table which cause the

duplicate signatures in the modified forms

o Designed Genviews in PowerChart to show nursing care information, 24-

hours view, and medication reconciliation.

o Created report showing unit census information and nursing shift

assignments; report could be printed on front end, showing real-time

information, and nurse managers received and used it daily.

o Wrote script that automatically cleaned up physicians' inbox.

o Supported medical professionals using system by staffing command center

to respond to questions during go-live.

Children's Hospital Boston(CHB)

Boston, Massachusetts ( 2004-2006

Application Development Specialist III - PharmNet and Discern Team

o Built and tested Cerner PharmNet applications, designing and implementing

custom clinical/pharmacy reports using CCL on AIX platform.

o Participated on team that upgraded from Cerner Classic to Cerner

Millennium, focusing on troubleshooting and back end support for

pharmacy.

o Developed 50 clinical and pharmacy reports using CCL and Report Writer;

created and supported patient medication profile (PMP), pharmacy work

lists, pharmacy cart fill report, daily charge summary report feeds for

Oracle, insulin report, inventory drug label report with bar code, and

dose range checking grouper linked with synonym and drugs

o Managed PharmNet design, development, and testing, with oversight of

formulary upload; provided back end support, including debugging,

resolving issues, generating test scripts, and uploading and patching

scripts for new labels.

o Scheduled and set up standard and customized reports, cart fill, labels,

and work lists; participated in generation of script file to send reports

to Report Viewer, enabling end users to access them via Web.

GE Medical Systems Information Technologies

Milwaukee, Wisconsin ( 2002-2004

Software Engineer - Network Application Team

o Designed and developed network server-side software application products.

o Implemented automatic preclinical testing tools to evaluate performance

of clinical monitoring products and managed verification testing

procedures.

o Developed collection daemon program for measuring database information to

control and optimize performance of patient data server (PDS) using Shell

Scripting and PostgreSQL.

o Created numerous trended vital sign parameters including those for ECG,

SPO2, and anesthesia/ventilators using Java; stored these into PostgreSQL

database and file system.

o Used Shell Scripting and PostgreSQL to design and develop automatic

testing tools to measure utilization of CPU, memory, disk I/O for PDS

system, and database performance; evaluated performance and safety of all

investigational versions.

o Implemented PDS verification testing tools and defined testing processes.

o Monitored and regulated Unity Information Suite (Unity IS) HL7 outbound

parameters using C++.

Education and Certification

M.S., Computer Science, Marquette University, Milwaukee, Wisconsin ( 2001

B.S., Medicine, West China University of Medical Sciences, Szechwan, China

( 1993

Certified, Six Sigma Green Belt - Design for Six Sigma (DFSS), GE Company

Contact this candidate