Resume

YIHENG (IAN) ZHU

Terre Haute, IN

Expected 05/26

Bachelor of Science, Computer Science, Minor in Music

Coursework: Database, Software Development (Java, Python), Web Development, Software Design, Data Structures, Computer Network, Algorithm Analysis
Honors: Dean's List

11/24 – 02/25

Designed and implemented a relational SQL database to efficiently store and manage player performance metrics, match statistics, and historical event data
Developed and optimized complex SQL queries, views, stored procedures, and indexing strategies to enhance query performance and scalability for large-scale data operations
Built a full-stack web application using JavaScript, HTML, and CSS, integrating the SQL database to enable users to filter, modify, analyze, and export data in real-time
Structured database schemas with a focus on scalability and maintainability, ensuring seamless API integrations and future feature expansions

09/24 – 11/24

Developed a software tool to analyze and visualize class dependencies within Java Jar files, simplifying program understanding and debugging processes
Utilized Object Web ASM, Java Swing, and other tools to extract detailed mappings of classes, methods, and fields, and to create an interactive UI with draggable panels and dynamic dependency graphs
Overcame challenges in parsing diverse JAR file formats, resolving complex dependencies, and managing large-scale visualizations

07/24 – 10/24

Designed and implemented a personal server and Network-Attached Storage (NAS) system using Raspberry Pi, ensuring efficient and cost-effective performance
Configured a VPN for secure remote access to files and resources across networks
Established a personalized NAS environment based on CasaOS and OpenMediaVault, featuring tailored functionalities including a Minecraft Server, Database Server, Personal Git Server, Home Media System, and Multi-Platform File Sharing System

09/23 – 11/23

Designed an interactive website using JavaScript, HTML, and CSS to facilitate campus navigation
Implemented a unique algorithm inspired by video game routing techniques to calculate and visualize optimal paths between classrooms on the Rose-Hulman campus
Enhanced navigational efficiency for students and faculty, maintaining a high user engagement to date

03/23 – Present

Implement AV solutions which integrate with computer networks and software systems, including configuring and managing complex setups that involve digital processing, streaming services, and video conferencing
Install AV software and hardware such as digital signal processors, media servers, and control systems
Provide technical support for AV technologies, diagnosing and resolving issues related to both software and hardware quickly

Java, Python, SQL, JavaScript, HTML, CSS, R

MacOS, Windows, Linux

English (fluent), Mandarin (native)