CV
This is a description of the page. You can modify it in '_pages/cv.md'. You can also change or remove the top pdf download button.
Contact Information
| Name | Esther Liu |
| Professional Title | M.S. Student in Computer Science |
| gefei_liu@brown.edu | |
| Location | Providence, Rhode Island |
Professional Summary
Computer science graduate student with experience in data science, machine learning, databases, analytics, and research engineering across academia, government, and industry.
Experience
-
2024 - 2024 Toronto, Canada
Data Analyst
Capital One
- Led end-to-end data productionization using Snowflake and Git, including user feedback collection, data standardization, dataset validation, and final production-ready releases.
- Automated workflows in enterprise modeling platforms to extract and transform data from AWS and Snowflake while maintaining governance compliance.
- Supported process management and business analysts with tailored reports and data insights for operational decision-making.
-
2024 - 2024 Remote
Data Management Analyst
Environment and Climate Change Canada
- Built interactive assessment tools with HTML, CSS, and JavaScript to evaluate FAIRER principles for datasets and knowledge assets.
- Recovered and restructured the International Research Data Management glossary from web archives using Python, restoring access to 500+ terms.
- Extended machine-actionable data management plan modules in Go to improve interoperability and machine readability.
-
2024 - 2024 Waterloo, Canada
Research Assistant
University of Waterloo
Supervised by Professor Diogo Barradas.
- Designed and developed a visualization dashboard for ICLab, enabling non-technical users to explore global Internet censorship data by country and measurement type.
- Improved the UI, containerized the project with Docker for remote deployment, and optimized database access with materialized views, caching, and indexing.
-
2024 - 2024 Waterloo, Canada
Research Assistant
University of Waterloo
Supervised by Professor Grant Weddell.
- Extended the relational model into ARM schema by adding an abstract domain for entity identifiers and improving reference handling in a domain-specific language.
- Enhanced SQLP with referring expression support and optimized query mapping from ARM schemata to relational schemata.
- Documented ARM schema concepts and SQLP applications to support future development.
-
2023 - 2023 Remote
Data Analytics Consultant
BDO Canada
- Led QA testing of SmartMine and resolved more than 100 data inconsistencies.
- Optimized Power BI dashboards, improving load times by 15%.
- Supported Azure-based architecture deployment and integration of five new data sources.
-
2022 - 2022 Waterloo, Canada
Research Assistant
University of Waterloo
Supervised by Professor Grant Weddell.
- Extended the relational model into ARM schema by adding an abstract domain for entity identifiers and improving reference handling in a domain-specific language.
- Enhanced SQLP with referring expression support and optimized query mapping from ARM schemata to relational schemata.
- Documented ARM schema concepts and SQLP applications to support future development.
-
2022 - 2022 Remote
Data Migration Analyst
CN Railway
- Cleansed more than 1 million records during a SAP HANA migration and reduced duplication by 20%.
- Optimized SQL queries, improving data retrieval speeds by 30% and reducing project timelines.
-
2022 - 2022 Waterloo, Canada
Tutor for MATH237
University of Waterloo Mathematics Tutoring Centre
- Tutored students in vector calculus, partial derivatives, and multiple integrals to improve understanding and course performance.
Education
-
2025 - 2027 Providence, Rhode Island
Master of Science
Brown University
Computer Science
- Human-AI Interaction
- Research Topics in Self Supervised Learning
-
2020 - 2025 Waterloo, Canada
Bachelor of Computer Science
University of Waterloo
Data Science, Statistics
- Introduction to Database Management
- Data Structures and Data Management
- Computational Statistics and Data Analysis
- Forecasting
- Data-Intensive Distributed Computing
- Distributed System
- Generalized Linear Models and their Applications
- Introduction to Artificial Intelligence
- Major in Data Science, Minor in Statistics
Publications
-
Sci2Pol: Evaluating and Fine-tuning LLMs on Scientific-to-Policy Brief Generation
Introduces Sci2Pol-Bench and Sci2Pol-Corpus for evaluating and fine-tuning LLMs on scientific-to-policy brief generation, with fine-tuned Gemma-27B outperforming GPT-4o and DeepSeek-V3 in reported experiments.
-
Computational Analysis Uncovers Contrasts in G-Quadruplex Propensity and Aptamer Enrichment in SELEX-Derived Libraries
Analyzes SELEX libraries to test whether predicted G-quadruplex propensity explains aptamer enrichment and concludes that structural prediction should be combined with empirical performance.
Projects
-
A Dashboard for an Internet Censorship Observatory
Research dashboard for exploring censorship measurements from ICLab.
- Built a user-facing visualization dashboard for global censorship data.
- Improved deployment and performance with Docker, materialized views, caching, and indexing.
-
Time Series Forecasting
Forecasting project completed in STAT443.
- Used ARIMA, ETS, TBATS, and ARIMA-GARCH with MSE and prediction intervals.
- Achieved the strongest results with a custom ARIMA-GARCH model.
- Applied Kalman smoothing, ARIMAX, and VARMA for multivariate forecasting and imputation.
-
Noisy Label Learning for Medical Image Classification
Course project completed in CS486.
- Compared five noisy-label learning methods for medical image classification.
- Evaluated accuracy, robustness, scalability, and computational tradeoffs.
- Identified limitations under severe noise and outlined future research directions.
Awards
-
2024 Bradley Family Upper-Year Scholarship for Women in Mathematics
Awarded annually to a woman in Mathematics with research in data analytics, coding, computer science, or artificial intelligence.
-
2024 University of Waterloo President's Research Award
Awarded for A Dashboard for an Internet Censorship Observatory under Diogo Barradas.
-
2023 University of Waterloo President's Research Award
Awarded for Enhancing a Main-Memory DBMS under Grant Weddell.
-
2021 University of Waterloo President's Scholarship of Distinction
Awarded for an admission average of 95% or above.
Languages
Certificates
- GRE: Verbal 164, Quantitative 170, Writing 4.5 - ETS (2025)