- Managing the migration of data from Colorado’s core surveillance system, CEDRS, which has served the state for over 20 years, into our new system, EpiTrax. - Provide instructions to our vendor, EndPoint, on variable and value mappings between our historic SQL-based system to the new PostgreSQL-based database. Once our vendor incorporates our requirements, I perform validation checks with R scripts. I predominately utilized a complete and unaltered approach to migration, working with program stakeholders to determine when data transformations would be necessary to preserve key metrics.- Conceived and completed a proof of concept for an integration between the Office of Vital Statistics and our surveillance system to identify deceased persons with a reportable health condition.

- Detected issues with the flow of data between our surveillance system (CEDRS) and investigation system (Dr. Justina). - Coordinated with developers in the Office of Information Technology (OIT) to update and validate a SQL stored procedure, which utilized data from the COVID-19 Patient Hospitalization Surveillance Project (COPHS) to perform updates and insertions into our surveillance system. Likewise improved the R scripts that compiled the data for the SQL server, reducing query response time and increasing overall database performance.- Developed and implemented a R script to identify cases considered a priority population through patient address matching to known addresses of interest, and integrate results back into our surveillance system through a SQL stored procedure. Detection of a case’s residency in an institution increased from 3.4% of cases before implementation, to 36.9% of cases as of December 2022. This process helped improve CI/CT’s ability to reach cases and complete interviews by 9%, while refusal rates dropped by 10%. - Represented the subject matter expert on vaccine breakthrough analytics – projects included rewriting all R scripts that generate the Tableau website visuals to include bivalent vaccines and demonstrate the effectiveness of the Omicron booster, evaluated the impact of updating population estimates from the State Demographer’s Office on risk ratios and timeseries to present to leadership, conducted an analysis on reinfections resulting in hospitalization and death by vaccine status for authorship in an MMWR. Detailed READMEs were compiled for each project.- Wrote scripts in SAS for transmitting data – with over 580 unique variables – to the CDC for the Active Bacterial Core Surveillance System (ABCs) program and developed a data dictionary to describe relationships between our surveillance system and CDC elements.

- Wrote user-friendly, 'point and click', R scripts for the Epidemiology response to bulk search for cases in our electronic lab reporting (ELR) SQL server and surveillance database, CEDRS.- Independently created a process to routinely send out of state ELRs, additionally resulting in the distribution of over 13,400 positive test results of out of state residents to their respective states.- Taught an R workgroup to the Epidemiology response and troubleshoot any R difficulties for our staff.- Developed the ability to safely bulk update outbreak-specific fields in our investigation database to integrate with our surveillance system.- Created and shared reports on the completeness and alignment of outbreak data entry between CEDRS and REDCap.

· Conduct investigations on COVID-19 variant cases and submit surveillance documentation to the Texas Department of State Health Services.· Identify vaccine breakthroughs in Tarrant County and, if the specimens remain available, facilitate the submission of the original samples to the North Texas Regional Laboratory for sequencing.· Create briefs and presentations on the state of COVID-19 variants and vaccine breakthroughs in Tarrant County. · Use R to import new cases from national and state surveillance systems into our platform.

I oversaw the Intake Team within Tarrant County’s COVID-19 surveillance and contact tracing response. My team was responsible for the entry and data integrity of incoming COVID-19 cases, which had peaked to over 5,000 new records per week. Since I began in June 2020, my team grew from 10 to 45 individuals - with additions of 15-30 volunteers from other teams. Once cases precipitously decreased in the spring of 2021, I transitioned staff to other parts of the response in need of assistance and to take on new projects within the Epidemiology division.

· Dedicated 600 hours to the Employment Solutions department of the Women’s Center. · Conducted oversight of approximately 10 program volunteers. · Assessed needs, opportunities, and strengths of clients as a Resource Coach.

Assisted in the recruitment and interviewing of participants, transcription of qualitative data, and preparation of the manuscript for a NIH-funded study titled “Addressing Contraceptive Disparities among Women Experiencing Homelessness.”

· Title: Antidepressant and Antianxiety Treatment Utilization in Cancer Patients · Clean and analyze a nationally representative sample – National Health Interview Survey – of years 2010-2018 with SAS 9.4.

· Performed marketing and outreach for the Center on University of Central Oklahoma’s campus with a cumulation of 200 hours experience.· Taught sexual health – Anatomy & Physiology, STI & Contraception – to Healthy Life Skills classes as a representative of the Sexual Health Ambassadors program.· Coordinated free STI testing and free HPV vaccinations.

· Assisted the transcription of 25 key informant interviews and 20 focus group interviews that utilized motivational interviewing techniques. · Discovered secondary data to describe the scope of chronic diseases in Tarrant County. Spence-Almaguer, E., Rohr, D., Morgan, K., Deahl, C., Sanderson, B., Aiken, J., Hardin, E., & Miank, A. (2019). United Way of Tarrant County Community Assessment 2018-2019: Technical Report.

· Managed a large data set with over 1300 observations.· Developed qualitative coding scheme.· Coordinated data cleaning and coding.