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 developing a Python script to
automate individualized timesheet creation in Excel
- Used Selenium to automate insurance claim submissions,
increasing efficiency by 80% for 400 clients biweekly
- Designed a responsive Bootstrap website to showcase
services offered, attracting 1,600 visitors per month
- Automated replies for online inquiries regarding
on-site tour availability using Twilio API and 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 CTkinter and Selenium to automate submitting health insurance claims on Office Ally. It uses an Excel template to pull account and member information to autofill claim forms. By selecting which member list and range of dates, it will automatically submit and download each claim and record the total value. This program has increased efficiency of submitting claims by 80% for 400 clients biweekly.
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.
Created a SwiftUI iOS app with Firebase integration to facilitate communication between social adult day care members and staff. Also supports user management for the staff, allowing paperwork to be saved and done digitally. Invitation-based onboarding where one account can only be affiliated with one SADC.
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.