Skip to content
View shubhammittal-data's full-sized avatar

Block or report shubhammittal-data

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.

Maximum 250 characters. Please don't include any personal information such as legal names or email addresses. Markdown supported. This note will be visible to only you.
Report abuse

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

Report abuse
shubhammittal-data/README.md

Hi there πŸ‘‹

I'm Shubham Mittal - Business Analyst | Product Owner | Operations Analyst

LinkedIn
πŸ“§ Email: sm145@illinois.edu | πŸ“± +1-(447) 902-7573


πŸ‘¨β€πŸ’Ό About Me

Business Analyst with 3+ years translating stakeholder requirements into data-driven solutions and operational improvements. Currently pursuing Master of Science in Engineering Management at University of Illinois Urbana-Champaign (UIUC), graduating August 2025.

What I Do:

  • πŸ“Š Gather requirements, write user stories, and manage product backlogs in Agile environments
  • 🀝 Bridge business stakeholders and technical teams to deliver impactful solutions
  • πŸ“ˆ Drive process improvements through data analysis, gap analysis, and Six Sigma methodologies
  • βœ… Facilitate UAT, sprint planning, and stakeholder workshops to ensure successful delivery

Recent Impact:

  • Recovered $300K through fraud detection system requirements and implementation
  • Identified $2M+ optimization opportunities through inventory classification analysis
  • Reduced operational costs 80% via ERP automation and process improvements
  • Delivered recruitment system reducing time-to-hire 60% for 500+ candidates

I'm passionate about using data and analytics to solve complex business problems, optimize operations, and deliver measurable value. Open to Business Analyst, Product Owner, Operations Analyst, and Data Analyst roles.


πŸŽ“ Education

Master of Science (MS) in Engineering Management
University of Illinois Urbana-Champaign | Aug 2024 - Aug 2025 | GPA: 3.8/4.0
πŸ“š Coursework: Big Data Infrastructure, Enterprise Database Management, Data Storytelling, Business Intelligence

Bachelor of Technology in Mechanical Engineering
Vellore Institute of Technology, India | Jun 2018 - May 2022


πŸ’Ό Professional Experience

Business Analyst | Road Ready Wheels

Champaign, IL | May 2025 - Present

  • Gather requirements from Finance, Operations, and C-suite stakeholders; document BRDs and collaborate in Agile sprints with engineering teams
  • Led automation project processing 120K+ monthly transactions, reducing manual reconciliation 80% (200+ hours saved)
  • Conducted gap analysis identifying inventory inefficiencies; delivered SKU classification recommendations worth $2M+ in optimization opportunities
  • Facilitated stakeholder workshops defining prioritization criteria for $4B aftermarket segmentation; presented strategy improving market penetration 54%
  • Created process flows and acceptance criteria for cross-reference system consolidating 5,000+ SKU relationships

Team Lead (Business Analyst) | Data Science Research Services, UIUC

Champaign, IL | Mar 2025 - Present

  • Gathered requirements from HR leadership; documented 25+ user stories with acceptance criteria and facilitated UAT with hiring managers
  • Delivered KPI dashboards reducing time-to-hire 60% for 500+ candidates through Agile sprint delivery
  • Analyzed 10K+ merchandise transactions using Pareto analysis; documented process flows and presented SKU rationalization improving inventory turnover 35% and reducing costs 20%
  • Led team of analysts on recruitment optimization and operations improvement initiatives

Business Intelligence Analyst | Discover Partners Institute

Champaign, IL | Aug 2024 - Jan 2025

  • Gathered requirements from policymakers; architected SQL Server data warehouse consolidating 250K+ education records from 5 sources
  • Built Tableau dashboards visualizing KPIs for 50+ stakeholders; designed automated ETL pipelines reducing data inconsistencies 15%
  • Collaborated with cross-functional teams on data-driven education policy initiatives

Senior Operations & Risk Analyst | Oxigen Services India

Gurugram, India | Mar 2022 - Jul 2024

  • Documented business requirements for fraud detection system across 5K+ kiosks processing $6M daily; collaborated with IT implementing solution recovering $300K
  • Conducted root cause analysis using 5-Why methodology on 30% error rates; recommended process improvements reducing errors to 9%, increasing revenue $150K annually
  • Gathered executive KPI requirements; built Tableau dashboards with SQL ETL pipelines for C-suite, reducing manual reporting 60%
  • Developed risk assessment frameworks improving fraud detection accuracy 40% and reducing false positives 25%

πŸ”Ή Core Competencies

Business Analysis & Product Management:
Requirements Gathering β€’ User Story Writing β€’ Acceptance Criteria β€’ Gap Analysis β€’ Process Mapping β€’ UAT Coordination β€’ Stakeholder Management β€’ Business Requirements Documents (BRD)

Agile & Project Delivery:
Scrum β€’ Sprint Planning β€’ Backlog Management β€’ Agile Methodologies β€’ JIRA β€’ Confluence β€’ SDLC β€’ Cross-functional Collaboration

Data & Analytics:
SQL (PostgreSQL, SQL Server) β€’ Python β€’ Excel (Advanced) β€’ Tableau β€’ Power BI (DAX) β€’ Data Visualization β€’ ETL Pipelines β€’ Data Modeling

Process Improvement & Operations:
Lean Six Sigma (DMAIC) β€’ Root Cause Analysis (5-Why, Fishbone) β€’ Process Optimization β€’ Operational Excellence β€’ KPI Development

Tools & Platforms:
JIRA β€’ Confluence β€’ Tableau β€’ Power BI β€’ SQL Server β€’ PostgreSQL β€’ NetSuite ERP β€’ AWS β€’ Visio β€’ Excel


πŸ† Certifications

  • Six Sigma Green Belt - Ernst & Young (EY)
  • Google Advanced Data Analytics Professional Certificate
  • AWS Cloud Practitioner (In Progress)

πŸ“Š GitHub Highlights

This GitHub showcases my technical projects and analytical work, including:

  • πŸ“ˆ Data Analysis Projects: SQL queries, Python analysis, visualization dashboards
  • πŸ”„ Process Automation: Scripts for data transformation and reporting automation
  • πŸ“Š Business Intelligence: Tableau/Power BI projects and data modeling examples
  • πŸ› οΈ Problem-Solving: Real-world business case studies and analytical solutions

Currently organizing repositories to showcase business analysis and product management work. Check back soon!


🎯 What I'm Looking For

I'm actively seeking opportunities in:

  • πŸ’Ό Business Analyst roles focused on requirements, stakeholder management, and Agile delivery
  • 🎯 Product Owner positions managing backlogs and driving product strategy
  • πŸ“Š Operations Analyst roles optimizing processes and improving efficiency
  • πŸ“ˆ Data Analyst positions leveraging analytics for business decision-making

Location Preferences: Remote, Chicago, IL, Denver, CO, or willing to relocate


πŸ“« Let's Connect!


πŸ’‘ Fun Facts

  • πŸŽ“ Graduated from UIUC's Engineering Management program
  • πŸ“ˆ Passionate about using data to drive business decisions and operational improvements
  • ⚑ Recovered $300K in fraudulent transactions through analytical detective work
  • 🌍 International experience working across US and India
  • πŸ† Six Sigma Green Belt certified with focus on process excellence

"Turning data into decisions, requirements into results, and stakeholders into advocates."

Popular repositories Loading

  1. DSRS_Applications_Email_Automation_Tableau DSRS_Applications_Email_Automation_Tableau Public

    A Tableau automation project using Python Flask. Clicking a student's NetID triggers an email via Outlook SMTP. Integrated with Tableau Actions for automated communication.

    Python 1

  2. Sales-Customer_Dashboard_Tableau Sales-Customer_Dashboard_Tableau Public

    An interactive Tableau project showcasing advanced data visualization techniques for sales performance and customer analytics. This dashboard provides key business insights using KPIs, trend analys…

  3. HR_Dashboard_Tableau HR_Dashboard_Tableau Public

    An interactive HR Analytics Dashboard built using Tableau. Provides insights into workforce demographics, hiring trends, salary analysis, and employee records for data-driven decision-making.

    Python

  4. shubhammittal-data shubhammittal-data Public

  5. Customer_Lifetime_Value_Analysis Customer_Lifetime_Value_Analysis Public

    A data-driven Customer Lifetime Value (CLTV) analysis using Python. This project explores customer acquisition costs, conversion rates, revenue, ROI, and CLTV across various channels using visualiz…

    Jupyter Notebook

  6. Credit_Scoring_and_Segmentation Credit_Scoring_and_Segmentation Public

    A data-driven Credit Scoring and Segmentation project using Python. This project evaluates customer creditworthiness, calculates credit scores using FICO methodology, and segments customers based o…

    Jupyter Notebook