I'm a software engineer specialising in full-stack development, database systems and data engineering. I have an interest in distributed systems applications, streaming and database systems.

More recently, I gained my AWS Certified Cloud Practictioner Certification ☁️🆒 It has given me a new appreciation for the operations side of things. All those networking classes in OpenFlow and bash scripting in Operating Systems class are falling into place.

In my free time, I am sharpening my Linux skills and playing around with my own Virtual Private Server. I have recently been exploring virtualisation, including installing ESXI using VSphere, creating VLANs, and learning about DB full backups and snapshots with MySQL. I am also studying Postgresql deeply, with a focus on performance tuning and a strong grasp on complex queries.

I am currently building projects in Django, with a focus on streaming and microservice architecture.

🌱 Project 1

We built a full-stack application for the Mandai Raffles' Banded Langur (super rare endangered pokemon) project! This was the project that I'm the proudest of as it demonstrated the real impact of what software engineering could do for the scientific community. I implemented core features including offline functionality with service workers, mapping functionality with Leaflet.js, database deployment to Firebase and API documentation with Swagger UI. Pretty swaggy but one thing I would've liked to explore further was mobile deployment, perhaps an extension for another time.

Here's the bit on adding a sighting. It's available offline for no-connectivity areas thanks to IndexedDB and service workers!

📊 Project 2

Built a web app to demonstrate the Chase Algorithm, frequently used in denormalisation steps in database systems. This was containerised, and I had lots of fun playing with Nginx to get the frontend and the backend servers to talk with one another! This bit got me quite interested in DevOps actually.

Here's the bit that checks for lossless decomposition, which basically means if you join back your tables, will you get back the same schema without loss of functional dependencies? If you can, then that's good. Minimal Cover suggests a schema with the functional dependencies you've decided on.

🚚 Project 3

I figured that if I wanted to work closely with data, I must learn how to apply transformations to it and load it from place to place 🤔. I built a data engineering pipeline using Airflow by extracting data from OpenStreetMap, applying cleaning and other transformations before loading it into MongoDB. This was also dockerised!

👾 Project 4

Buckle up! My friend and I made a game for you to play out scenarios for certain decisions you could make in university. It was made in Unity and C#, and it was a blast writing all the scripts and deciding on the storyline. Oh, we also wrote all the paths ourselves, and used a great software called Ink to sort out the huge story tree we had created (yes, there were path loops and we had to keep track of player inventories too). I also set up the cloud authentication bit which saves your progress! It's deployed on Itch.io, and you can play it here 😄

👯 Hackathon? I'm always down to commit a weekend! My last one was building plugins for Chrome to aid in offline translation and summaries of foreign text.

You can reach out to me via LinkedIn.