Hamdhaan A Ghani Portfolio

Business Analyst | Business Thinker | Problem Solver
This portfolio showcases my work, mostly in Business, Analytics & IT.

Dhishops — Standalone System Upgrades

December 2025

Dhishops admin dashboard and system upgrades

Iterated on the Dhishops standalone system after real client usage, focusing on scalability, admin efficiency, and long-term maintainability. Major upgrades included a redesigned orders workflow, a full overhaul of categories and filters with subcategory support, bulk product editing, traffic analytics, centralized messaging, and improved data transparency through backups and support tools.

Macros for Payroll Payslips in Excel

December 2025

Excel payroll automation screenshot (placeholder)

Helped a small business owner turn a manual, error-prone payroll routine into a semi-automated Excel workflow. By restructuring the workbook and adding a simple VBA macro to batch-generate payslip PDFs, I managed to cut hours of repetitive work every month and removed the risk of broken file links.

Dhishops – Mini Websites for Social Sellers

November 2025

Dhishops storefront and admin preview

A mini-website platform designed to fix the single biggest problem social sellers face: having to recreate all their content when they want a website. Instead of forcing sellers to retype names, prices, descriptions, and upload “clean” photos, Dhishops works directly with the images they already use on social media. Products go live instantly — no forms, no duplication, no hassle — while a single PHP backend powers as many shops as needed.

Resort Performance Dashboard

August 2025

Resort Dashboard thumbnail

Power BI dashboard comparing resort performance metrics for 2023 and 2024 — including occupancy, bookings, revenue, ADR, RevPAR, and departmental income.

Data Exploration with SQL

May 2025

Structured SQL analysis of the OLIST e-commerce dataset, covering revenue trends, customer behavior, shipping logistics, payment methods, and product performance. This project simulates real-world business analytics use cases using SQL queries on a cleaned dataset.