Mohan Ranganath — Data Engineer
Mohan Ranganath Varma Vummadisetty. Snowflake-focused data engineer at Prolim AI, a Snowflake Elite Partner — one of four Best Performer Award recipients (Apr–Sep 2025), and the sole Impact Maker named in Oct 2026, for client appreciation. Eight client engagements across live CDC, migrations, performance engineering, orchestration and life-sciences analytics; I've converted four source platforms to Snowflake SQL: SAP ABAP, T-SQL, MySQL and PostgreSQL. Outside work I build things because I want them to exist — desktop apps, automation, AI experiments, and this world you're standing in.
Skills: Snowflake, SQL, Python, PySpark, ETL / ELT, Data Warehousing, Dimensional Modeling, Query Optimization, Dynamic Tables, Task Graphs, Streams & Tasks, Iceberg Tables, Streamlit, FastAPI, Data Sharing, Life Sciences Analytics, Patient Journey Modeling, Retail / POS Analytics, Marketing Analytics, Clinical Trial Data.
Professional work
Data Engineer at Prolim AI (formerly Kasmo Digital) (Dec 2024 — Present)
A Snowflake Elite Partner with 200+ consultants. Joined as Kasmo Digital in Dec 2024; PROLIM acquired and rebranded it a year later. Eight client engagements across life sciences, freight and logistics, retail POS, marketing analytics, decentralised storage, home interiors and field services — five of them US accounts, each with direct client contact from kickoff through go-live.
MySQL Conversion — Home Interiors · India. First Snowflake work: MySQL queries and procedures, converted and validated. Converted workloads validated against source behaviour. This was the introduction to Snowflake that everything since is built on.
Iceberg Storage POC — Decentralised Storage · US. 1 TB to Iceberg — under 45 minutes and under $4. Processed 1 TB to Iceberg inside both limits, and drove the write failure to resolution with Snowflake support and vendor engineering. Proof that performance engineering is a feature, not an afterthought.
SQL Server Migration — Field Services · US, PE-backed. Over 1 TB migrated, and a 7-hour batch window cut to 2. The batch window fell from 7–8 hours to roughly 2, with dependency-aware orchestration replacing clock-time scheduling. Automation moved the data; the procedural logic was translated by hand.
POS Analytics Migration — Retail Point of Sale · US. 35 reporting queries: 13 minutes down to under one. Runtimes fell from over 13 minutes to under a minute — several of them sub-second — with the warehouse size held at S. Same data, a fraction of the wait and none of the extra spend.
Oncology Analytics Warehouse — Life Sciences · US. A life-sciences enterprise data warehouse I own end to end, in a daily one-to-one with the client's data lead. (Current) The client credits the weekly outputs with field-sales leads that led to treatments for patients who would not otherwise have been reached. Underneath it: gated weekly orchestration where a failed run reruns only its failed steps, an SFTP feed and a Microsoft Graph API stored procedure replacing a costly managed ingestion service, Delta Sharing from Databricks with OIDC federation, and 22 Streamlit apps that let the client update and control data through a UI instead of code — forecast data entry among them, in production use.
Logistics CDC Platform — Freight & Logistics · India. 419 MySQL tables and ~12M transactions a day, landing in Snowflake every hour. (Current) Hourly and live since August 2026. Validation of the Redshift history found a 5.5-hour timestamp shift across roughly 258 million rows — every row from the full load, none from the incremental — before anyone reported on them.
Pulled-in Engagements — SAP ABAP & Marketing Data. Pulled onto two slipping engagements while already sole DE on another. Together with the other engagements these complete a four-source-platform conversion record — SAP ABAP, T-SQL, MySQL and PostgreSQL to Snowflake SQL. Almost no Snowflake engineers carry the SAP side of that.
Personal builds
Quarry — Web Data Acquisition / Snowflake Native App. It discovers the schema before it harvests anything.
Watch Party — Real-time Web App. Watch together, webcams in sync.
Automation Utilities — Developer Tooling. If I do it twice, I script it.
Raphael — Local-First AI Assistant. An AI assistant that lives inside my Linux desktop.
This Portfolio — Interactive 3D Web. The world you're standing in right now.
AI Playground — AI / LLM Engineering. Not just using AI — taking it apart.
Linux
Linux is probably my favorite hobby. I enjoy customizing every layer of my environment until it feels personal, efficient, and genuinely fun to use.
Contact
Whether it's a data platform that needs building, a pipeline that needs to be faster, or just an interesting problem — I'd like to hear about it.
mohanvarma130@gmail.com · GitHub · LinkedIn · Resume (PDF) · Text version of this portfolio
zone 01 / 06
Arrival Hub
Mohan Ranganath — Data Engineer
Scroll to explore ↓
preparing the world — 0%