Center for Improving Youth Justice logoCurrently an Extern @Center for Improving Youth Justice
Rachel Mbolembe portrait

Fourth-year Business & Data analytic student focused on youth justice

I turn data into clear analysis and visuals to inform youth justice policy and programs.

Work samples

Portfolio of analysis, visualizations, and reports created during coursework and my externship with the Center for Improving Youth Justice.

  • Retail Sales Performance Analysis

    Personal Project · Jul 2026

    Retail Sales Performance Analysis

    Conduct an end-to-end analysis of 9,994 retail transactions across 21 business attributes to evaluate sales, profitability, customer segments, product categories, and regional performance. I defined the business objectives, stakeholder questions, and KPIs before conducting the analysis, then used tr

    ExcelTableauSQLKPI TrackingBusiness Analysis
  • Montgomery County Crime Database
    Montgomery County Crime Database

    Coursework Project · May 2026

    Montgomery County Crime Database

    Collaborated with a five-member team to transform more than 300,000 public Montgomery County crime records into a structured relational database. I contributed to data preparation in Excel, normalization through 3NF, relational database design, SQL implementation, and validation.

    MySQL WorkbenchSQL

About me

I turn data into clear analysis and visuals to inform youth justice policy and programs.

I’m Rachel Mbolembe, a fourth-year Information Science student at the University of Maryland with a minor in General Business. I have experience in data analytics, business analysis, research, and data visualization, including a Data Analytics Externship with CIYJ. I’m seeking Business Analyst, Data Analyst, Operations Analyst, and Product Analyst opportunities where I can turn data into actionable insights and support better decisions.

Externships

Data Analytics Externship with Center for Improving Youth Justice

Center for Improving Youth Justice

Experience

Data Analytics Extern

Center for Improving Youth Justice (CIYJ) · July 2026 – Present

Business and Product Analyst Fellow, AllVoyager

AllVoyager · Nov 2025 – Jan 2026

Education

University of Maryland, College Park

Bachelor of Science in Information Science | Minor in General Business. Dean's List | Fall 2025. · Class of 2027

Skills

Data analysisData visualizationReporting and documentationPolicy-focused data workExcel or spreadsheet analysisBusiness Analysis
Back to works

Retail Sales Performance Analysis

Conduct an end-to-end analysis of 9,994 retail transactions across 21 business attributes to evaluate sales, profitability, customer segments, product categories, and regional performance. I defined the business objectives, stakeholder questions, and KPIs before conducting the analysis, then used tr

ExcelTableauSQLKPI TrackingBusiness Analysis

Overview

Conduct an end-to-end analysis of 9,994 retail transactions across 21 business attributes to evaluate sales, profitability, customer segments, product categories, and regional performance. I defined the business objectives, stakeholder questions, and KPIs before conducting the analysis, then used trend and root-cause analysis to investigate performance differences and identify potential outcomes.

View all works
Back to works

Montgomery County Crime Database

Collaborated with a five-member team to transform more than 300,000 public Montgomery County crime records into a structured relational database. I contributed to data preparation in Excel, normalization through 3NF, relational database design, SQL implementation, and validation.

MySQL WorkbenchSQL

Overview

Collaborated with a five-member team to transform more than 300,000 public Montgomery County crime records into a structured relational database. I contributed to data preparation in Excel, normalization through 3NF, relational database design, SQL implementation, and validation.

Montgomery County Crime Database

Outcome

The resulting database supported analysis across geographic areas, police districts, and offense categories while incorporating responsible data-management considerations for sensitive public information. The team documented the database architecture and methodology in a 10-page report and earned a 95% project grade.

View all works
Back to works

Business Licensing Awareness Research

Investigated why business owners in Berwyn Heights, Maryland could experience difficulty accessing or understanding licensing information. I analyzed Census demographic trends, including population, age, race and ethnicity, and language accessibility, and designed a qualitative research approach inv

researchDemographic AnalysisStakeholder ManagementRecommendations

Overview

Investigated why business owners in Berwyn Heights, Maryland could experience difficulty accessing or understanding licensing information. I analyzed Census demographic trends, including population, age, race and ethnicity, and language accessibility, and designed a qualitative research approach involving local business-owner interviews.

Business Licensing Awareness Research

What I've accomplished

I was able to recommend new strategies with data visualizations.

Outcome

Based on the analysis, I developed recommendations including multilingual resources and expanded community outreach. The project was selected by my instructor to be shared with another researcher conducting related community studies. I recorded and uploaded a presentation pitch on YouTube.

View all works
Back to works

AllVoyager Product Analysis

Conducted user and market research to identify traveler pain points related to planning, budgeting, navigation, and information overload. Translated research findings into functional requirements and prioritized product features for a centralized travel-planning application. Created a travel website

Requirements GatheringUser ResearchFigmaProduct

Overview

Conducted user and market research to identify traveler pain points related to planning, budgeting, navigation, and information overload. Translated research findings into functional requirements and prioritized product features for a centralized travel-planning application. Created a travel website. Presented findings and demonstrations to peers &industry profesional.

AllVoyager Product Analysis

What I've accomplished

View all works

✅ Verified by Extern · ⏱️ In progress

Data Analytics Externship with Center for Improving Youth Justice

A data analytics externship with the Center for Improving Youth Justice, focused on analyzing long-term juvenile justice datasets to surface correlations in incidents, demographics, and outcomes.

Data AnalysisPythonData VisualizationStatistical Research

Overview

The externship worked with CIYJ's multi-decade juvenile justice dataset, including incident reports, surveys, demographic records, and outcome measures. The project established what kinds of correlational analysis the data can support and documented methodological limitations and appropriate analytic roles. The work summarized analytic approaches and clarified where the dataset could reliably

Data Analytics Externship with Center for Improving Youth Justice

What I've accomplished

I cataloged the YouthClimate sheet, quantifying its scale (over 4,000 rows and 90 columns), identified each row as an individual survey response, and recorded where the codebook and variable descriptions resided.

Project breakdown

I examined the YouthClimate sheet, counted scale (4,000+ rows, 90+ columns), identified each row as one youth survey response, noted two tabs (data and codebook), and recorded where variable descriptions lived for later analysis.

Google Sheets
Access
View all works