name : Jayati Nilekar
role : Data Analyst Trainee @ AlmaBetter
education : B.Tech, Electronics & Communication (RGPV Bhopal) · CGPA 8.22
speciality : Dashboards, EDA & End-to-End Analytics on Microsoft Fabric
tools : SQL · Python · PySpark · Power BI · DAX · Tableau
domains : Retail · HR · Finance · E-Commerce · Logistics
also_into : GenAI — RAG, multi-agent workflows, LangChain, CrewAI
mission : "Turn messy data into clear, actionable stories."
contact : jayati.nilekar2@gmail.com✨ I build end-to-end analytics solutions: cleaning raw data, modeling it, writing SQL business queries, and shipping dashboards that decision-makers can actually use. I also build GenAI apps on the side.
╔══════════════════════════════════════════════════════════════╗
║ JAYATI — BY NUMBERS ║
╠══════════════════════════════════════════════════════════════╣
║ 🗂️ 9+ Analytics projects completed ║
║ 🖥️ 8 Power BI & Tableau dashboards ║
║ 🏗️ 3+ End-to-end solutions on Microsoft Fabric ║
║ 🗃️ 1M+ Records analyzed (SQL · Python · PySpark) ║
║ 🥈 Silver SQL Badge on HackerRank ║
║ 🎓 Google AI Professional Certificate ║
╚══════════════════════════════════════════════════════════════╝
Analyzed 1M+ transactions to uncover revenue trends, retention patterns, product concentration and regional cancellation risks. Built a PySpark → Lakehouse → Warehouse pipeline feeding a 2-page Power BI dashboard: $20.32M net revenue, 5,943 customers, 71.61% repeat rate, with OneLake row- and column-level security.    🔗 View Project |
Evaluated accounts-receivable data to flag overdue payments, surfacing $53.96K at risk across 83 late-paying customers and 34 repeat offenders to prioritize collections. Automated cleaning with PySpark and Delta tables, then built a Power BI dashboard.  🔗 View Project |
Examined 1,470 employee records across departments, roles, salary bands and demographics to explain a 16.12% attrition rate. Built interactive Power BI dashboards on Fabric (Dataflows Gen2, semantic models) with column-level security.  🔗 View Project |
Led a 7-member team building an AI documentation platform with a five-agent workflow (context reading, writing, fact-checking, tone refinement, publishing). Uses RAG, ChromaDB and Pydantic for source-grounded output and human-in-the-loop review.    🔗 View Project |
Enterprise-grade dashboard with interactive KPIs, DAX measures, star schema modeling and executive views. 🔗 View Project |
Retail dashboard on a self-generated, DMart-inspired synthetic dataset using Power Query, DAX and SQL. 🔗 View Project |
Data cleaning, EDA, SQL business queries and an interactive dashboard.  🔗 View Project |
Financial behaviour, credit scores and credit risk, using DAX, Drillthrough and Report Page Tooltips. 🔗 View Project |
|
Interactive Power BI dashboard on the SCMS Delivery History dataset. 🔗 View Project |
EDA of pharmaceutical shipments: performance, freight costs, delivery delays and global supply chain operations.  🔗 View Project |
| Skill Area | What It Covers |
|---|---|
| Data Cleaning & Prep | Missing values, duplicates, type fixes, Power Query and PySpark transformations |
| Exploratory Data Analysis | Python (Pandas, NumPy), trend and outlier detection, visual storytelling |
| SQL Analytics | Joins, CTEs, window functions, aggregations, business-driven queries (MySQL, PostgreSQL) |
| Data Engineering | Microsoft Fabric, Lakehouse, Warehouse, Delta tables, ETL/ELT pipelines |
| Power BI & DAX | KPIs, measures, drillthrough, tooltips, row- and column-level security |
| Data Modeling | Star schema, fact and dimension tables, semantic models |
| GenAI & Automation | RAG, multi-agent workflows, prompt engineering, vector databases, n8n |
- 📝 Data Analyst Trainee, AlmaBetter (Mar 2026 – Present): 9+ analytics projects, 8 dashboards, a SQL product dissection, a YouTube analytics case study and EDA projects on customer insights.
- 🎓 B.Tech in Electronics & Communication Engineering, UIT RGPV Bhopal (2022 – 2026), CGPA 8.22.
- 🎓 Google AI Professional Certificate
- 🥈 HackerRank Silver Badge in SQL
const jayati = {
lookingFor : ["Data Analyst roles", "BI / Power BI Developer roles", "Fabric & analytics engineering projects"],
canHelpWith: ["SQL reporting", "Power BI dashboards", "PySpark pipelines on Fabric", "KPI design", "GenAI prototypes"],
reachMe : "jayati.nilekar2@gmail.com"
};
⭐ Thanks for stopping by! If you like my projects, drop a star. ⭐