Serve as sole product software engineer since April 2025, responsible for end-to-end technical product management:

• Write complex data queries for terabyte-scale PostgreSQL databases, manipulate data using Pandas, and optimize existing queries, with speed improvements of up to 50x.

• Build data models and design REST API endpoints in Python/FastAPI.

• Manage library dependencies, monitor and triage Sentry-reported bugs, ensuring platform reliability for users.

• Craft feature-rich, interactive UI components, including graphs, maps, data filters, etc., delivering new features and improvements often ahead of schedule.

• Created new data pipelines using Apache Airflow, including a workflow to analyze transportation infraction data and send the personalized results to hundreds of city employees across the US.

• Helped modernize the frontend stack: migrated the codebase to TypeScript, integrated React Query and URL query parameters for improved data handling and state management, and established automated testing with Cypress and Vitest, significantly improving maintainability and development velocity.