ABOUT ME

I'm Yifan Guan.

Publications

  • 2020
    1. Identifying Insufficient Data Coverage in Databases with Multiple Relations
      Yin Lin, Yifan Guan, Abolfazl Asudeh, H. V. Jagadish
      VLDB 2020
      pdf
  • 2019
    1. MithraRanking: A System for Responsible Ranking Design
      Yifan Guan, Abolfazl Asudeh, Pranav Mayuram, H. V. Jagadish, Julia Stoyanovich, Gerome Miklau, Gautam Das
      SIGMOD 2019
      pdf
Big thanks to supervision from Prof. Jagadish and Prof. Asudeh.
I had a great collaboration experience with Yin Lin.

Work Experience

YugabyteDB logo
YugabyteDB, Sunnyvale, CA
Software Engineer Intern -- April 2021 - Current
zillow logo
Zillow, Seattle, WA
Software Development Engineer Intern -- May 2018 - July 2018
Major tasks:
- Refactored neighborhood module on Zillow home detail pages using React, added asynchronous loading to improve user experience, and wrote test cases using Jest and enzyme
Work sample:
sample
- Migrated region data from Zillow Pogo database to GraphQL
- Fixed bugs including URL generation and page redirections

Education

umich logo

I had countless great and unforgettable memories at Umich.
At Umich, my primary research interests were Data Management, Data Science, and Database systems.
I worked on problems related to fairness and data management.
I was fortunate enough to work as a research assistant in University of Michigan Database Research Group directed by Prof. Jagadish.
If you are a student at Unviersity of Michigan and you want to do research in Database or Data Science area, Jag is definitely a good person to work with. He is willing to give opportunities to his students and help them become an independent researcher. He is one of the person I admire.

University of Michigan Sep 2019 - Dec 2020
M.S.E in Computer Science   GPA: 4.00
University of Michigan Jan 2017 - May 2019
B.S.E in Computer Science   GPA: 3.96



vt logo
Virginia Tech July 2015 - Dec 2016
B.S. in Computer Science   GPA: 3.96   Major Rank:1/134

Honors and Awards

James B. Angell Scholar, Winter 2019, University of Michigan
EECS Scholars, Winter 2018 & Winter 2019, University of Michigan
University Honors, Winter 2017 & Winter 2018 & Fall 2018 & Winter 2019, University of Michigan
Dean’s List, Winter 2017 & Winter 2018 & Fall 2018 & Winter 2019, University of Michigan
Dean’s List, Fall 2015 & Spring 2016 & Fall 2016, Virginia Tech

Misc

I have many genius friends, and this Link will redirect you to one of them.
I enjoy Chinese, Korean, Japanese, and Indian food!
I'm planning to learn how to cook Italian food.