Portfolio

Telegram Bots

BTT / FTT / RTT QuizBot

While preparing for my own the Riding Theory Test, I found myself navigating through ad-filled websites or purchasing quiz banks from Carousell, which is an unpleasant experience. Many resources are locked behind paywalls, limiting access for those who need them most. 

I believe education should be democratized, and I set out to address this issue by creating a solution that maximizes value while minimizing resource expenditure.

To achieve this, I utilized web scraping to gather content and developed a Telegram bot to deliver it. 

I hosted the bot using Google Apps Script, ensuring the deployed solution remained simple, while keeping the total cost at zero. 

Telegram was chosen for its massive reach and the fact that many users already have the app installed, eliminating the need for additional downloads or visits to other websites. This reduces adoption inertia.

Skills:

  • Web Scraping: Selenium
  • Telegram Bot Development: Telegram API, Google App Scripts
Try It Out!

Express Bus Alert Bot

Express bus interval is around 30minutes. I do not want to keep refreshing bus app. I create bot to tell me when bus is 10minutes away. I no longer need to stress about missing bus.

Google Professional ML QuizBot

The Google Professional Machine Learning Certification was a pre-requisite for one of my internships. 

The video resources provided by Google was thorough but often long-winded. However, I needed to ensure I retained the information.

To tackle this, I employed web scraping to extract transcripts from the video resources. I then used a Large Language Model (LLM) to summarize these transcripts and create quizzes based on the main points. Additionally, I scraped the web for existing practice questions to further reinforce my understanding.

By combining these methods, I developed a comprehensive study tool that not only summarized the content but also provided interactive quizzes to test my knowledge. This approach ensured that I could effectively prepare for the certification while making the study process more efficient and engaging.

I developed a Telegram bot to deliver these quizzes, allowing me to practice whenever I had pockets of time, such as during transit.

Skills:

  • Web Scraping: Selenium
  • Generative AI: Large Language Models (Google Gemini Pro)
  • Telegram Bot Development: Telegram API, Google App Scripts
Try It Out!

Google Sheets/ App Scripts

Support Ticket System

Many people, many complaints, Many complaints, need management. I create management using Google App Script, for Google Sheet. and Google Forms Everyone knows Google Forms.

Web Scrapping

Textile Exchange

My friend needed to extract data from the Textile Exchange website, but faced challenges as the site did not offer an API, and attempts with UiPath were unsuccessful. The data was dynamically loaded within a PowerBI iframe, which meant it was not directly accessible on the webpage. UiPath struggled with this complex issue due to the need for emulating scrolling and waiting as data was continuously loaded within the iframe.

To overcome this challenge, I utilized Selenium to effectively handle the dynamic content. Selenium allowed me to automate scrolling and waiting actions, ensuring that data was fully loaded and accessible for extraction. This approach enabled efficient data retrieval from the dynamically generated content within the PowerBI iframe.

Skills:

  • Web Scraping: Selenium
Check it out!

Automation

Shopee Autobuy

During Shopee’s 7.7 marketing campaign in 2023, the iPhone was offered at a discounted price limited to the first 400 units. I developed a bot using Selenium to automate the purchasing process as soon as the price dropped.

To minimize the risk of triggering Shopee’s anti-bot measures, I set the refresh interval to 2 seconds. Unfortunately, this cautious approach ultimately led to my bot missing the opportunity to secure the purchase at the discounted price.

Skills:

  • Automation: Selenium

Google Cloud Products (GCP)

benjaminli.info

Google Cloud offers a free tier for its Compute Engine services, which I utilized to host my portfolio website at no cost. By leveraging this free tier, I was able to set up and maintain my portfolio online, providing potential employers and collaborators with easy access to view my work.

Skills:

  • Google Cloud Products: Compute Engine
  • Web Development: Wordpress, Cloudflare