Dhruvil Hirani

1. Contributing to backend micro services development using Python, AWS, SQL, and GraphQL, improving system performance, scalability, and data efficiency. 2. Developed a Retrieval-Augmented Generation (RAG) system using LLM embeddings to resolve textual ambiguities.

1. Designed and optimized SQL stored procedures for daily KPI calculations on ~1B records, reducing pipeline runtime from 1 hour to 14 minutes using window functions instead of nested joins. 2. Built a Python-based data ingestion tool to fetch and process ~10K+ records from paginated APIs; improved execution time by ~45% using multiprocessing and message queues.

1.Designed and developed an end-to-end internal web application with Django REST APIs and MySQL, implementing role-based access control and approval workflows and reducing latency by ~30–40% through caching and backend optimizations. 2.Developed end-to-end data pipelines to ingest and process 30 GB+ of daily API data with multiple data dependencies using Python and Google Cloud Dataflow; stored results in BigQuery with intermediate storage on Google Cloud Storage.