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
Email 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

English : Bilingual proficiency
Mandarin : Primary proficiency
Spanish : IB Spanish Standard Level 6
Korean : Diploma in Korean Language I, University of Waterloo

Certificates

  • GRE: Verbal 164, Quantitative 170, Writing 4.5 - ETS (2025)