Client Project

Vehicle Fleet Tracking

• Designed and deployed an IoT data pipeline using Supabase Edge Function to send GPS data from MQTT broker into hosted PostgreSQL, ensuring high data reliability and scalability.
• Engineered a geofencing feature and automated entry/exit detection, to provide transport clients real-time vehicle fleet visibility.
• Optimized SQL logic and PostgreSQL triggers for data aggregation and archiving, reducing query latency and faster display of vehicle's track history in the web application.

Technologies used:

• JavaScript/TypeScript
• Leaflet.js
• PostgreSQL
• Supabase

Client Project

Automated Reporting and Analytics

• Built Grafana dashboards (timeseries, bar, gauge, X-Y, dual-axis chart etc.) for a long term Oil & Gas client. Data flow from SCADA System to MySQL to Grafana.
• Built proof-of-concepts: data flow from Modbus to Grafana; Telegraf agent to Influxdb to Grafana.
• Developed VBA macros in Excel to automate formatted daily reports using data imported from VTScada, delivering automated daily reports directly to stakeholders' SharePoint drive.
• Optimized MySQL queries, reducing latency (dashboard load time).
• Served clients across the RnG, Oil & Gas and Solar industries in the USA, Denmark as an official systems integrator for enterprise SCADA platforms, Ignition and VTScada.

Technologies used:

• Grafana
• MySQL
• Excel Macro
• SCADA(ERP) Reporting Module

Personal Project

FastAPI Blog CI/CD & Load Testing

• Dockerized: Multi-stage build; compose-yaml file to deploy multi-container stack.
• CI/CD: Github Action pipeline to automate build & push to Registry. WatchTower polls for new image, re-deploys app.
• Monitoring: CloudWatch Agent, Grafana tracking node health, DB load, memory spikes.
• Architecture & workflow available in Github.
• Fully functioning blog, register, login and make posts, upload user profile pictures. Made following resources online, Corey Schafer in youtube

Technologies used:

• Python FastAPI
• SQLAlchemy
• Pydantic
• Pydantic

Funded Development Project

• Built a social awareness android game in collaboration with graphics and storyboard team. Had to learn a pythonic third party game engine called Ren'py.
• Our university team was awarded a grant by FNF Bangladesh and Preneur Lab to develop and publish the game (link).

Technologies used:

• Python
• Ren'py library