I'm a Data Analyst from Nagpur, India, who builds end-to-end analytics — from raw SQL queries to Tableau dashboards — around real business problems, and writes curriculum-grade SQL content on the side.
- 🎓Engineering B.tech student at Nagpur — SGPA 8.53 (Sem 1), 7.86 (Sem 2)
- 🔭 Co-founder — Execution & Lead Data Analyst at Apex Analyticx, a freelance venture delivering data analytics and other services to businesses
- 🏙️ Building NagpurLens, an open-source urban intelligence platform mapping infrastructure gaps across Nagpur
- 📚 Author of the SQL Engineering Handbook, a 20+ module production-grade SQL curriculum
- 🎯 Currently seeking a paid Data Analyst internship where I can contribute from day one with SQL, Python, and data storytelling
🌐 Website : https://theammarngp.lovable.app
|
Data & Analytics
|
Languages & Programming
|
Tools & Platforms
|
- HackerRank — SQL (Advanced)
- HackerRank — SQL (Basic)
- Zetheta Algorithms — Certificate of Project Work Experience, Data Analyst Securitisation (Data Analyst role, 15 full-time days equivalent) — IFRS 9 ECL modeling, DAX, star schema, and Python analytics on real auto loan data
Co-founder — Execution & Lead Data Analyst
A freelance venture offering multiple services to businesses, including data analytics — I lead execution and the data analytics function.
| Project | What it answers | Stack |
|---|---|---|
| SQL Engineering Handbook | A 20+ module production-quality knowledge base covering advanced SQL, performance tuning, data modeling, and real-world query design — with a full resource library and community health docs | SQL MySQL Git |
| NagpurLens (open-source, in progress) | An urban intelligence platform mapping infrastructure gaps and growth signals across 57 Nagpur localities using custom KPIs — density, healthcare access, investment attractiveness | MySQL FastAPI Streamlit Python |
| Olist Sales Analysis | Which categories & regions drive 80% of revenue across 95K+ orders? | SQL Python Pandas Tableau |
| Cohort Retention Analysis | Why do 96%+ customers never return after their first purchase? | SQL Python Tableau |
| RFM Customer Segmentation | Who are the high-value vs. at-risk customers? | SQL Python Pandas Tableau |
| Daily Reflection Tree | A deterministic CLI journaling app with 25+ branching nodes across three psychological axes — no LLM at runtime | Python FastAPI JSON |
NagpurLens is a multi-collaborator, in-progress project — link will be added once the repo is public-ready.
If you're a recruiter — start with the project table above. Each project links directly to the repo with full documentation.