Resume

Sign in

Epic Clarity Report Writer, Project Manager Data

Location:
Ottawa, Illinois, 61350, United States
Posted:
February 08, 2018

Contact this candidate

Resume:

Marilyn Fabricius

Senior Epic Clarity Report Writer Analyst, Ottawa, IL

EXPERIENCE DEPTH

CERTIFICATIONS

EXPERTISE

• 13 years as Epic Clarity Report Lead

• 30 years of experience in Healthcare IT

• 16+ years working as a Consultant.

• 15+ years of Developing Clarity Reports

• 5+ years of developing conversion

Interfaces

• Epic Clarity Data Model

v. 2012 NVT 2015, 2017

• Epic Ambulatory Data

Model v. 2015 NVT 2017

• Proficient in HIM, RWB,

Caboodle, Willow.

• Extensive knowledge and hand on

experience building Clarity

reports for Epic clinical,

ambulatory and financial

applications,

• Extensive experience with

Microsoft Business

Intelligence technologies like

SQL Server Integration Services

(SSIS), SQL

Server Reporting Services (SSRS)

• Test and modify the report per

system requirement and user

request.

• Design and initially test Patient

Access and HIM, Willow,

Ambulatory, Beaker, Rev Cycle

clarity reports, including RWB

and Clarity Crystal Reports 2008

and all versions up to Crystal 13.

• Building views and extracts from

Clarity to optimize report process

• Data Integrity/QA testing and

validation.

• Experienced in writing

reports and creating new db using

SSRS 2005/2008.

PROFESSIONAL HISTORY

Wellmont Health Systems, Kingsport TN April 2015 – December 2017 Sr. Consultant - EPIC Clarity Senior Report Writer Served as a Clarity Mentor for an Implementation and Upgrade project.

• Helped create, modify and customize reports using RWB and Crystal version 8, 11,13 for Physicians Network using BI and ETL tools (Business Objects Data Integrator).

• Extensive experience writing hundreds of Clarity Reports for the Willow module

• Created and maintained all reports for the 340B project

• Created and maintained interfaces and reports for the Immunization registry and reports

• Was Project Manager for the ICD9-ICD10 upgrade

• Extensive experience writing hundreds of Clarity Reports for the Ambulatory module

• Instructed staff on Crystal Reports, SQL, and BO that may arise Including but not limited to CTEs, Unions, Stored Procedures, Lag/lead, Stuff.

• Trouble-shoot any problems with existing reports across all languages

• Instructed new staff with RWB and Clarity training.

• Interacted and communicated with colleagues as needed as both a technical and functional expert.

• Instructed staff with Clarity and SQL reporting across all platforms.

• Extensive experience writing Clarity Reports for the HB and PB module

• Extensive experience writing Clarity Reports for the ASAP and HIM module

• Designed and created/altered logical and physical database for reporting tool, generating various end user reports

• Load Clarity data into Data Warehouse.

• Created, altered and deleted databases as needed

• Build and maintain SQL 2008 scripts, indexes, and complex queries for data analysis and extraction.

• Wrote Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008

MD Anderson: Houston, TX March 2014 – March 2015

Consultant - Report Writer

Served as a BO/BI report writer for full cycle Implementation

• Created and modified new applications within MaxMc.

• Instructed staff with any questions concerning Crystal Reports, SQL, and BO that may arise. Including but not limited to; CTEs, Unions, Stored Procedures, Lag/lead, Stuff.

• Helped create, modify and customize reports using Crystal version 8, 11,13 for Physicians Network using BI and ETL tools (Business Objects Data Integrator).

• Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services

(SSIS)

• Designed and created/altered logical and physical database for reporting tool, generating various end user reports

• Created relational indices on tables and views

• Build and maintain SQL 2008 scripts, indexes, and complex queries for data analysis and extraction.

• Trouble shoot any problems with existing reports in any language

• Instructed new staff with RWB and Clarity training.

• Extensive experience writing hundreds of Clarity Reports for the Willow module

• Created and maintained all the executive metrics including Oncology Quality Assessment Metrics

• Extensive experience writing hundreds of Clarity Reports for the Ambulatory module

• Instructed staff with Clarity reporting across all platforms. Medcentrix: Harvey, IL April 2013 – March 2014

Consultant - EMR Analyst

EMR Analyst for a Full Life Cycle Implementation

• Responsible for the support and training of Centricity's EMR system in a specialty medical center.

• Implemented Centricity EMR. Supported the go-live process by being on-call to fix any discovered errors and assist technical and clinical staff with any questions concerning system operation that may arise.

• Helped create, modify and customize reports using Crystal version 11 for both billing and ambulatory using BI and ETL tools (BusinessObjects Data Integrator).

• Wrote Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005

• Helped create, modify and customize forms using VFE and EFE.

• Responsible for implementation of ePrescribing, Pharmacy reporting and electronic faxing and ICD10 readiness.

• Interacted and communicated with colleagues as needed as both a technical and functional expert. Hayes Management Consulting: Newton Center, MA November 2007 – March 2013 Senior Healthcare Consultant, Ambulatory Services

• Coordinated staff training, implementation plans/policies, and reports for go-lives and optimizations, ICD10 readiness.

• Managed projects for time and budgetary requirements.

• Provided support by building, implementing, supporting, and training various users on multiple healthcare IT systems

• Developed extensive material for classroom, onsite, and online training ensuring effective training for a variety of users, processes and systems.

• Ran support for system upgrades and a migration from GE Centricity to Epic resulting in successful transitions.

• Developed EMR, PM, tech support, nursing, EMT, patient registration workflows and processes to improve patient care and utilize best practices.

• Conducted on-site training, web-based training, and organized/host user conferences.

• Interacted and communicated with colleagues as needed as both a technical and functional expert. UMMC: Baltimore, MD August 2012 – February 2013

Clarity Report Writer

• Customize reports for hospital billing in Epic using Crystal version 11 and SQL.

• Modify and create reports using Workbench and Radar.

• SAP Business Objects.

Hendricks: Abilene, TX September 2012 – January 2013 Project Manager

• Helped with optimization of GE EMR after Nextgen to GE conversion.

• SAP Business Objects and ETL tools (BusinessObjects Data Integrator).

• Helped create and customize Clarity reports using Crystal version 11 for HR and Billing. CSA: Las Vegas, NV March 2012 – December 2012

EMR Analyst

• Responsible for the support and training of Centricity's EMR system in a specialty medical center.

• Implemented of Centricity EMR. Supported the go-live process by being on-call to fix any discovered errors and assist technical and clinical staff with any questions concerning system operation that may arise.

• Develop/Customize Crystal reports for Oncology Department.

• Responsible for implementation of ePrescribing, Pharmacy reporting and electronic faxing and ICD10 readiness.

• Customize reports for billing using Crystal ver 11 using BI tools.

• Wrote Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005

Iowa Health Systems: Des Moines, IA July 2012 – August 2012 EPIC Clarity/Report Analyst

• Mentored the Epic CBO Training team to ensure proper setup and utilization of MY Reports and Dashboard features. Ran reports as needed from EpicCare to verify CBO data.

• Modify and create reports using Workbench and Radar and Crystal ver 11. North Shore Long Island Jewish Hospital: Long Island, NY February 2012 – June 2012 Business Report Analyst

• Provided Crystal 11 report writing assistance to help create customized reports.

• Soarian SQL report assistance.

UC Health: Cincinnati, OH June 2011 – July 2012

Crystal Report Writer

• Provided Crystal 11 report writing assistance to help create customized reports. Texas Children’s Hospital /Baylor College of Medicine: Houston, TX March 2011 – May 2011 Clinical Data Migration Analyst,

• Assisted in the build and unit testing of the ambulatory interface between GE and EpicCare.

• Created the Scheduling, Registration, Notes, Medications, Appointments, Orders and Lab HL7 transactions for the GE to EpicCare conversion.

• Modify and create reports using Workbench and Radar and SQL. EMMC: Bangor, ME July 2010 – December 2010

Technical Analyst/EMR Trainer

• Responsible for the support and training of Centricity's EMR system in a multi-specialty medical center. Cedars Sinai Hospital April 2009 – April 2010

Conversion Analyst

• Worked closely with the EpicCare team to verify correct mapping from GE to EpicCare. Ran reports as needed from both GE and EpicCare to verify data mapping.

• Assisted in the build and unit testing of the ambulatory interface between GE and EpicCare.

• Created the Scheduling, Registration, Notes, Medications, Appointments, Orders and Lab HL7 transactions for the GE to EpicCare conversion.

• Developed test scripts and test results documentation for Centricity interfaces.

• Provided Clarity and RWB assistance

• Provided Crystal report writing assistance to help create customized reports. UC Health: Cincinnati, OH September 2008 – November 2008 EMR Trainer

• Responsible for the support and training of Centricity's EMR system in a multi-specialty medical center. Baylor College of Medicine: Houston, TX November 2007 – May 2009 Application Analyst

• Managed and coordinated activities among the staff which provided 24/7 support for the Centricity EMR at a large academic organization, including trouble shooting, database and DTS server maintenance and LinkLogic.

• Created and maintained Clarity Reports for the Baylor Epic Ambulatory implementation. Assisted Baylor staff in learning to create new reports and find model reports to meet the needs of providers.

• Responsible for the support and training of Centricity's EMR system in a multi-specialty medical center.

• Provided Crystal and SQL report writing assistance to help create customized reports.

• Implemented Rosetta Stone interface and managed the technical team to create the HL7 transactions to successfully convert patient information into Centricity EMR and EpicCare. Southern Illinois University School of Medicine: Springfield, IL February 2004 – October 2007 Application Analyst

• Worked with EMR Core Implementation team to determine all key implementation decisions such as: user requirements, security, workflows, procedures, training, and schedules. Set-up all EMR user configurations including, users, roles, groups, specialties, privileges, preferences and securities.

• Managed and coordinated activities among the staff which provided 24/7 support for the Centricity EMR at a large academic organization, including database and DTS server maintenance and LinkLogic

• Responsible for the support and training of Centricity's EMR system in a multi-specialty medical center

• Implemented Rosetta Stone interface and managed the technical team to create the HL7 transactions to successfully convert patient information into Centricity EMR and EpicCare.

• Experienced in the implementation of Centricity EMR. Supported the go-live process by being on-call to fix any discovered errors and assist technical and clinical staff with any questions concerning system operation that may arise.

• Developed test scripts and test results documentation for Centricity interfaces.

• Provided Crystal report writing assistance to help create customized reports. State of Illinois: Springfield, IL February 1999 – February 2004 Programmer Analyst

• Performed needs analysis and developed new MS Access programs/subsystems to track results.

• Participated in design review meetings to help create standards.

• Helped modify and create Pharmacy reports for the State Pharmacy Program.

• Developed design specifications to document new or changed program logic. New World Consulting: Springfield, IL January 1996 – February 2001 Owner

• Provided IT services to various State of IL agencies

• Provided Consultants to State Agencies in response to outstanding RFPs. FORMAL EDUCATION & TRAINING

USAF, University of Illinois,

BA, Computer Science, Minor Math



Contact this candidate