# Yifan Guan

> Cloud native distributed SQL database

Location: San Francisco Bay Area, United States
Profile: https://flows.cv/yifanguan

Passionate about building scalable and efficient backend, infrastructure, and cloud solutions. Currently at Yugabyte, I leverage my expertise in database systems and data science to work on distributed database internals, optimizing query execution, and enhancing system performance. My background spans database systems, query optimization, and cloud-native architectures.

I earned my Bachelor's and Master's with a focus on Systems and ML/AI. I’ve conducted research in database indexing, responsible ranking, and data coverage analysis. I'm generally passionate about all sorts of Computer Science topics and took 10+ upper-level CS courses in college. With all kinds of CS fundamental building blocks in mind, I can quickly adapt to new domains and contribute effectively to fast-evolving teams.

Beyond work, I stay engaged with the latest in distributed systems, AI infrastructure, and ML research, continuously learning and exploring innovations that shape the future of computing.

## Work Experience
### Software Engineer @ Yugabyte
Jan 2021 – Present
Colocation, SQL DDL, Backup && Restore, Query Optimization and Execution, Table Auto-Analyze

### Research Assistant @ University of Michigan Database Research Group
Jan 2018 – Jan 2021
Mithraranking
Coverage in DB
Advised by Prof. H. V. Jagadish

### EECS 445 Machine Learning Grader @ University of Michigan Database Research Group
Jan 2018 – Jan 2018

### Software Development Engineer Intern @ Zillow Group
Jan 2018 – Jan 2018 | Greater Seattle Area
- Refactored neighborhood module on Zillow home detail pages using React, added asynchronous loading to improve user experience
- Migrated region data from Zillow Pogo database to GraphQL
- Fixed bugs including URL generation and page redirections


## Education
### Master's degree in Computer Science
University of Michigan
Jan 2019 – Jan 2020

### Bachelor's degree in Computer Science
University of Michigan
Jan 2017 – Jan 2019

### Bachelor's degree in Computer Science
Virginia Tech
Jan 2015 – Jan 2016


## Contact & Social
- LinkedIn: https://linkedin.com/in/yifanguan

---
Source: https://flows.cv/yifanguan
JSON Resume: https://flows.cv/yifanguan/resume.json
Last updated: 2026-03-20