Skip to content
View seema-kri's full-sized avatar
🎯
Focusing
🎯
Focusing
1 follower · 0 following

Block or report seema-kri

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
seema-kri/README.md

Hi, I'm Seema Kumari

Data Analyst | SQL • Python • Power BI • Microsoft Fabric

Turning raw operational and business data into automated dashboards and decisions.

  

💼 Core Value

  • 🏭 Manufacturing Analytics — Built a live Power BI dashboard tracking 5,600+ production units, cutting reporting latency by 40%.
  • 🔍 Root-Cause Analysis — Diagnosed 500+ component defect events to surface recurring defect patterns for engineering teams.
  • 🛍️ Business Analytics — Analyzed 1.09M+ customer records and 2,351 catalog SKUs, flagging 44 underperforming products.
  • 🚚 Operations Analytics — Processed 45,000+ fulfillment logs, uncovering an 80% latency surge and modeling an 18% delivery-time improvement.

🎯 Open to: Data Analyst / Business Analyst / BI Analyst roles & internships.

🛠️ Technical Stack

Area Tools
Data Analysis SQL (PostgreSQL, CTEs, Window Functions), Python (Pandas, NumPy)
BI & Visualization Power BI, DAX, Power Query, Advanced Excel (PivotTables, INDEX/MATCH)
Data Engineering Microsoft Fabric (Lakehouse, Dataflow Gen2), ETL, Data Modeling, Star Schema

🚀 Featured Projects

🛍️ Sephora Skincare Commercial & Customer Intelligence Analytics SQL Python Power BI Excel Analyzed 1.09M+ customer records and 2,351 catalog SKUs using Python (Pandas, SQLAlchemy) and PostgreSQL. Built a 3-page Power BI dashboard on pricing, product performance, and brand contribution — found the top 10 brands drove 40.9% of catalog sales. Flagged 44 low-rated, high-traffic products as inventory risks. View Repository →

🍱 MealDash — Logistics Operations & Analytics SQL Microsoft Fabric Power BI DAX Processed and validated 45,000+ fulfillment logs using Dataflow Gen2 and Lakehouse. Diagnosed an 80% latency surge during peak hours and a 25-minute dispatch bottleneck via SQL diagnostics. Built a Power BI dashboard modeling an 18% improvement in delivery cycles. View Repository →

💼 Experience

Data Analyst Intern — Bosch Chassis Systems India Automated SQL-based ETL workflows for production data. Built a live Power BI dashboard connected to Azure Databricks tracking 5,600+ production units, cutting reporting latency by 40%. Diagnosed 500+ defect events for root-cause investigation.

📜 Certifications

  • Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)
  • Google Data Analytics Professional Certificate
  • HackerRank SQL (Advanced) — 5-Star Gold Badge

Open to connecting on data analytics, BI dashboards, and open roles.

Pinned Loading

  1. seema-kri seema-kri Public

  2. MealDash MealDash Public

    End-to-end food delivery operations analytics using SQL, Microsoft Fabric & Power BI to identify delivery delays, performance drivers, and actionable operational insights.

    1

  3. Sephora-Skincare-Commercial-Customer-Analytics Sephora-Skincare-Commercial-Customer-Analytics Public

    End-to-end analytics pipeline using Python, PostgreSQL, and Power BI on 1.09M+ Sephora reviews ($192.5M revenue proxy) to model brand concentration, pricing tiers, and $6.27M in quality risk.

    Jupyter Notebook

  4. nyc-taxi-revenue-optimization-2026 nyc-taxi-revenue-optimization-2026 Public

    Hypothesis testing on 4M+ NYC taxi trip records (May 2026) to determine payment type's impact on fare revenue data cleaning, outlier removal, EDA, T-test, stakeholder recommendations for drivers.

    Jupyter Notebook