Ishu Harit

I’m an aspiring Data Analyst (fresher) who has already shipped two end-to-end analytics projects covering 100,000+ e-commerce orders and a decade of India’s UPI transactions. I take raw CSV data all the way to executive-ready dashboards—cleaning, modeling, querying with SQL window functions, and visualizing in Power BI.

In my Olist E-Commerce Analytics project, I built an ETL pipeline merging 9 raw CSV files into a clean set of 100,000+ orders, engineered delivery and lateness features, and collapsed 112,650 into 98,666 order-level records for analysis. I also wrote 10 MySQL window-function queries to run cohort and timeseries analysis on delivery and revenue trends.

My UPI Digital Payments Analytics work automated ingestion of 7 NPCI Excel files using a Python (glob) script, producing a repeatable 10-year pipeline. I normalized messy real government data and used Power BI to surface insights like the shift to micro-transactions and market share trends across payment methods.

Because I was a former full-stack developer, I’m comfortable with production-minded thinking—structures, code quality, and reliable pipelines. In internships, I built a full-stack banking management system with secure authentication and transaction processing, developed AI chatbot capabilities via Mistral LLM through REST APIs, and delivered full-stack web features end-to-end.