——
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 few years. Please reach out if you want to collaborate! I'm always excited to work on new projects!
—— Projects ——
AASHTO TAM Data Assistant
2020- Designed Django app for transportation agencies to assess their data management practices, select and prioritize applicable improvements, and produce results for presentation to agency executives
- Fulfilled and adapted to the ongoing desired features and changes of the project’s research panel—such as adding a group assessment workflow enabling users to invite others to their assessment, monitor and manage group statistics, select consensus respons
- Led the development team and contributed 95% of the repository’s code base as the sole member of the development team with Django experience
AASHTO Transportation Portals
2019-2021- Developed an interconnected Wordpress multi-site network to provide access to transportation management resources and to 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
—— 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
- Men's volleyball captain, Varsity basketball
- School newspaper sports editor
- Proctor/RA of dorm
—— Skills ——
Python
Skilled
Data analysis, Web apps
GraphQL
Skilled
graphene, dataloaders, relay
Telemetry/Monitoring and Alerting
Skilled
profiling, logging, traces, reading flamegraphs, Datadog, Elasticsearch
Javascript
Skilled
React, d3, jQuery, Next.js
WordPress
Proficient
Toolset, Dabbled w/ PHP
Spreadsheets
Skilled
Formulas (lookups, filters, etc.), Google App Script
Devops
Proficient
Kubernetes, Terraform, ArgoCD, Autoscaling, Docker Images, GitHub Actions, AWS (RDS, ECR, security groups, Cloudwatch, ...)
Java
It's been a While
STATA
It's been a While
MATLAB
It's been a While
—— Experience ——
Senior Backend Software Engineer
First Resonance
Los Angeles, CA
2022-01 → Present
- Foremost contributor to the main backend monorepo, consistently ranking highest in all key GitHub metrics (commits, code changes, PRs, reviews) both overall and across nearly any time slice
- Grew into and promoted to the backend team's lead and, after an eng org restructure to domain driven teams, headed our most-vital and trafficked domain team: leading key churn-risk features like "mBOM Versions", per-step "Installation Requirements, and "ION Actions" (our rules engine) while driving down our bug queue.
- Spearheaded tools to accelerate developer velocity: 1) a cli tool to execute scripts across multiple DBs and schemas for one-off jobs and investigations prior to/after writing DB migrations, build visualizations for our trees and DAGs, pull data from key tools like Sentry and Linear, and more; 2) ruff for faster linting, sorting imports, and reducing git diff clutter; 3) built a robust Makefile for tasks like code regeneration, DB management, and DB migrations, 4) pre and post commit hooks for atuomated feedback and to guard against bad CI runs
- Achieved 30x iteration times for local test execution by not rebuilding test DB on every test session, making all tests conform to our rollback pattern, and writing a custom bulk inserter - many times faster than our ORM, which I later utilized in production to vastly improve the speed of copying 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.
- Vastly enhanced monitoring and visibility by persisting stats of our DB migrations, by tagging key data from FE to BE for Elasticsearch and Sentry, and - after changing vendors to Datadog - by developing tagged traces, metrics, dashboards, and alerts
- Reviewed and led difficult DB migrations to eradicate old legacy patterns like migrating our audit table from hstore to jsonb and changing the tree structure for aBOMs, which required both high technical aptitude and communication with product and customers
- Identify key bottlenecks mainly via pyinstrument profiles and production logs and traces and acclerate API response times: eg writing a sql function for a large json agg ("Run Step Snapshots", optimize updates to users last_login, replace api calls for our barcode label generation worker, developing framework for resolving graphql aggregate and grouped/distinct fields server-side, constructing prefetching/eager-loading of multi-relationship-path dependent ORM properties establishing pattern for building ORM objects from sql views instead of raw tables
- Refactored the barcode label preview worker for improved reliability and maintainability.
- Resolve critical hotfixes and incidents, ensuring system stability and minimal downtime—squashing a company-leading number of fires.
- Established a centralized Notion directory, improving organizational knowledge sharing and documentation standards.
- Define and promote effective database migration philosophies, enhancing development practices and reducing risks.
- Onboard and mentor numerous engineers, including senior, junior, and intern roles, fostering team growth and knowledge transfer.
- Create a generic label component in the frontend (FE) for UI consistency.
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 and—for AWS specifically—host EC2, RDS, and Elastic Beanstalk instances; managed user roles and security groups; established CodePipelines; and configure 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
- Developed Google Script Editor (JavaScript) scripts to automate cumbersome tasks which had been processed prior manually (i.e. “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 of 2016 → 18
- 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