Ziyuan Han
Automation Engineer
Nanjing City, Jiangsu, United States
Summary
👤
Senior🎓
Top SchoolZiyuan Han is an automation engineer and full-stack developer with 11 years of experience blending data science and engineering across Bay Area product teams. He has built production ML features—like a LightGBM-based story recommender and a BigQuery/Jenkins cheater-detection pipeline—that lifted ARPU by 6%, and he routinely delivered dashboards and pipelines used by C-level stakeholders. Comfortable across JavaScript, Python, SQL, and modern frameworks (React, Node, Django/Flask), he moves between front-end UX work and backend data engineering with equal fluency. His open-source contributions include core SQL parsing and parser test improvements to the widely used Apache ShardingSphere project, reflecting a strong aptitude for database internals. Based in Nanjing with degrees from the University of San Francisco and Oxford, he brings a global perspective and a habit of reflective self-improvement evident in his brief Chinese GitHub motto. Colleagues rely on him to close the loop from research to deployable, measurable product impact.
11 years of coding experience
5 years of employment as a software developer
Materials Science, Materials Science at University of OxfordMaster Data Science, Master Data Science at University of San Francisco
Github Skills (24)
unit-testing10
middleware10
databases10
user-interface10
ui-design10
graphical-user-interface10
java10
human-interface10
javas10
front-end-development10
sql10
database10
swing10
server-client9
mysql9
Programming languages (15)
Github contributions (5)
apache/shardingsphere
Dec 2020 - Jul 2022
Empowering Data Intelligence with Distributed SQL for Sharding, Scalability, and Security Across All Databases.
Role in this project:
Back-end Developer / Database Engineer
Back-end Developer / Database EngineerContributions:3 reviews, 6 commits, 6 PRs in 1 year 7 months
Contributions summary:Ziyuan contributed to the core functionality of the ShardingSphere project by implementing features related to SQL parsing and database interaction. They added support for the `MAXVALUE` keyword within the SQL parser, enhancing the system's SQL dialect capabilities. Additionally, the user implemented and extended unit tests for critical components like `SelectStatementContext`, improving code coverage and overall reliability. They also added a test case for database metadata drop and add operations and fixed an issue where INSERT column and values mismatched.
dbmsrdbmsdatabase-systemmore-featuresbigdata
Bpazy/ssManager
Aug 2018 - Jul 2021
Shadowsocks manager api
Contributions:4 PRs, 113 pushes, 2 branches in 2 years 11 months
apiapi-managershadowsocksshadowsocks-manager
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.