Data Engineering with Google Cloud

Undertook the searching and rescuing tasks of missing children and aged people in the Beijing area

Volunteer

Master's degree

Bachelor's degree

•	Maintained network infrastructure which contains hundreds of devices. 
•	Troubleshot dozens of network glitches weekly. 
•	Analyzed network packets using Wireshark, etc.
•	Reduced 1/2-day configuration backup work to 90 seconds by VBScript.

Network Engineer

• Assisted to explore sensor data anomaly detection and recovery by using our experimental car in the lab.
• Designed and developed car operating programs based on Donkey Car framework with factory pattern to control the car
in random speed, pulse speed and uniform speed.
• Applied machine learning (Linear Regression, KNN, LSTM) to detect the sensor attacking activity and successfully recovered
the speed control within 200ms with speed prediction accuracy up to 72%.

Research Assistant

• Worked on project schemes’ design and selection, bidding schemes compilation and final implementation
• Hands on-campus network construction, MESH wireless network system, radio relay intercom system, etc.

Languages: Python, SQL, R, Java, Scala
Data Science: Data Analysis, Data Warehouse, Machine Learning, Deep Learning 
Big Data: Hadoop, Spark, Hive, Kafka, Flink, Azkaban, BigQuery
Business Intelligent: Tableau, PowerBI
Others: Git, Docker, Shell, Scrapy, Network, Web, FastAPI

Graduate Student

• Designed and built data warehouse using Spark, Delta Lake, MongoDB by Scala and improve data query performance from time cost 30 mins down to seconds.
• Developed batch queries API services by Spring Boot to gain data in an efficient manner and deployed by Docker.
• Created and maintained data pipelines based on own pipeline management system written in Scala.
• Migrated billion rows of Parquet data on HDFS and performed exploratory data analysis to figure out dimension and fact tables to build data warehouse and help data scientist get their data better.

Bioinformatics Backend Engineer

Software Engineer

Webex Analytice Platform

- Explored and implemented an LLM-based SQL agent for querying Pinot, enabling direct visualization of dashboard data.
- Designed and Developed an Intelligent survey system(global service) for Webex dealing with the data then sending a survey to users. (Core staff from design to completion)

Know about Yuki He's work experience, education, bootcamps, certifications, and much more. Yuki He