Ronald Kipngetich

Available for new opportunities

Ronald Kipngetich

Data Engineer · Data Scientist

I build end-to-end ETL pipelines, multi-tenant SaaS platforms, and load-tested APIs — then harden the infrastructure they run on.

01. About

Data Engineer and Data Scientist with hands-on experience building end-to-end ETL pipelines, multi-tenant SaaS platforms, analytics dashboards, and load-tested APIs. Proven track record automating complex workflows, eliminating 85%+ of manual processing, and shipping full-stack products — from orchestrated data pipelines to production Django platforms with 2FA, payments, and integrated LLM features.

02. Skills

ETL/ELT

PythonPandasSQLAlchemyMage AI (orchestration)

Backend/Web

DjangoDjango REST FrameworkFlaskdjango-tenants (multi-tenant SaaS)

Databases

SQL ServerPostgreSQLRedisQuery OptimizationIndexed Caching

Visualization

Power BIApache SupersetExcel

APIs & Integrations

RESTJWTAfrica's Talking (SMS/USSD)SendGridM-Pesa DarajaZoom/Jitsi

Load Testing

Locust

AI/LLM Integration

Claude APIGemini API (structured extraction, in-product AI features)

AI-Assisted Development

Claude Code

DevOps & Security

DockerNginx Reverse ProxyUFW/iptablesOpenVPNGit

Programming

PythonSQLJavaScriptVB.NET

03. Selected Work — Image Registrars Ltd

178s → 0.13s exact search across 11 databases

ICT Tools — Internal ICT Automation Suite

Python · PySide6 · pymssql/pyodbc · PyInstaller

Self-updating desktop suite for ICT operations, headlined by an indexed cross-database search cache.

View details →
90% of daily reporting automated

Enterprise ETL & Data Pipeline

Python · Mage AI · SQL Server · Pandas · 3CX API · Freshdesk API

Orchestrated pipelines pulling call-centre, ticketing, and agent-performance data into one warehouse.

View details →
8,500+ concurrent users, 99.9% uptime

API Performance & Load Testing Framework

Python · Locust · REST

Locust-based load testing that caught capacity issues before they hit production.

View details →
8,500+ registrations, 10min → 2min

Multi-Channel USSD & Web Shareholder Registration System

Python · Flask · SQLAlchemy · PostgreSQL · Africa's Talking · SendGrid

Flask app handling shareholder registration over USSD and web, with an automated raffle draw.

View details →
Grant → vest → exercise → dividend, fully automated

Employee Share Ownership Plan (ESOP) Platform

Django · PostgreSQL · django-two-factor-auth · ReportLab · qrcode

Django platform automating the full ESOP lifecycle for an enterprise client, live in production.

View details →
2FA + maker-checker on every shareholder edit

Corporate Shareholder Registry & Transfer Platform

Django · SQL Server · django-two-factor-auth · ReportLab

Django registry platform for a second enterprise client — transfers, statements, and certificates.

View details →
Fully admin-editable, zero placeholder content

Corporate Law Firm Website & CMS

Django · PostgreSQL · Gunicorn · systemd · Nginx

Content-managed marketing site for a Nairobi corporate law firm, built from the ground up.

View details →

04. Personal Projects

05. Experience

Junior Data Analyst

May 2025 – Present

Image Registrars Limited

  • Engineered automated ETL pipelines (Mage AI) processing 50,000+ daily records from telephony (3CX), ticketing (Freshdesk), and queue systems — cutting manual processing by 85% and saving 15+ hours weekly.
  • Built a weighted KPI scoring engine for agent performance management, reducing reporting errors ~95% via automated validation frameworks.
  • Optimised complex SQL queries and incremental processing strategies for 1M+ record datasets, slashing execution time from 5 min to ~15 sec.
  • Designed 15+ KPI Power BI dashboards and Flask APIs (sub-second response times), reducing management reporting turnaround by 70%.
  • Load-tested APIs with Locust (1,000+ concurrent users), improving peak-time stability by ~40%.
  • Built and deployed multi-tenant Django shareholder-registry platforms for enterprise clients — 2FA (email/SMS OTP), maker-checker approval workflows, PDF statement generation, and a hand-reverse-engineered fixed-width regulatory file parser for automated monthly register imports.
  • Hardened production infrastructure across 10+ Django/Docker services — audited and closed unnecessary public port exposure, migrated internal traffic behind nginx reverse proxies with TLS, and containerized a VPN-based secure access channel, reducing internet-facing attack surface without service downtime.

Electrical & Electronics Intern

2021 – 2023

Ministry of Public Works

  • Supported maintenance, circuit testing, and fault diagnosis across government facilities — contributing to 15+ successful infrastructure projects.

Education

B.Sc. Electrical & Electronics Engineering JKUAT · Expected Dec 2025
Data Science Certificate Moringa School · 2024

Certifications

Certified Data Scientist Moringa School · 2024
Machine Learning & Data Analysis Kaggle · 2024
Python Programming SoloLearn · 2024
SQL Fundamentals SoloLearn · 2024

06. Get in Touch

Have a project in mind or just want to connect? Send a message below.

Email
ronaldkipngetich80@gmail.com

Phone
+254 704 877888

Location
Nairobi, Kenya