Hamdhaan A Ghani Portfolio

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

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.