Category «Index»

Evolving To Robotic Process Automation

After leaving R1 RCM in June 2020, I have been fortunate to work on a variety of data engineering/data architect projects. I have had a few small business clients and some larger corporate clients. These projects utilize my skills in data architecture, data engineering, and machine learning. I have morphed into what I think of …

An Exercise In Gathering Healthcare Intelligence From An All Payer/All Claims Data Set

I have written an article with Mike Ghen (https://www.linkedin.com/in/mikeghen) on data analysis of healthcare data.  We used IBM Watson Analytics, Microsoft Azure SQL Database, and some Linux editing tools to product a nice summary table of findings.  The article is found here.: An Exercise In Gathering HealthCare Intelligence Using Azure SQL Database, Linux Editing Commands, …

Data Warehouse 201

So, continuing on from the previous article, Data Warehouse 101, I would like to delve a little bit deeper.  First, I would like to backtrack on how I defined a data warehouse in the Data Warehouse 101 article.  I defined a data warehouse as follows.: a large set of databases where data from disparate systems …

Data Warehouse 101

What is a data warehouse? I like to answer this question by defining a warehouse first.  What is a warehouse? Here is the definition provided by Google: a large building where raw materials or manufactured goods may be stored before their export or distribution for sale So, where do these raw materials or manufactured goods …

Value-Based Care And Bundled Payments

As I am currently employed by PinpointCare (pinpointcare.com), I would like to explain why we are in business.  To do that, I must define the Bundled Payment.  The Center For Medicare And Medicaid Services  or CMS ( formerly called the Health Care Financing Administration) is working towards enabling a “Value-Based” care environment.   A Bundled Payment …

A Data Migration Project

I have been working on a data migration project for PinpointCare (pinpointcare.com) for about 10 months now.  I will try to describe it from as high of an altitude that I can. So, what is the purpose of this project? We currently have both version  1 and version 2 of our software in production.  Version …