——
Andrew Poggione
——
Hi, I'm Andrew! I'm a software engineer with a passion for solving difficult problems and building maintainable projects. I hope each of my projects stand the test of time, and I can continue to grow my project portfolio below. In my spare time, I play basketball, beach volleyball, and the piano. I'm currently, as of 04/30/2025, based in Los Angeles, CA and plan to be here for at least the next couple years. Please reach out if you want to collaborate! I'm always excited to work on new projects!
FYI. I'm not the greatest at keeping this all up to date either 😅 (Last update: 2026-02-26)
FYI. I'm not the greatest at keeping this all up to date either 😅 (Last update: 2026-02-26)
702-498-3006
Los Angeles, CA
—— Projects ——
ION
2022-Present- Primarily backend development, with contributions across infrastructure, data, and frontend.
- Much more detail is included in the Experience section (for First Resonance).
AASHTO TAM Data Assistant
2020- Built a Django application enabling transportation agencies to assess data management practices, prioritize improvements, and generate executive-ready results.
- Iterated on features based on ongoing research panel feedback—including a group assessment workflow to invite collaborators, track progress, manage group statistics, and capture consensus responses.
- Led development and contributed ~95% of the codebase as the sole engineer with deep Django experience.
AASHTO Transportation Portals
2019-2021- Developed an interconnected WordPress multisite network to provide transportation management resources and connect transportation communities.
- Constructed the Document and Video Libraries, the Community Pages (which allow privileged users to post information and resources), and Event Pages on each site.
Nobara Labs Blog
2025-Present- A blog where my coworker/partner-in-crime Orion Follett and I write random thoughts about (mostly software related) things.
- Made with a go+templ.
- Hosted on Hetzner.
—— Education ——
Occidental College
Los Angeles, CA
2019-05
- Double majored in Mathematics and Economics
- Mathematics: Statistical Data Analysis, Real Analysis, Ordinary Differential Equations, Probability, Advanced Linear Algebra Applications, Cryptology, Operations Research. Economics: Microeconomic and Macroeconomic Theory, Applied Econometrics, Industrial Organization, Environmental Economics, Accounting and Financial Analysis. Computer Science: Data Structures, Databases
Phillips Exeter Academy
Exeter, NH
2015-05
- Proctor/RA of dorm
- Sports editor of school paper (printed continuously since 1878, the oldest continuously-published prep school newspaper in the US)
- Men's volleyball captain, Varsity basketball
—— Skills ——
Python
Skilled
Data analysis, Web apps
SQL (Especially Postgres)
Skilled
CTEs, Triggers, Functions, Stored Procedures, Locks, Indexes, Handling Concurrency, Query Optimization
GraphQL
Skilled
Graphene, Dataloaders, Relay
Telemetry/Monitoring and Alerting
Skilled
Profiling, Logging, Traces, Reading flamegraphs, Datadog, Elasticsearch
JavaScript/TypeScript
Skilled
React, Next.js, jQuery, D3
DevOps
Proficient
Kubernetes, GitHub Actions, Terraform, ArgoCD, Helm, Vault, Autoscaling, Docker, Lots of AWS
Spreadsheets
Skilled
Formulas (lookups, filters, etc.), Google Apps Script
Go
Dabbling
NoSQL
Dabbling
Java
It's been a While
STATA
It's been a While
MATLAB
It's been a While
WordPress
It's been a While
Toolset, Dabbled w/ PHP in the process
—— Experience ——
Senior Backend Software Engineer
First Resonance
Los Angeles, CA
2022-01 → Present
- Heavily contributed to our main backend monorepo, consistently ranking highest in key GitHub metrics (commits, code changes, PRs, reviews) across the team
- Promoted to backend team lead and later—after an org restructure—led our most vital and trafficked domain team while personally shipping retention-critical features such as "mBOM Versions", per-step "Installation Requirements", "ION Actions" (rules engine), and "Instant Inventory History".
- Served numerous on-call rotations: unblocked customers, debugged production issues, coordinated customer communications, deployed targeted hotfixes, wrote postmortems, and drove post-incident resiliency work.
- Spearheaded internal tooling to accelerate developer velocity: adopted Ruff early, fixed and centralized local dev scripts, and built an operator-focused CLI for safe one-off analysis and jobs (e.g., running SQL across multiple DBs/schemas, generating DAG visualizations for architecture docs, and managing deploy schedules).
- Built a history service that transforms 10k+ audit rows/sec into context-rich, denormalized, customer-facing events—enabling near-instant visibility into the full history of any inventory item (including a 300M+ row backfill).
- Reduced local test iteration time by 30x by avoiding unnecessary test DB rebuilds, enforcing a rollback-based testing pattern, and implementing a custom bulk inserter (many times faster than the ORM)—later reused in production to speed up inserting many large trees of data.
- Oversaw and contributed to a fork of alembic_utils, ensuring consistent management of our SQL triggers, stored procedures, functions, and views.
- Significantly improved observability across the stack—especially for the API and database migrations—by recording key metrics, building dashboards, defining SLIs/SLO-style calculations, and crafting monitors (Elasticsearch/Sentry early; later Datadog).
- Wrote and reviewed complex database migrations while learning and evangelizing non-blocking, backward-compatible practices—executing large backfills and schema changes without production disruption.
- Contributed heavily to organizing and maintaining our Notion knowledge base as a reliable source of truth for engineering documentation.
- Interviewed, onboarded, and mentored engineers across senior, junior, and intern roles—boosting team productivity and ensuring rapid knowledge transfer.
Full Stack Developer
Spy Pond Partners LLC
Arlington, MA
2019-08 → 2021-12
- Constructed "portal" websites to provide transportation agencies with curated collections of relevant events, guides, reports, tools, web apps, and training resources
- Developed web apps to assist transportation agencies in the self-assessment of their own practice—in relation to other agencies and the goals and expectations set by federal transportation agencies (i.e. FHWA and AASHTO)
- Hosted sites and applications on AWS, Heroku, and DreamHost; on AWS, managed EC2, RDS, and Elastic Beanstalk, configured IAM/security groups, set up CodePipelines, and managed S3 buckets.
- Scraped, cleaned, analyzed, and produced visualizations for transportation project data to shed light on the interconnectedness of transportation agencies and their research projects
- Built Google Apps Script (JavaScript) automations to eliminate manual workflows (e.g., mail-merging Google Sheets data into Google Docs).
- Issued newsletters to alert agencies of upcoming publications, webinars, peer exchanges, and workshops and conducted surveys to gather client feedback for content improvement
- Tracked travel arrangements and reimbursements for national transportation agency workshops and peer exchanges to facilitate smooth travel for our clients
Math Gateway Exam Facilitator
Occidental College
Los Angeles, CA
2017-09 → 2019-05
- Administered proficiency tests to verify students' competencies in fundamental math skills at professor-designated checkpoints in their collegiate math courses
- Mentored and instructed failing and struggling students
- Encouraged students to further pursue Mathematics
Credit Analyst Intern
Bank of Nevada
Las Vegas, NV
2017-09 → 2019-05
- Analyzed and constructed reports for over 400 financial statements to facilitate assessment of borrowers applying for loans greater than $50,000
Instructor
Sparkskill
Las Vegas, NV
Summers 2016 → 2018
- Created and instructed curriculum for 3D Modeling and Printing, Robotics, and Minecraft coding course
- Cultivated students' STEM skills to spark interest in design, coding, and up-and-coming technologies