Skip to content
View JohnKimaiyo's full-sized avatar
6 followers · 7 following

Achievements

Achievement: Pull SharkAchievement: YOLOAchievement: Quickdraw

Achievements

Achievement: Pull SharkAchievement: YOLOAchievement: Quickdraw

Block or report JohnKimaiyo

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don't include any personal information such as legal names or email addresses. Markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
JohnKimaiyo/README.md

👋 Hi, I’m John Kimaiyo

🚀 Data Analytics | Business Intelligence | Supply Chain & Aviation Analytics | Finance → Tech

I’m a data-driven professional with a strong background in finance, supply chain operations, and analytics, currently building end-to-end data and analytics systems using open-source and cloud technologies. My work focuses on turning complex operational data into actionable insights, dashboards, and decision-support tools.

🔍 What I Work On

  • 📊 Data Analytics & BI – SQL, Power BI, Python (Pandas, NumPy)
  • 🏗 End-to-End Data Projects – ETL pipelines, data modeling, dashboards
  • 🏬 Supply Chain & Inventory Analytics – stock movement, warehouse visibility, donor-funded health supply chains
  • ✈️ Aviation & Revenue Management Analytics – demand forecasting, pricing logic, route performance
  • 🌐 Analytics Web Apps – Flask apps with query-driven dashboards
  • ☁️ Cloud & Data Engineering (Beginner → Intermediate) – AWS (S3, RDS), MySQL

🛠 Tech Stack

Languages & Tools

  • Python (Pandas, NumPy, Matplotlib)
  • SQL (MySQL, PostgreSQL)
  • Power BI
  • Microsoft Access (Operational Reporting)
  • Jupyter Notebooks

Web & Apps

  • Flask (Analytics APIs & query UI)
  • HTML / CSS (basic dashboards)
  • React (learning & experimentation)

Cloud & Platforms

  • AWS S3 (Data Lake)
  • AWS RDS (MySQL)
  • Git & GitHub

📌 Featured Projects

🔹 End-to-End Supply Chain Analytics Platform

  • ETL pipeline using Python + SQL
  • Centralized warehouse inflow vs outflow tracking
  • Power BI dashboards for bottlenecks, stock variances & trends
  • Flask app with a query-based user interface

🔹 Stock Movement & Inventory System (Access → Analytics)

  • Automated stock movement module replacing Excel
  • Parameterized queries and reporting
  • Audit-ready transaction tracking

🔹 Airline Revenue Management Analytics (Learning Project)

  • Demand forecasting concepts
  • Route performance & yield analysis
  • SQL-driven metrics + BI dashboards
  • Flask-based decision-support prototype

🔹 Blockchain-Inspired Commodity Traceability (Concept Project)

  • Commodity issuance & movement tracking
  • Backend analytics & data integrity focus
  • Designed for supply chain transparency

🎯 Career Focus

I’m positioning myself for roles in:

  • Data Analyst / Business Intelligence Analyst
  • Supply Chain & Operations Analyst
  • Revenue Management / Aviation Analytics
  • Analytics-focused Finance & Development Roles

I enjoy building portfolio projects that mirror real-world systems used in airlines, logistics, NGOs, and financial institutions.

📈 What I’m Currently Learning

  • Advanced SQL for analytics
  • Flask + Power BI integration
  • Data modeling best practices
  • Cloud-based analytics architectures
  • Applied analytics for aviation & supply chains

🤝 Let’s Connect

⭐ I believe strong analytics starts with clean data, clear questions, and systems that decision-makers can actually use.

Pinned Loading

  1. Business-Analyst-Projects Business-Analyst-Projects Public

    Jupyter Notebook

  2. Business-Analytics-Power-BI Business-Analytics-Power-BI Public

    Jupyter Notebook