Denzil Gumbo

Worked on a franchise-focused marketing project powered by Reach Agency.

Acting as a full-stack developer, I created a digital marketing app using C#, .NET Core, and Angular. The app manages users' digital advertisement suite. It reports tracking costs, clicks, and conversions, helping users narrow down on demographics for target marketing.

Created COVID-19 dashboard and reporting system used by the hospitals to proactively manage patients. The system was also used to report data to the health ministry nationally.

Built a Microsoft SQL Server database and ETL procedures to get data from hospital labs.

Created a REST API Web using C#, ASP.NET Core, and REST methods to manipulate and update data.

Developed a front-end client using ASP.NET Blazor WebAssembly and Chart.js for visual charts. The client can also be used to manipulate the data.

Created a Power BI dashboard for the hospital for interactive and insightful reports and dashboards.

The hospital has some wards that serve outpatients on an appointment basis.
The ward clerks would manage these appointments on a physical ward diary, and the diary could only be managed by a single user at a time to avoid duplicates. This manual system always resulted in overbooking, underbooking, and overlapping appointments despite all efforts.

I led a team that created a system now used to manage patient appointments across different wards.

As a result, appointments can now be made, depending on staff availability and hospital capacity. The hospital can now manage appointments effectively.

We build the system using ASP.NET Core Blazor Web Services, with a SQL Server Database.
Also, we implemented a CI/CD pipeline, including unit testing using the xUnit testing framework, and managed work items on the GitLab server.

The hospital had three systems, including Active Directory, Employee Staff Records, and Switchboard, that managed different aspects of employees’ details. However, these systems all required employee contact details. There was no central system for collecting this data; thus, each system updated its records. The hospital had three sets of the same information and organically huge inconsistencies.

I led a team that created a system that would start the day with a fresh copy of data from Active Directory.
All contact details for the day would be done through this system. Updated contact details would then be moved over to the other systems.
The system also handles conflicts if data gets updated outside the central system.

The team started by building a Microsoft SQL Server database.

We then created an ASP.NET Core MVC Web application for managing employee details.
Implemented security at a record level.

We then created a scheduled task that would run at appointed intervals to synchronize records accordingly.

The hospital has different wards, including whiteboards where they would manually write, color-coded, statuses of patients, those ready for discharge and seen by a doctor, patients who have been clerked by nurses, and others.
Some wards would have multiple boards that would show additional information like dietary requirements for the patients.

This information was critical for improving service quality to patients, and most of the data manually inputted on the boards was extracted from the Hospital Management System.

I led a team that created a system that extracted the above information from the Hospital Management System and displayed it on an electronic whiteboard displayed on a computer with a huge TV screen.

The information displayed on these screens is organized, compact, color-coded, with various icons representing different conditions such as dementia, disabilities, allergies, and more.

Doctors and other interested parties would simply walk in and use the dashboards for rapid insights on the stages of their patients and their care.
These whiteboards improved the quality of care and have entirely replaced whiteboards and any manual input.

Lead developer for Healthcare Management System (HMS) reporting module design and development, testing, and implementation.

• Conducted database performance tuning and query optimization.
• Developed using C# ASP.NET Framework, MVC Web Application.
• SQL Server Database on a high-availability/failover cluster.

Created an extract, transform, load (ETL) solution using SQL Server Integration Services (SSIS) that consolidated and synchronized data from 104 strategic business units’ physically separated databases. Also, developed an Analysis Services Solution (SSAS/Cubes) that improved Server Reporting Services (SSRS) load speed and reporting accuracy.

Created an extract, transform, load (ETL) solution using SQL Server Integration Services (SSIS) that consolidated and synchronized data from 104 strategic business units’ physically separated databases. Also, developed an Analysis Services Solution (SSAS/Cubes) that improved Server Reporting Services (SSRS) load speed and reporting accuracy.

Developed, managed, and maintained a business intelligence system.

Worked on automating business reports, including creating the first automated sales reporting system using SSRS, delivered reports via email and increased report accuracy, enabled timely and informed decisions. Designed SSAS cubes from the data warehouse, trained business users in self-service cube manipulation.