Hannah Kaufman Email & Phone Number

Phoenix, Az, Us

- Extracted semi-structured medical data from patient Electronic Health Record (EHR) snapshots obtained from Health Information Exchange (HIE), Contexture. Data was sourced from behavioral health facilities Jewish Family and Children’s Services and Copa Health.- Led survey design, physician interview follow-ups, and data analysis in Qualtrics, Excel, custom VBA (Visual Basic for Applications) scripts, and integration with Python scripts for data quality control and remediation.- Conducted qualitative research and thematic analysis on semi-structured clinical interview transcripts using MAXQDA.- Presented research findings to the Substance use HeAlth REcord Sharing (SHARES) grant advisory board.

- Created SAS code to organize 700 million+ rows of Medicaid claims data, reducing runtime performance by over 50%.- Implemented SAS macros for data ingress, streamlining the pipeline for incoming data from the AHCCCS (Arizona Health Care Cost Containment System) into SAS Enterprise database.- Identified ineligible claims within the Medicaid database using SAS macros and hash tables, conducting analysis to determine potential causes.- Corrected data migration issues between SAS and Microsoft SQL Server through the utilization of native SQL and built-in functions.- Provided documentation for coding projects to ensure clarity and ease of use by other staff.

- Collaborated with other assistants on grading, prepping media, autoclaving, & answering questions.- Taught students how to conduct genetic engineering techniques such as restriction digestion, agarose gel electrophoresis, PCR colony screen, western blot, etc.

Tempe, Arizona, United States

- Created a questionnaire for the Arizona Community Action Agency, (CAA), to survey Arizona's homeless population.- Survey on health behaviors, healthcare access/utilization, cancer screening, and COVID-19 vaccine. - Organized data collection in meaningful ways for analysis with the use of Excel.

Master Of Science - Ms, Biomedical Informatics, 4.0

Bachelor Of Science - Bs, Biomedical Informatics, 3.82

High School Diploma