Projects
A collection of my technical projects showcasing skills in data engineering, software development, and data visualization.
Market Basket Analysis
Large-scale market basket analysis on the Instacart dataset using PySpark. Demonstrates end-to-end data engineering workflows on millions of customer transactions.
E-commerce Analytics with MongoDB
Built aggregation pipelines for Technet e-commerce to generate revenue, top product, and customer trend reports for strategic decision-making.
Air Cargo Analysis
Designed a relational database system for an aviation company to manage customer info, ticket sales, and flight data. Identified busiest routes and generated ticket sales insights.
Claims Analytics Dashboard
Power BI dashboard integrating policy, claims, and transaction data to track claim settlement times, loss trends, and financial KPIs.
Policy Underwriting Audit
Automated transaction-level audit solution for non-life insurance underwriting. Recomputes expected premiums from sum insured, tariff, and loadings, then compares against booked amounts to surface premium leakage, NCD discount errors, commission mismatches, and MID reconciliation issues. Built on a star-schema semantic model with ~50 DAX calculated columns.
Roofing Invoice System
Invoice, payment, commission, and receipts management system for Rudon Roofing Ltd.
Rudon Roofing Website
Corporate website built to enhance digital marketing and online presence for Rudon Roofing Ltd.
Hotel Room Booking System
Hotel room booking and management system built with MS Access, Visual Basic, and PHP.
Employee Performance Mapping
SQL project for ScienceQtech to map employee contributions across high-impact projects, enabling accurate data-driven appraisal decisions.
JBR POS
Full-featured point-of-sale system for retail shops, supermarkets, restaurants, and service businesses. Includes cashier interface with barcode scanning, real-time inventory tracking, customer loyalty programs, automated sales reports, and role-based staff access control.
JBR Inventory
Multi-branch inventory management platform for distributors, manufacturers, and retailers. Features centralised stock control across unlimited branches, inter-branch transfer tracking, sales order and dispatch note processing, and advanced analytics.
EduPortal SMS
Complete school management system for private and international schools. Covers student admissions, attendance tracking, academic records, fee management with Paystack mobile money integration, timetabling, and a parent portal with real-time student updates.
Clinic Manager
Digital clinic management system for private clinics and hospitals. Handles patient registration, appointment scheduling, SOAP consultation notes, lab test tracking, pharmacy dispensing, NHIS and private billing, and exposes a REST API for third-party integrations.
JBR Pharma
Pharmacy management system for independent and hospital pharmacies. Features drug inventory with generic/branded linking, prescription processing, multi-branch support, automated 60-day expiry alerts, controlled substances audit trail, and a built-in dispensing POS.
ClearMetrics Pro
Corporate data literacy platform delivering self-paced Excel and Power BI courses, an interactive template marketplace, and one-on-one coaching. Supports bulk corporate enrolments, auto-generated certificates, and Paystack payment integration.
JBR Hotel & Hostel Manager
Web-based hotel and hostel management system for hotels, schools, universities, and rental properties. Manages bed allocation, tenant records, automated rent collection, check-in/out monitoring, maintenance request tracking, and multi-property reporting.
JBR Property Manager
Property administration platform for landlords and real estate companies. Centralises portfolio tracking, tenant records, automated late-payment alerts, lease management, maintenance ticketing, vacancy tracking, and financial reporting.
JBR Bizextrat
Business intelligence tool that extracts and exports data from Google Maps for lead generation and market research. Supports industry category filtering, location targeting, bulk record processing, and export to Excel, CSV, or JSON.
Suspense Reconciliation & Allocation Automation
Eliminated a monthly bottleneck in suspense allocation at Enterprise Trustees by building a Power Automate flow that triggers instantly when a Relationship Manager resolves a pending record on SharePoint. The flow enforces a standardised file-naming convention, pulls the updated record into a shared Excel tracker, and automatically downloads attached schedule documents to a team folder — turning a monthly batch handoff into real-time allocation as soon as each case is resolved.
Billing Email Assignment Automation
Diagnosed and overhauled an existing Power Automate billing assignment flow at Enterprise Trustees that was assigning all file types indiscriminately and disconnecting unexpectedly. Modified the flow to filter strictly for Excel files only, implemented continuous monitoring to prevent unexpected disconnections, and added automatic export of all processed files to SharePoint as a backup archive — restoring reliable, uninterrupted operation aligned with business requirements.
Flagged Policy Audit Alert System
Built an automated compliance alert system at Enterprise Insurance that monitors daily Power BI policy audit report refreshes and automatically sends targeted email notifications to officers who have not addressed flagged policy exceptions. Ensures consistent daily follow-up without manual tracking, driving accountability and timely resolution of audit findings.