Hi, my name is

Jia Hao.

Full Stack Software Development Engineer

Software engineer, geographer, team player, and lifelong learner — and a big fan of movies, guitar, and travel

About Me

I am a software developer with a passion for building that contribute to positive change in the lives of people and society. I love learning and exploring new problem domains, dealing with challenges and ambiguous situations head-on, and collaborating with others to learn and grow together.

I am currently working at Esri Canada, specifically with Ratio.City, which is a PropTech that aims to empower planners, developers and municipalities with comprehensive tools and data-driven insights to accelerate housing developments. This is my first full-time role after graduating from the University of Toronto, where I specialized in Computer Science with a minor in Geographic Information Systems (GIS).

Here are a few technologies I've worked with professionally:
  • Python (Django & FastAPI)
  • PostgreSQL (with PostGIS)
  • Angular (TypeScript, RxJS, TailwindCSS)
  • Java, Kotlin (Spring Boot)
  • AWS
  • ClickHouse

Work Experience

Full Stack Software Developer - Esri Canada (Ratio.City)
Jan 2024 - present

I am currently working as a full stack software developer at Esri Canada, specifically with Ratio.City team where I interned at previously for a summer.

In this position, I work in a distributed microservices environment that uses Python (Django, FastAPI), PostgreSQL/PostGIS, Angular (TypeScript, RxJS, TailwindCSS), ontologies and knowledge graph, Clickhouse, ETL pipelines, and AWS. I also collaborate closely with cross-functional teams including product, design, data, and industry to deliver high-quality features that meet customer needs.

Some of my key contributions so far include:

  • Currently leading the development of a spatial data versioning system prototype to enable change tracking and time-based analysis features.
  • Designed and implemented a robust self-service Stripe payment system with real-time updates and conflict-free asynchronous processing; adopted by customers within a day of release and projected to drive 15%+ of revenue.
  • Architected and led development of a distributed data ingestion pipeline, which now automates almost 25% of all data and saves 200+ hours of manual work for the data team every month.
  • Launched a synchronous working feature on platform tools using real-time event streaming, ensuring users receive relevant live updates and notifications on projects and files within seconds.
  • Contributed to engineering practices improvements and mentorship of junior developers through code reviews, documentations, design discussions, and knowledge sharing sessions.
  • Took initiatives to improve team productivity such as setting up automated scripts for internal libraries releases and improving package management workflows in local and CI/CD environments.
Sep 2023 - Dec 2023

I had the opportunity to work as a teaching assistant for the Technology Leadership Initiative program at the Department of Computer Science at the University of Toronto. Specifically, the course is CSC207 Software Design.

In this role, I provided technical and knowledge support to students in the program as they worked to create a software application MVP that addresses a real world problem in under 12 weeks.

A few of my responsibilities included:

  • Explained and illustrated key software design concepts such as SOLID principles, design patterns, and clean architecture.
  • Provided technical support and recommendations for students’ projects, such as in database design, Java & Spring Boot, API development, testing, CI/CD deployment, and cloud services.
  • Reviewed and graded tests and projects, and communicated feedback and insights to students and instructors.
Software Development Engineer Intern - Amazon Web Services
May 2023 - Jul 2023

I worked in the Payment Programs team, which owns the systems that enables special payment programs for AWS customers, such as Fixed Currency Exchange, Advance Payment and discounts. In this role, I learnt to work with highly scalable, distributed, and critical systems, as the team’s services are used by millions of AWS customers worldwide.

In the course of my internship, I owned the planning, design & delivery of a new foundational data service that integrates various payment programs data from multiple external sources for millions of customers. Some of the technologies I worked with include Java, Kotlin, DynamoDB, CloudFormation, AWS CDK, ECS/Fargate, Cloudwatch, auto-scaling policies and load testing infrastructures.

Some of what I accomplished in that 3-month period include:

  • Architected a new microservice that provides a unified API for accessing payment programs data that has 99% availability, less than 300ms latency, and scales to millions of requests per day in multiple global regions based on SLA.
  • Delivered the service that is fully integrated and deployed, with full testing and monitoring infrastructure set up, accelerating the team’s roadmap by 50%.
  • Created APIs and data models with extensive use of dependency injection and interface segregation principles to facilitate future extensibility; these serve as a foundation for the team to expand to new payment programs and data types easily in the future.
Full Stack Software Developer Intern - Ratio.City
May 2022 - Aug 2022

This was my first software engineering internship, where I worked on building features for Ratio.City, a web application that provides comprehensive tools and data to simplify and accelerate housing development planning processes.

A few of the technologies I worked with include Angular, Jasmine/Karma, Docker, and Python.

Some highlights from this internship include:

  • Spearheaded the unit and integration testing initiative for the Angular app using Karma and Jasmine, achieving 80%+ code coverage; also led a knowledge sharing session to onboard other developers on testing best practices.
  • Delivered in-app survey tool that collects user feedback on a new “Locate” beta feature, which was used to gather insights from over 50 users and informed future feature improvements.
  • Experimented and prototyped Matomo analytics integration to track user interactions and behaviours, as part of an early product effort into understanding user engagement and pain points.

Education

Sep 2020 - May 2024
Honours Bachelor of Science
University of Toronto
GPA: 3.93 out of 4.0 (High Distinction)

Computer Science Specialist with a minor in Geographic Information Systems.

Notable involvements include:

  • 1 out of 23 students admitted to Munk One Program in 2020, an interdisciplinary program focusing on understanding and addressing global challenges.
  • 1 out of 24 students admitted to Technology Leadership Initiative in 2021, a program that provides industry exposure and leadership development opportunities for Computer Science students.

Projects

Rerouting the TCS Toronto Waterfront Marathon
Python (pandas, ArcPy) ArcGIS Pro Traffic Modelling Project Management Technical Communication
Rerouting the TCS Toronto Waterfront Marathon
Python program that evaluates alternative marathon routes that maximizes sustainability factors and overall participants experience of the TCS Toronto Waterfront Marathon.
TDSB Active Travel Planner Webmap
HTML, CSS, JavaScript Bootstrap Mapbox GL JS Turf.js
TDSB Active Travel Planner Webmap
A web map to facilitate active school commute planning for parents and students by integrating visualizations of relevant features and direct in-map route planning capabilities
TraderAuto+
React AWS (EC2, Amplify, RDS) Java (Spring Boot) SQL CI/CD Agile & Project Management Clean Architecture & SOLID Principles
TraderAuto+
A web application that facilitates connections car buyers who have lower credit scores with subprime auto loans lenders.
Power of Policy
Python (plotly, pandas, networkx)
Power of Policy
A python program and visualisation tool that analyses the efficacy of various government policies in reducing COVID-related deaths and cases
Money & Climate Change
Python (plotly)
Money & Climate Change
A python program that analyses the relationship between money/capital and climate change

Achievements & Awards

Dean's List Scholar
Recognized for academic excellence throughout my undergraduate studies at the University of Toronto.
UTAGA Undergraduate Computer Applications Award
Awarded for outstanding scholarship in applying computer applications to geographic work, specifically for my GIS web map project in GGR472 (2023/24).

Get in Touch

My inbox is always open – whether you have a question or just want to say hi!