Hello there! I'm Johnny and I tend to find myself in interesting situations. I love going on adventures and creating stories. Here's a little about me:
Capabilities:
- Eat countless packets of Mi Goreng instant noodles
-
Carry any amount of groceries in a single trip
- Speedrun
any task with Mario Kart Star Music 10 hours
Accomplishments:
- Survived two separate graduations in pouring rain
-
Crowned the Four Square King in elementary school
- Worked
as an Assistant (to the) Manager of a restaurant
Misdemeanors:
- Enjoys chewing bubble gum but can't blow bubbles
-
Claims to be trilingual but still uses translate apps
- Has
a confusing one-word, all-lowercase WiFi password
I've gained experience within established corporations and led multiple teams on various academic projects. These opportunities have given me a well-rounded perspective on addressing complex problems using data-driven techniques.
- Saved 45 hours monthly by building a Python script
to automate the creation of unique timesheets in Excel
- Developed a SwiftUI app with Firebase to facilitate
real-time communication between staff and 500+ members
- Created a responsive Bootstrap website to showcase
services offered, attracting 1,600 online visitors per month
- Automated online inquiries regarding on-site tour
availability using Twilio API and Google Apps Script
- Applied k-means clustering on population density data
of 300k to locate optimal stops for a mobile health clinic
- Leveraged Anadonda’s debugger and virtual environment
to resolve 2 legacy codebases with outdated libraries
- Employed OpenAI API to generate training data of block
descriptions containing up to 3 features per sentence
- Bachelor of Science in Computer Science
- 2019 Hackathon JPMorgan Sponsored Challenge Winner (900+ participants)
- Leonhard Center Speaking Contest semi-finalist (Top 3%)
Led a team of 5 in organizing biweekly workshops about GCP products. Also provided year-long mentorship to members participating in the Google Solutions Challenge.
Led a team of 30 staff members to run a variety of intramural games. Also contributed to the launch of the LinkedIn Learning Program, which accumulated over 44,000 hours of total watch time.
Here are the projects I've developed, each inspired by the motto "See a need, fill a need." I've pursued these journeys through self-directed learning, with a focus on creating solutions that make a tangible impact. I'm always working on a new project - stay tuned for more!
Created a SwiftUI iOS app to save birthday profiles in core data and count down until the next. It will notify users of upcoming birthdays. The main idea is to help ABC's (American-born Chinese) to help remember their family's birthdays since Lunar birthdays are never on the same day on Gregorian calendars.
Developed a Python script with a GUI to automate the timesheet creation process. For the start of every new month, over 500 unique timesheets are neededed. Achieved 40 hours of monthly time-savings by constructing this script. Timesheets are curated based on service days, month, and year.
Designed a Bootstrap website to showcase the services of a party hall. By filling out the embedded Google Form, you can receive an immediate response on the venue's availability via Twilio. When submitted, Apps Script will look for schedule conflicts in the Google Sheet that hold all the reservations.
Created a Java Swing GUI, Point-of-Sale system that allows self-service for food ordering during the pandemic. It deploys PostgreSQL to store every menu item and dynamically retrieves the correct items based on the selected category. It also counts the frequency of each item so restocking is easier.
Developed a Python script to construct reward assignments for World of Warcraft guilds. It utilizes web scraping techniques and GraphQL to extract data to be used in the criterion. Environment variables are used to safeguard API keys. GitHub Actions will automatically run the script once a week.
(More detail for each experience)
If you have any questions or wish to discuss potential opportunities, feel free to reach out to me via email at johnnyj2608@gmail.com or shoot me a message on LinkedIn.