Hi there!

It's Deepanshu.

I'm a Computer Science student and builder working across AI, product, growth, and execution. I've spent my time in early-stage startups, where the fastest learning happens by being involved in everything.

At PicaPool, I work in the Founder's Office, building AI systems, internal tools, analytics infrastructure, attribution systems, and automation. At UniLyf, I worked across product and growth, using user behaviour and retention data to shape product and launch decisions. I also build and ship products independently — ProofMart, Gapl and LpuTV — and run Deepanshu Labs, a small software studio whose first product is a WhatsApp AI receptionist.

What I care about:

  • Building useful products
  • Understanding distribution
  • Creating leverage through technology
  • Learning how companies scale
  • Turning ideas into shipped systems

I like being close to both the problem and the implementation. Build. Measure. Learn. Iterate.

From G15 to MacBook Air

Five years ago, my family bought me an Asus ROG G15 — on sale, and still more than they should have spent. They never once told me to pick something cheaper. They asked what I actually needed, and paid for it.

I told them then: the next one is on me. In January I gave myself six months to make that true. The deadline was July.

On 15 August — six weeks late, but here, and mine — the G15 retired. Its replacement: a MacBook Air M5, bought with my own money.

It was never once the reason something didn't ship. Neither is the new one.

Portrait of Deepanshu Lathar

Experience

A timeline, not a list.

Résumé (PDF)
  1. Jul 2025 — Present · Current

    AI Intern · Founder's Office

    PicaPool · Delhi · On-site

    • Built a read-only AI data analyst over a 79-table PostgreSQL schema that parses and validates LLM-generated SQL before it runs, removing the injection surface; deployed a Telegram RAG bot on the analytics layer.
    • Shipped 15+ production internal tools in 8 weeks, including a CRM with role-based access, a WhatsApp Business API dashboard, campaign attribution and merchant onboarding, with the CTO advising on database design.
    • Engineered event-fingerprinting attribution across on-ground and digital funnels, replacing download counts with per-channel visibility for spend decisions.
    • Automated daily KPI digests and n8n workflows; the attribution and CRM tooling supported a two-month campus push that reached 3,000+ students.
  2. Jan 2026 — May 2026

    Product & Growth Intern · Founder's Office

    UniLyf · Remote · London Area, UK

    • Instrumented a demand-validation framework across 200+ profiled beta users; cohort analysis isolated the actions that correlated with Day-7 retention.
    • Led a cross-functional team of 6 across growth, content and deployment, owning sprint planning, task allocation and release accountability for a pre-launch product.
    • Turned the signals into a phased go-to-market plan and launch priority order, and grew a 100+ member insider community as the first testing cohort.
  3. Jun 2025 — Feb 2026

    Web Development & Growth · Freelance

    Delhi

    • Launched and ran a Shopify storefront for Spraykart LLP: store setup, catalogue configuration and uninterrupted orders.
    • Ran SEO and lead generation for YourProfessional, a chartered-accountancy practice, lifting organic visibility and bringing in inbound client leads.
  4. 2025 — Present · Three campus roles

    Campus roles

    LPU and Delhi

    • LPU Division of Admissions, part-time intern (Jan 2026 — present): SEO-optimised content and storytelling for the university's channels.
    • Student Organization Cell, HR Coordinator (Jul 2025 — Aug 2026) after Event Coordinator (Mar — Jul 2025); member to HR Coordinator of a 10–15 person team in four months.
    • INGLU, Regional Manager intern (May — Jul 2025): campus outreach, events and digital promotions.

Skills

Tools I actually ship with.

Languages — TypeScript, JavaScript, Python, C++, SQL

Also: C (certified)

TypeScript runs ProofMart and Gapl end to end; JavaScript powers LpuTV's client and signaling server. Python is my analytics language at PicaPool, C++ ran the ESP32 firmware in the Vehicle Pollution Monitor — and SQL is where the attribution ledger lives.

Frontend — React, Next.js, Tailwind, Vite, HTML, CSS

Next.js ships both ProofMart and Gapl — UI, API routes and middleware in one codebase. React + Vite drive LpuTV's chat and video client, and Tailwind kept PicaPool's campus experiment pages shipping in hours, not days.

Backend — Node.js, Express, REST, Socket.IO, WebRTC

Also: FastAPI

Next.js route handlers serve ProofMart's inspect, upload and billing APIs. Node + Express 5 run LpuTV's API and signaling server, with Socket.IO carrying real-time matching and chat and WebRTC carrying peer-to-peer video.

Data & infra — PostgreSQL, Supabase, Firebase, SQLite, MongoDB, Docker

Also: AWS

Supabase (Postgres) holds ProofMart's users and documents, with files in Vercel Blob. Firestore runs Gapl's users, reports and email campaigns, and SQLite keeps LpuTV's friend graph light. MongoDB and Docker ran the Advanced Backend capstone.

AI & Tools — LangGraph, n8n, OpenAI, Anthropic, Gemini, Tesseract OCR, Git, Linux, Vercel

Also: LangChain, OpenCV

LangGraph agents and n8n automations run PicaPool's internal tooling. Gapl sends every analysis through a multi-model AI gateway (Groq, OpenAI, Anthropic, Gemini); ProofMart runs Tesseract OCR on scanned pages. Git, Linux and Vercel hold the pipeline together.

Growth & marketing — SEO, email marketing, marketing automation, attribution modelling

Funnel analysis, cohort retention and A/B testing come from running PicaPool's campus launches and UniLyf's demand validation; Figma for the mock-ups in between.

Credentials

All listed on LinkedIn.

  • McKinsey Forward Program
    McKinsey & Company
    Apr 2026
  • Advanced Backend Development, Grade A
    LPU Centre for Professional Enhancement
    Jul 2026
  • Data Analytics Job Simulation
    Deloitte Australia, via Forage · ID BaQLf9u7dkdyLE4L2
    Sep 2025
  • Young Innovator Internship Challenge, Edition 2
    Scaler School of Technology
    Jun 2025
  • Digital Marketing
    HubSpot Academy
    Jul 2025
  • C Programming
    iamneo, an NIIT venture · ID 25dM7bj5dk7bI5Am0B21
    Apr 2025