TruBridge logoCurrently an Extern @TruBridge

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

TruBridge

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 translated course concepts into concrete analytics work: I prepared datasets, ran exploratory and correlational analyses, and produced visuals suitable for interactive dashboards.

Project breakdown

View all work