ABHINAV JAIN
PORTFOLIO
INITIALIZING
Home About Experience Projects Skills Achievements Leadership Certificates Publications Contact Resume ↓
Portfolio

ABHINAV

Scroll

Working at the intersection of markets, data, and the things you can build when the two meet.

SQL Python Pandas Scikit-learn Statistics Product Metrics Power BI Data Analytics
View all skills Click to view all skills Scroll
Open to opportunities
FINANCE
DATA
MARKETS
Abhinav Jain
01 / ABOUT & EXPERIENCE

THE STORY

Finance, data
and the systems
where they meet

Who I am

Electrical Engineering, NSUT Delhi

Finance and data is where I actually spend my time. I picked up SQL and Python to answer my own questions about markets, and the same tools turned out to answer most business questions too. What I like is problems that don't have an obvious answer. Most analysis stops at what moved. Why it moved is the harder question, and usually the only part worth asking.

  • Building data products, start to finish.
  • Reading Indian markets, IPOs mostly.
  • Teaching finance to 400+ students at NSUT.
  • SQL for the business questions nobody has phrased properly yet.

Product Intern

May 2026 – July 2026

Kents Coffee, D2C coffee brand

Problem

Customers could not decide which coffee to buy. Someone landing on the site had several beans in front of them and nothing telling them which one suited how they actually drink coffee. The choice itself became the blocker, and that confusion sat right before the point where people were supposed to pay.

What I did

Tracked North Star and funnel metrics in GA4 and Wix Analytics to follow how customers moved through the site rather than how many landed on it. Split product performance across all three channels using sales and inventory KPIs.

Impact

Mapped the customer journey from first visit to checkout and turned it into UX recommendations for the brand's new website. Most of them were about making the choice easier, not adding more to the page.

Tools
GA4 Wix Analytics Excel Funnel metrics Journey mapping
02 / PROJECTS

SELECTED
WORK

05PROJECTS SHIPPED
How these were built

Causa, the KPI diagnostic engine, and the IPO Listing Gain Predictor are entirely mine, from the idea through to the finished build. The vendor performance analysis and the SQL data warehouse were my first time using SQL and Python inside a project rather than for problem solving, so I followed guided tutorials to get started and then extended them with my own analysis, visualisations and optimisations to take them past where the tutorial stopped. Dish Discovery is a product improvement case study, not a build.

AI · KPI Root-Cause Engine

CAUSA
DIAGNOSTICS

  • Upload any sales file and the tool explains why a KPI moved, not just that it moved.
  • The heavy statistics run inside the database, so each analysis costs almost nothing to run: 479K tokens down to 430.
  • Covers revenue, profit, customers, products and regions, and every number comes with the SQL query behind it.
#built_from_scratch FastAPI PostgreSQL SQL Pandas HTMX OpenAI API
🧭
Root-Cause Engine
Machine Learning · Markets

IPO LISTING
GAIN PREDICTOR

  • Predicts listing-day gains for Indian IPOs, trained on 310+ mainboard IPOs (2022–2026) collected by web scraping.
  • Tested the honest way: train on the past, predict forward. That gives R² 0.50 instead of a flattering 0.55 from a random split.
  • Running as a live web app. Grey-market premium alone predicts nothing on its own; the model supplies the missing scale.
#built_from_scratch Python scikit-learn Pandas FastAPI Walk-Forward CV
📈
Listing Gain Model
Data Analyst · Science

VENDOR
PERFORMANCE

  • Built a SQL pipeline that turns raw purchase and sales data into clean vendor-level summaries.
  • Tested profitability, pricing and inventory turnover in Python to see which vendors actually earn their place.
  • The Power BI dashboard surfaced $2.71M stuck in slow-moving stock and a heavy dependence on a few vendors.
#learning_project SQL Python Power BI EDA ETL
📊
Vendor Performance
Data Engineering

DATA
WAREHOUSE

  • Combined ERP and CRM data into one SQL Server warehouse, cleaned and ready for analysis.
  • Designed a star schema so sales, customer and product questions are one query away instead of a week of joins.
#learning_project SQL Server ETL Star Schema Notion
🗄️
Data Warehouse
Product Improvement

ZOMATO
DISH DISCOVERY

  • People search for a dish but get ranked restaurants, so a rating about everything answers a question about one thing.
  • Proposed dish-first ranking with dish-level ratings, so the best version of a dish actually surfaces.
  • Wrote up the trade-offs as well: new dishes start with no data, and broad restaurants lose some visibility.
Product Strategy UX Ranking Logic User Research
🍽️
Dish Discovery
WHAT I BRING

SKILLSET

A working toolkit across data, markets, and the systems where the two meet, built on what the projects actually needed.

Programming & Analytics 07
01 SQL
02 Python
03 Exploratory Data Analysis
04 Root Cause Analysis
05 Statistical Analysis
06 Product Metrics
07 User Journey Analysis
ML, Tools & Libraries 08
01 Pandas & NumPy
02 Advanced Excel
03 Scikit-learn
04 Feature Engineering
05 Regression & Classification
06 Model Evaluation
07 Matplotlib
08 Power BI (Basic)
Soft Skills
Team Collaboration Problem Solving Strategic Thinking Presentation Skills Business Acumen Effective Communication Interpersonal Skills
PROOF OF WORK

PROBLEMS SOLVED

The unglamorous reps behind the skillset: consistent daily practice across competitive-programming and database platforms.

0
DSA Problems Solved
Arrays · Trees · Graphs · DP & more
0
SQL Problems Solved
Joins · Windows · Aggregations · Tuning
Multiple
Platforms
Solved across different online judges & trackers
10 Days of Code badge
100 Days of Code
Days of Code badge
50 Days of Code
SQL badge
SQL
SQL Gold five-star badge
SQL · Gold ★★★★★
10 Days of Statistics badge
10 Days of Statistics
LEAD LEAD LEAD LEAD LEAD
LEAD LEAD LEAD LEAD LEAD
LEAD LEAD LEAD LEAD LEAD
01 / LEADERSHIP
FINANCE & ECONOMICS SOCIETY
Vice President · FES, NSUT Delhi
> I LEAD <

Leading the SIG team at FES NSUT, with finance sessions delivered to 400+ students. Also ran Maudrik, the policy case event under Consilium'25, as Event Head: 350% more participation than the previous edition, off planning and outreach alone.

400+
Students Reached
350%
Maudrik Participation ↑
10+
Events Organized
FOUNDED FOUNDED FOUNDED
FOUNDED FOUNDED FOUNDED
FOUNDED FOUNDED FOUNDED
02 / INITIATIVE
CORE FINANCE RESEARCH GROUP
Founder & Lead Researcher
> I FOUNDED <

Took the initiative to build a core finance research group open to any college student, a space to dissect markets together. Served as main lead on research reports tackling the questions investors keep asking, like why IPOs over the last 2–3 years keep bleeding after delivering strong listing gains.

OPEN
Any College Student
LEAD
Report Author
2–3 YR
IPO Data Studied
HOBBIES HOBBIES HOBBIES
HOBBIES HOBBIES HOBBIES
HOBBIES HOBBIES HOBBIES
03 / OFF HOURS
WHEN THE MARKETS CLOSE
Curiosity on · Screens off
> HOBBIES <

Even off the clock, the curiosity never switches off: staying plugged into the news cycle, reading deep on finance, and then resetting with a fast game of table tennis or a long drive and ride.

Reading NewsFinance ReadsTable TennisDrivingRiding
BEYOND BEYOND BEYOND BEYOND
BEYOND BEYOND BEYOND BEYOND
BEYOND BEYOND BEYOND BEYOND
04 / LIFE & BEYOND
OFF THE SCREEN
Adventure · Curiosity · Impact
> BEYOND WORK <

The best view of the market comes from 15,000 feet. Skydiving on the bucket list, a Delhi-to-Leh bike ride in the plans, and mountains calling louder than any Bloomberg terminal. Adventure is the best risk-adjusted return I know.

SkydivingLadakh RideAdventures
EDUCATION EDUCATION EDUCATION
EDUCATION EDUCATION EDUCATION
EDUCATION EDUCATION EDUCATION
05 / EDUCATION
NSUT DELHI · EE
2023 – 2027 · B.Tech, Electrical Engineering
> EDUCATION <

B.Tech in Electrical Engineering at Netaji Subhas University of Technology, Delhi, alongside self-directed finance learned from markets, books, failures, and first principles.

7.45
CGPA · NSUT B.Tech
98%ile
JEE Main 2023
81%
Class XII · Kiddys Corner
95%
Class X · DPS
05 / CREDENTIALS

CERTIFICATIONS

Verified
SEBI-Recognised · Regulatory

Research Analyst Certification

National Institute of Securities Markets, Series XV. The benchmark regulatory exam for equity research in India, covering valuation, financial modelling, securities laws, and the conduct standards required of a registered research analyst.

IssuerNISM · SEBI
StatusCertified
View Certificate ↗
Verified
HackerRank · Skill Certification

SQL (Advanced)

HackerRank's advanced SQL track: complex joins, window functions, CTEs and aggregation-heavy problem solving under a timed test. It backs the SQL-first architecture behind Causa and the vendor-performance ETL, where the analytics deliberately live in SQL rather than Python.

Earned21 Jul 2026
Credential ID0C136314C5B7
View Certificate ↗
06 / RESEARCH & WRITING

PUBLICATIONS

Featured
Ebook · Authored Work

BEYOND THE
BALANCE SHEET

A book written to make financial literacy approachable, translating the language of statements, ratios, and capital allocation for readers who were never given the manual. Built to foster financial education at the ground level, one chapter at a time.

FormatEbook
AudienceBeginners & Curious Readers
StatusPublished
Read Ebook ↗
Abhinav Jain
07 · GET IN TOUCH

LET'S BUILD
SOMETHING REAL.

Open to internships, research collaborations, and conversations about finance, data, and the future of intelligent systems.

Start a conversation ↗