# Tsung-Yu Lai > Software Development Engineer Location: San Francisco Bay Area, United States Profile: https://flows.cv/tsungyu HANDS-ON EXPERIENCE: Built scalable data pipelines ground up on AWS EC2 Ubuntu instances under Amazon Virtual Private Cloud, using technology including Spark, Kafka, ZooKeeper, Airflow, Cassandra, Flask/Dash within 3 weeks. Github Link: https://github.com/gary19941216/bitcoin-fluc-detector PROGRAMMING LANGUAGES: 1. C/C++: 6 years experience 2. Java: 5 years experience 3. Python: 5 years experience 4. BASH: 5 years experience 5. Scala: 4 years experience 6. SQL: 4 years experience 7. HTML, JavaScript, jQuery, PHP, Node.js: 4 year experience 8. C#, BootStrap: < 1 year experience ## Work Experience ### Software Engineer @ Box Jan 2023 – Present | United States ### Software Engineer @ Pure Storage Jan 2022 – Jan 2023 | Mountain View, California, United States ### Software Engineer @ Apple Jan 2020 – Jan 2022 | Cupertino, California, United States ### Insight Data Engineering Fellow @ Insight Data Science Jan 2020 – Jan 2020 | San Francisco Bay Area Reddit-Trend-Bitcoin • Analyzed how users' behavior of Reddit cryptocurrency community made impacts on bitcoin price. Produced analytic reports for bitcoin investors to draft a more strategic plan. • Developed a Scala/Spark batch processing pipeline. Transformed 5TB of JSON data in AWS S3 into 1TB of Parquet data and accelerate Spark SQL query speed from 6 hours to 1.5 hours. • Ingested real-time events data streams by Kafka coded in Java, processed micro-batch data with Spark Structured Streaming, and stored in Cassandra for web access from Flask/Dash. • Unified historical and real-time data by running Airflow periodically. ## Education ### Master's degree in Computer Science University of Southern California ### Bachelor's degree in Computer Science National Tsing Hua University ## Contact & Social - LinkedIn: https://linkedin.com/in/tsungyulai --- Source: https://flows.cv/tsungyu JSON Resume: https://flows.cv/tsungyu/resume.json Last updated: 2026-03-29