Engineering expertise

Databases & data modeling

SQL, PostgreSQL, graph & application data engineering

I treat the data model as part of the product design. Invoices, tenant credit, patient context, payment ledgers, cargo assignments, journal entries, local mobile state, and recommendation history all become easier to reason about when the database expresses the real business relationships clearly.

What this looks like in practice

  • Accounting-oriented invoice, payment, credit, lease, property, unit, and tenant relationships in RentPayor.
  • Patient, encounter, facility, billing, orders, movement, and receipt state in CliviQue HMIS.
  • Operational load, reservation, driver, fleet, payout, and immutable ledger state in Macsim Cargo.
  • SQLite/local state and cloud-backed application data patterns in mobile products.

Core technologies

PostgreSQLSQLSQLAlchemyAlembicSQLiteNeo4jGraph dataAsyncStorageCaching patterns

Project evidence

Products that demonstrate this capability

Each project below links to a deeper case study covering product scope, engineering ownership, supporting systems, and production evidence.

Enterprise · Case study

RentPayor

Rent collection and reconciliation software for landlords and property managers. RentPayor connects iOS and Android apps with a web management dashboard for landlords and property managers. It handles properties, leases, rent invoicing, M-Pesa collections, partial payments, automatic reconciliation, receipts, credits and reporting.

Read case study

Enterprise · Case study

CliviQue HMIS

Hospital management information system connecting patient registration, OPD, emergency, inpatient care, orders, referrals, theatre, billing, ambulance, mortuary, duty coverage, patient movement, documents, and facility operations. It includes facility-bound Tuma M-Pesa patient billing and reconciliation, alongside SaaS subscription billing infrastructure.

Read case study

Enterprise · Case study

Macsim Cargo

Cargo and logistics operations platform spanning mobile field workflows and back-office administration. Macsim handles loads, reservations, driver assignments, trip tracking, documents, notifications, fleet operations and finance, with a guarded M-Pesa/Daraja flow for funding a collection-account ledger and paying drivers in full or partial load installments.

Read case study

SaaS · Case study

JournPad: Voice Journal

Voice-first journaling app that preserves the original recording, transcribes spoken entries, and uses AI to generate useful titles, summaries, and categories. Entries can be searched and revisited by date, linked to goals, supported by reminders and prompts, and protected with account, deletion, and optional biometric controls.

Read case study

SaaS · Case study

AI Stylist

Mobile wardrobe-management and outfit-recommendation product. Users create wardrobes, upload clothing photos for AI-assisted category, tag, and description analysis, and generate one-time, daily, or weekly outfit suggestions that can use precise local weather; recommendation history is stored locally in SQLite and designed to sync with the cloud.

Read case study

Let's build something that lasts

Have a software challenge? Let's turn it into a working product.

Talk directly with the engineer responsible for your project. Joeltech Geek Systems works with businesses and founders in Kenya and across the world.