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.

- Owned a Python + SQL ingestion service moving SAP Analytics Cloud data to BigQuery with dedup, retry, and redrive-from-failure - with transactional stored procs and SCD Type 2 tables powering revenue reporting. - Cut BigQuery compute time from 1 hour to 14 minutes on 1B+ record datasets by rewriting critical SQL procedures — sped up revenue and COGS reporting for finance stakeholders.

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.