Abhay Kotal

• Designed, developed, and maintained scalable RESTful APIs (DRF) for a high-availability vehicle access control/surveillance system across multiple environments.
• Engineered and optimized backend services for resource-constrained edge devices (NVIDIA Jetson, Raspberry Pi), enabling local AI processing and reliable cloud data synchronization.
• Developed comprehensive data analytics dashboards (PostgreSQL, Django) providing real-time insights into vehicle movement and access patterns.
• Architected and built "Connect," a centralized cloud portal aggregating real-time data streams from numerous edge devices.
• Improved database query performance through PostgreSQL partitioning (pg-partman, pg-cron) and indexing.
• Reduced Docker image sizes significantly (~50% backend, ~90% frontend) via multi-stage builds and Nginx static file serving.
• Implemented automated system functions: real-time alerting (TAT, blacklists), rule-based hardware control, and multi-format report generation (Email, PDF, Excel).
• Built distributed, asynchronous task systems (Celery, RabbitMQ, Redis) for efficient background job handling.
• Implemented an end-to-end semantic search solution using Milvus vector database and LLMs on OCI for efficient incident retrieval.
• Managed application deployment and infrastructure on Oracle Cloud Infrastructure (OCI).

• Developed "Argon," a central Django app automating management of multiple SaaS platforms, reducing operational overhead and contributing to ~$4k+/month cost savings.
• Deployed and managed open-source Snipe-IT (asset management) and Passbolt (password management), enhancing security and organization while saving costs on equivalent SaaS subscriptions.
• Engineered scalable data pipelines (Celery, RabbitMQ) to ingest IT operational data into Zoho Analytics for centralized reporting.
• Improved system compliance visibility by creating automated data flows into a central analytics dashboard.
• Integrated disparate SaaS applications (G-Suite, Slack, OpenVPN) via APIs into the unified Argon interface.
• Designed and implemented automation workflows for user lifecycle management (account provisioning/de-provisioning, policy enforcement).
• Utilized Python, Django, Celery, RabbitMQ, and Docker for building internal tools and automation.

• Developed interactive data visualization dashboards (Metabase) for key business metrics (Inventory, Orders, Warehouse).
• Performed data analysis on operational datasets to identify trends.
• Gained experience with cloud data warehousing (Snowflake) and ETL tools (FiveTran) for data migration (MySQL to Snowflake).

● Contributed as an intern to the backend development of a Django-based accounting application ("MyAccountBook").
● Assisted in the implementation of core application modules, gaining experience in feature development for invoicing and contact management.
● Created technical design artifacts (Class Diagrams, Flow Diagrams) to communicate application structure and logic.
● Gained initial web development experience by contributing to feature enhancements on the company's landing page.