Shixuan Fan
Software Engineer at Snowflake
Menlo Park, California, United States
Summary
🤩
Rockstar🎓
Top SchoolShixuan Fan is a Software Engineer with a decade of experience building high-performance back-end systems, currently working on Snowpark at Snowflake after four years contributing to Presto at Facebook. He has deep database and streaming expertise from graduate work at University of Wisconsin–Madison—where he implemented end-to-end window aggregation and integrated Quickstep streaming with Twitter Heron—and from shipping SQL engine features like Hamming distance and TRY desugaring in the widely used Presto project. Proficient in Java and C/C++ and familiar with Python, he excels at productionizing complex data processing features and collaborating across teams. Based in Menlo Park, he combines top academic performance (M.S. 4.0) with practical open-source impact on large-scale query engines.
10 years of coding experience
4 years of employment as a software developer
Master of Science (M.S.), 4.0/4.0, Master of Science (M.S.), 4.0/4.0 at University of Wisconsin-MadisonBachelor of Science (B.S.), 3.5/4.0, Bachelor of Science (B.S.), 3.5/4.0 at Peking University
English, Chinese
Github Skills (22)
trino10
strings10
text-manipulation10
big-data10
java10
javas10
sql10
query-engine10
presto10
distributed-systems9
databases9
data-processing9
database9
stringi8
user-data8
Programming languages (5)
Github contributions (5)
prestodb/presto
Aug 2017 - Jun 2021
The official home of the Presto distributed SQL query engine for big data
Role in this project:
Back-end Developer
Back-end DeveloperContributions:281 reviews, 149 commits, 226 PRs in 3 years 10 months
Contributions summary:Shixuan contributed to the development of the Presto distributed SQL query engine by adding new functionality. They implemented a Hamming distance function for VARCHAR data types, including tests for various scenarios, such as unicode and invalid arguments. Additionally, the user introduced an internal "try" function for TRY desugaring, adding the related code and test cases, as well as a rewriter to desugar TRY expressions.
distributed-sqlquerybigdataquery-enginesql
shixuan-fan/presto
Aug 2017 - Sep 2021
Distributed SQL query engine for big data
Contributions:571 pushes, 171 branches in 4 years
querykuduquery-enginenosqlmysql
Find and Hire Top DevelopersWe’ve analyzed the programming source code of over 60 million software developers on GitHub and scored them by 50,000 skills. Sign-up on Prog,AI to search for software developers.