ABOUT ME

Welcome to the Portfolio of Shubham Mittal

Where Data Unlocks Insights, Analysis Shapes Strategy, and BI Drives Decisions.

Every dashboard, model, and analysis on this page is a testament to my passion for transforming complex data into clear, actionable intelligence. My journey, rooted in an engineering foundation and advanced by a Master of Science in Engineering Management from the University of Illinois, Urbana-Champaign, is focused on delivering measurable impact. I have enhanced reporting accuracy by up to 40%, recovered $300K in fraudulent transactions by replacing manual systems, and reduced manual reporting for C-suite executives by 60%.

With deep expertise in SQL, Python, Tableau, and AWS platforms, I excel at building the BI solutions and ETL processes that empower stakeholders to make informed, data-driven decisions. My experience ranges from developing predictive fraud models that achieved a 40% improvement in accuracy to designing public-facing dashboards that make hundreds of thousands of data points accessible to policymakers and education leaders.

If you are searching for an analyst who bridges the gap between raw data and strategic business outcomes, you are in the right place. Explore my projects to see how I translate numbers into narratives and challenges into opportunities. Let's connect to explore how we can drive progress through data.

MORE ABOUT ME

Academic Background

Education

UNIVERSITY OF ILLINOIS URBANA-CHAMPAIGN

MASTER OF SCIENCE IN ENGINEERING MANAGEMENT

August 2023 - Expected August 2025

Specialization: Business Data Analytics

Relevant Coursework: Data Science & Analytics, Big Data Infrastructures, Project Management, New Product Development, Data Storytelling, Business Intelligence
Learning essential concepts in Technology and Business Management honing my ability to transform business needs into technical solutions.

VELLORE INSTITUTE OF TECHNOLOGY, INDIA

BACHELOR OF ENGINEERING (MECHANICAL)

July 2018 - July 2022

Relevant Coursework: Statistics and Probability for Engineers, Project Management, Applied Linear Algebra, Supply Chain Management, Operations Management
My mechanical engineering background, combined with training in statistics, supply chain, and operations, allows me to bring a unique analytical and problem-solving approach to any project.

Professional Journey

Work Experience

Data Scientist | Data Science Research Services, UIUC

March 2025 - Present

Designed and implemented an AI-powered visualization agent using Python and Pandas, automating insights from 10K data points for a business simulation platform. Leveraged data visualization best practices and dashboarding techniques to translate complex business scenarios into actionable insights, increasing stakeholder data accessibility by 40%. Applied statistical analysis and data-driven methodologies to deliver interactive business intelligence solutions, resulting in a 30% improvement in user engagement and scenario analysis efficiency.

Team Lead (Data Analyst) | Road Ready Wheels (Business Practicum)

May 2025 - July 2025

Analyzed $4B wheels aftermarket and developed a scoring model to rank vehicle-to-SKU segments by complexity and volume; recommended high-ROI investments with 200%+ projected return and improved market coverage by 54%. Led cross-functional team to deliver strategic business recommendations based on comprehensive market analysis.

Data Analyst | Discover Partners Institute (Business Practicum)

August 2024 - January 2025

Built public-facing Tableau dashboard visualizing 250K Illinois school district data points, enabling key insights for 50+ stakeholders including policymakers and education leaders. Implemented SQL-based ETL processes across 5+ data sources, reducing data inconsistencies by 15% and coordinating cross-functional delivery to meet stakeholder expectations.

Senior Risk Data Analyst | Oxigen Services India

July 2022 - July 2024

Analyzed daily transactional data for 5K banking kiosks, processing $6M+ daily to ensure regulatory compliance and fraud prevention. Automated real-time fraud detection by replacing manual Excel reconciliation with SQL-based system, reducing detection time from 30 days to same-day and recovering $300K in fraudulent transactions. Developed predictive fraud detection models using Random Forest and Logistic Regression, achieving 40% improvement in accuracy and 25% reduction in false positives for payment anomalies. Built executive Tableau dashboards and SQL ETL pipelines for C-suite, reducing manual reporting by 60% and enabling data-driven risk management strategies.

Portfolio Showcase

Projects

A collection of my data science, analytics, and visualization projects

Credit Scoring and Segmentation

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 on their financial behavior and risk profiles.

View Project

Customer Lifetime Value Analysis

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 visualization techniques to drive marketing strategy.

View Project

Email Automation with Tableau

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, streamlining the notification process.

View Project

HR Analytics Dashboard

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 in human resources management.

View Project

Sales & Customer Dashboard

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

View Project

Hi, I'm Shubham Mittal