Abhay Kotal

Designed backend services for edge devices (Jetson TX2, Raspberry Pi) to store and sync AI-detected vehicle data.

Built REST APIs and dashboards using Django, DRF, and PostgreSQL for multi-location access monitoring and analytics.

Developed “Connect” – a cloud-based portal aggregating data from all edge devices for real-time insights.

Implemented TAT (Turnaround Time) alerts and vehicle intelligence features (brand, color, model detection).

Automated reports and alerts using Playwright, OpenPyXL, and email systems.

Optimized log storage using pg_partman and pg_cron with time-based PostgreSQL partitioning.

Integrated UPI (PhonePe) payments and dynamic parking pricing for 2W/4W vehicles.

Built async workflows with Celery, RabbitMQ, Redis, and APScheduler.

Reduced Docker image size by 50%+ for Python (using python-slim + multi-stage) and React (converted to Nginx static container).

Centralized routing and HTTPS handling with Nginx Proxy Manager, enabling future scalability and caching.

Implemented vector-based search using Milvus and LLM-generated embeddings for highway products.

Enabled semantic search of past incidents from vehicle images by converting natural language queries to vector format.

Deployed and managed infrastructure on Oracle Cloud Infrastructure (OCI) – VM instances, Object Storage, etc.

• Worked on developing Internal Application name Argon
• Argon is an application based on Django Framework in the background it is performing the job of Data pipelining where data from different application was dumped into our database from different application via parallel processing using celery
• Argon Frontend job is to manage different application from one application
• Different Operation can be performed on different application via argon
• This application was basically keeps the track of all the application that an employee has assigned and also via automations remove those application when an employee has left the org by following proper steps
• Worked on Mysql making queries for Data analytics part
• Technology used for making Argon application, Python, Django,Rabbit Mq,Nd Scheduler, Javascript, HTML CSS
• Docker Containers were used for Deployment into the Ubuntu based Vm
• Worked on Deploying some of the different open-source application like Snipe-IT, Passbolt on server

• Worked on Building Dashboard for Different Teams according to their requirements
• Analyzed Orders, Stock Related Data
• Worked on Inventory Forecasting Model
• Delivered Attractive Dashboard on Metabase Platform
• Worked on Snowflake Data Warehouse
• Made PHP Scripts for Data Dumping
• Used Fivetran for Data Migration from Mysql to Snowflake

• Worked on Project MyAccountBook , application like QuickBook for managing vendors automatic payment generation, invoice generation etc
• Worked on Developing Frontend as well backed for the application
• Developed Contact Module , Invoice Module for the application
• Developed Frontend landing page for the organization
• Developed Test case documents, Flow diagram etc