Freelancers using MySQL in NairobiFreelancers using MySQL in Nairobi
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
111
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
246
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
225
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
241
MySQL(4)
Pete Sang's avatar
Pete Sang
Juja, Kenya
Full-Stack Web Developer | eCommerce & ERP Solutions
Full-Stack Web Developer | eCommerce & ERP Solutions
Cover image for My Journey Into Building
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.
2
68
Cover image for Deliver exceptional support with ticket
Deliver exceptional support with ticket management, SLA tracking, and customer care tools.
0
42
Cover image for Manage payroll, attendance, recruitment, and
Manage payroll, attendance, recruitment, and employee lifecycle from one unified platform.
0
46
Cover image for Streamline accounting, budgeting, invoicing, and
Streamline accounting, budgeting, invoicing, and financial reporting with real-time insights.
0
54
MySQL(5)
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
26
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
101
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)