TruBridge Externship via Extern

Graduate student at Yeshiva University starting a career

Master's student exploring opportunities and building practical skills before launching my career.

View my workMessage Me

Work samples

A record of coursework, practice work, and early projects created while I complete my master's and prepare for professional roles.

  • Data Modeling & Database Systems Project
    Data Modeling & Database Systems Project

    Designed and implemented a full end-to-end Disease Data Management solution, including an enhanced ER model with 8+ entities, a complete data dictionary, and a fully normalized PostgreSQL OLTP database with referential integrity. Built and populated the database with realistic data, executed operational queries, and demonstrated business rule behavior through DML operations. Populated the database with 1,000+ rows of realistic synthetic data and executed 20+ operational SQL queries to validate business logic, constraints, and DML behavior across core tables. Developed a dimensional data warehouse using Kimball techniques, creating 4 fact tables and 8 dimension tables, and engineered ETL/ELT pipelines that processed 50,000+ records to deliver BI-ready analytical structures for advanced reporting.

    PostgreSQL
  • API Project: Data Retrieval and Storage with Redis and MongoDB
    API Project: Data Retrieval and Storage with Redis and MongoDB

    Designed and implemented a RESTful API to retrieve, cache, and store structured data using Redis and MongoDB. Built scalable data models and optimized query performance to support fast, reliable data access. Integrated Python and Node.js to enhance backend functionality and streamline data processing workflows. Improved data retrieval speed and reduced server load through efficient caching strategies.

    RedisMongoDBPythonNode.js

About me

Master's student exploring opportunities and building practical skills before launching my career.

I am Brandon Mahachi, a graduate student at Yeshiva University pursuing a masters degree. I am beginning my career and using my time in grad school to learn, explore opportunities, and build a foundation for professional work.

Externships

TruBridge Healthcare Data Analytics Externship

In progress

Experience

Junior Financial Analyst Intern

FBC Holdings, Harare, Zimbabwe · August 2023 - July2025

Education

Yeshiva University, Katz School of Science and Health New York, NY

Master of Science in Data Analytics and Visualization, GPA : 3.6 · Class of 2027

University of Zimbabwe Harare, Zimbabwe

Bachelor of Science Honours Degree in Financial Mathematics, GPA: 3.5 · Class of 2024

Skills

Graduate-level studyLearning and professional developmentAcademic research
Back to work

Data Modeling & Database Systems Project

Designed and implemented a full end-to-end Disease Data Management solution, including an enhanced ER model with 8+ entities, a complete data dictionary, and a fully normalized PostgreSQL OLTP database with referential integrity. Built and populated the database with realistic data, executed operational queries, and demonstrated business rule behavior through DML operations. Populated the database with 1,000+ rows of realistic synthetic data and executed 20+ operational SQL queries to validate business logic, constraints, and DML behavior across core tables. Developed a dimensional data warehouse using Kimball techniques, creating 4 fact tables and 8 dimension tables, and engineered ETL/ELT pipelines that processed 50,000+ records to deliver BI-ready analytical structures for advanced reporting.

PostgreSQL
View all work
Back to work

API Project: Data Retrieval and Storage with Redis and MongoDB

Designed and implemented a RESTful API to retrieve, cache, and store structured data using Redis and MongoDB. Built scalable data models and optimized query performance to support fast, reliable data access. Integrated Python and Node.js to enhance backend functionality and streamline data processing workflows. Improved data retrieval speed and reduced server load through efficient caching strategies.

RedisMongoDBPythonNode.js
View all work
Back to work

NYC Government Payroll Visualization & Reporting Project

Analyzed payroll data for 2.3M+ employees, identifying that 72% earn between $0–$100K. Highlighted $109B+ payroll concentration in Manhattan to support equity analysis. Identified 723K inactive or seasonal employees affecting workforce costs. Evaluated agency spending and flagged high overtime usage in Police & Fire departments. Tracked payroll growth from 2018–2025, revealing significant spikes in 2024–2025. Analyzed payroll data for 2.3M+ employees, identifying that 72% earn between $0–$100K.

View all work
Back to work
TruBridge ↗

✅ Verified by Extern · ⏱️ In progress

TruBridge Healthcare Data Analytics Externship

A TruBridge externship focused on applied healthcare data analytics, using public health datasets to identify patterns and produce interactive analyses.

Data AnalysisData VisualizationData Storytelling

Overview

The externship worked with large public healthcare datasets to explore infection trends and apply statistical and visualization techniques. The work synthesized foundational analytics concepts, built reproducible analyses, and produced interactive outputs for trend and model inspection. Deliverables included cleaned datasets, exploratory analysis, and dashboard-ready visualizations.

TruBridge Healthcare Data Analytics Externship

What I've accomplished

I located county-level diabetes prevalence and median household income datasets, validated they shared a FIPS county identifier, and assessed them against a six-dimension fitness checklist for analysis.

Project breakdown

Faced with finding analyzable health data, I searched public repositories, selected county-level diabetes rates and median household income, and committed to the CDC Places dataset (and Census income data) as a joinable pair using FIPS codes.

Open Link

I examined CDC PLACES and U.S. Census ACS, recorded units, row/column counts, documentation sources, and planned preprocessing steps. I noted 3,143 county rows per source, column inventories, and a FIPS-based merge strategy.

Google Docs
Access

I selected Pearson correlation for two continuous variables, ran the test on U.S. county data, and reported a moderate, statistically significant negative correlation (r = -0.45, p < 0.001, n = 3,141). I summarized results in a short, no-jargon narrative.

Google Docs
Access

I ran the 9-item checklist on county-level diabetes and income data, then rewrote the finding into Pattern, Strength, Limits, Implication. The result reported a consistent inverse income-diabetes pattern, noted age and ecological limits, and offered non-directive programmatic implications.

Google Docs
Access
View all work