Hope International

During my time working with HOPE International, I assisted the microfinance team in research and analysis for an expansion project. Apart from my main expansion project, I also developed a cultural manual and culural manual templates, reviewed and edited quarterly reports through PowerBI, created an initial draft for a help page for a Burundian banking app, and scraped all content from all microfinance institutions network wide for webpage revamps.

Presentation Design

Overall desirability ranking without weighted measurements. HOPE International microfinance institution expansion project.

This slide contains the original research completed in June. To arrive at this conclusion, I collected data for each metric listed above. Once the data was collected and organized, I developed a tool to calculate the rank of which country met the most qualifications.

Overall Desirability Ranking with Weights. HOPE International microfinance expansion project.

At the next meeting HOPE staff requested a new weighted data tool to evaluate rank. They also wanted to reevaluate nations that had been previously eliminated from our list of prospects. I developed a new ranking tool which weighed ~25 metrics (available in the appendix) for 57 countries.

After adding the original 57 countries back into the tool, I then reevaluated the nations using the initial minimum requirements. I then added back nations with qualifiable exceptions.

Countries with the Greatest Economic Need

The tool was edited since this presentation, showing a larger gap between the need for economic development rates of South Africa and Cameroon/Zimbabwe. While the rates changed slightly, the order of need for economic development did not shift.

After adding back in the nations with "+" next to them, I used the tool to rank the nations based on their weighted desirability scores.

Provided was my final recommendation.

This heat graph displays which countries most adequately meet the regulation requirements.

Provides further notes on foreign shareholder policies in each nation.

Financial Inclusion Deep Dive: MFI Market

Financial inclusion scores calculated in June.

Financial Inclusion Deep Dive: Mobile Phone

Financial inclusion scores calculated in June.

Financial Inclusion Deep Dive: Other Financial Metrics

Financial inclusion scores calculated in June.

Metrics used to develop August version of the excel tool. (Not up to date).

This slide contains the original research completed in June. To arrive at this conclusion, I collected data for each metric listed above. Once the data was collected and organized, I developed a tool to calculate the rank of which country met the most qualifications.

At the next meeting HOPE staff requested a new weighted data tool to evaluate rank. They also wanted to reevaluate nations that had been previously eliminated from our list of prospects. I developed a new ranking tool which weighed ~25 metrics (available in the appendix) for 57 countries.

After adding the original 57 countries back into the tool, I then reevaluated the nations using the initial minimum requirements. I then added back nations with qualifiable exceptions.

The tool was edited since this presentation, showing a larger gap between the need for economic development rates of South Africa and Cameroon/Zimbabwe. While the rates changed slightly, the order of need for economic development did not shift.

After adding back in the nations with "+" next to them, I used the tool to rank the nations based on their weighted desirability scores.

Provided was my final recommendation.

Tool Building & Analysis

Click above to download MFI Africa Greenfield Research.xlsx

I developed an excel tool to grade 57 African countries in 7 different categories comprised of data from 26 different metrics. You can view the tool by selecting the XLS file.

On the tool you will find a "Master Sheet" tab, which contains all the data points for each country in each metric. You will also find a "Weighted Grade" tab, which organizes and measures the data points and then returns the overall desirability score of each country (see cells G4:G57 or table "Country_Overall_Rank").

The images provided account for about 5% of this project. I recommended opening the excel file to view the full tool. For further information on how the tool works, view the "Tool Instructions" tab located on the sheet.

Cross Cultural Manual

Assignment:

Develop a cross-cultural manual to be used by HOPE staff members in preparation for business trips overseas.

Process:

I began by outlining everything HOPE might want in the manual. Unlike other culture manuals I've worked on in the past, this manual was specifically for business etiquette. After researching a list of what typically goes into business etiquette manuals, I drafted an outline and proposed it HOPE.

Once the outline was approved, I developed a list of questions I needed answers to in order to create quality and comprehensive content. I also created a list of potential interviewees for each nation. Interviewees tended to be business professionals native to the country, but also business professionals who had previously resided in each nation.

I collected and organized the responses of interviewees into a spreadsheet and cross checked answers with other interviewees for confirmation.

After compiling all of the relevant information, I designed a template to be used for future cross-cultural manuals. Once the template was finished, I was able to complete the Rwandan cultural manual and begin manuals for four other nations.

shaydawn

Hope International

Presentation Design

Tool Building & Analysis

Cross Cultural Manual