Ethel Xu
Irvine,CA
Summary
Junior at UCI studying Biology with a minor in Statistics. I’m interested in research data workflows and have experience with data cleaning, standardization, and dataset merging from internship (Excel, SAS, basic GraphPad Prism). I’m building my R skills through coursework and am excited to contribute to data preparation, QC, and documentation.
Overview
1
1
year of professional experience
Work History
Research Assistant
The First Affiliated Hospital of Hunan University of Chinese Medicine
Changsha, China
07.2025 - 08.2025
- Streamlined organization and cleaning of experimental datasets, including physiology recordings and measurement tables.
- Verified animal IDs and group labels by cross-checking raw records. Assisted in correcting mismatches, missing entries, and inconsistent units or coding.
- Designed and produced polished, presentation-ready figures, including bar charts with error bars and significance markers, utilizing GraphPad Prism.
Intern
Beijing Key Tech Statistical Consulting Co., Itd. Xian Branch
Xi'an,China
07.2024 - 08.2024
- Executed internal SAS training and utilized SAS for structured clinical-style sample datasets, emphasizing data preparation and reproducible processing.
- Used DATA step programming to clean raw tables, standardize variable formats, and implement rule-based transformations.
- Utilized PROC SQL to streamline sorting and merging workflows for dataset integration.
- Engineered reusable macro-driven routines to analyze approximately 63 datasets, identifying candidate date variables with inconsistent naming and formats.
- Engineered derived features, including maximum date duration indicators, while implementing robust handling of missing and incomplete records.
Education
Bachelor of Science - Biology And Statistics
University of California Irvine
06-2027
Skills
- R (basic; learned through statistics coursework)
- Data cleaning / data management (basic)
- GraphPad Prism (basic figure making)
- SAS (basic DATA step)
- Attention to detail
- Time management
- Teamwork and collaboration
- Problem-solving
Timeline
Research Assistant
The First Affiliated Hospital of Hunan University of Chinese Medicine
07.2025 - 08.2025
Intern
Beijing Key Tech Statistical Consulting Co., Itd. Xian Branch
07.2024 - 08.2024
Bachelor of Science - Biology And Statistics
University of California Irvine