Hi! I'm Hong Bo.

I'm an undergraduate student at Columbia University, studying Computer Science.

I have coded using Java, Python, and C. I also have used MySQL in my projects.


On my free time, I occasionally create projects that applies my skills learnt through the classroom to hopefully, do something interesting. Right now, my most proud project is using Discord Bot wrapper JDA to write a moderation bot that automates some grueling tasks that used to be done manually.

About Me

Projects

This "bot" was written because I started having more responsibilities, and this project was an excuse to spend less time moderating. Hosted on my own laptop for free :).

  • Built a system to automatically and periodically scan messages and user profiles for harmful content, reducing moderation workload by 25% for Ndemic Creations
  • Developed and managed an optimized SQL database to track user punishments efficiently
  • Engineered an HTTP-based system to track Ndemic’s BlueSky account and post updates to Discord

This project was completed in a student-ran faculty-supported hackathon hosted by University at Buffalo "UB Hacking" group.

  • Fetches online data based on user specifications and formatted climate information in a neat way
  • Practiced software engineering protocols by using version control and RESTful API Standards
  • Project created under 36 hours in a hackathon

These are the "mini-projects" that are simpler than my other projects that I have created out of curiosity or necessity for other projects.

  • Used Playwright automation to routinely check for new posts for a user on social media platform BlueSky
  • Wrote efficient and lightweight memory allocators and managed memory pools
  • Implemented a client-side instant messenger that was able to send/transit messages
  • Designed a media library, practiced OOP principles: encapsulation, inheritance, polymorphism, and I/O operations