I designed and developed a full-stack organizational and awards platform for ELDoF and the Pan African Crown of Humanity Awards (PACHA 2027). The platform includes a professional public website, event information, registration and application workflows, administrative dashboard, database management, authentication, communication features, interactive sections and payment-related functionality. The system was built to transform organizational and event processes into a practical digital platform.

Accounts Payable (AP) Invoice Automation:

The project automates the Accounts Payable process by consolidating separate financial data files.

Using Excel’s VLOOKUP function, it links a central summary sheet (AP_Summary.xlsx) with two source workbooks to automatically fill in missing information. It reads the Vendor ID to pull the matching company name from Vendor_Master.xlsx. It reads the Invoice Number to pull the correct billing total from Invoice_Register.xlsx. This process eliminates manual cross-referencing, cuts down on data entry errors, and instantly creates a unified financial dashboard for efficient invoice tracking and accurate bookkeeping.