Extern logoCurrently an Extern @Extern
Rima Sehgal portrait

Aspiring Business Data Analyst

I'm a data science student passionate about transforming insights into impactful strategies. Currently exploring e-commerce at Breaking Games.

Work samples

Dive into my portfolio showcasing e-commerce data analysis and strategic insights from my externship experience.

  • Breaking Games E-Commerce Data Analysis & Strategy Externship
    Breaking Games E-Commerce Data Analysis & Strategy Externship
    Breaking Games logo

    Breaking Games · Jul 2026 · ✅ Verified by Extern

    Breaking Games E-Commerce Data Analysis & Strategy Externship

    A Breaking Games externship focused on analyzing marketing and commerce data to diagnose funnel gaps and measure paid-ad and product performance.

    Digital MarketingSalesPresentation Skills
  • Retail Sales, Data Quality, and Pricing Analysis
    Retail Sales, Data Quality, and Pricing Analysis
    Retail Sales, Data Quality, and Pricing Analysis

    Automated a Python and SQL workflow to integrate, clean, and standardize 90+ product records from 3 retailers. Built a Power BI dashboard analyzing pricing, retailer positioning, data-quality exceptions, and trends across 8+ product attributes. Identified approximately 15% pricing variation and deve

    PythonSQLExcelPower BI

About me

I'm a data science student passionate about transforming insights into impactful strategies. Currently exploring e-commerce at Breaking Games.

I am a third-year undergraduate student working toward a Bachelor's degree in Statistics and Data Science. I am currently gaining hands-on experience through my externship at Breaking Games, where I analyze e-commerce data and develop strategies to enhance performance. This role allows me to apply my academic knowledge to real-world challenges, honing my analytical skills and understanding of data-driven decision-making.

Externships

Excel & AI Financial-Modeling Sprint

Extern

Experience

E-Commerce Data Analytics & Strategy Extern

Breaking Games LLC · May 2026 - Aug 2026

Fashion E-Commerce Data Analyst Intern

Erthe · Aug 2026

Data Science Intern

Kelvolta · Jun 2026 - Aug 2026

Finance & Data Operations Chair

TAARA, UC Santa Barbara · May 2025 – May 2026

Finance Intern

Diva Designs · Sep 2025 – Dec 2025

Education

University of California, Santa Barbara

B.S. Statistics and Data Science · Class of 2028

Skills

Data AnalysisE-Commerce StrategyData ScienceStatistical Analysis

✅ Verified by Extern

Breaking Games E-Commerce Data Analysis & Strategy Externship

A Breaking Games externship focused on analyzing marketing and commerce data to diagnose funnel gaps and measure paid-ad and product performance.

Digital MarketingSalesPresentation Skills

Overview

The work examined Google Analytics, Meta Ads, Google Ads, and Shopify exports to trace customer behavior across the e-commerce funnel. It combined user-journey mapping, campaign- and product-level KPI calculations, checkout inspection, and cross-platform consolidation. Deliverables included campaign-level KPIs, a quantified 59.9% checkout drop-off, top-SKU sales figures, and an interactive funnel

Breaking Games E-Commerce Data Analysis & Strategy Externship
Google Slides
Access

What I've accomplished

I produced a consolidated, interactive e-commerce funnel dashboard and a set of data-backed analyses, including a 59.9% checkout drop-off calculation, campaign-level KPIs, and product-level sales and conversion findings.

Project breakdown

View all works

Retail Sales, Data Quality, and Pricing Analysis

Automated a Python and SQL workflow to integrate, clean, and standardize 90+ product records from 3 retailers. Built a Power BI dashboard analyzing pricing, retailer positioning, data-quality exceptions, and trends across 8+ product attributes. Identified approximately 15% pricing variation and deve

PythonSQLExcelPower BI

Overview

Automated a Python and SQL workflow to integrate, clean, and standardize 90+ product records from 3 retailers. Built a Power BI dashboard analyzing pricing, retailer positioning, data-quality exceptions, and trends across 8+ product attributes. Identified approximately 15% pricing variation and developed recommendations for product positioning, pricing, and sales strategy.

Retail Sales, Data Quality, and Pricing Analysis

What I've accomplished

The main accomplishment was taking messy product data from three different retailers and turning it into something I could actually analyze and compare. I created visualizations around price versus rating, average discount percentage, and average ratings by retailer, which helped me understand how the retailers differed in pricing, promotions, and overall product performance.

View all works

✅ Verified by Extern · ⏱️ In progress

Excel & AI Financial-Modeling Sprint

Build a three-statement model, forecast with drivers, run a DCF, and pitch a company like a pro. In this 3-week sprint, GPT helps you work faster—so you can walk away with real valuation skills and a polished investor deck.

Overview

The externship covered building a three-statement financial model, forecasting using driver-based assumptions, running a discounted cash flow valuation, and preparing an investor-style pitch deck. Work combined spreadsheet modeling with AI-assisted drafting to accelerate model construction and narrative slides. Deliverables included a completed model, valuation outputs, and a polished investor

Excel & AI Financial-Modeling Sprint

What I've accomplished

I built a full financial model and supporting materials over a three-week sprint, using AI tools to speed calculation and narrative tasks. Below are the key steps I completed and the artifacts I produced.

Project breakdown

View all works