——
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!
(Last update: 2026-03-11)
(Last update: 2026-03-11)
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
Backend services, APIs, Testing, CLI tooling, Concurrency, Performance tuning
Agentic Engineering
Proficient
Claude Code/Codex/Open Code, AGENTS.md / skills, MCP-backed workflows, Tuning AI PR Reviews
SQL (Especially Postgres)
Skilled
Schema design/Data modeling, CTEs, Triggers, Functions, Stored Procedures, Transaction management, Data integrity, 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
- Accelerated backend delivery in a large Python monorepo, ranking at or near the top of the team in commits, code changes, PRs, and reviews by owning high-priority backend work across product, platform, and operational needs.
- Earned promotion to backend team lead and later led our highest-traffic domain team by shipping retention-critical backend features including mBOM Versions (versioned DAGs), Installation Requirements (linking versioned DAGs), ION Actions (our hand-rolled rules engine), and Instant Inventory History (our event processor).
- Restored customer workflows during numerous on-call rotations by debugging backend failures, deploying targeted hotfixes, coordinating communications, and driving follow-up resiliency work.
- Improved engineering throughput by adopting Ruff early; centralizing local dev scripts; building an operator-focused Python CLI for cross-tool and cross-tenant diagnostics and analysis; and fine-tuning AI review prompts and agent instructions for higher-signal code review output.
- Delivered near-instant visibility into the lifecycle of inventory on the factory floor by building a Python/Postgres history service that transforms 10k+ audit rows/sec into context-rich, customer-facing events and supports 300M+ row backfills.
- Reduced schema drift and improved database change safety by forking and extending alembic_utils to manage triggers, stored procedures, functions, and views as code.
- Reduced local test iteration time by 30x by avoiding unnecessary test DB rebuilds, enforcing a rollback-based Python testing pattern, and implementing a custom module for bulk insertions often >10x faster than our ORM; the same approach was later reused in production for large tree inserts.
- Drastically improved production visibility across the API and database migration pipeline by instrumenting key metrics, building dashboards, defining SLI/SLO-style calculations, and creating monitors in Grafana, Elasticsearch, Sentry, and Datadog.
- Reduced migration risk during large backfills and schema changes by writing and reviewing complex Postgres migrations and pushing non-blocking, backward-compatible migration practices across the team.
- Improved engineering knowledge sharing by organizing and maintaining our Notion knowledge base as a reliable source of truth for technical documentation and operational context.
- 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
- Built client-facing portal websites and web applications that gave transportation agencies curated access to events, guides, reports, tools, and training resources.
- Developed Django-based assessment applications that helped agencies evaluate their own practices against peer agencies and federal standards from FHWA and AASHTO.
- Owned deployment and hosting across AWS, Heroku, and DreamHost, including EC2, RDS, Elastic Beanstalk, IAM, security groups, CodePipeline, and S3.
- Scraped, cleaned, analyzed, and visualized transportation project data to reveal relationships between agencies and research initiatives.
- 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 400+ financial statements and built lending reports used to assess 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