Los Angeles, CA

Dhwani Jain

Information Systems & Business Analytics student at Loyola Marymount University

Experience

Data Analyst Intern

Jun 2026 – Present

HUM Nutrition · Los Angeles, CA

  • Delivered a data-driven commercial growth strategy to client leadership, analyzing 3+ years of HUM Nutrition's Target Corp sales and consumer demand to uncover GLP-1's rise to 56% of monthly sales.
  • Evaluated growth through analysis of sales patterns, finding select promotions that drove sales to a 33% lift - informing marketing decisions.
  • Automated HUM Nutrition's weekly ULTA Beauty sales reporting into a self-updating omnichannel dashboard (Google Apps Script, Excel) - tracking sell-through, inventory, and forecasting across SKUs, in-store, and e-commerce - cutting 3 hours/week of manual work.
  • Backfilled and validated 25 weeks of SKU and channel-level ULTA sales data and built pace-to-plan forecasting against an annual sales goal.

Data Analytics Engineer Intern

Jun 2026 – Aug 2026

DecisionNext · San Francisco, CA

  • Built 24+ automated ETL pipelines in Python ingesting trade, water, and satellite data from 15+ sources across REST APIs, web scraping, and PDF parsing - standardizing all outputs into a self-archiving schema.
  • Led a regression analysis to identify the drivers of Australian rice supply, testing 6 variables across 8 months against two targets using correlation analysis, multi-model OLS regression, and year-over-year detrending.
  • Synthesized findings into a stakeholder presentation proposing a forecasting approach to close the benchmark model's 50%+ error.

Business Analyst Intern

Jun 2025 – Aug 2025

Scorpio Tankers · Greenwich, CT

  • Delivered LNG bunkering vessel investment pitch, leveraging maritime datasets and scenario-based financial models to support strategic capital allocation; presented recommendations to 30+ stakeholders.
  • Built a predictive risk model using Prophet to forecast vessel incidents; authored a high-visibility report, flagging operational risks.
  • Performed on-site fieldwork aboard STI Modest, observing vessel operations and leveraging firsthand data to strengthen model outputs.

Student Research Assistant

Jan 2025 – Aug 2026

Digital Veterans Legacy Project · Los Angeles, CA

  • Leading research on biographical information for Veterans Interred at Los Angeles National Cemetery.
  • Curating biographies that are uploaded to Veterans Legacy Memorial Website.
  • Presented research at LMU's Undergraduate Research Symposium, showcasing findings to the broader research community.

Product Development Intern

Jun 2024 – Jul 2024

GeoServe Energy Transport DMCC · Dubai, U.A.E.

  • Completed the "Building a Database Agent" course on DeepLearning.AI, enhancing data sorting and analysis capabilities.
  • Leveraged PowerBI for validating UAT data within operations dashboards and performed detailed KPI analysis for bunker sales.
  • Conducted SEO analysis for Geoserve's verticals and competitors to increase online visibility.

Projects

L'Oréal Consumer Intelligence Dashboard - Lancôme Whitespace Analysis

Featured

End-to-end Consumer & Market Insights pipeline and Streamlit dashboard surfacing product whitespace for Lancôme from 600,000+ Sephora reviews.

  • Built an end-to-end Consumer & Market Insights (CMI) pipeline; deployed Streamlit dashboard to identify product whitespace opportunities for Lancôme from over 600,000 Sephora reviews.
  • Detected and classified consumer desire/need language across 5,951 Lancôme specific reviews into 9 consumer need themes using SQL and regex.
  • Automated weekly data pipelines via GitHub Actions and built an LLM-queryable brand knowledge base from 19 scraped sources.

LMU Datathon - 1st Place Winner

Featured

First place out of 150+ participants from 18+ universities, analyzing the impact of meal break regulations on EMT operations.

  • Competed against 150+ participants from 18+ universities.
  • Automated weekly data pipelines via GitHub Actions and built an LLM-queryable brand knowledge base from 19 scraped sources.
  • Analyzed the impact of meal break regulations on EMT operations using Python, SQL, and Excel; presented findings to 10+ industry judges.

Auto Recall Risk & Stock Impact Analysis

Finalist at Manhattan University's Business Analytics Competition 2026; NLP severity classifier and event-study model linking vehicle recalls to abnormal stock returns.

  • Competed against 100+ participants from 21+ universities nationwide.
  • Analyzed 18,000+ NHTSA vehicle recalls records (2000-2025); built an NLP severity classifier and event-study model linking recall intensity to abnormal stock returns across 15+ global OEMs.
  • Presented real-time investment signals and a back tested buy/avoid framework under live new-data conditions to industry judges.

Skills

Technical

  • Microsoft Excel
  • Microsoft Access
  • PowerBI
  • Python
  • Prophet
  • pandas
  • SQL
  • Java
  • JSON
  • Snowflake
  • Streamlit
  • dbt
  • Docker
  • GitHub Actions

Language

  • English
  • Hindi
  • Spanish
  • Arabic

Education

Loyola Marymount University (LMU)

Expected May 2027

Bachelor of Science, Information Systems and Business Analytics, minor in Computer Science

Coursework: Network Cloud Computing, Systems Analysis Design, Computer Systems Organization, Data Structures and Applications, Database Management Systems, Developing Business Applications using SQL, Computer Programming, Computer Graphics

Universal American School, Dubai

May 2023

International Baccalaureate Diploma

Awards & Leadership