Rodney Gitonga

Selected Works

A collection of case studies focusing on Data Analytics, BI, and Software Engineering.

01Geospatial BI

ATM Logistics Command Center

Simulates 'Last Mile' logistics for retail banking to optimize armored truck routes and prevent cash-out events.

PythonSQL ServerPower BI
View Project
ATM Logistics Command Center
02Financial Tech

Bank Treasury & Market Watch System

Tracks live market data, calculates treasury rates, and feeds real-time prices for assets like Gold and Bitcoin.

SQL ServerLive Data Feed
View Project
Bank Treasury & Market Watch System
03Predictive Analytics

AI-Powered Loan Risk Assessment

Predicts borrower default probability using a Random Forest Classifier wrapped in a Streamlit app.

PythonScikit-learnStreamlit
View Project
AI-Powered Loan Risk Assessment
04Generative AI

AI Banking Analyst

Text-to-SQL Enterprise Solution acting as an Intelligent Analyst for a Tier 1 Banking Data Warehouse.

GenAIMS-SQLStar Schema
View Project
AI Banking Analyst
05Data Engineering

Financial Data Pipeline

ETL pipeline extracting financial news and exchange rates into Google BigQuery.

Web ScrapingAPIsBigQuery
View Project
Financial Data Pipeline
06E-Commerce Analysis

Customer Segmentation Engine

Conducts e-commerce analysis using clustering for targeted marketing strategies.

PythonPandasScikit-learn
View Project
Customer Segmentation Engine
07Productivity

Streamlit Workflow Dashboard

Personal data hub integrating External APIs and Google Gemini AI for summarization.

StreamlitGemini AIAPIs
View Project
Streamlit Workflow Dashboard
08Backend API

Banking NBO Microservice

REST API serving real-time product recommendations (Next Best Offer) to banking frontends.

FastAPIPython
View Project
Banking NBO Microservice

Other Noteworthy Projects

LuxeMetricDashboard

A luxury metric tracking dashboard for high-end analytics.

#Dashboard#Analytics

Flixsasa.py

Python-based streaming service utility or analyzer.

#Python#Automation

DockerChat

Containerized chat application using Docker.

#Docker#Chat System

dskeeper

Data science project keeper and organizer.

#Data Science#Utility

NeonProtocol.vsTheme

Custom neon-themed Visual Studio extension.

#VS Code#Theme

RenderKeeper

Rendering management tool for graphics or data visualization.

#Rendering#Tools

NewYouPortfolioChallenge

Portfolio challenge project for Dev.to.

#Web Development#Portfolio

Portfolio (Legacy)

Previous version of personal portfolio website.

#HTML/CSS#Legacy

TrafficController.docker

Dockerized traffic control simulation or system.

#Docker#Simulation

ReactTodoList

Classic Todo List application built with React.

#React#Frontend

ResourceMonitor.ms

System resource monitoring tool.

#System#Monitoring

DevOpsBootstrapper

Bootstrapping tool for DevOps environments.

#DevOps#Automation

YtDownloader.py

Python script for downloading YouTube videos.

#Python#Scripting

DataExplorer.py

Tool for exploratory data analysis.

#Python#EDA

FallingBlocks.game

Tetris-style falling blocks game.

#Game Dev#Logic

Starfield

Starfield simulation project.

#Simulation#Graphics

RealtimeChat.app

Real-time messaging application.

#WebSockets#Chat

Snake.game

Classic Snake game implementation.

#Game Dev#Python/JS

ParameterizedDbPreservation

PowerShell script for database preservation.

#PowerShell#Database

RepoCloner.py

Automated tool for cloning repositories.

#Python#Git

Nova.web

Web application project 'Nova'.

#Web#Frontend

BackupSQLServerDbs

Tool to backup SQL Server databases to network locations.

#SQL Server#Backup

Flopy-Blarb Game

Experimental game project.

#Game Dev#Experimental

PBIRS Dashboards

Power BI Report Server dashboards collection.

#Power BI#Reporting

AIBankingAnalyst v0.1

Early version of the AI Banking Analyst.

#AI#SQL

TimuAI.web

Web interface for TimuAI project.

#Web#AI

SQLQueriesRepo

Collection of useful SQL queries and scripts.

#SQL#Database

UrbanCart

E-commerce platform simulation.

#E-commerce#Web

HighValueTransactionAlerts

System for alerting on high-value financial transactions.

#FinTech#Security

MarketMonitor.streamlit

Streamlit app for monitoring market trends.

#Streamlit#Data Viz

LiveFraudProject.py

Real-time fraud detection script.

#Python#Security

SpotifyJobPipeline

ETL pipeline for Spotify data.

#ETL#Data Eng

CustomerVoiceNLP

NLP analysis of customer feedback.

#NLP#Python

FinancePipeline

General purpose financial data pipeline.

#Data Eng#Finance

StockPricePredictor

ML model for predicting stock prices.

#Machine Learning#Finance

Simple ETL VS

Simple Extract-Transform-Load project.

#ETL#Data

EcommercePipeline

Data pipeline for e-commerce metrics.

#ETL#E-commerce

TimeSeriesForecasting

Forecasting using Facebook Prophet.

#Prophet#Time Series

NLPTextClassifier

Text classification using NLP techniques.

#NLP#Classification

SklearnModelShowdown

Comparing various Scikit-learn models.

#Scikit-learn#ML

CustomerChurnPrediction

Pipeline for predicting customer churn.

#ML#Prediction

CreditRiskPrediction

Random forest model for credit risk analysis.

#ML#Risk Analysis

FraudDetection Jupyter

Jupyter notebooks for fraud detection analysis.

#Jupyter#Data Analysis

BankDataWarehouse

Data warehouse implementation for banking data.

#DBT#Data Warehouse

ContainerizedDataLake

Dockerized setup for a Data Lake.

#Docker#Data Lake