Mohan Ranganath

Data Engineer

Data engineer at Prolim AI specializing in Snowflake: migrations, performance engineering, ETL, and healthcare analytics. Outside work I build things because I want them to exist — desktop apps, automation, AI experiments, and this world you're standing in.

This is the lite version. Explore the interactive 3D world instead →

Skills

Core

SnowflakeSQLPythonETL / ELTData WarehousingQuery Optimization

Platform

StreamlitFastAPIREST APIsDynamic TablesTask GraphsIceberg Tables

Domain

Healthcare AnalyticsPatient Journey ModelingForecastingClinical Trial DataCommercial Reporting

Professional Work

Prolim AIDec 2024 — Present

Data Engineer

Joined as an intern in Dec 2024, full-time data engineer since Jul 2025 — five client engagements, five different classes of data problems.

Homelane

Data Engineering Intern · Home Interior & Design

First migration: MySQL to Snowflake.

Problem — Legacy MySQL workloads — queries and stored procedures — needed to move to a modern cloud data warehouse without breaking downstream behavior.

Work — Converted queries and stored procedures to Snowflake SQL, resolved dialect incompatibilities, and validated migrated workloads against the originals.

Outcome — Workloads migrated and validated. This project was my introduction to Snowflake and cloud data warehousing — the foundation everything since is built on.

MySQLSnowflakeSQL

Akave

Data Engineering Intern · Performance Engineering POC

A workload with a stopwatch and a $4 budget.

Problem — A proof-of-concept with hard constraints: complete the full execution in under 45 minutes, keep total cost below $4, and export results to external Iceberg tables.

Work — Redesigned and iteratively optimized queries — restructuring logic, tuning warehouse usage, and wiring up external Iceberg integration — until every run satisfied both constraints.

Outcome — Consistently hit both the runtime and cost targets with correct outputs. Proof that performance engineering is a feature, not an afterthought.

SnowflakeSQLIceberg Tables

Certus

Data Engineer · Enterprise Database Migration

SQL Server procedures, reborn as Task Graphs.

Problem — A full-scale migration from Microsoft SQL Server to Snowflake, including procedural execution chains that had no direct equivalent in the target platform.

Work — Converted SQL queries and stored procedures, then recreated the procedural execution chains as orchestrated Snowflake Tasks and Task Graphs with proper dependency management.

Outcome — An enterprise workload running natively on Snowflake with automated, dependency-aware orchestration replacing manual procedure chains.

SQL ServerSnowflakeTasks & Task GraphsStored Procedures

Supersonic POS

Data Engineer · Retail / Point of Sale

Cut pipeline execution time by ~80%.

Problem — Existing pipelines were correct but slow — execution time needed to drop dramatically without changing results.

Work — Profiled and rewrote queries, tuned warehouse usage, and rebuilt key transformation steps on Snowflake Dynamic Tables.

Outcome — Roughly 80% reduction in execution time with identical outputs. Same data, a fifth of the wait.

SnowflakeDynamic TablesSQL

Delcath

Data Engineer · Healthcare Analytics

A healthcare analytics platform, end to end. (Current)

Problem — A large healthcare analytics platform needs continuously evolving datasets for reporting, forecasting, commercial analytics, and clinical insights — with strict data quality expectations.

Work — Design and maintain analytical models across patient journey, referral, forecasting, and marketing analytics. Automated clinical trial data ingestion, built internal Streamlit tools, integrated REST APIs via FastAPI, and continuously improved transformation logic and data quality.

Outcome — Ongoing: multiple production pipelines and analytical models powering clinical and commercial decisions, with steadily improving quality and automation.

SnowflakeSQLPythonStreamlitFastAPIREST APIs

Personal Builds

Curiosity projects — built because I wanted them to exist.

Migranix

Creator · Desktop App / Data Tooling

Database migrations to Snowflake, without the pain.

Problem — Database migration is something I do professionally — and the tooling around it always felt heavier and less friendly than it should be.

Work — Building a desktop application that makes migrating databases into Snowflake approachable: an intuitive interface over the messy workflow of moving schemas and data.

Outcome — Combines everything I enjoy: database engineering, cloud, UI design, and workflow automation — in one tool I actually want to use.

Desktop AppSnowflakeDatabasesUI DesignAutomation

Watch Party

Creator · Real-time Web App

Watch together, webcams in sync.

Problem — Two people, one movie, different places. Existing tools made shared watching clunky.

Work — Built a real-time watch party app where playback stays synchronized while both webcams stream — exploring WebRTC, state synchronization, and real-time UX.

Outcome — A working app, and a crash course in the hard parts of real-time communication on the web.

WebRTCReal-time SyncFrontend Engineering

Automation Utilities

Creator · Developer Tooling

If I do it twice, I script it.

Problem — Repetitive tasks accumulate silently — in development workflows, file handling, and daily routines.

Work — A growing collection of small utilities and workflows that automate repetitive work: dev-environment helpers, file processors, and glue between tools that don't talk to each other.

Outcome — Automation became one of my favorite areas of engineering — most of these tools save minutes daily, forever.

PythonShellAPIsWorkflows

Raphael

Creator · Local-First AI Assistant

An AI assistant that lives inside my Linux desktop.

Problem — Cloud assistants don't belong in every corner of a personal machine. I wanted a persistent assistant that runs fully locally — inside the desktop environment I'd already built.

Work — Building Raphael into my Caelestia (Quickshell) setup on Hyprland: a QML drawer for the face, a FastAPI brain streaming from a local model via Ollama, one milestone at a time — chat first, then memory on Postgres + pgvector, then approval-gated actions.

Outcome — The first vertical slice runs: one keybind slides the drawer in and replies stream from a fully local model, themed to match the rice. Memory and safe actions are next on the roadmap.

PythonFastAPIOllamaQML / QuickshellHyprlandpgvector

This Portfolio

Creator · Interactive 3D Web

The world you're standing in right now.

Problem — A resume tells you what I've done. It can't show you what I love building — experiences where engineering and design meet.

Work — Designed and built this interactive 3D world: Next.js and React Three Fiber, GSAP scroll choreography, custom shaders for the data pipelines, and AI-generated hero assets compressed from 380MB of raw output into a world that loads in seconds.

Outcome — You're inside it. If it made you scroll one zone further than a PDF would have — it worked.

Next.jsThree.jsReact Three FiberGSAPTypeScriptMixar AI

AI Playground

Explorer · AI / LLM Engineering

Not just using AI — taking it apart.

Problem — AI tooling moves fast, and reading about it teaches you almost nothing compared to building with it.

Work — Continuous experiments with AI agents, Claude Code workflows, local LLMs, MCP servers, prompt engineering, and ComfyUI pipelines — integrating them into real engineering workflows.

Outcome — A practical understanding of how modern AI systems actually behave — and a toolbox of working integrations.

AI AgentsClaude CodeLocal LLMsMCPComfyUI

Linux & Beyond

Linux is probably my favorite hobby. I enjoy customizing every layer of my environment until it feels personal, efficient, and genuinely fun to use.

Daily driver

Hyprland window managerCaelestia shell — with Raphael, a built-in local AI assistantCustom dotfiles, managed and versionedNeovimTerminal-first workflowsShell scriptingDesktop ricing

Currently exploring

Three.js & React Three FiberGSAP & motion designBlenderAI Agents & MCPGraphics programmingLocal AI

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