Freelancers using MySQL in Nairobi CountyFreelancers using MySQL in Nairobi County
ProjectsPeople
Samuel Maina's avatar
Samuel Maina
Nairobi, Kenya
Data Analyst | SQL, Python, Excel, and Power BI Expert.
New to Contra
Data Analyst | SQL, Python, Excel, and Power BI Expert.
Cover image for Road Safety Analysis | Python,
Road 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.
1
110
Cover image for Retail Inventory and Sales Analysis Retailers
Retail Inventory and Sales Analysis Retailers collect plenty of sales and inventory data, but turning it into useful decisions about stock, demand, and revenue isn't always straightforward. I built this project to bring those numbers together in one interactive Power BI dashboard. I used Python and Pandas to clean and prepare the data, handling missing values according to their business meaning, then used MySQL to analyze sales, inventory, discounts, product categories, regions, and seasonal trends. The dashboard brings together key metrics such as revenue, total stock, demand fulfillment, number of products, and average discount. It also shows sales by category, monthly trends, regional performance, inventory against demand forecasts, and seasonal patterns. One of the key findings was a 95.72% demand fulfillment rate. The analysis also showed relatively balanced sales across the five product categories and similar performance across the four seasons. These insights help highlight sales trends and areas where inventory and demand may need closer attention. The screenshot shows the dashboard overview, with the complete project available on GitHub.
1
245
Cover image for Retail Fraud Analysis Retail businesses need
Retail Fraud Analysis Retail businesses need to detect fraud without unnecessarily flagging legitimate transactions. I built this project using 100,000 retail transactions to explore fraud patterns and identify where financial risk was concentrated. During data exploration, I found that the original fraud-risk score was stuck at 0.0 across all records, while two location fields contained duplicate information. Rather than inventing a score, I created transparent Low, Medium, and High risk classifications using available security indicators, including transaction velocity, proxy/VPN usage, and high-risk devices. I used SQL to clean and prepare the data, then built an interactive Power BI dashboard covering the overall picture, fraud detection, and recommendations. One key finding was that medium-risk transactions represented approximately $7.1 million in financial exposure, compared with $3.3 million for high-risk transactions. The analysis also showed that fraud activity was concentrated in lower transaction-value brackets. The overview below shows the project, while the full analysis is available on GitHub.
1
224
Cover image for Security Support Information System This project
Security Support Information System This project focuses on improving operational visibility and decision-making in the private security industry. I built an end-to-end Business Intelligence solution using Python for data cleaning and transformation, MySQL for database design and data management, and Power BI for the dashboards. The final solution brings everything together in four dashboards: Executive Overview, Workforce Analytics, Operations Analytics, and Commercial Analytics.
1
240
MySQL(4)
Amos Mutai's avatar
Amos Mutai
Nairobi, Kenya
Experienced Fullstack Engineer - React/NextJS
Experienced Fullstack Engineer - React/NextJS
Cover image for Unifilters Kenya E-commerce Website
Unifilters Kenya E-commerce Website
0
30
Cover image for Mkombozi Healthcare
Mkombozi Healthcare
0
25
Cover image for Wilex GMBH Website
Wilex GMBH Website
0
11
Cover image for Honest Experiences website
Honest Experiences website
0
17
MySQL(1)
Manaseh Maingi's avatar
Manaseh Maingi
Nairobi, Kenya
Creative WordPress Designer
Creative WordPress Designer
Cover image for woocommerce website
woocommerce website
0
15
Cover image for Pharmaceutical distributor website
Pharmaceutical distributor website
0
5
Cover image for Glass and Aluminium Website
Glass and Aluminium Website
0
2
Placeholder project card media
View more →
MySQL(1)
Enock Abel's avatar
Enock Abel
Nairobi, Kenya
Web developer
    5.0
    Rating
    2
    Followers
Web developer
Cover image for QandAHub: a UK edtech Q&A
QandAHub: a UK edtech Q&A platform I co-developed with another developer. Students ask questions and join live classes, with real time notifications. Laravel, React and Inertia.js, with Agora powering live video.
1
129
Cover image for GM Rides: a transport booking
GM Rides: a transport booking platform for the Kenyan market that I built and deployed end to end. It covers one way, round trip and airport transfer search, dynamic fares, seat selection, M-Pesa and Stripe payments, multi-currency pricing, an AI chatbot and an admin dashboard. Next.js and Laravel 11, live at gmrides.net (http://gmrides.net).
1
1
107
Cover image for Sagini AI Analytics: an AI
Sagini AI Analytics: an AI data intelligence platform I built and deployed end to end. Users upload data files and get AI insights, interactive charts, anomaly detection and a Q&A chat over their own data. Python, FastAPI and the Claude API, live at sagini.net (http://sagini.net).
1
1
110
Cover image for Ranksit: an AI content and
Ranksit: an AI content and SEO platform I built and deployed end to end. It scores articles against 20 SEO checks, with Google sign in and an admin analytics dashboard. Python, FastAPI and HTMX, live at ranksit.net (http://ranksit.net).
1
1
100
MySQL(1)
bonface oyondi's avatar
bonface oyondi
Nairobi, Kenya
Prompt engineer building intelligent AI workflows.
New to Contra
Prompt engineer building intelligent AI workflows.
Cover image for My project of a live website. click here to check it out: wa...
My project of a live website. click here to check it out: waypointclm.com (http://waypointclm.com)
0
10
Cover image for PROMPT
PROMPT
0
49
Cover image for AI, AUTOMATION AND DESIGN
AI, AUTOMATION AND DESIGN
0
52
Cover image for My work
My work
0
50
MySQL(1)
Karisa Michael's avatar
Karisa Michael
Nairobi, Kenya
Web and mobile developer.
Web and mobile developer.
Cover image for Sports Streaming solution for clubs
Sports Streaming solution for clubs
0
48
Cover image for Over 3years + since I
Over 3years + since I started using flutter clean ui and a good control on animations. Trying various solutions to make 4retails a reality stock, debt and sales brought to new heights.
0
59
Cover image for I’ve been tinkering with how
I’ve been tinkering with how small retail shops operate. Most don’t use laptops at the counter, just smartphones, yet many still rely on handwritten debt books and manual stock tracking. When staff change, confusion follows. Using Flutter, I built 4Retails, a mobile first app that records sales via keypad or voice, tracks debts digitally, monitors stock inflow and outflow, and shows product trends to help owners stock smarter.
0
30
Cover image for You sit down to apply
You sit down to apply for an internship or job. You open a resume template. It looks outdated. You try another website. Too many ads. You finally find one that looks decent… and it asks for a subscription. Frustrating, right? That’s exactly why I built a better solution. I created a Mobile-First Resume Builder designed for simplicity, privacy, and affordability, especially for students and young professionals who just want to create a clean, professional resume without stress. It has been quite a journey.
1
36
MySQL(1)