At Work

Shubham

Mittal

Senior Data & Business Analyst · Project Management · Fraud & Risk Analytics · Marketing Communications
scroll ↓
Headshot
"Outcomes over outputs. Understand the problem before picking the tool."
$300K
Fraud Recovered
$3.4M
At-Risk Flagged
10+
Teams Managed
500+
Platform Users

About Me

About Me


Where I'm From

Originally from India, I completed my Master's in Engineering Management at the University of Illinois Urbana-Champaign (GPA: 3.8/4.0). My path from mechanical engineering to data and business analytics was not linear — it was driven by a simple realization: the most impactful work happens when you understand the data well enough to find what others miss and build systems that help people act on it.


How It Started

At Oxigen Services India I worked on SBI's consumer banking network — 5,000 payment kiosks processing $6M in daily transactions. I identified an active AML structuring scheme, built fraud detection models improving accuracy from 60% to 84%, and recovered $300K through systematic exception analysis under RBI and PMLA frameworks — the Indian equivalent of BSA/AML compliance in the US. That experience shaped how I think about data, risk, and operational systems. It also taught me that the real skill is not just finding the problem — it is building something that keeps finding it after you leave the room.


What I Do Now

Today my work spans fraud analytics, project management, marketing communications, and data platform development. At UIUC's Data Science Research Services I manage digital projects across 10+ teams using Asana, design brand-consistent marketing materials using Figma, and own the product strategy for an AI hiring platform serving 500+ users. I have also spent 1.5 years as a Teaching Assistant for iMBA courses including Project Management and Digital Marketing Analytics. Whether I am running SQL audits on 1,500 weekly transaction anomalies, managing a project schedule in Asana, or presenting KPI dashboards to a C-suite audience — I own the problem from discovery to delivery.


Domains I've Worked In

Project Management · Marketing Communications · Fraud & Financial Crimes · AML/BSA Compliance · AI & Data Platforms · Risk & Financial Modeling · Supply Chain & Operations


Beyond Work

When I am not buried in transaction logs or project workflows, you will find me playing chess (rated 1800, always looking for a match), diving into conversations about historical events and mythologies, or unwinding on the dance floor. I am also building Talk Palette, an Instagram page about living an intentional, simplified life. I believe curiosity outside of work makes you sharper inside of it.

Experience

Data & Analytics

Python (LightGBM, XGBoost, SHAP, Scikit-learn, Pandas), SQL (PostgreSQL, SQL Server, DuckDB), Snowflake, PowerBI (DAX), Tableau, Alteryx, Streamlit, AWS, Salesforce (Service Cloud, Dashboards, Case Management)

Project Management & Operations

Asana, Agile (Scrum), Waterfall, SDLC, Jira, Confluence, Visio, Sprint Planning, Deadline Tracking, Vendor Coordination, Budget Management, Stakeholder Management

Marketing & Communications

Figma, Marketing Strategy, Brand Management, Digital Marketing Analytics, Marketing Mix, Content Creation, Google Drive, MS Teams, Zoom, MS PowerPoint

AI & Modeling

Statistical Model Building, Hypothesis Testing, Feature Engineering, Isolation Forest, SHAP Explainability, LLM Integration, Threshold Tuning, Model Benchmarking

Fraud & Risk Analytics

Fraud Detection Modeling, AML/BSA Compliance, Transaction Monitoring, Exception Analysis, Anomaly Detection, Root Cause Analysis, Regulatory Reporting, Audit Trail Management

Certifications

CAPM — In Progress (PMI) · CFE — In Progress (ACFE) · Six Sigma Green Belt (Ernst & Young) · Google Advanced Data Analytics Professional · AWS Cloud Practitioner

Research & Teaching Assistant — Gies College of Business, UIUC

  • Enhanced consumer behavior research through conceptual modeling and advanced visualizations, supporting faculty-led research initiatives
  • Mentored 10 MSBA Business Practicum teams on project execution, strategic framing, and stakeholder communication
  • Refined statistical tables and data visualizations, translating complex academic findings into clear, actionable formats for industry and academic audiences

Senior Data & Business Analyst

Data Science Research Services, UIUC
Mar 2025 – PresentChampaign, IL
  • Owned product strategy for an AI hiring platform serving 500+ users, defining feature priorities and roadmap decisions in collaboration with engineering and data science teams.
  • Managed end-to-end project workflows using Asana across 10+ teams, assigning tasks, tracking deadlines, and ensuring timely delivery of goal-driven projects.
  • Designed brand-consistent marketing content and introduction brochures using Figma, executing engagement strategies that promoted platform adoption across the college.
  • Built PostgreSQL pipeline with metadata definitions, deduplication controls, and audit logging, cutting processing time from 10 to 4 days and reducing monthly costs from $12K to $9.6K.
  • Identified 4 critical data integrity gaps through structured gap analysis, led full remediation documenting lineage and governance standards, reducing post-deployment issues by 45%.
  • Restored data continuity during a critical API failure by building an alternative intake system, coordinating recovery across 3 cross-functional teams with zero data loss.

Senior Data & Business Analyst

Road Ready Wheels
May 2025 – Apr 2026Chicago, IL
  • Worked directly with the CTO on Oracle NetSuite ERP architecture, performing business requirements analysis across 150+ variable cost drivers and confirming technical change readiness before production rollout.
  • Built scenario models using SQL and Python, surfacing $100K+ in margin improvement opportunities and delivering strategic pricing recommendations to executive leadership.
  • Conducted SKU-level data quality auditing across 900+ products using Oracle NetSuite ERP, identifying $250K in misclassified inventory capital and providing assortment recommendations that shaped GTM strategy.
  • Developed demand forecasting models comparing Holt's Linear, SES, and Croston's Method, reducing stockout events from 45 to 8 per month across the product portfolio.

Data & Business Analyst, Team Lead

Discovery Partners Institute (Practicum), UIUC
Aug 2024 – Jan 2025Champaign, IL
  • Led a cross-functional analyst team through full project lifecycle using Agile Scrum methodology, managing sprint planning, risk, scope changes, and deadline accountability across 5 workstreams for 50+ stakeholders.
  • Consolidated 5 source systems into a Snowflake data warehouse via AWS S3 with IAM-governed access controls, eliminating 563 downstream reporting errors across 250K+ records.
  • Built self-serve Tableau dashboards replacing manual reporting processes, enabling independent data exploration and delivering executive-ready project summaries to leadership.
  • Defined source-of-truth business definitions and metadata standards across the Snowflake warehouse, ensuring downstream analytical consumers worked from consistent and documented data models.

Senior Data Analyst

Oxigen Services India
Client: SBI — Consumer Banking, Deposits, Payments and ATM Network
Mar 2022 – Jul 2024Gurugram, India
  • Managed end-to-end case lifecycle of transaction anomalies across SBI's 5,000-node network using Salesforce Service Cloud — tracking cases, coordinating cross-functional remediation, and maintaining steady-state operations across $6M in daily transactions.
  • Designed Salesforce dashboards to identify case outliers and performance trends, conducting monthly business reviews with bank stakeholders reporting on 20+ KPIs, system health, and project milestones.
  • Served as primary contact center escalation point for inbound platform complaints — managing ticket lifecycle via Salesforce and coordinating phone-based resolution across support teams.
  • Identified and escalated an active AML structuring scheme, converting the fraud pattern into a permanent automated monitoring rule that closed a critical compliance gap under RBI reporting thresholds.
  • Developed fraud detection models using Python and Scikit-learn, improving detection accuracy from 60% to 84% and recovering $300K through systematic exception analysis.
  • Authored a Data Governance Manual defining 5 anomaly detection controls, contributing to zero material findings across all quarterly RBI compliance audits.
  • Automated monthly reconciliation workflows using Alteryx and delivered PowerBI dashboards tracking 20+ risk KPIs to C-suite stakeholders, eliminating 20+ hours of manual weekly reporting.

Projects

Financial Risk
Intelligence

Financial Risk Intelligence

Credit Risk Modeling · Fraud Detection · AI Risk Narratives

End-to-end financial risk intelligence pipeline built on Capital One's PersonaLedger dataset — 30M transactions across 144K users. Combines LightGBM credit risk modeling, Isolation Forest fraud detection, SHAP explainability, and LLM-generated executive risk narratives for 332 high-risk customers. Flags critical-risk customers with $3.4M in at-risk exposure across 5.6M test transactions.

PythonLightGBMXGBoostSHAPIsolation ForestStreamlitDuckDB
30M Transactions | 144K Users | $3.4M Exposure Flagged
View on GitHub
ReplenishIQ Supply Chain Analytics

ReplenishIQ — Supply Chain Analytics

End-to-end inventory management platform for retail supply chain optimization. Combines multi-model demand forecasting, K-Means SKU clustering, a 6-type exception alert engine, and scenario modeling — built on 500+ SKUs and ~920K transactional records.

PythonPostgreSQLScikit-learnPandasSupply Chain
500+ SKUs | 920K Records Analyzed
View on GitHub
Credit Scoring & Segmentation

Credit Scoring & Segmentation

Credit risk evaluation using FICO methodology. Calculates customer credit scores and segments profiles into risk categories for data-driven financial decision-making.

PythonFICO ScoringRisk AnalysisSegmentation
FICO-Based Risk Segmentation
View on GitHub
TriageIQ Workflow Automation Prioritizer

TriageIQ — Workflow Automation Prioritizer

Insurance operations teams often struggle to decide where to start with automation. TriageIQ removes the guesswork — score 15 common brokerage workflows across 9 business dimensions and instantly see which are worth automating now, which need standardizing first, and which to skip. Built for ops leaders, not developers.

Insurance OpsProcess ExcellenceAutomation StrategyWorkflow Analysis
15 Workflows | 9 Scoring Dimensions
View on GitHub
DSRS Email Automation

DSRS Email Automation — Tableau + Python

Automated communication pipeline built with Python Flask and Tableau Actions. Clicking a student's NetID triggers an email via Outlook SMTP — bridging dashboards with real-world workflows.

Python FlaskTableauSMTPWorkflow Automation
Automated Communication Pipeline
View on GitHub
Customer Lifetime Value Analysis

Customer Lifetime Value Analysis

End-to-end CLTV analysis exploring acquisition costs, conversion rates, revenue, ROI, and lifetime value across marketing channels. Rich visualizations surface actionable channel-level insights.

PythonCLTVMarketing AnalyticsJupyter
Multi-Channel ROI Analysis
View on GitHub
Sales & Customer Dashboard

Sales & Customer Dashboard — Tableau

Interactive Tableau dashboard for sales performance and customer analytics. Features KPIs, trend analysis, and customer segmentation — designed for executives and sales managers to drive data-driven decisions.

TableauData VisualizationKPIsCustomer Segmentation
Interactive Executive Dashboard
View on GitHub
HR Analytics Dashboard

HR Analytics Dashboard — Tableau

Workforce analytics dashboard providing insights into demographics, hiring trends, salary analysis, and employee records. Enables data-driven people decisions for HR teams and hiring managers.

TableauHR AnalyticsWorkforce PlanningPython
Workforce Insights at a Glance
View on GitHub

Connect with me

I love meeting fellow analysts, project managers, fraud professionals, and builders. I am open to Fraud Analytics, Financial Crimes Analytics, Risk Reporting, Data & Business Analyst, Project Management, Marketing Communications, Strategy & Operations, and Biz Ops roles. Open to relocate anywhere in the US. Let's connect.