The Lodge
Download the file (PDF)

Yashank Kothari

Mumbai, India · kothariyashank@gmail.com · linkedin.com/in/yashankkothari · github.com/yashankkothari

Experience

Jul 2026 – Present · Mumbai, India

Data Engineer

ICICI Lombard

  • Built scalable ETL pipelines with 100+ PL/SQL stored procedures and triggers, raising data integrity and processing accuracy by 18%.
  • Replaced manual extraction and refresh cycles with automated, schedule-driven Oracle workflows, cutting daily load times by 25%.
  • Encoded BI logic (dynamic KPIs, aggregated metrics, derived columns) into ETL workflows using PL/SQL analytical functions for enterprise dashboards.
  • Wrote automated reconciliation scripts to resolve sync anomalies between OLTP systems and the OLAP warehouse.

Jan 2026 – Jun 2026 · Mumbai, India

Data Engineering Intern

Colgate Palmolive

  • Designed a Medallion data model (Staging, Curated, Consumption) in dbt and Jinja-templated SQL for BI reporting in Domo and Sigma.
  • Built idempotent Apache Airflow pipelines moving high-volume data from Google Cloud Storage to Snowflake.
  • Supported the SAP ECC to SAP S/4HANA migration: remediated legacy tables, updated transformations, validated for zero-defect production data.
  • Built a natural-language query interface in Retool AI so business teams could query databases without writing SQL.

Jun 2025 – Jul 2025 · Bangalore, India

AI/ML Intern

Card91

  • Integrated the Tazama open-source fraud detection engine, porting core rule logic from TypeScript to Python.
  • Implemented 30+ transaction rules across P2P and P2B flows, reducing false positives and reaching 98.5% detection accuracy.
  • Added Google Maps API geolocation checks for real-time verification of transaction locations.

Education

Oct 2022 – May 2026

B.Tech, Computer Engineering, Honours in Data Science

K.J. Somaiya College of Engineering, Mumbai

Projects

2025 · Next.js, React, TypeScript, PWA

NotesAid

An open-source study companion that 2,700+ students found on their own.

2025 · Docker, VirusTotal API, Browser Extension, JavaScript

MalNotWare

A browser extension that watches what you download, then watches what it does.

2025 · MobileNetV2, MediaPipe Model Maker, React Native, Expo, Flask

OncoLytix

A phone app that reads lung CT scans and returns a prediction in seconds.

Certifications

Skills