Amazon logoAmazon Externship via Extern
Geraldine Nyika portrait

Data scientist-in-training focused on analytics

I turn messy data into dashboards and consumer insights using SQL, survey design, and AI tools.

Work samples

Portfolio includes a Beats by Dre externship on consumer behavior and a Breaking Games externship converting CSVs into an analytics database and a Q4 dashboard using SQL and AI.

  • Beats by Dre Consumer Behavior & Market Analysis Externship
    Beats by Dre Consumer Behavior & Market Analysis Externship
    Beats By Dre logo

    Beats By Dre · Aug 2025 · ✅ Verified by Extern

    Beats by Dre Consumer Behavior & Market Analysis Externship

    Discover how top brands like Beats by Dre turn consumer insights into products people can’t resist. Dive into the psychology of buying decisions, master survey design, and use cutting-edge AI tools to analyze real consumer data. In this externship you’ll gain hands-on experience shaping marketing strategy for a leading global brand—perfect for anyone curious about marketing, psychology, or product innovation.

    Market ResearchData AnalysisPresentation Skills
  • SQL & Database Architecture Externship with Breaking Games
    SQL & Database Architecture Externship with Breaking Games
    Breaking Games logo

    Breaking Games · Sep 2026 · ✅ Verified by Extern

    SQL & Database Architecture Externship with Breaking Games

    Turn six messy CSVs into an analytics database and a Q4 dashboard that drives real business decisions. SQL + Claude.

    Analytics Database DesignData AnalysisSQL FundamentalsData Storytelling

About me

I turn messy data into dashboards and consumer insights using SQL, survey design, and AI tools.

I am a graduate student in Data Science focused on data analytics. My work includes externships in consumer behavior analysis and in SQL and database architecture, where I turned messy CSVs into an analytics database and built a Q4 dashboard.

Externships

Amazon Operational Strategy & People Analytics Externship

In progress

Education

Eduvos

BSc (Honours) in Information Technology - Data Science · Class of 2025

Honours in Information Science

Information Science · Class of 2022

Bachelor in Information Science

Applied Information Science · Class of 2019

Skills

SQLDatabase architectureDashboard designSurvey designConsumer behavior analysisAI tools for analysis

✅ Verified by Extern

Beats by Dre Consumer Behavior & Market Analysis Externship

Discover how top brands like Beats by Dre turn consumer insights into products people can’t resist. Dive into the psychology of buying decisions, master survey design, and use cutting-edge AI tools to analyze real consumer data. In this externship you’ll gain hands-on experience shaping marketing strategy for a leading global brand—perfect for anyone curious about marketing, psychology, or product innovation.

Market ResearchData AnalysisPresentation Skills

Overview

This externship produced a set of consumer-research artifacts grounded in a 12-question survey and analysis plan. Work included a five-type Ideal Consumer List, a deployed survey about drivers of interest in high-fidelity wireless speakers, a data analysis plan covering qualitative codes and cross-question calculations, and a presentation outlining satisfaction drivers, gaps, and a proposed $99

Beats by Dre Consumer Behavior & Market Analysis Externship
Google Docs
Access

What I've accomplished

I produced a research package that included five detailed consumer profiles, a deployed 12-question survey, a final analysis plan with coding and cross-question calculations, and a presentation that recommended targeting 18–24-year-olds plus a $99 SKU.

Project breakdown

View all work

✅ Verified by Extern

SQL & Database Architecture Externship with Breaking Games

Turn six messy CSVs into an analytics database and a Q4 dashboard that drives real business decisions. SQL + Claude.

Analytics Database DesignData AnalysisSQL FundamentalsData Storytelling

Overview

The externship converted six raw e-commerce CSVs into a structured local analytics database and a dashboard-ready schema. Work involved cataloging each data source, ingesting and cleaning the CSVs, and configuring a SQLite database for analysis. Deliverables included the populated database files and documentation of the schema.

SQL & Database Architecture Externship with Breaking Games
Google Drive
Access

What I've accomplished

I produced an inventory of six raw data sources, created a populated SQLite database, and wrote five example SQL queries that returned results such as top products by units and by revenue.

Project breakdown

View all work

✅ Verified by Extern · ⏱️ In progress

Amazon Operational Strategy & People Analytics Externship

Imagine shaping how AMAZON — yes, THE Amazon — welcomes and keeps its workforce. Every year, Amazon loses billions because new hires leave before Day 90. You’re going to fix that. In this externship, you’ll web scrape real-world employee reviews from across the web, extract actionable insights, and design persona-driven strategies to help Learning Ambassadors connect smarter, faster, and more humanely. It’s part research, part strategy—and all about learning how people data drives big decisions.

Data AnalysisPythonStrategyOperations

Overview

The project analyzed employee feedback and operational context at Amazon fulfillment centers, synthesizing quantitative and qualitative signals to identify drivers of early turnover. The work combined web-scraped reviews, persona segmentation, and operational analysis to produce actionable insights and recommended interventions for Learning Ambassadors.

Amazon Operational Strategy & People Analytics Externship

What I've accomplished

I combined operational research with people-analytics methods to understand the fulfillment-center environment and how it relates to new-hire experience. Below are the discrete pieces of work I produced during the externship.

Project breakdown

View all work