Fredrick Mandela

Selected work

Projects and technical products

Practical products and technical demos spanning financial data, analytics engineering, backend systems, full-stack development, and applied AI.

Featured · In development

Investar Companion

A financial-data platform that collects Kenyan unit-trust rates from provider websites and documents, then standardizes them into auditable, analysis-ready records in Supabase.

It combines provider-specific scrapers with AI-assisted extraction, preserves source evidence and confidence, tracks rate history and freshness, and exposes an API-ready market snapshot for fund comparison, advisor tools, and automated publishing.

PythonPlaywrightSupabasePostgreSQLAI extraction

AI SQL Analyst

A local-first Streamlit analytics assistant that turns plain-English business questions into safe SQL, runs queries against sample data, and explains the results clearly.

The architecture is designed to extend to Snowflake or another production database.

PythonStreamlitSQLApplied AI

AI Career Assistant

A local-first Streamlit assistant that helps users create professional resumes and assess their fit for roles using job descriptions.

It has a future path to integrate with LinkedIn or other job platforms.

PythonStreamlitApplied AI

Dairy Farm Records

A full-stack farm management product for capturing animal records, milk production, feeding logs, health events, heat cycles, and insemination records from a Flutter Android application.

A FastAPI backend provides authenticated endpoints while the mobile app gives farmers a straightforward record-management workflow.

FlutterFastAPIPythonREST APIs