Vansh Agarwal

Developed a multimodal image retrieval system using FAISS, CLIP-ViT (Vision Transformer), and Flask, enabling image and text-based queries to improve search efficiency in large unstructured collections. Designed a data extraction pipeline from Mapillary and fine-tuned YOLOv8 and YOLOv9 models to detect CCTV cameras, achieving F1 scores of 68% and 81% on test sets to analyze their utilization, deployment, distribution, and privacy impact. Extracted and transformed data to identify racial discrepancies in sentencing within counties of California, employing advanced analytics to uncover potential biases. Designed an automated pipeline for a Yale University lab to extract and summarize court cases, enhancing accessibility through Flan-T5 and GPT-4 integration.

Researched and applied the Google Operations Research Tools VRP Solver to enhance logistics operations for John Deere. Tailored a solution with multiple capacities and resources, time windows, multiple visits, ordered visits, vehicle reloading, and other constraints, resulting in a 36% decrease in depreciation expense per productive hour.

Predicted candidate galaxies for deeper observation of Low Surface Brightness Structure (LSB) using galaxy simulations. Implemented a CNN in Keras/TensorFlow, achieving 83% accuracy in classifying low surface brightness galaxies.

Automated twelve global reports for McDonald's by building ETL pipelines, enabling data insights and boosting service speed by 39%. Extracted, transformed, and orchestrated data from multiple sources, including Redshift, SQL Server, and S3, using Databricks' Lakehouse; loaded the transformed data into Redshift and utilized Tableau for data visualization.

https://rapidleads.glideapp.io/ Launched a non-profit Covid-19 resources app with Glide Apps during India's critical second wave, featuring automated resource verification through users' actions, fraud detection, map integration, and more to address the urgent public health crisis. Coordinated a network of 200+ volunteers across India, gathered 1728 resource leads spanning 87 cities, and merged Rapid Leads with Covid Relief India Alliance (https://life.coronasafe.network/partners) for centralized data management.

Improved Hazard Detection game load time through lazy loading, enhancing user experience with boosted responsiveness. Built 10+ features, revamped 2 different pages, and debugged 60+ issues in the MyAccount section.

Handled Metamorphosis Entrepreneurship Olympiad, Sales, and Marketing. Developed a base for the organization in Delhi by linking the organization with a number of schools.