Chaitanya Gupta

Data Analyst @Illinois Department of Transportation

Springfield, IL, US

Owned High-Level & Low-Level Design of a state-wide traffic data processing system handling 50M+ monthly telemetry records from roadside IoT devices, weather stations, and safetymonitors- Designed scalable ETL pipelines (Python + SQL + Snowflake) reducing latency 45%, supporting real-time dashboards for government operations- Developed fault-tolerant signal resampling and synchronization modules to unify multi-frequency sensor feeds, eliminating 32% synchronization errors in downstream control systems- Implemented predictive fault detection algorithms on roadside electronics, enabling proactive maintenance and reducing downtime 18%- Collaborated with civil engineers, cloud architects, and product managers to deliver mission-critical public infrastructure systems with near real-time decision support