@bruktawit-mekonnen

I’m Bruktawit Mekonnen, exploring my next career move

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

View my workMessage Me

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.

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
Back to work

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
Back to 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
Back to 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