Projects using MySQL in NairobiProjects using MySQL in NairobiRoad Safety Analysis | Python, SQL & Power BI
Developed an end-to-end road safety analytics project to help authorities understand accident patterns, identify high-risk areas, and make informed decisions about road safety interventions.
The project involved cleaning and preparing road accident data using Python and Pandas, followed by SQL-based exploratory analysis to investigate accident trends, casualty figures, severity distributions, and geographical patterns.
Using Power BI, I transformed the findings into an interactive dashboard featuring key performance indicators and visualisations that provide an overview of accident activity, highlight trends over time, and reveal differences in accident occurrence across districts and locations.
The analysis also explored accident severity in relation to road types, weather conditions, lighting, and road surface conditions.
Tools used: Python, Pandas, SQL, Power BI.
Project deliverable: An interactive Power BI dashboard supported by data cleaning, transformation, and SQL analysis.
The objective was to turn raw accident data into clear, meaningful insights that can support evidence-based road safety planning and resource prioritisation. My Journey Into Building Systems That Actually Help Businesses
Most businesses don’t fail because of lack of effort.
They struggle because their systems are messy, slow… or don’t exist at all.
I’ve seen it.
People juggling spreadsheets, losing track of inventory, missing customer follow-ups, or running online stores that just don’t convert.
And honestly, it’s frustrating.
Because it doesn’t have to be that way.
What I Do
I help businesses bring order, automation, and clarity into their operations by building:
Web Applications
Clean, fast, and scalable systems that actually solve problems, not just look good.
eCommerce Platforms
Online stores that are easy to manage, optimized for conversions, and integrated with payments like M-Pesa, Stripe, and PayPal.
ERP Systems
Custom-built solutions to manage inventory, sales, customers, and internal processes, all in one place.
Why This Matters
Time is money.
Mistakes are expensive.
Manual work slows growth.
When your systems are working against you, your business feels heavier than it should.
I build solutions that:
Save you time
Reduce errors
Give you control
And help you scale with confidence
My Approach
I don’t just “build software.”
I take time to understand:
How your business works
Where things break
What can be improved
Then I create something that fits you, not a generic template.
Let’s Build Something Better
If you’re tired of:
Doing things manually
Outgrowing your current tools
Or struggling with inefficient systems
Let’s talk.
Sometimes, the right system changes everything.
Open to collaborations, projects, and conversations. Business Operations Dashboard for Service Management
Built an operational dashboard that helps service businesses manage daily operations from a centralized interface.
The dashboard provides quick access to jobs, customers, vehicles, invoices, and reports, allowing teams to track work progress and manage business data efficiently.
Features include job tracking, customer records, vehicle management, invoicing, reporting tools, and operational alerts. 
