Back to projects
Congressional Oversight Platform
PythonPostgreSQLETLLLMsRedisGIS
Full-stack civic tech platform processing 328,000+ government records via Python ETL pipelines and LLM extraction.
Architected a comprehensive civic-tech web application delivering intuitive geographic visualization for congressional oversight. Solved the fragmented government data problem by building a unified data infrastructure.
Key Technical Achievements:
Key Technical Achievements:
- ETL Orchestration: Engineered a 5-pipeline system with topological dependency resolution, processing 1.44 million operations in under 2 minutes.
Complex Modeling: Designed PostgreSQL schema with 21 tables and GIS extensions, supporting sub-second queries across 39 committees.
AI Integration: Deployed LLM extraction pipeline across 520+ government websites for contact info with 100% accuracy via heuristic validation.
Real-time Data: Implemented Redis cache for live streamed tracking of congressional updates.