SUMMARY:

Designed, implemented, tested and maintained numerous CCL reports during 12 years of Cerner systems experience. Possess strong knowledge of Cerner table schema including clinical events, orders, person, location, pharmacy, Revenue Cycle and more. Proven ability to manage multiple projects at one time.

TECHNICAL SKILLS:

Experience with: Cerner Millennium, Discern Rules, Discern Visual Developer and Layout Builder

Programming Languages: CCL (Discern Explorer), PL/SQL, SQL, C/VC++, MFC, Visual Basic

CCL Report Formats: Layoutbuilder, Postscript,CSV/Delimit,RTF(Genview/SmartTemplate)

WORK EXPERIENCE:

Confidential

Reports Developer / Analyst (consultant)

Responsibilities:

• Created a Revenue Cycle report to display patients with a zero balance benefit order not in a completed status.
• Created a Revenue Cycle report to display patients with a self - pay balance that is not in collections or on a work item.
• Created a Revenue Cycle report to identify all self-pay encounters with a credit on the account and also a primary, secondary, or tertiary health plan of Charity Care.
• Created a Revenue Cycle report to identify all encounters that were sent to a collections vendor and were returned with a fee still owed to the vendor.
• Created a Revenue Cycle report to display encounters that have an assistant surgeon charge attached.
• Created four Revenue Cycle reports to retrieve Medicare & Medicaid patients that were re-admitted to the clinic within a certain timeframe.
• Created a summary and detail report to show all charges and accompanying data for a specific encounter.

Confidential, Denver, CO

Reports Developer / Analyst (consultant)

Responsibilities:

• Completed 25 CCL report requests for Orders, Results, PathNet, PharmNet, SurgiNet, Revenue Cycle, and Scheduling
• Created two Core Measures Central Line and Urinary Catheter reports to pull order and infection control assessment results
• Two similar reports to calculate line days per nurse unit
• Created three Core Measures Restraint reports that evaluated order and documentation
• Created a Core Measures Fall Risk report that retrieved patients who have had a fall documented and all relevant orders and results before and after the fall
• Created an IPOC Utilization report that calculated statistics for Initiating and Canceling of plans.
• Created report to calculate the length of stay on a nurse unit for patients on ventilators. It also calculated the total length of time the patient was on the ventilator.
• Created a report to display HIM Hold Queue and the associated physician deficiencies. It also displayed patient remaining balances and demographic info.
• Created a report to display patients over the age of 50 that have DVT orders and blood thinner medications
• Created a report to display active patients who have not had a Pneumococcal vaccine.
• Created a Pharmnet report that displayed prescriptions for a given location and date range.
• Created a Surginet report to display surgical cases with the patient in/out times, and the anesthesia start/stop times.
• Created a report to calculate usage statistics for clinics using a Powernote form for PHQ9 Psychiatric Evaluation
• Created a Respiratory Therapy report to calculate the productivity of therapists by summing their RVU workload and the tasks they are charting.
• Created a Respiratory Therapy report to show the overdue tasks for a given therapist

Confidential, Seattle, WA

CCL Reports Developer / Analyst

Responsibilities:

• Created an HTML PowerNote Clinical Summary Template.
• Created four smart templates to be used in PowerNote documents.
• Created fifteen CCL User Defined Tokens that retrieved demographic data; pharmacy, radiology, & lab orders; and other charted data for the Clinical Summary Powernote.
• Completed over 50 change requests that included new reports, enhancements, performance-tuning, and defect fixes in the areas of Pharmnet, Orders, Pathnet, Surginet, Radnet, Firstnet, & Scheduling.
• Rewrote seven Dietary/Nutrition Services reports reducing the run and convert to ops jobs.
• Modified four Pharmacy Label scripts (Intermec) to fix defects and add enhancements.
• Modified five Radnet and Pathnet reports to fix defects and performance tune.
• Created two Pathnet reports for blood bank functionality.
• Created a new Surginet report to display PM Admits scheduled for surgery.
• Modified two Firstnet reports to add enhancements and fix defects.

Confidential, Asheville, NC

CCL Reports Developer / Analyst

Responsibilities:

• Created a report to analyze policy/ Confidential compliance by staff when completed Admit Medication Reconciliation.
• Created a report to analyze policy/ Confidential compliance of anticoagulation therapy protocol. It compared the ratio of anticoagulants ordered via Powerplan/Careplan (compliant) to the number of anticoagulant administrations.
• Created a report to analyze policy/ Confidential compliance of urinary catheter assessments completed every 12 hour shift by staff.
• Created a report to analyze policy/ Confidential compliance of checking the “Patient Understands…” checkbox when completing the Depart Medication Reconciliation Form.

Confidential, York, PA

CCL Reports Developer / Analyst

Responsibilities:

• Created or modified four Genview Reports.
• Created four Radiology/Cardiology reports to display order reference and activity data.
• Created a Surginet-Anesthesia report to show charting compliance data for surgical cases.
• Created two custom CCL User Defined Tokens for the Depart Process.
• Created or modified six other reports around orders and results.

Confidential, Huntington, WV

Reports Developer / Analyst (consultant)

Responsibilities:

• Created eight Meaningful Use CCL reports using HITSP specifications. Stroke STK-1 thru STK-6, STK-8, and STK-10.
• Created two Meaningful Use CCL reports using HITSP specifications. VTE-1, VTE-3.

Confidential, Denver, CO

Reports Developer / Analyst

Responsibilities:

• Created or enhanced 15 CCL reports around Orders, Clinical Results, Surginet, Scheduling, Firstnet, and Pharmacy.
• Created three new PathNet reports to display contaminated order sample statistics, phlebotomist draw statistics, and orders in a collected status.
• Fixed defects and added enhancements to eight other reports.

Confidential, Houston,TX

Reports Developer / Analyst

Responsibilities:

• Created five new complex reports to analyze policy/ Confidential compliance by staff.
• Created a new report to show tasks for restraints that are not charted or that are overdue.
• Fixed defects and added enhancements to twelve other reports.

Confidential, Plano, TX

Reports Developer / Analyst

Responsibilities:

• Created a custom SBAR Summary MPage consisting of thirteen sections with information including vascular access, safety data, patient info, blood products, various orders, vital signs, wounds/tubes/drains, respiratory info, lab data, and diagnostic test data.
• Created five new Orders reports to display patients receiving med, lab, dietary, and consult orders.
• Created five reports around census data, Charge Services, security, and PathNet.

Confidential, Washington, D.C.

CCL Reports Developer / Analyst (consultant)

Responsibilities:

• Created three new Medication Reconciliation reports and two Nursing Assignment Reports.
• Modified Cerner’s Drug Inquiry report to be a spreadsheet view and add new fields.
• Created a three new Pharmnet reports including a manual call to a print the patient .