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 business data into clear insights, KPIs, and decisions.

👩‍💻 About

Final-year B.Tech Mechanical Engineering student at NIT Agartala with hands-on experience in data analytics, business intelligence, and operations analytics.

  • 💼 Data Analyst Intern — Bosch Chassis Systems India
  • 🛠️ SQL • Python • Power BI • DAX • Excel • Microsoft Fabric
  • 📊 Experienced with production, logistics, customer, risk, and revenue analytics
  • 🎯 Focused on finding performance gaps and turning them into actionable recommendations

🚀 Featured Work

🏦 Complaint Risk & SLA Analytics

62K+ CFPB complaints | Python | PostgreSQL | SQL | Power BI

  • Identified 3 products above a 5% late-response benchmark
  • Found 2 products driving 65.6% of complaints and 87.27% of monetary relief
  • Built a 3-page decision-focused Power BI dashboard

→ View Project

🍔 MealDash — Logistics Analytics

45K+ orders | SQL | Microsoft Fabric | Power BI

  • Found festival deliveries were 75% slower
  • Identified bundled-order delivery time increasing from 23 → 48 min
  • Translated findings into staffing and delivery recommendations

→ View Project

🚕 NYC Taxi Revenue Analysis

4.09M+ trips | Python | Statistics

  • Card payments showed 18.9% higher average fares
  • Used Welch's t-test to validate the difference statistically
  • Identified corridor and payment-method revenue opportunities

→ View Project

💼 Experience

Data Analyst Intern — Bosch Chassis Systems India

  • Analyzed data across 5,600+ production units
  • Built Power BI reporting with DAX, reducing reporting latency by 40%
  • Automated SQL ETL workflows and validated production data
  • Analyzed 500+ defect events to identify operational gaps

🧠 Skills

  • SQL: PostgreSQL, T-SQL, CTEs, Window Functions
  • Python: Pandas, NumPy, SciPy, Statsmodels, EDA
  • BI: Power BI, DAX, Data Modeling, KPI Dashboards
  • Data: Excel, Power Query, Microsoft Fabric, ETL, Data Validation
  • Analytics: Statistical Analysis, Business Analysis, Data Visualization

🎓 Education

NIT Agartala — B.Tech Mechanical Engineering 2023–2027 | CGPA: 7.66 / 10

🏆 Recognition

Siemens Scholar — Top 1% nationally Infosys STEM Stars Scholar

📜 Certifications

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

SQL • Python • Power BI • Microsoft Fabric • Business Analytics

LinkedIn • GitHub • Email

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.

    3

  3. 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

  4. Complaint-Risk-SLA-Analytics Complaint-Risk-SLA-Analytics Public

    Complaint risk analytics delivering actionable operational decisions to mitigate regulatory SLA breach rates and reduce financial remediation exposure.

    Jupyter Notebook 2

  5. Supply-Chain-Delivery-Delay-Operational-Risk-Analysis Supply-Chain-Delivery-Delay-Operational-Risk-Analysis Public

    End-to-end supply chain analytics and machine learning pipeline diagnosing a 54.7% late-delivery rate across 172K+ orders and predicting fulfillment SLA breaches using Random Forest & SMOTE.

    Jupyter Notebook 5 1