Center for Improving Youth Justice Externship via Extern
Business analyst in training: turning stakeholder needs and data into clear requirements and recommendations. I turn data into clear analysis and visuals to inform youth justice policy and programs.
Portfolio of analysis, visualizations, and reports created during coursework and my externship with the Center for Improving Youth Justice.
Center for Improving Youth Justice · ✅ Verified by Extern · ⏱️ In progress
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.
Personal Project · Aug 2026
Defined business objectives, stakeholder questions, and KPIs, then analyzed 9,994 retail transactions across 21 attributes using Excel, SQL, and Tableau. Root-cause analysis showed that a region with $501K in sales earned only a 7.92% margin, driven by heavier discounting and loss-making product cat
Business analyst in training: turning stakeholder needs and data into clear requirements and recommendations. 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. My work centers on business analysis: researching what users and stakeholders need, structuring data, and communicating recommendations to non-technical audiences. I have hands-on experience with SQL, Excel, Tableau, and Python through a Data Analytics Externship with CIYJ, a product analyst fellowship, and coursework projects. I’m seeking entry-level Business Analyst, Business Systems Analyst, and Operations Analyst opportunities.
Externships
Data Analytics Externship with Center for Improving Youth Justice
In progress
Experience
Operations Management & Business Analytics Fellow
Robert H. Smith School of Business · Sept 2026 – Present
Business Operations Analyst Extern (Data Analytics)
Center for Improving Youth Justice · July 2026 – Present
Business Analyst, Product Requirements
Computing Catalyst Career Launch Hackathon · Nov 2025 – Jan 2026
Education
University of Maryland, College Park
B.S. Information Science; Minor, General Business (Robert H. Smith School of Business) · Class of 2027
Skills
✅ Verified by Extern · ⏱️ In progress
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.
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
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.
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.
Personal Project · Aug 2026
Defined business objectives, stakeholder questions, and KPIs, then analyzed 9,994 retail transactions across 21 attributes using Excel, SQL, and Tableau. Root-cause analysis showed that a region with $501K in sales earned only a 7.92% margin, driven by heavier discounting and loss-making product cat
Defined business objectives, stakeholder questions, and KPIs, then analyzed 9,994 retail transactions across 21 attributes using Excel, SQL, and Tableau. Root-cause analysis showed that a region with $501K in sales earned only a 7.92% margin, driven by heavier discounting and loss-making product categories. Built interactive dashboards and executive-style recommendations.
Coursework Project · May 2026
Collaborated with a five-member team to design a normalized (3NF) relational database from Montgomery County’s public 300K+ record crime dataset (cleaned 2021 to 2023 sample loaded). I contributed data preparation in Excel, SQL implementation, and validation. The team documented the architecture and
Collaborated with a five-member team to design a normalized (3NF) relational database from Montgomery County’s public 300K+ record crime dataset (cleaned 2021 to 2023 sample loaded). I contributed data preparation in Excel, SQL implementation, and validation. The team documented the architecture and methodology in a 10-page report and earned a 95%.
May 2026
Analyzed 2010–2020 Census data for Berwyn Heights, MD, finding Hispanic/Latino residents grew from 27% to ~36% while the White population fell from 56% to 41%, signaling possible language barriers to licensing information; designed a four-theme interview protocol and recruitment plan to validate bar
Analyzed 2010–2020 Census data for Berwyn Heights, MD, finding Hispanic/Latino residents grew from 27% to ~36% while the White population fell from 56% to 41%, signaling possible language barriers to licensing information; designed a four-theme interview protocol and recruitment plan to validate barriers with local business owners; presented charts and recommendations for multilingual businesses.