Software Projects

01. Sony Music

Software Engineering Intern, Summer 2024

Developed automated shell/SQL scripts to streamline data fetching, reducing extraction time by 30%
Refactored code and encoded dataset values, enhancing query processing efficiency for streaming insights
Enhanced Spotify playlist SEO by identifying key search terms and boosting user engagement metrics
Designed and built a high-fidelity prototype for Sony Music’s website, enhancing UX and navigation

View Figma Prototype

02. Harvard Medical School

Software Engineering Intern, Summer 2023

Contributed to 3D imaging software development, automating signal permutation processes
Implemented noise reduction, masking, and Gaussian filtering, optimizing processing times by 55%
Developed file management systems and conducted unit testing, supporting the AWS deployment pipeline
Enhanced system performance through caching, multithreading, and memory mapping

View Presentation

5d4a61_ef1bf823595c47cba0720d295531d2ec~mv2

Mobile & Web Development

01. MDB Website

Web Designer/Developer, Spring 2023

Built professional website for Mobile Developers of Berkeley using WordPress, integrating Divi Builder and incorporating custom CSS
Improved navigation and user experience through better structure and animations
Aligned the website’s color scheme with the newly designed club logo, maintaining visual consistency and added scroll effects for a dynamic touch

View Figma Design

02. Task Scheduling App

Mobile Developer, Spring 2022

Developed a task scheduling app using React and Firebase, winning 1stplace at Google-sponsored Tech Fair
Implemented interactive calendar, dashboard, and push notifications to enhance user experience
Collaborated in an Agile team, contributing to iterative design, development, and testing cycles

View Github Repo

melody_lai@berkeley.edu