Marilyn Fabricius

SUMMARY

** ***** ** **** ******* Report Lead

** ***** ** ********** ** Healthcare IT

20+ years working as a Consultant.

20+ years of Developing Clarity Reports

5+ years of developing conversion Interfaces

Extensive knowledge and hands on experience with BO and BO server

Extensive knowledge and hands 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, Tapestry, Ambulatory, Beaker, Inpatient clarity reports, including RWB and Clarity Crystal Reports 2008 and all versions up to Crystal 13.

Webi

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.

TECHNICAL SKILLS

Epic Clarity Data Model v. 2012 NVT 2015, 2017

Epic Ambulatory Data Model v. 2015 NVT 2017

Proficient in HIM, RWB, Caboodle, Inpatient, Optime, Willow, Beaker, Surgery, Quality, Webi, Cogito

PROFESSIONAL EXPERIENCE

Stanford Health System March 2023 – present

Sr. Consultant -

Remediate and function test Webi reports for addition of the use of the SA, service area field

Modified Ambulatory, Beaker, Inpatient, Surgery, Anesthesia and Quality reports

Ran Scrum calls daily

Participate in update calls for C suite

UVA Health System April 2022 – March 2023

Sr. Consultant - EPIC Clarity Senior Report Writer

Remediate reports for addition of 4 new hospitals

Helped create, modify and customize reports using RWB and SSRS for all Providers

Create functional specs for report creation

Create Views for Dashboards

Created NICU Reports

Modified and created Ambulatory, Beaker, Inpatient and Quality reports

Modified and created Health Maintenance reports

Create data extracts for 4 hospitals merging into 1 using SQL/SSIS

Modified existing reports to allow selection of new hospitals

Ardent Health Nov 2021 – April 22

Sr. Consultant - EPIC Clarity

Create data extracts across all modules for integration of non Epic hospitals into Epic

Upload extracts and data to Google cloud

Santa Clara Valley Health System April 2019 – Nov 21

Sr. Consultant - EPIC Clarity Senior Report Writer

Remediate reports for addition of 3 new hospitals

Helped create, modify and customize reports using RWB and Crystal version 8, 11,13 for all Providers

Trouble-shoot any problems with existing reports across all languages

Create functional specs for report creation

Create Views for Dashboards

Create Webi reports

Created Covid Reports

Modified and created Ambulatory, Beaker and Quality reports

Modified and created Health Maintenance reports

Create data extracts for 4 hospitals merging into 1 using SQL/SSIS

Data extracts for Ambulatory, Beaker, Pharmacy and Willow

Assisted in quality checking of data extracts

Created Source tracking documents of data extracts

Lehigh Valley August 2018 – August 2019

Sr. Consultant - EPIC Clarity Senior Report Writer

Data Integrity/QA testing and validation.

MIPS report creation for 2018 Specs

Help implement Org Filtering for Community Connect

Helped create, modify and customize reports using RWB and Crystal version 8, 11,13 for all Providers

Tasked with creating and modifying Clarity Reports for the Ambulatory and Beaker modules

Trouble-shoot any problems with existing reports across all languages

Created 2018 MIPS Quality Reports

Assisted in the remediation of 100 + reports

Hackensack Meridian Health Feb. 2018 – July 2018

Sr. Consultant - EPIC Clarity Senior Report Writer

Epic Clarity Data Model v. 2012 NVT 2015, 2017

Epic Ambulatory Data Model v. 2015 NVT 2017

Reported in HIM, RWB, Caboodle, Willow, Beaker.

Extensive knowledge and hand on experience building Clarity reports for Epic Beaker, ambulatory and financial applications,

Extensive experience with Oracle SQL

Test and modify the report per system requirement and user request.

Data Integrity/QA testing and validation.

Helped create, modify and customize reports using RWB and Crystal version 8, 11,13 for Physicians Network

Extensive experience writing hundreds of Clarity Reports for the Inpatient and Tapestry modules

Created and maintained interfaces and reports for the Immunization registry and Healthy Planet reports

Trouble-shoot any problems with existing reports across all languages

Extensive experience writing Clarity Reports for MU, MIPS and HEDIS

Wellmont Health Systems, Kingsport, TN April 2015 – Dec. 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 and Tapestry modules

Created and maintained all reports for the 340B project

Created and modified reports for Home Health/Hospice

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.

Wrote reports for MU, MIPS and HEDIS per CMS guidelines

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

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 reports for Home Health/Hospice

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)

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 MIPS Quality Reports

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

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 Nov. 2007 - March 2013

Senior Healthcare Consultant

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 – Feb. 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 Sept. 2012 – Jan. 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 – Dec. 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 Feb. 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 – Dec. 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 Sept. 2008 – Nov. 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 Nov. 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 Feb. 2004 – Oct. 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 Feb. 1999 – Feb. 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 Jan. 1996 – Feb. 2001

Owner

Provided IT services to various State of IL agencies

Provided Consultants to State Agencies in response to outstanding RFPs.

EDUCATION

University of Illinois

USAF - BA in Computer Science

Contact this candidate