RMOperations Management & Business Analytics Fellow
Rachel Mbolembe portrait

Fourth-year Information Science + Business student at the University of Maryland. Data Analytics Ext

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.

Work samples

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

  • Retail Sales Performance & Profitability Analysis

    Personal Project · Aug 2026

    Retail Sales Performance & Profitability Analysis

    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

    ExcelSQLTableau
  • Montgomery County Crime Database

    Coursework Project · May 2026

    Montgomery County Crime Database

    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

    MySQLERD Design

About me

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.

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

Process AnalysisRoot-Cause AnalysisKPI AnalysisData ValidationUser & Market ResearchBusiness RecommendationsStakeholder CommunicationCross-Functional CollaborationTechnical DocumentationSprint-StyleWorkflowPresentationsData StorytellingSQLMySQLRelational Database DesignExcelPivotTablesINDEX/MATCHAnalysis ToolPakTableauRPythonStatistical AnalysisEnglishFrench
Back to work

Retail Sales Performance & Profitability Analysis

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

ExcelSQLTableau

Overview

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.

View all work
Back to work

Montgomery County Crime Database

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

MySQLERD Design

Overview

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%.

View all work
Back to work

Business Licensing Awareness Research

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

U.S. Census DataInterview DesignCanva

Overview

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.

View all work