Peter Mangoro — Data Analyst
About
What I do
Analytics work spanning cleaning, modeling, dashboards, and production data systems.
Data Analysis
Clean messy, multi-source data and turn it into KPIs, trends, and decision-ready insights.
Dashboards & BI
Tableau, Streamlit, and Shiny dashboards for technical and non-technical stakeholders.
SQL & Pipelines
Schema design, reporting queries, and reproducible SQL-backed analytics workflows.
Machine Learning
Interpretable models, NLP at scale, and honest holdout evaluation stakeholders can trust.
Cloud ETL
Serverless AWS pipelines from ingest to Athena SQL and interactive dashboards.
Data Storytelling
Clear reporting that connects metrics to operational and business decisions.
0M+
Million reviews modeled
0
Hospitals in ML study
0+
Users on production systems
0%
Manual work reduced
Skills
Work Experience
Software Developer at Propertybook
Aug 2024 – Dec 2024
- Built Laravel/PostgreSQL backends, APIs, and reporting workflows for property operations.
- Improved data capture and automated listing/reporting (~30% less manual work; ~40% less data-entry time).
- Supported ~20% improvement in lead conversion through more reliable operational data and stakeholder reporting.
Software Developer at SoliderMed
Jan 2023 – Aug 2024
- Built Django/Laravel healthcare applications handling sensitive patient and operational data.
- Designed database schemas and SQL-backed reporting; replaced ad hoc spreadsheets with reproducible reports.
- Automated reconciliation and operational workflows (~30% reduction in manual processing).
Software Engineer at DataConexions
Jan 2022 – Dec 2024
- Built and maintained SQL-backed applications, APIs, and data access layers for platforms used by 10,000+ users.
- Owned schema design, reporting-related queries, production support, and technical documentation.
- Partnered with stakeholders to deliver reliable data workflows under changing priorities.
Featured projects
Traffic Violation Data Analysis
Jan 2025 - June 2025
2.8M+ traffic records turned into Tableau & Streamlit KPIs for non-technical stakeholders
Analyzed 2.8M+ public traffic enforcement records to surface trends, patterns, and KPIs for non-technical stakeholders. Built Python ETL, Tableau, and Streamlit dashboards for safety and enforcement insights.
AWS Serverless ETL Pipeline
Dec 2025
Serverless ETL (S3 → Glue → Athena → dashboards) at ~$1–2/month with Parquet cost savings
End-to-end serverless ETL for e-commerce sales data—from ingest to SQL analytics and dashboards—at ~$1–2/month. S3 + Lambda + Glue into Parquet, Athena SQL, QuickSight/interactive dashboards, with data-quality checks.
Amazon Review Sentiment at Scale
Spring 2026
4M-review NLP pipeline with locked holdout — F1 ~0.906, ROC-AUC ~0.966
Group capstone on binary sentiment over a 4M Amazon Reviews corpus (3.6M train / 400k locked test). Compared linear models, Random Forest, MLP, and DistilBERT under strict leakage controls—TF–IDF + linear baseline reached F1 ~0.906 / ROC-AUC ~0.966.
Hospital Readmission Prediction Model
Aug 2025 - December 2025
30-day readmission models across 130 U.S. hospitals + interactive Shiny dashboard
Interpretable ML to predict 30-day hospital readmissions across 130 U.S. hospitals—logistic regression, CART, and Random Forest—with an R Shiny dashboard for clinical/analytics stakeholders.
Fraud Detection System
Aug 2025 - Sept 2025
Isolation Forest anomaly detection with a live Streamlit monitoring dashboard
Unsupervised anomaly detection for mobile-money-style transactions using Isolation Forest, with behavioral/geographic/temporal features and a live Streamlit monitoring dashboard.
GraphRAG Research Chatbot (Neo4j + LLM)
Spring 2026
Neo4j + vector GraphRAG research assistant with grounded citations and streaming UI
Built a graph- and vector-grounded research assistant over a scientific PDF corpus with route-aware retrieval, streamed citations, and a production chat UI—combining Neo4j knowledge graphs, vector search, and grounded LLM answers.
Latest writing
Notes on data analytics methodology, cloud pipelines, and graph systems
Let's talk roles
Prefer a quick intro call?
Book 15–20 minutes to talk about Data Analyst / analytics roles and how I can help your team.
