👋 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

• 💼 Portfolio: johnkimaiyo-rosy.vercel.app
• 📧 Email: kimaiyojohn6@gmail.com
• 🔗 LinkedIn: [(https://www.linkedin.com/in/johnkimaiyo/)]

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