Portfolio

An Excel financial tracking solution that automates daily sales reporting, monthly financial consolidation, and employee commission calculations. This system provides real-time visibility into service performance, retail sales, and individual employee contributions while automating monthly file management. Core Functionalities:.

This project required up to 90 possible combos with different main products and additional products. This solution allowed the client to enter their own personal skus per combo and the macro automatically retrieves the cost and selling price from their price list. It also contains conditional formatting to show which products went out of stock […].

The goal of this project was to create a payroll sheet with a specific format, that allows the client to insert data with the use of drop downs in order to improve their workflow. Key Features:• Interactive Dropdown Menus: Cell-level dropdowns for employee selection, pay types, and deduction categories• Automated Salary Calculations: Automatic computation of […].

A composite products management system designed to streamline complex product pricing and component management. This solution enables businesses to efficiently handle products composed of multiple components while maintaining accurate, real-time pricing. Key Features: • Dynamic Component Pricing: Seamlessly combines pricing from multiple product components into a unified composite price • Real-time Price Updates: Automatically reflects […].

An inventory management system that automates stock tracking and seamlessly integrates with internal systems. This solution handles real-time inventory updates, shipping documentation, and prepares files for system uploads, significantly reducing manual data entry and improving accuracy. Core Functionalities:.

A comprehensive Excel VBA solution that automates the entire supplier pricing and inventory management process. This system processes 50+ supplier files, performs cost analysis, and provides real-time pricing comparisons while maintaining product database integrity. Key Functionalities:.

Comprehensive website development project (Beauty by Grace) from concept to completion, including:.

A custom-built Python-based Product Information Management (PIM) platform designed to centralize and automate critical business operations. Deployed across multiple Windows workstations, the system serves as the core hub for product information, supplier integrations, inventory synchronization, pricing management, auditing, and e-commerce updates. Built around internal business workflows, the platform provides secure, near real-time data synchronization and […].

A custom-built mobile attendance management app designed for fast, reliable record-keeping and seamless data handling. The app allows administrators to manage members, track attendance, and export selected data with just a few taps. It includes CSV import/export functionality, image importing, detailed member search, and dynamic family grouping to make selection quicker and more intuitive. Key […].

A fully automated weekly booking system built using Google Sheets and Google Apps Script. The system dynamically generates a structured booking form for each available Friday time slot using dropdown menus. Whenever a user selects a time slot, the system instantly updates the main Google Sheet, ensuring live, real-time visibility for all collaborators. Key Features:.

A custom-built Python application that automates large-scale image preparation for web and e-commerce use. The tool streamlines the entire workflow: upload a CSV containing image paths, bulk-resize the images, optimise them for quality, and optionally upload them to Cloudinary. It supports both square cropping (with smart padding) and preserving original aspect ratio, ensuring consistent and […].