Shanghai skyline
Profile
I'm Fred (Rongfei) Shao, a Data Science and Applied & Computational Math student at USC with a strong foundation in backend engineering, infrastructure automation, and data analysis. I’ve contributed to large-scale system reliability projects, including BDMS at UCloud—enabling one-click deployment and lifecycle automation for Kafka, Etcd, and Elasticsearch, reducing delivery time from 3 days to 0.5 hr across 176 clusters and 600+ nodes. I’ve also built cost analysis pipelines and improved reliability across MySQL, MongoDB, and RocketMQ, and received UCloud’s internal Luban Award (鲁班奖) for innovation and impact.
Education

University of Southern California

B.S., Computational and Applied Mathematics / Data Science · Aug 2023 – May 2027

Pickering College

High School Diploma · Sep 2019 – Jun 2023

Brown University

Summer Program: Habitable Worlds · Jul 2022 – Aug 2022

Experience

TikTok — Site Reliability Engineer Intern

Dec 2025 – Present · San Jose, CA · Incoming 2026 Summer

USC Marshall School of Business — Research Assistant

Sep 2025 – Present · Los Angeles, CA

Executed an end-to-end data pipeline using Google’s Gemini AI to categorize and extract structured data from YouTube videos focused on Alzheimer’s patient–caregiver interactions. Utilized Python with the YouTube Data API and Gemini API; performed human-in-the-loop validation and correction to ensure dataset accuracy.

Trojan Archery at USC — Team Captain

Oct 2023 – Present · Los Angeles, CA

USC Trojan Archery compound bow team captain.

UCloud — Site Reliability Engineer Intern

May 2025 – Sep 2025 · Yangpu District, Shanghai, China

Standardized and automated deployment and lifecycle management for Kafka/Etcd/Elasticsearch; reduced delivery time from 3 days to 0.5 hr across 176 clusters and 600+ nodes; enabled future support for 6,000+ instances (Redis/MySQL in progress). Received internal Luban Award (鲁班奖) for innovation and impact. Built a Python automation pipeline integrating REST APIs to aggregate resource usage from global clusters, apply regional pricing models, and generate Excel cost reports—improving billing accuracy and boosting profit by ~2%. Led full-stack deployment and configuration of MySQL 5.6/5.7/8.0 clusters in restricted environments; resolved RPM/Perl issues, patched legacy scripts, and refactored Ansible for multi-version MHA and cross-platform compatibility. Modified and migrated cluster/node structures for MongoDB, RocketMQ, Elasticsearch, and ETCD using Go, Postman, MySQL, and YAML scripting; supported auto-deployment, failover, disaster recovery, and 24/7 ops across Linux environments.

Dream Schools AI — Founder Software Engineer

May 2025 – Aug 2025 · Seattle, WA

Designed a web crawler algorithm using image recognition and machine learning models to build a robust database and improve education consulting accuracy for clients.

Phalanx Analysis Group — Data Analyst

Feb 2025 – Apr 2025 · San Francisco Bay Area

Analyzed the U.S. restaurant industry using three years of data; identified YoY trends by sales growth, business size, emerging brands, and rankings; noted post-COVID rise of low-cost fast-food (boba/cafés/bakeries) and 2024 saturation; recommended data-driven reporting and strategy opportunities.

University of Cambridge — Solo Researcher

Jul 2024 · Shanghai, China

Completed a project under Mr. Kieren Lovell: developing a computer science prototype to prevent negative labeling in teenage internet users; submitted a paper and built a prototype website.

Tsinghua University — Assistant Product Development Engineer

Jun 2024 – Jul 2024 · Suzhou, Jiangsu, China

Developed and launched a real-time dashboard for autonomous prototype vehicle testing using Vue.js, HTML, ECharts, and MongoDB; integrated telemetry and road test data with backend and computer vision teams to support monitoring, troubleshooting, and field trials.

Weitai Biological Pharmaceutical Co., Ltd — Medic Data Intern

May 2024 – Jun 2024 · Shanghai, China

Managed a drug inventory database using MongoDB and TypeScript; gained hands-on experience in data collection, entry, classification, storage, and retrieval.

Pickering College — Head Proctor

Sep 2022 – Jun 2023 · Toronto, Ontario, Canada

Joined the high school student committee as Head Proctor for New House.

First Robotics Team 8349 — Hardware Technician

Sep 2022 – May 2023 · Toronto, Ontario, Canada

Supported hardware build for a robotics prototype for a regional competition.

Shanghai Dapuqiao Community Center — Elder Care Volunteer

Jul 2020 – Aug 2020 · Shanghai, China

Engaged with local community empty-nest elders; provided companionship and support.

Certifications
  • USA Archery Level 2 Instructor Certificate
Top Skills
  • Prompt Engineering
  • Large Language Models (LLM)
  • Web Services API
Languages
  • English (Full Professional)
  • Chinese (Native or Bilingual)
Honors & Awards
  • 2021 YRSTF Science Fair Silver Medal
  • 2022 Physics Bowl — 33/40 (Top 10 around Canada)
  • Recommendation from Professor Schultz (Brown University Summer Program: “Habitable Worlds”)
  • Thesis Publication Acceptance — ICAPM 2022 Academic Meeting
  • 2022 Euclid Math Contest Distinction
Publications
  • A New Method to Reduce Near-Infrared data of Palomar Observatory
© 2026 Fred Rongfei Shao