Fall 2023 - Internship Project
At the time of this internship, CDPH's Immunization Branch did not have an up-to-date masterlist of active FQHC providers to reference nor a way to easily distinguish a true FQHC from a Look-a-Like (LAL) clinic.
For this project, I was tasked to determine which clinics/providers were true FQHCs,LALs, or an associated clinic and create a master spreadsheet to be used for future reference by CDPH staff.
Team: Riana Tadeo, Jennifer Wommack (Preceptor)
Project Duration: 13 weeks
Tools: Microsoft Excel, CAIR2 Mass Vaccination System, SAS Viya
Skills: project management, research, problem solving, data analysis, coding
Preliminary research was conducted on FQHCs and LAL clinics to understand the distinguishing qualities between the two.
Research and cross-referencing were carried out utilizing four distinct resources: the CAIR2 Mass Vaccination Registry, the HRSA FQHC database, the VFC Provider database, and an additional internal FQHC spreadsheet.
Once a clinic's status was confirmed as either an FQHC, LAL, or associated clinic, their information was recorded in an internal master Excel spreadsheet.
Utilized SAS Viya to analyze and sort the data collected on FQHCs and LALs.
Slide deck presentation summarizing data analysis findings.
Framer 2024
Riana Tadeo