Project Clinical Reports Consultant Crystal SQL Clinical

PROFESSIONAL SUMMARY

I am a healthcare professional with 17 years healthcare IT experience, and

more than 30 years full and part-time clinical practice. My special skills

include project planning, delivery, and implementation, live support, and

education to customers and colleague consultants in clinical software and

reporting. I have particular expertise in creating reports for physicians,

nurses, and clinical managers to help simplify their clinical practices, as

well as performing data queries for troubleshooting, data migration and

software implementations.

CAREER OBJECTIVES

I am seeking opportunities to participate in strong Soarian Clinicals

implementation teams and to apply my years of Soarian Clinicals experience

in enterprises committed to creating comprehensive forward-looking EHRs.

PROFESSIONAL EXPERIENCE

Soarian Clinicals Consultant, HSM Consulting LLC, Quincy, MA February 2013

- May 2015

I served clients nationwide to develop clinical reports, query SQL for data

extracts, and served as team lead consultant for the firm in Soarian

Clinicals and Financials. I was also engaged to support major software

upgrades and provide Live Event support. During one engagement I trained a

new inexperienced clinical reporting analyst in all techniques required for

work in MS SQL, SAP Crystal Reports, Soarian Clinicals and associated

Siemens applications.

Soarian Clinicals Consultant, H&A Consulting LLC, Atlanta, GA January 2012

- January 2013

I served clients implementing and upgrading Siemens Soarian Clinicals in

all of the areas cited below during my tenure with Siemens Healthcare, with

emphasis on clinical reporting, and on reports to analyze the state of live

Soarian systems, and systems undergoing implementation.

Systems Analyst IV, Managed Services Division, SIEMENS HEALTHCARE, Malvern

PA

April 2008 - December 2011

I served as a senior healthcare systems analyst in the Siemens Healthcare

Managed Services Division, implementing and supporting Soarian Clinicals.

My responsibilities were to:

Create operational and analytical reports in Soarian Clinicals using

Crystal Reports Writer, Microsoft SQL Server, custom stored

procedures, user-defined functions, and direct data queries to provide

clear and precise data, for hard-copy, as metadata or for storage in

an EHR.

. Manage OMS, Job Scheduler and Event Driven Routing (EDR) for Soarian

document routing and management

. Implement and manage Context Sensitive Printing (CSP) to provide

intuitive and efficient access for Soarian users to clinical reports

. Build complex screen and print forms using the Soarian Form

Adaptability Tool. These include columnar and page assessments for

nursing and ancillary services, order detail forms, and customizations

to patient record facesheets

. Perform Soarian Clinicals SIEV error root cause analysis and

resolution, to assure timely and accurate demographic and clinical

data for Soarian users, and high data integrity in the EHR

. Deliver formal classroom training in Soarian Clinical Reporting

. Extract flat files from legacy systems, using Monarch and other

software tools to extract data for Soarian Upload Spreadsheets.

. Create SQL queries and run SQL profiler to troubleshoot security

concerns, report failures, etc.

. Consult with nursing, ancillary healthcare and HIMS professionals to

create dynamic data collection systems to replace paper forms and

processes, including electronic document storage where possible, and

automating the generation of hard copy documentation where required

. Assist customers to define and manage automated routing of forms and

reports to complement their clinical workflows and processes

. Guide and educate customers in weighing criteria for the use of Forms

versus Crystal Reports for the display and storage of data in the

patient EHR, or for hard copy medical records.

Principal Consultant, Professional Services, SMS / SIEMENS HEALTHCARE,

Malvern PA

September 1998 - April 2008

Implementation Consultant in the National Implementations Group assigned to

install and support Enterprise Access Directory, the Siemens mainframe

EMPI, and beginning in 2003, Soarian Clinicals. Responsibilities included:

. Conduct and participate in project implementation kick-offs at project

initiation, to educate customers and establish a collaborative working

relationship

. Conduct implementation planning sessions to review roles, scope of

work, the project workplan, project software tools and documents to be

used in the project

. Analyze and resolve errors on inbound interfaces (RTIF) from sending

systems to EAD, during implementation, system tuning, post-Live

support, and during error investigations

. Formal education delivery of the EAD class for the Education Services

division of Siemens, at Siemens Corporate Headquarters and customer

sites across the country

. Implementation of HL7 and Non-HL7 interfaces to integrate Siemens and

third party software systems with EAD. These included store and

forward, and query and response interfaces

Respiratory Therapist, Supervisor, Various Facilities

August 1970 - April 2008

For more than thirty years, I practiced full and part time as a Respiratory

Therapist. Both in staff and supervisory roles, I worked in every division

of acute care for adults and pediatrics, skilled nursing and long term

ventilator care facilities, including:

. Community based acute care facilities including Paoli Hospital and

The Bryn Mawr Hospital in Pennsylvania, and St. Luke's Hospital in

Missouri

. Urban and University affiliated acute care facilities, including

Thomas Jefferson University Hospital and Lankenau Hospital, in

Pennsylvania, and St. Louis Children's Hospital in Missouri

. Rehabilitation facilities including Bryn Mawr Rehabilitation

Hospital, and several Main Line Healthcare and Genesis skilled care

and ventilator facilities in Pennsylvania

EDUCATION

. Bachelor of Science degree in Microbiology from the University of

Oklahoma in 1974

PROFESIONAL CERTIFICATION AND LICENSURE

. Certified Inhalation Therapy Technician - 1972

. Registered Respiratory Therapist - 1994

. Certified Respiratory Care Practitioner - Commonwealth of

Pennsylvania - Active

. Associate Real Estate Broker - Commonwealth of Pennsylvania -

Active

Contact this candidate