1. Built a full-stack web application using Python and TypeScript for analyzing the conductor sag and temperature relationship from time-series data and plotting it for the user
2. Created internal tools to simplify device health monitoring, inventory, and device installation to manage IoT devices
3. Devised script to flash firmware remotely on sensor devices using bash, paramiko and Python, decreasing touch time by 90%
4. Reduced data access latency by 50% by constructing caching mechanism for frequently used data using AWS S3
5. Optimized existing tools by refining PostgreSQL queries and refactoring DataFrame manipulation to further speed up data access
6. Engineered a trigger-based sensor data processing mechanism by utilizing an AWS SQS queue, cutting artificial latency by 100%