FO_
// PORTFOLIO_v2026 // NAIROBI, KE OPEN TO DATA ENG

FRED ONYANGO

LOGISTICS & SOFTWARE PROFESSIONAL
Customs clearance · Supply chain · Backend-minded builder · Targeting data engineering

VIEW_FLAGSHIP_WORK → VIEW_RESUME EMAIL_ME
NOW: AGL · FREIGHT FORWARDER FOCUS: DATA ENG + DOMAIN

01 SELECTED_WORK

Proof over fluff. Domain problems first — then systems work that shows I can ship software.

F01 DATA ENGINEERING · LIVE PRODUCTION

IMPORT CLEARANCE TRACKING & AUTOMATED REPORTING PIPELINE

Live automated reporting pipeline at ICD Nairobi & AGL. Ingests 1,200+ container shipments across multi-tab Excel workbooks & companion railage lists — cutting delays and demurrage.

// PROBLEM

Manual daily status updates for incoming container shipments. Error-prone spreadsheets, slow handoffs, and hidden demurrage penalties.

// DATA INGESTION

Parses 1,200+ cargo manifest rows across Dec 2025–Jul 2026 tabs + companion railage lists (discharge/docs/railage).

// ARCHITECTURE & FRESHNESS

Shift-window freshness alerts (50% warn / 20% block print), live yard dwell calculations, pre-ICDE queue tracking, and print-ready executive summaries.

// STACK & METRICS

Python (pandas/openpyxl) · Jinja2 · GitHub Actions EAT cron · Cloudflare Pages · −35% clearance delays · −20% storage penalties · 99% KPI accuracy.

LIVE_PRODUCTION_DEMO → GITHUB → SEE_ICD_EXPERIENCE →
F02 FINTECH · SERVERLESS · CLOUDFLARE WORKERS + D1

KOMOL FAMILY CHAMA — FINTECH & FINANCIAL SYSTEMS

Production digital financial platform for a 200-member community savings group in Kenya. M-Pesa SMS credit parsing, atomic payment splits, and signed-balance arrears tracking.

// PROBLEM & GOAL

Manual ledger tracking for 200+ members and M-Pesa cash collection. Needed a zero-data-loss, mobile-first public dashboard and audit system.

// MPESA PARSER & ALIASES

Single & bulk SMS regex parser with phone normalization, masked-phone alias resolution, and txn_id idempotency guards.

// FINTECH ENGINE

Atomic multi-member payment splits, signed-balance arrears model (balance = actual - expected), advance months calculation, and isolated Event/Burial funds.

// STACK & OPS

Cloudflare Workers · Cloudflare D1 (SQLite) · Vanilla JS · Cookie Auth · Dual Collector/Admin workspaces (`chris`/`abros`) · CSV member import.

LIVE_SYSTEM_DEMO →
F03 DATA ENGINEERING · SCRAPING ARCHITECTURE · ML & OCR

NAIROBI RESTAURANT DATA PIPELINE & TELEMETRY

Zero-budget (KES 0.00/mo operating cost) automated 5-layer ETL pipeline mapping, scraping, OCR-parsing, and serving venue metadata and menus across Nairobi.

// DISCOVERY & ACQUISITION

OSM Overpass API bounding box queries (Westlands, Kilimani, CBD, Karen, Gigiri) + Puppeteer Stealth scrapers with DuckDuckGo/Glovo multi-backend search fallbacks.

// SCRAPER GUARDRAILS

7 active guardrails: Cloudflare stealth evasion, DOM sibling pairing, location coordinate verification, lodging directory filters, and output concurrency isolation.

// PROCESSING & OCR

Local Tesseract OCR menu extraction, automatic dish categorization (Starters, Mains, Drinks, Desserts), and PostgreSQL relational schema storage.

// TELEMETRY & SERVING

Nuxt 4 SSR web application on port 3000 + Docker 3-tier architecture (Airflow scheduler, Postgres, Nuxt) · 478 venues discovered · 258 dishes categorized.

F04 PRODUCT · FIELD OPS

MERCHANDISER MANAGEMENT SYSTEM

Web app for organisations to plan and manage merchandiser field workforces.

Route/ops oriented product thinking. Full write-up on Medium.

GITHUB → MEDIUM →
F05 BACKEND · SYSTEMS

FILES MANAGER

Auth, uploads, pagination, thumbnails, Redis-backed background jobs — production-shaped backend patterns.

Node.js · MongoDB · Redis · Express. Proof I can design APIs and async workers, not just UIs.

GITHUB →

// STACK · GROUPED

DOMAIN

  • ICMS · KEBS compliance
  • KWATOS · SPOT · CIYOS
  • ICD / port ops
  • M-Pesa FinTech & Chama
  • Freight forwarding & ops

DATA & ETL

  • SQL · Postgres · D1 SQLite
  • Puppeteer Stealth Scraping
  • Tesseract OCR & Vision
  • Apache Airflow pipelines
  • Shift-window freshness & audit

BACKEND & CLOUD

  • Python · Node.js · C
  • Cloudflare Workers · Pages
  • REST APIs · Express
  • Redis · MongoDB · Docker
  • Git · GitHub Actions CI/CD

FRONTEND

  • JavaScript · TypeScript
  • Nuxt 4 (SSR) · React · Vue
  • Ant Design · Vanilla CSS
  • UX / QA instincts

02 EXPERIENCE

DATES · TITLES · METRICS

Resourceful logistics and software professional: customs clearance, supply chain optimisation, and backend development. High-volume, cross-functional work with measurable efficiency gains.

  1. 01

    INTERNATIONAL FREIGHT FORWARDER — KEBS INTERVENTION / ADMIN

    AFRICAN GLOBAL LOGISTICS (AGL) · FEB 2025 – PRESENT · NAIROBI

    • End-to-end customs clearance via ICMS; full KEBS compliance — −35% clearance delays.
    • Monitored 50+ container shipments daily; −20% storage penalties; 99% KPI reporting accuracy.
    • Used KWATOS & SPOT for real-time validation and 24-hour process turnaround.
    • Physical container inspections; resolved 15+ weekly discrepancies with detailed reports.
  2. 02

    QA & CUSTOMER SUCCESS SOFTWARE ENGINEER

    APPINAPP (EPICAPP LIMITED) · NAIROBI / REMOTE

    • Architected E2E test suites across Customer Web, Staff POS, and Vendor Portals — zero cross-tenant data leakage.
    • Validated hybrid security models (RBAC / ABAC) and patched cross-branch privilege escalation vulnerabilities.
    • Triaged P0/P1 blockers (M-Pesa API checkout errors, WebSocket sync failures) into dev tickets — −45% resolution time.
    • Authored visual "Zoom-style" user guides and CS cheat sheets — −35% support ticket volume.
  3. 03

    JUNIOR DEVELOPER

    REDUZER TECHNOLOGIES · APR 2024 – FEB 2025 · REMOTE

    • Migrated Africa’s Pocket Vue.js → React.js + reusable Ant Design components — −30% dev time.
    • Product docs & user journey maps — +40% team alignment.
    • UX improvements — −25% navigation errors; surfaced 15+ enhancements.
  4. 04

    TECHNICAL TUTOR

    ALX SOFTWARE ENGINEERING PROGRAM · SEP 2024 – JAN 2025 · REMOTE · VOLUNTEER

    • Mentored students to 100% project completion (Python, Flask, REST APIs).
    • Code reviews & consulting — 90% positive feedback.
    • Debugging approaches — −40% challenge resolution time.
  5. 05

    COMMUNITY MANAGER

    DIGITAL PUBLIC GOODS (GITHUB) · JUL 2024 – DEC 2024 · REMOTE · VOLUNTEER

    • +45% first-time contributor engagement via docs & onboarding.
    • Led 7 virtual workshops on open source & community management.
    • Built data-driven systems to monitor community health and programme impact.
  6. 06

    OPERATIONS OFFICER

    KENYA PORTS AUTHORITY — ICD NAIROBI · AUG 2023 – NOV 2023 · NAIROBI

    • Ops reports with CIYOS — +25% efficiency, +15% productivity.
    • Managed 500+ monthly operational tasks (SSR, export, auctioned cargo, vessel ops).
    • Export process redesign — −20% loading errors, −10% storage charges.

// EDUCATION

  • Diploma — Computerised Customs Clearing & Forwarding
    Nairobi Aviation College · Feb 2022 – Dec 2023
  • ALX Software Engineering — Backend Specialisation
    African Leadership (ALX) · May 2022 – Jul 2023

03 RESUME

Read the CV below without downloading. Prefer a full window? Open it in a new tab.

OPEN_IN_NEW_TAB → DOWNLOAD.PDF

PDF not showing? Open resume in a new tab or download the file.

04 PITCH_VIDEO

Short video introduction mapping domain background in customs clearance & software engineering.

V01 1-MIN VIDEO PITCH

FREDRICK ONYANGO — INTRO & VISION

Overview of customs clearance operations, backend architecture, and data engineering focus.

WATCH_PITCH_VIDEO →

// WRITING

W01
REVOLUTIONIZING FIELD OPERATIONS Deep dive into modern merchandiser management systems and field-ops software design.
MEDIUM READ → W+
MORE ON MEDIUM @ochieng.fredrich — software, ops, and building practical tools.
PROFILE MD →

05 HIRE_ME

CURRENTLY @ AGL.
TARGETING DATA ENGINEERING & ADJACENT ROLES.

// WHAT I WANT

Data engineering / analytics engineering / ops-tech roles where logistics data becomes reliable product.

// WHAT I BRING

Lived customs + ICD domain, measurable ops wins, backend training, and a bias to ship boring reliable systems.

// WHERE I’M STRONGEST

Clearance workflows × Python/SQL × process automation × turning Excel chaos into pipelines and KPIs.

VIEW_RESUME OPEN_RESUME_TAB → EMAIL_ME

06 REACH_OUT

Fastest path: email or phone. Socials if you want context.

EMAIL · PREFERRED ochieng.fredonyango@gmail.com PHONE (+254) 725 550 414 GITHUB github.com/aTfure LINKEDIN fredonyango MEDIUM @ochieng.fredrich X @aTfure