I spent my time at KPMG learning the whole way through. I immersed myself in the world of Government Pharmaceuticals which revealed the interesting way we receive the drugs that we use to treat our ailments. Specifically, the Government Rebate program for Medicaid and Medicare programs. So, before I tell you about what I did, let me tell you about this program.
When the poor or elderly need drug, the U.S. Government programs that cover healthcare costs normally covered by private insurance. For the manufacturer to gain access to the population that uses Government healthcare, they are required to participate in a drug rebate program. Medicaid.gov explains it here:
The Medicaid Drug Rebate Program (MDRP) is a program that includes Centers for Medicare & Medicaid Services (CMS), state Medicaid agencies, and participating drug manufacturers that helps to offset the Federal and state costs of most outpatient prescription drugs dispensed to Medicaid patients.
One of the responsibilities of the manufacturer is to calculate a Unit Rebate Amount (URA) for each drug that participates in the program. The local States are owed the rebate amount back for that drug.
So what did I do?
I supported the Medicaid Claims processing. All of those states with up to 30 programs each, submit an invoice that contains hundreds of drugs claimed in quarters reaching back t0 15 years ago. This is no small data processing challenge. An early assumption I made was that they implemented a system that would allow for a paperless process - this the last time I made that assumption.
I spent a month trying to identify ways to improve the existing process for the team responsible for ensuring the accounting and allocations line up for the clients we serviced. Afterwards, came my Python automations. With a rise in remote work due to COVID-19, most paper invoices were digitized. We used OCR and PDF tools in tandem with my quick Python scripting, and I developed 3 key algorithms that helped me do my job.
In short, I learned a ton about the world that is Government Healthcare Programs. Specifically how people get care, and how the Pharma business makes money. In the end, this experience has helped me identify the value I bring:
I'm a little lazy, so I'll automate it just to avoid doing it