🛠 Built

A running record of what I've built, shipped, or helped build across my career. Projects I own personally include a short description of what it does, why I built it, and what it runs on.

AI and Data Projects

CityCycle London — End-to-end bike rebalancing intelligence pipeline for London's 795-station cycle network. Ingests 32 million real rides via Meltano into BigQuery, transforms through a 7-model dbt star schema with Great Expectations quality gates, and surfaces operational recommendations through an XGBoost demand forecast (RMSE 2.4) and a 5-page Streamlit dashboard with geospatial rebalancing maps. Orchestrated with Dagster and GitHub Actions CI. Built as a DSAI4 capstone to prove a full production-grade data engineering stack, not just notebooks. Stack: Meltano, dbt, BigQuery, Great Expectations, Dagster, XGBoost, Streamlit, Looker Studio, Python.

Digital Tools and Dashboards

EverySong — A self-hosted music discography explorer that catalogues every song an artist has ever released — album tracks, B-sides, solo work, collaborations, bonus discs, and soundtracks. Currently covers BTS (386 songs, 2013–2026) and Pet Shop Boys (350 songs, 1984–2025). Built as a full-stack portfolio piece: data is compiled from Wikipedia and fan wikis into version-controlled CSVs, seeded into SQLite via custom Node.js scripts, and served through a server-rendered Express app with filterable gallery views, album art fetched live from the iTunes API, and Spotify search links per song. GitHub Actions CI validates CSV integrity and DB seeding on every push.
```
Stack: Node.js, Express, SQLite (node:sqlite), EJS, nginx, PM2 on AWS Lightsail. GitHub Actions for CI.
```
Under The Hood — A website intelligence platform that reveals any site's full tech stack, SEO health, DNS structure, SSL details, and Core Web Vitals using 100% free APIs. No paid subscriptions, no data sold. Built to prove that meaningful infrastructure tools don't require expensive third-party services.
```
Stack: Node.js, Express, Google PageSpeed Insights API, RDAP, Wappalyzer patterns, PM2, nginx on AWS Lightsail.
```
Finance Dashboard — A financial intelligence dashboard for evaluating company performance through efficiency-first metrics: Rule of 40, S&M Efficiency Ratio, and operating leverage. Pulls live data via yfinance, detects reporting currency automatically, and converts to USD equivalent for cross-market comparison.
```
Stack: Python, Streamlit, yfinance, curl_cffi, systemd on AWS Lightsail.
```
SG Registry — A searchable directory of all 2 million+ ACRA-registered business entities in Singapore, built from 27 CSV datasets via the data.gov.sg public API, synced into SQLite and served through a FastAPI backend with in-memory caching.
```
Stack: Python, FastAPI, SQLite, pandas, data.gov.sg API.
```
Carpark Availability — Real-time carpark space search across Singapore, built as a quick API integration exercise.
Telegram Rain Check Bot — A Telegram bot that monitors Singapore weather and notifies you when rain is coming and when it clears. Built because I got caught in the rain one too many times.

Professional Build History

Large-scale digital projects I owned or led as part of my career, working with internal teams and agencies.

Applied Materials Website — Managed appliedmaterials.com as an embedded developer at Beck Interactive in Silicon Valley, handling content deployment, version control, brand consistency, and client-side technical support across HTML, CSS, XML, JavaScript, and Perl. (2002-2008)
Salesforce APAC Sites — Built and executed online marketing campaigns across Australia, Singapore, India, China, Taiwan, and Korea. Established Salesforce's social media presence across APAC from scratch at a time when the company had none in the region. (2009)
AWS APAC Sites and The AWS Podcast — Led localisation and launch of AWS websites for Hong Kong and Taiwan, managed the regional web team in China, and co-pioneered the AWS podcast with Simon Elisha. Implemented JIRA for cross-departmental website change management. (2014)
Johnson Controls APAC Sites — Served as Asia Pacific lead for JCI's global digital team across seven markets. Led the digital component of the Johnson Controls Hitachi Air Conditioning rebranding, including launch of new corporate website and intranet for the merged entity. Recognised with a Merit Award. (2012-2017)
SUSS Website and Intranet — End-to-end delivery of a full institutional website rebrand and a corporate intranet build, owning project management, vendor coordination, stakeholder alignment, content strategy, and post-launch training across the organisation. Drove 25% year-on-year growth in digital reach. (2017-2021)

Ventures

Businesses I founded or co-founded.

PinqueLife — Co-founded a bath and body care brand on Shopee selling essential oil rollers with simple, purposeful ingredients. Took full ownership of brand, packaging, operations, and marketing. Broke even within 6 months. (2022-Present)
Bernie's Bug Farm — Ran a working mealworm farm producing frass as organic fertiliser and researching edible insects as a protein source. Directly informed my sustainability education work under Werms Inc. and Gardenasia.
Fresh Baked Web — Boutique web and digital marketing agency serving local businesses, with select enterprise clients including Salesforce and AWS. Closed to take a full-time leadership role at Johnson Controls. (2010-2012)
Cowork.sg — Co-founded one of Singapore's first coworking spaces, bringing a concept observed firsthand in the US to a local market where it didn't yet exist. Received press coverage in local media. (2011)

For Fun

Side projects that have nothing to do with career positioning and everything to do with staying curious.

Snacks Reveal — YouTube channel reviewing snacks from around the world. Started it during a period when I needed a low-stakes creative outlet. (2020-2021)
Bernie Studio Delivery — YouTube channel documenting my food delivery adventures as a rider in Singapore. Started as data collection, turned into something I genuinely enjoyed. (2021-Present)
Notion Templates — Templates for AI-curious non-technical people, built under the Power of Smol brand. More coming. (2025-Present)

Looking for deeper write-ups on selected projects? See the Work section of my Pulse page.