Andrew Bliss

Summary

Software engineer with 8+ years of experience designing, building, and scaling production web applications. Specializes in React, Next.js, Node.js, and PostgreSQL/BigQuery-based data systems, with a track record of migrating legacy platforms to modern architectures and building real-time, high-throughput backend systems.

Work History

• Software Engineer / Carketa

  Sep, 2022 – Current
  • Led the migration of a legacy PHP system to a modern React/Next.js architecture, modernizing core platform workflows.
  • Architected and built a vehicle reconditioning system that lets dealership teams create tasks, capture photos, and push updates to seller APIs in real time.
  • Built a daily data aggregation pipeline spanning BigQuery and PostgreSQL, including table partitioning, materialized views, and indexing strategy, to keep dashboard queries fast as daily vehicle record volume grew.
  ReactTypescriptTailwindNext.JsPostgreSQL

• Software Engineer / nth-child consulting

  Dec, 2017 – Sep, 2022
  • Led the transition from a legacy PHP system to a new solar appraisal platform built with React and Next.js, used by solar companies to manage and sell installation contracts.
  • Replaced a polling-based customer service system with a Node.js and Redis-backed queue, enabling real-time call and chat handling with no downtime for the support team..
  ReactTypescriptTailwindNext.jsPostgreSQL