WebApp: Online Front-End for Legacy ERP Desktop Application
Overview: I developed an online portal that unlocked the full potential of data from numerous legacy, desktop-only ERP systems. These systems were only accessible via Citrix (Remote Desktop), with data stored in a proprietary database. The only database connector available was a 32-bit ODBC driver compatible with Windows Operating Systems. Previously, the businesses generated numerous […]
WebApp: Dynamic Online Sales Reporting for Reps
Overview: To build an online reporting portal for a legacy ERP system that was only accessible over remote desktop, providing autonomous reporting capabilities. The ERP system lacked API functionality but had a proprietary ODBC driver running on a specific operating system. Multiple businesses using the ERP system each had separate databases, and the umbrella company […]
Unmanned Surface Vehicle for Autonomous Bathymetric Surveys
Overview: Collecting data from freshwater lakes is essential for monitoring ecological health and water quality. Traditional methods involve using manned vessels that require multiple personnel and often rely on ecologically harmful fuels or involve tedious manual kayaking. These methods are not only resource-intensive but also infrequent, typically responding to ecological issues only after significant damage […]
WebApp: Inventory Data Management v2.0
Overview: This project involved transforming an Excel-based application (which relied on formulas, macros, and user forms) into a fully functional web application with user controls and the ability to add modules as needed. Originally, the process involved maintaining supplier data, products, and pricing across multiple systems using an Excel application integrated with Access for large […]
Excel: Inventory Data Management
Overview: A team of Data Maintenance Officers manage inventory data for a master database and for other businesses ERP systems.The data being maintained consists of: Suppliers details, products, descriptions, pricing, special quantity pricing, barcodes, promotions.The supplier would supply the Data Maintenance team with a price list in Excel format containing all of their products and […]
Excel: Asset Management and Maintenance Scheduling System
Overview: Staff used a basic spreadsheet to track the company’s assets, registration, and service maintenance schedule. The spreadsheet was simple and not well-organized, limiting its usefulness. Solution: After understanding the requirements and purposes, I redesigned the spreadsheet to maximize its potential and automated various data entry and task requirements. Improvements Implemented: Expiration Date Alerts: Created […]
Excel: Financial Rebate Report Tool
Overview: A large and complex Excel spreadsheet with custom functions and macros was used by a company to track suppliers and clients’ rebate payables. The data entered into the spreadsheet was also manually entered into the ERP system to invoice relevant parties, resulting in duplicated data entry. This spreadsheet was critical for the company’s budgeting […]
Excel: Warehouse Management System
Overview: In a high-volume warehouse storing perishable goods, pallets were stacked three high and ten deep. The warehouse used a system to track the location, product, and expiry date of each pallet. Daily, staff needed to consolidate stock by use-by date to make room for bulk incoming deliveries, often up to 30 pallets at a […]