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 the company over 1,000 cumulative hours of workload by utilizing Python to develop tailored automation tools across various departments. The most significant included automating hundreds of insurance claim submissions with Selenium and generating individualized Excel workbooks using Xlwings.
An AI / ML focused role where I worked with Explainable AI, the What-If-Tool, OpenAI API, and k-means clustering. Also spent time debugging legacy codebases.
Bachelor of Science in Computer Science
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.
Provided mentorship to 8 first-year engineering students per semester. Also contributed to the orientation events and material.
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 90% for 500 clients biweekly.
Developed a full-stack web application with Node.js enables remote food ordering for social adult day cares, allowing kitchen staff to set daily menus and track orders effortlessly. It features self-ordering capabilities with schedule-aware menus managed by the staff. It saves the kitchen staff 30 minutes each day from manually asking every individual for their meal preference.
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 45 hours of monthly time-savings by constructing this script. Timesheets are curated based on service days, month, and year.
(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.
