Amazon Externship via Extern

I’m Bruktawit Mekonnen, exploring my next career move

Early-career professional evaluating new directions and building practical experience to find the right fit.

Work samples

A collection of early-career work and experiments that reflect skills I am developing and the directions I am exploring.

  • Patient Recovery Dashboard - Excel (Pivot tables, Slicers, Charts, Dashboard)
    Patient Recovery Dashboard - Excel (Pivot tables, Slicers, Charts, Dashboard)

    Extracted and cleaned an Excel file showcasing patient count, departments, treatment type, doctor name, gender, age, treatment cost, hospital stays, recovery score; Constructed Pivot Tables and automated KPI metrics (Average Treatment cost, Average age, Average Recovery Score, Average Recovery Score per doctor, etc.); Designed an interactive Excel dashboard with multi-criteria Slicers (Department type, treatment type, doctor name, patient gender)

    ExcelPivot tablesSlicersChartsDashboard
  • Community Context and Personas Capstone Project - UX Design (Figma)
    Community Context and Personas Capstone Project - UX Design (Figma)

    Served as Project Manager leading a 5-member research team to analyze voter engagement barriers and community context for the Southern Poverty Law Center (SPLC); Synthesized public datasets—including U.S. Census, Redistricting Data Hub, and BLS data—to identify systemic obstacles; Designed 4 detailed user personas and journey maps in Figma; Formulated actionable, persona-tailored strategic recommendations to enhance SPLCcommunity outreach initiatives and voter education programs.

    FigmaU.S. CensusRedistricting Data HubBLS data

About me

Early-career professional evaluating new directions and building practical experience to find the right fit.

I am Bruktawit Mekonnen. I have started my career and am exploring a possible change in direction, learning what fits next for my skills and interests.

Externships

Amazon Operational Strategy & People Analytics Externship

In progress

Experience

Capstone Project Manager

Southern Poverty Law Center · Feb. 2026 – May 2026

Membership Intern

International Association of Blacks in Dance · Aug. 2025 – May 2026

Circulation Desk Administrator

Michelle Smith Performing Arts Library · Feb. 2022 – Jan. 2025

Education

University of Maryland, College Park

Bachelor of Science, Information Sciences · Class of 2026

Skills

Career explorationAdaptabilityLearning mindset

Patient Recovery Dashboard - Excel (Pivot tables, Slicers, Charts, Dashboard)

Extracted and cleaned an Excel file showcasing patient count, departments, treatment type, doctor name, gender, age, treatment cost, hospital stays, recovery score; Constructed Pivot Tables and automated KPI metrics (Average Treatment cost, Average age, Average Recovery Score, Average Recovery Score per doctor, etc.); Designed an interactive Excel dashboard with multi-criteria Slicers (Department type, treatment type, doctor name, patient gender)

ExcelPivot tablesSlicersChartsDashboard
View all work

Community Context and Personas Capstone Project - UX Design (Figma)

Served as Project Manager leading a 5-member research team to analyze voter engagement barriers and community context for the Southern Poverty Law Center (SPLC); Synthesized public datasets—including U.S. Census, Redistricting Data Hub, and BLS data—to identify systemic obstacles; Designed 4 detailed user personas and journey maps in Figma; Formulated actionable, persona-tailored strategic recommendations to enhance SPLCcommunity outreach initiatives and voter education programs.

FigmaU.S. CensusRedistricting Data HubBLS data
View all work

Transforming and Analyzing Maryland Health Data - Python (Pandas, Matplotlib, Seaborn, Numpy)

Extracted, cleaned, and merged multi-source CDC PLACES and EPA Smart Location datasets across 3,500+ Maryland census tracts using Python - pandas; Standardized geographic identifiers (GEOIDs) and calculated custom wage distribution variables; Conducted exploratory data analysis to evaluate relationships between walkability, wage levels, and key public health metrics like adult depression and physical inactivity; Delivered data-driven insights and summary statistics to help public health officials and employers understand community health patterns across Maryland counties

PythonPandasMatplotlibSeabornNumpyCDC PLACESEPA Smart Location
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 examined turnover among new hires at Amazon fulfillment centers by collecting and analyzing employee reviews and people-data. The work combined web scraping, qualitative coding, and persona development to surface patterns in early-tenure exits and to produce concrete, persona-driven recommendations for Learning Ambassadors.

Amazon Operational Strategy & People Analytics Externship

What I've accomplished

I analyzed how fulfillment-center operations intersect with early-tenure retention, turning scraped employee reviews and operational context into evidence-backed observations and personas.

Project breakdown

View all work