Zihan(Teddy) Guo

· Organized and managed electronic medical records for over 73,000 individuals, ensuring accurate and accessible information for healthcare providers

· Conducted data cleaning, classification, and structured sorting to enhance data quality for epidemiologic research initiatives

· Conducted comparative analysis of 115 CAH patients and 2,300 matched referents using longitudinal medical record data spanning multiple years

·Managed 25 to 30 analysis variables, including cardiometabolic indicators, demographics, and derived variables

· Managed 25 to 30 analysis variables, including cardiometabolic indicators, demographics, and derived variables

· Presented research findings to faculty mentor and scheduled presentation at university capstone research symposium to disseminate results

· Prepared manuscript for submission to contribute to academic literature on clinical outcomes

· Analyzed longitudinal data from 69 participants with 6-month follow-up (about 414 repeated observations) to evaluate associations between missed daily PrEP doses and sexual behaviors

· Managed 20-30 analytic variables and conducted regression modeling using R

· Presented analytic updates and findings to principal investigator and research team

· Led manuscript development describing statistical findings; manuscript submitted for publication

Collaborated with clinical and laboratory teams to enhance translational HIV prevention research.

Performed p24 ELISA assays and multiplex cytokine panels to evaluate inflammatory responses.

Processed human primary cells and tissues to support longitudinal ex vivo HIV-1 challenge experiments.

· Performed 1,000+ RNA extractions and 100+ RT/qPCR assays to generate reliable data for ongoing research projects

· Conducted HIV latency reactivation experiments across multiple cell models to investigate potential therapeutic strategies

· Contributed experimental data that supported successful conference abstract submission, enhancing visibility of research findings