Xiaoyan Zhao

About Xiaoyan Zhao

Innovative engineering lead with a background in big data analytics, sql query engines, managed ETL pipelines, data warehouse infrastructure. Research experience with computational biology and DNA sequence analysis in bioinformatics.Specialties: C/C++(20+ experience), C#(2 + experience), JAVA (3+ experience).

Experience

1. Engineering Lead Senior Staff Software Engineer

   Google

   Mar 2011 — Present · Sunnyvale, CA, US

   Architected real-time streaming/querying infrastructure to power realtime analytics use cases across multiple Google product areas(such as Google DeepMind, Cloud, YouTube, and Ads).Built the query engine features for various analytics tools (Procella, F1, Dremel, Tenzing), built automated ETL pipeline system as part of Google\'s internal BI solution and Data warehouse, and built the E2E analytics solution for YouTube Analytics, for supporting analytics needs for creators, monitoring services health, and for internal ad-hoc analysis.

Education

• Stanford University Graduate School of Business

  Stanford LEAD Program

  2022 — 2023

• Beijing Normal University

  Bachelor of Science (B.S.), Computer Science

  1998 — 2002

• Texas A&M University

  Doctor of Philosophy (PhD), Computer Science

  2003 — 2010

Skills

• Databases
• Java
• Javascript
• C#
• Algorithms
• Machine Learning
• Matlab
• C
• Programming
• Software Development
• Python
• Scrum
• Software Engineering
• Linux
• Computer Science
• Unix
• C++
• Parallel Computing
• High Performance Computing
• Perl
• Computer Architecture
• Distributed Systems
• Data Mining