Rodney Gitonga

Selected Works

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

01 — Geospatial 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
02 — Financial 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
03 — Predictive 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
04 — Generative 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
05 — Data Engineering

Financial Data Pipeline

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

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

Customer Segmentation Engine

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

PythonPandasScikit-learn
View Project
Customer Segmentation Engine
07 — Productivity

Streamlit Workflow Dashboard

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

StreamlitGemini AIAPIs
View Project
Streamlit Workflow Dashboard
08 — Backend API

Banking NBO Microservice

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

FastAPIPython
View Project
Banking NBO Microservice
09 — Financial Analytics

SPY Golden Cross Analyzer

Evaluates the SPDR S&P 500 ETF (SPY) using Simple Moving Averages (50-day & 200-day SMAs) to identify Golden Cross buy/sell signals.

PythonSQLFinancial Analysis
View Project
SPY Golden Cross Analyzer

Other Noteworthy Projects

NetworkReport.py

A Python utility to monitor network status and compile automated health reports.

#Python#Networking#Automation

NodejsReleaseScraper.py

A Python script that scrapes the official Node.js releases and parses version history.

#Python#Web Scraping#Automation

DailySystemReporter.py

Automated daily system auditing and email reporting script for server diagnostics.

#Python#System Administration#Automation

3dDesign.web

A web-based interactive 3D design showcase built with HTML and modern rendering techniques.

#HTML#CSS#WebGL

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