Support clients through software implementation including application training. Review client workflows, current state assessment and gap analysis. Educate clients on regulatory requirements and electronic clinical quality measure (eCQM) specifications and submit data to regulatory agencies. Validate and troubleshoot measure results, perform data analysis using SQL/ Databricks. Participate in User Acceptance Testing.

Medisolv, Inc. | Oct 2021 - Sep 2022

Sr Health Data Integration Specialist

ETL of Healthcare Data (Meditech/Epic/Cerner/Ecw/Allscripts Pro) using SQL, Azure Data Lake, Databricks, Spark SQL and Python Troubleshooting issues with data and extraction processes and eCQM measure performance.

Acmeware | Jan 2020 - Oct 2021

Senior Application Developer

N/A

Acmeware | Jul 2017 - Jan 2020

Application Developer

Involved in all aspects of the product development life-cycle of web-based business intelligence/decision support software for the healthcare industry. SQL development, data warehousing, ETL, and database management using Microsoft SQL Server, Visual Studio and Team Foundation Server. Certified ScrumMaster®.

Acmeware | Jan 2017 - Jun 2017

Consultant Analyst

Collaborated with healthcare clients to develop custom reporting solutions using T-SQL and SQL Server Reporting Services. Performed basic SQL server database administration tasks as necessary to support products and services. Supported custom software solutions for healthcare regulatory reporting from the Meditech EHR.

Self Employed SQL Consultant | Oct 2016 - Jan 2017

SQL Server Consultant

Provided SQL development and database management for clients in the healthcare industry.

Medisolv, Inc. | May 2011 - Oct 2016

Business Intelligence Analyst

T-SQL development in Microsoft SQL Server. Created custom clinical and financial reporting solutions using SQL Server Reporting Services (SSRS). Troubleshooting data and software issues, collaborating with clients to find solutions.

Stardust Web Design | Jun 2005 - Dec 2015

Owner

Self-employed offering web design and internet marketing services to small businesses. Offered web hosting and web site maintenance on Linux and Windows platforms.

Ephrata Community Hospital | Nov 2007 - May 2011

DBA/Financial Systems Analyst

Led the implementation of Meditech Data Repository (DR), a Microsoft SQL Server database. Audited Data Repository via the Blue Elm DR Auditor. Management of SQL 2005 servers including security, software installation and upgrades, backups and query tuning. Responsible for support of Meditech Financial modules, including monthly server maintenance. Used T-SQL Programming, Microsoft Reporting Services, and SQL Server Integration Services (SSRS and SSIS) to deploy clinical and financial reports. NPR Report Development within the Meditech system. Provided assistance and training in T-SQL and Reporting Services to other DR users.

Ephrata Community Hospital | Nov 2007 - Oct 2008

Medical Records Clerk

Filed, distributed and release records in accordance with hospital policies and HIPAA regulations. Trained on health information systems such as SoftMed, Unity, Meditech and document imaging software.

D&E Communications | May 2004 - Jun 2006

Revenue Assurance Analyst

Prepared revenue-related metrics including analysis of network usage and billing events for carrier network access, telephone subscribers, special circuits, IP and video services and detection of phantom traffic and fraud. Analyzed and interpreted reported data, identifying trends and anomalies using Excel, Access and Crystal Reports.

D&E Communications | Jul 2004 - Oct 2005

Accountant

Developed, tested, and reported on the internal controls of the company for Sarbanes Oxley requirements. Prepared the Gross Receipts Tax, Sales and Use, Excise, and Tire Tax payments and returns. Processed elimination journal entries monthly and reconciled assigned accounts.

XO Communications | Mar 2002 - Jul 2004

Billing Supervisor

Supervised a group of Billing analysts responsible for auditing billing cycles, resolving customer billing complaints, and reporting cycle statistics. Participated nationally in special projects such as the development of new audits for Sarbanes Oxley compliance and the integration of new systems.

XO Communications | Jan 2001 - Mar 2002

Senior Revenue Research Analyst

Responsible for ad hoc reporting of billing data to support CEO/CFO, Finance, Marketing, Regulatory and Sales using BrioQuery, as well as developing reports and templates using Access and Excel. Responsible for auditing and committing billing cycles, including trending and reporting of financial statistics.

My Education

Take a look at my formal education

MBA, Business AdministrationKutztown University College of Business | 2005

B.S., Business Administration, minor in AccountingMansfield University of Pennsylvania | 1996

About Me

Erika hasn't filled in a bio text

Create Your Data Portfolio for Free

Erika Bricker

Senior Manager eMeasures (software implementation)

Medisolv

Quantitative navigator, guiding decision-makers through the sea of data.

My Work

Introduction to Databases in Python

Python Fundamentals

Introduction to Data Visualization with Bokeh

Data Manipulation

Python Toolbox

Introduction to Functions in Python

Intermediate Importing Data in Python

Introduction to Importing Data in Python

Practicing Coding Interview Questions in Python

pandas Foundations

Manipulating DataFrames with pandas

Merging DataFrames with pandas

Introduction to Data Visualization in Python

Introduction to Data Engineering

Cleaning Data in Python

Database Design

Data Manipulation with pandas

Understanding Data Engineering

Introduction to SQL

Intermediate SQL

Understanding ChatGPT

Introduction to Snowflake SQL

Analyzing Police Activity with pandas

Introduction to Python

Intermediate Python