Bill and Melinda Gates Foundation
Recommending key education players for African vaccine development.
Role: Pro-Bono Operations Consultant
Tools: SQL, Tableau
Image from gatesfoundation.org
The purpose of my consulting project is understanding the existing education infrastructure in Africa related to vaccine manufacturing. This would then lead into developing a strategy for growing and strengthening the talent pool of vaccine manufacturing engineers by systematically improving university programs in Africa.
This allows for a direct pipeline of students in Africa to work in local and cross-country vaccine manufacturing firms, helping address the medical issues facing Africa today such as TB, HIV, etc.
Working with a BMGF team of ex-Mckinsey and ex-Bain consultants, I solidified three main objectives:
I’m currently working on the second objective of the project, so I will only be able to showcase work accomplished for the first objective. This page will be updated as the project continues.
Objective 1 - Building a Landscape
To better understand the already-existing talent pool for vaccine manufacturing in Africa, the team decided to break down the landscape of Africa into regions with strong universities, existing partnerships, and potential key players. Our team presented a midterm deliverable deck to BMGF for the first objective.
Education Landscape Map
Using the 4ICU African University ranking system, I mapped out the various places universities with engineering and STEM programs were located across the country.
Here is an example of one map. The dots are colored based on opacity, with more opaque schools being better target schools that have engineering students for vaccine manufacturing.
Some key insights are:
Map created to indicate the different levels of STEM education across Africa
Program Use Cases
To make the content more digestible, I believed the best way to tackle the entire continent of Africa was by splitting up different regions of Africa into West, North, South, Central, and East. And while there are geo-political and socio-economical ties to these regions, this distinction is instead to better understand the content.
Here are a few sample slides about South Africa and its schools:
Transition slide to Africa
In-depth look at the University of KwaZulu-Natal
In-depth look at the University of Pretoria
These slides focus on presenting information focused on the university’s commitment to research, engineering programs, and any potential partnerships the university has toward vaccine development. I also made sure to note any key benefits the university provided that made it unique, but also some areas of improvements that the BMGF could help out with.
This specific project was no different, outlining the thought process admins would have while creating goals and the importance of having an additional response script feature, or an automatic default additional response script.
After compiling this information with the other regions of Africa, we noticed that there were certain key features that made a “good” program for the BMGF.
The table lists out what a "good" program is for BMGF
Currently, this project is still in progress. This will be updated as the project continues.