SQL/SSMS: Geemac Embassy Ltd
I had the opportunity to work with a mid-sized e-commerce company called Geemac Embassy Ltd, which sells a wide variety of products online and ships orders to customers worldwide. Geemac provided me with their orders table—a dataset packed with valuable information like customer, orders, shipping, and freight information. I worked under a 3-month contract, and the company was eager to improve their shipping and logistics processes, and they turned to data analysis to uncover insights that could help them optimise efficiency and cut costs. You can access my work for this firm using this link.
SQL/SSMS: Horizon Fitness Ltd
As part of their digital transformation initiative, Horizon Fitness Solutions maintains a SQL Server database to track member activities, facility usage, and IT-related incidents. My role as a server developer was to perform advanced date and time manipulations, aggregations, and time series analyses to provide actionable insights to the company’s management and IT teams. You can access my work for this firm using this link.