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

SQL database development in the healthcare industry. Leading our transition to Agile practices and serving as ScrumMaster to our team of developers.

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

N/A

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

N/A

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

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 Healthcare Data Integration Specialist

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 Data Science Toolbox (Part 2)

Python Data Science Toolbox (Part 1)

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

Introduction to ChatGPT

Introduction to Snowflake

Analyzing Police Activity with pandas

Introduction to Python

Intermediate Python