Andrew Poggione's Resume

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).

Andrew Poggione

Experience

Education

Skills