Data Analyst

Joel Esparza

********@********.*** 708-***-**** *1524 S. Lavergne, Alsip, IL 60803 LinkedIn Github

Education

Graduate: University of Illinois at Urbana-Champaign

Master of Science – Business Analytics, Finance Graduation Date: May 2024

Cumulative GPA: 3.89/4.00

Undergraduate: University of Illinois at Urbana-Champaign

Bachelor of Arts – Economics Graduation Date: May 2023

Bachelor of Science – Finance Graduation Date: December 2022

Cumulative GPA: 3.62/4.00

Work Experience

Misumi USA Schaumburg, IL

Data Analyst August 2024 – February 2025

Automated Excel workflows into streamlined ETL pipelines using Python, enhancing operational efficiency

Tracked KPI metrics, prepared monthly presentations for upper management, and optimized stock management for 150k SKUs through new templates and processes

Developed Tableau dashboards to monitor inventory trends and support strategic decision-making

Researched & proposed a new inventory management system by engineering features, performing PCA, and forecasting demand using machine learning models, including Neural Networks, RNNs, Random Forests, and XGBoost. Created simulation to compare performance of current & proposed system, highlighting key metrics

Untrade Partners Remote

Quantitative Researcher Development Program June 2024 – Present

Developed and refined trading strategies using Python, leveraging data analysis tools and mentorship to optimize performance

Reduced market noise through variety of methods (HA Candles, Renko blocks, principal components, etc.)

Aggregated metrics of interest to implement trading strategies that meet required benchmarks

Outlier Remote

Large Language Model Evaluator (Contractor) June 2024 – September 2024

Designed and evaluated prompts to optimize Large Language Models (LLMs) for reliability and accuracy

Reviewed and edited AI responses, ranking outputs and refining JSON code for quality

Assessed text outputs to enhance AI training with clear, actionable feedback

Business Practicum: Chicago Transit Authority (CTA) Remote

Economic Researcher September 2023 – May 2024

Project managed team of 6 for providing significant evidence against government proposal of $400m defunding

Collected, Cleaned, Joined, & Analyzed multiple external & internal datasets for data preparation

Quantified transit accessibility for numerous factors to analyze economic impact of these factors at 60% decrease in operations

Performed quantitative analysis through construction of Machine Learning & Statistical models

Presented to client bi-weekly to show progress/results & gather feedback

Iowa Graduate Business Analytics Case Competition (Ball Corp) March 2024 – April 2024

Competed in internal competition amongst cohort to determine UIUC’s representatives. Finished top 4 amongst peers in attaining highest prediction % in classification model (machine learning competition)

Competed against 16 universities across the nation, analyzing operational and HR datasets to offer solutions in enhancing operational excellence across 16 Ball Corp manufacturing plants. Presented to industry experts

Camping World Chicago, IL

Corporate Development Intern June 2023 – August 2023

Optimized product store placement by assembling an Excel model to help minimize transportation costs

Forecasted future retail sales across 190+ stores to provide targets for manager variable compensation

Formatted training checklists & manager report cards to improve labor force at lowest level

Collaborated with team of 5 to identify solutions for high employee turnover rates by conducting interviews with current & former employees

Skills & Distinctions

Excel (VBA)

SQL

President’s Award (2019-23)

Tableau

R Studio

ETL Process Automation

Machine Learning Models

Python

Dean’s List (2020-24)

Feature Engineering

Data Pipelining

PowerPoint/Word

Contact this candidate