At Work

Shubham

Mittal

Senior Data Analyst · Fraud & Risk Analytics · AML Compliance
scroll ↓
Headshot
"Outcomes over outputs. Understand the problem before picking the tool."
$300K
Fraud Recovered
$3.4M
At-Risk Exposure Flagged
84%
Fraud Detection Accuracy
3+
Years in Banking Analytics

About Me

About Me


Where I'm From

Originally from India, I am now based in Atlanta, GA after completing my Master's in Engineering Management at the University of Illinois Urbana-Champaign (GPA: 3.8/4.0). My path from mechanical engineering to fraud and risk 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.


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 that improved accuracy from 60% to 84%, and recovered $300K through systematic exception analysis. My work operated under RBI and PMLA regulatory frameworks — the Indian equivalent of BSA/AML compliance in the US. That experience shaped everything about how I think about data, risk, and financial crime.


What I Do

I build fraud detection systems, risk intelligence pipelines, and data platforms that turn messy financial data into decisions that matter. I partner with engineering, compliance, and finance teams to identify risk patterns, define detection frameworks, and deliver systems that keep working after I leave the room. Whether that means running SQL audits on 1,500 weekly transaction anomalies, designing a PostgreSQL schema with full audit logging, or presenting risk KPI dashboards to a C-suite audience — I own the problem from discovery to delivery.


Domains I've Worked In

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 model outputs, 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

Risk & Fraud Analytics

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

Data & Analytics

Python (LightGBM, XGBoost, SHAP, Scikit-learn, Pandas), SQL (PostgreSQL, SQL Server, DuckDB), Snowflake, PowerBI (DAX), Tableau, Alteryx, Streamlit, AWS

AI & Modeling

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

Technical Tools

Python, SQL (PostgreSQL, SQL Server), Tableau, Power BI (DAX), Excel, Snowflake, NetSuite, Oracle NetSuite (ERP), DuckDB, Streamlit, LightGBM, Alteryx

Certifications

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

Project Management

Agile (Scrum), Waterfall, SDLC, JIRA, Confluence, Visio

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 Analyst

Road Ready Wheels
May 2025 – PresentChicago, IL
  • Built scenario models across 150+ variable cost drivers using SQL and Python, surfacing $100K+ in margin improvement opportunities and delivering pricing recommendations to leadership.
  • Conducted data quality auditing across 900+ SKUs using Oracle NetSuite ERP, identifying ~$300K in misclassified inventory capital and providing assortment recommendations that shaped go-to-market strategy.
  • Developed demand forecasting models comparing Holt's Linear, SES, and Croston's Method, reducing stockout events from 45 to 8 per month and improving service level targets across the product portfolio.

Senior Data Analyst

Data Science Research Services, UIUC
Mar 2025 – PresentChampaign, IL
  • Owned AI platform product strategy for 500+ users, identifying 4 critical data integrity gaps through gap analysis and leading full remediation that reduced post-deployment issues by 45%.
  • Built PostgreSQL pipeline with metadata definitions, deduplication controls, and audit logging, cutting processing time from 10 to 4 days and reducing monthly operating costs from $12K to $9.6K.
  • Restored data continuity during a critical API failure by building an alternative intake system, acting as central point of contact across 3 teams with zero records lost.

Senior Data Analyst

Oxigen Services India
Client: SBI — Consumer Banking, Deposits, Payments and ATM Network
Mar 2022 – Jul 2024Gurugram, India
  • Identified and escalated an active AML structuring scheme across SBI's 5,000-node network, 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 on consumer banking transactions.
  • Authored a Data Governance Manual defining 5 anomaly detection controls across SBI's consumer banking network, contributing to zero material findings across all quarterly RBI compliance audits.
  • Ran weekly SQL audits across $6M in daily transactions, tracing 1,500 weekly anomalies to root cause and driving error rate from 30% to 9% through iterative remediation.
  • 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, fraud professionals, and builders. I am open to Fraud Analytics, Financial Crimes Analytics, Risk Reporting, AI Analytics, and Senior Data Analyst roles in financial services and banking. Open to relocate anywhere in the US. STEM OPT through August 2028 — no sponsorship required. Let's connect.