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