MS Information Management · UIUC · Data & Analytics
Data Analyst and Analytics Engineer with 2.5 years of industry experience at Accenture across automotive operations and healthcare domains, plus graduate work at UIUC. I engineer automated data pipelines, architect dimensional star schemas in dbt and BigQuery, and deliver decision-grade dashboards and quantitative models in SQL, Python, and Power BI.
Portfolio
Production-grade analytics pipelines, dimensional data models, cross-system reconciliation, and executive dashboards.
End-to-end operational analytics platform integrating warehouse fulfillment (WMS), carrier tracking (TMS), and ERP item master catalogs. Implements automated cross-system reconciliation rules (timestamp anomalies, order status discrepancies), calculates operational KPIs (inventory turns, fill rates, dispatch cycle time), and feeds an executive Power BI star schema model.
Analytics engineering pipeline modeled on two-sided marketplace transaction dynamics. Extracts creator and show metadata via the iTunes Search API, generates synthetic listener and impression event streams, models dimensional tables in dbt on Google BigQuery, and automates daily CI/CD pipeline runs with data quality test assertions.
Quantitative time-series pipeline examining the lead-lag relationship between the NY Fed Global Supply Chain Pressure Index (GSCPI) and US Consumer Price Index (CPI) inflation. Features stationarity tests (ADF), Granger causality validation across 12 lags (p < 0.001), Vector Autoregression (VAR) 12-month forecasting, and a Streamlit dashboard with automated monthly GitHub Actions data refreshes.
Competitive intelligence benchmark analyzing 598,000+ CFPB consumer complaints and 2M+ mobile app store ratings across six major US financial institutions (BofA, Chase, Wells Fargo, PNC, Fifth Third, Truist). Normalized by deposit base, scores competitive gaps on a RICE framework, and deploys an interactive analytics dashboard to GitHub Pages with automated monthly ingestion.
Analytics engineering framework for customer journey and A/B experimentation using real Google Analytics 4 (GA4) event data. Features dbt models for funnel and cohort retention alongside a Python statistical library with 18 passing unit tests covering two-proportion z-tests, Welch's t-test, Mann-Whitney U, Benjamini-Hochberg FDR correction, and Difference-in-Differences estimation.
Securitization data ingestion pipeline and reconciliation engine processing SEC EDGAR ABS-EE loan-level disclosures. Normalizes subprime auto loan datasets into SQLite, validates cross-field balance and payment discrepancies, and models loan performance and delinquency metrics for Power BI portfolio analysis with automated validation tests.
Star schema data warehouse tracking UIUC graduate employment outcomes with SQL ETL pipeline feeding Tableau dashboards.
Video verification and deepfake detection API built for UIUC Cozad Challenge using frame analysis, Laplacian blur gating, and FastAPI.
Epsilon-delta differential privacy mechanisms applied to empirical datasets with privacy-utility trade-off evaluations.
Productivity auditing toolkit and MCP server for tracking velocity, code churn, and test impact in AI-assisted developer workflows.
Toolkit
Core tools and methodologies applied across production data pipelines and analytical modeling.
Analytics Engineering & SQL
Programming & Analysis
BI & Visualization
Statistics & Infrastructure
Background
Industry analytics experience at Accenture combined with graduate-level data engineering, warehousing, and quantitative analysis at UIUC.
2024 – 2026
Specializing in data warehousing, analytics engineering, statistical modeling, information architecture, and relational database design. Delivered end-to-end data pipelines and analytical platforms across all coursework.
2021 – 2024
2.5 years delivering operational reporting, SQL data transformations, and cross-functional performance dashboards across automotive operations and healthcare domains. Built automated reconciliation procedures and streamlined reporting workflows.
2024
Led analytics and data architecture for an AI-powered billing assistant and patient portal. Built retrieval over complex insurance policy documents with PHI/PII guardrails, evaluating performance and presenting to executive leadership.
2023 – 2024
Built VeriStream AI, a video verification API for deepfake detection, as part of UIUC's premier startup competition. Designed pipeline architecture, ML inference services, and interactive demo dashboards.
2023
Research assistant exploring cross-modal music accessibility for Deaf and Hard of Hearing users, contributing to transcription algorithms and experimental evaluation.
Open to full-time roles in Data Analytics, Business Intelligence, Analytics Engineering, and Data Engineering. Based in Champaign, IL — open to relocation and remote opportunities.