Lydia Zhong

Location

Berkeley, CA
San Diego, CA
Education
    University of California-Berkeley
    August 2020 - May 2024
    degree
    Bachelor's
    majors
    Cognitive Science
    Data Science
    Economics
    coursework
    Structure and Interpretation of Computer Programs,
    Data Structures and Algorithms,
    Discrete Math and Probability theory
    Linear Algebra and Differential Equations
    Principles and Techniques of Data Science
    Health Economics
    Economic Models
    Microeconomics
    Macroeconomics
    Probability for Data Science
    Econometrics
    Introduction to Artificial Intelligence
    Business Analytics
    Financial Economics
    Data Engineering
Work Experience
    Voya Investment Management
    IT Solution Engineer Intern
    May 2023 - August 2023
    company
    Voya Investment Management
    title
    IT Solution Engineer Intern
    overview
    • Leverage PySpark, REST API, GitHub, Azure Data Lake Storage (ADLS), and Databricks to develop robust tools for maintenance, analysis, data extraction, and testing of database administration processes • Utilize database design methodologies to extract, organize, clean, and summarize data across 10,000+ objects, reducing manual data processing time by 10% and allow timely identification of critical issues and performance • Develop scripts for automating data extraction workflows to generate daily reports on tables and schemas with nonstandard permissions, track uptime of SQL warehouses and compute clusters, and identify tables and schemas in improper storage locations • Participate in calls with manager on code review and implementation to optimize Python commands and SQL queries in Azure Databricks notebooks
    AFX Dance Company
    Captain & Artistic Intern
    January 2022 - May 2023
    UC Berkeley College of Computing, Data Science, and Society
    Academic Intern
    Berkeley, CA, United States, 94720
    September 2022 - December 2022
    University of California, Berkeley, Haas School of Business
    Behavioral Lab Laboratory Assistant
    Berkeley, CA, United States, 94720
    June 2021 - August 2021
    U.S. Department of Labor
    Investigative Intern
    May 2021 - August 2021
    See 6 More
Skills
Languages
ChineseEnglish
Technical skills
javapythonsql
Skills
AlgorithmsData AnalysisData Analytics
Leadership
    AFX Dance Company
    Captain & Artistic Intern
    January 2022 - May 2023
Hobbies
Dancing
Videos