Projects

I used to track my investments on spreadsheets, but as my portfolio grew and I opened more brokerage accounts, maintaining these spreadsheets became increasingly cumbersome. To reduce the hassle and centralize all my investment data, I decided to build an investment portfolio dashboard using Looker and BigQuery. This dashboard now allows me to analyze my investment data from my first stock in 2020 to the latest updates, providing an intuitive way to visualize trends, evaluate asset allocation, and track cumulative performance.

In this project, I aimed to leverage the power of live stream chat to extract valuable insights and analytics. Utilizing the chat-downloader tool developed by xenova, I successfully retrieved chat data from popular live streaming platforms such as Twitch and YouTube. I conducted a comprehensive analysis of the chats from famous streamers like XQC, Disguised Toast, and Ludwig.

In this project, I explored and compared two popular methods for pose detection: MediaPipe and MoveNet. Through this project, I aimed to analyze the strengths and limitations of each approach and gain insights into their performance in real-time pose estimation. This is initially a project I planned for my lab research but I ended up using a more accurate (and expensive) motion capture system instead of doing pose detection through videos.

The Investment Portfolio Tracker is a powerful spreadsheet tool I developed to streamline and simplify investment portfolio management. This versatile tool allows users to track their investments, monitor portfolio performance, and seamlessly share the tracker with other individuals or teams.