
SQL · Business intelligence
FruitCo SQL Analytics
Turn five years of messy harvest records into a confident expansion decision — by catching the SQL join that was quietly doubling the numbers.
Read the caseData · Automation · Decisions
I help agrifood teams, SMEs, and NGOs save time, reduce reporting errors, and act faster with automated workflows and decision-ready dashboards.

Genson Kithome
Data Analyst & AI Automation Expert

From field to decision
One clear view of the operation.
Selected work

SQL · Business intelligence
Turn five years of messy harvest records into a confident expansion decision — by catching the SQL join that was quietly doubling the numbers.
Read the case
Sales analytics · SQL
KES 267.8M in sales, five channels, four segments — separated real demand from discount-driven demand to find the channel that looked like growth but acted like a leak.
Read the case
Supply chain · Risk analysis
9,600 shipments across six cities, attributed stage by stage — to find the real point where product disappears before it reaches the customer.
Read the case
Profitability · SQL
47,693 orders across three outlets, costed end to end — to reveal the true profit after transport, storage, and labour are counted.
Read the caseHow I work
Each engagement begins with the operating decision—not a fashionable tool.
You share the problem. I clarify the decision before touching data.
I review your data and flag quality issues early.
We define success metrics tied to real decisions.
I build and test the system against real scenarios.
You get a working system your team can run independently.
I fix issues post-delivery and offer ongoing support.
Every engagement includes
Working in
Tools & technology
Analysis
Automation
AI & Intelligence
Build & Ship
My journey
2026 — Present
Spirdsheet Automations
Building SQL pipelines, dashboards, and reporting systems for small businesses.
2025 — 2026
Spird Farms
Built farm dashboards, feed models, and a delivery portal that improved fulfilment visibility.
2024 — 2025
Spird Farms
Standardised operational records and surfaced cost-saving opportunities from historical data.
2023 — 2024
Haraka Tutors
Mapped workflow bottlenecks and supported automated evaluation tools.
2019 — 2020
KNBS · Remotasks
Built an early foundation in accurate collection, annotation, and quality review.
Skills
SQL analytics
Data modelling
Data cleaning & validation
KPI reporting
Statistical analysis
Visual storytelling
Workflow automation
Google Apps Script
Spreadsheet systems
Dashboard development
Python fundamentals
Stakeholder handover
“The goal is not more data. It is a clearer next move.”
Contact