Extern logoCurrently an Extern @Extern
Rima Sehgal portrait

Aspiring Data Analyst

I'm a data science student passionate about transforming insights into impactful strategies.

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.

    Top performerDigital 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.

I am a third-year undergraduate student working towards a Bachelor's degree in Statistics and Data Science. My coursework and hands-on projects have honed my analytical skills, particularly in data analysis, statistical modeling, and machine learning. I have experience with programming languages like Python and R, along with tools such as SQL and Tableau. I take pleasure in transforming complex data into actionable insights and have completed projects that enhanced decision-making processes. I look forward to applying my skills in real-world situations and making a positive impact.

Externships

Excel & AI Financial-Modeling Sprint

Extern

Experience

Procurement Data Analyst Intern

WIPP Data · Sep 2026

Fashion E-Commerce Data Analyst Intern

Erthe · Aug 2026

Data Science Intern

Kelvolta · Jun 2026 - Aug 2026

E-Commerce Data Analytics & Strategy Extern

Breaking Games LLC · May 2026 - Jul 2026

Finance & Data Operations Chair

TAARA, UC Santa Barbara · May 2025 – May 2026

Education

University of California, Santa Barbara

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

Skills

Data AnalysisE-Commerce StrategyData ScienceStatistical AnalysisFinancial ModelingPower BISQLPython

✅ 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 consolidated Google Analytics, Meta and Google Ads, and Shopify exports to map user journeys, compute campaign- and product-level KPIs, inspect checkout behavior, and build interactive visualizations. Deliverables included campaign-level KPI tables, a quantified 59.9% checkout drop-off, top-SKU sales figures, and an interactive funnel dashboard. The work was awarded Top Performer by

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

What I've accomplished

I delivered a consolidated, interactive e-commerce funnel dashboard plus data-backed analyses: a 59.9% checkout drop-off calculation, campaign-level KPIs (impressions, clicks, conversions, CPA, ROAS), and product-level sales and conversion findings including the top-selling SKU.

Top performer

Project breakdown

View all work

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 work