MEDA, Business Development and the Utilization of Information Technology

1
MEDA, Business Developmentand theUtilization of
Information Technology
Presented to mHealth Working Group June 2010
2
Clear language and communication is vital to the
success of any organization this same rule
applies when dealing with IT
3
Table of Contents

• MEDA TZ
• Maintain
• Expand
• Explore
• MEDA worldwide

4
Situation

• Malaria mortality and morbidity

5
Complication

• ITNs new on scene
• Clear world health targets set in Abuja, Nigeria
  in 2000
• Focus is on at-risk groups Px women and infants
  60 coverage
• Limited funds, no distribution
• Solution
• TNVS
• 2004
• Success factor Clear event for issuance of a
  voucher
• From that flowed a distribution sector

6
Maintain back-end systems
Program Management
Data Management

• Voucher tracking and security
• Voucher statistics
• Stakeholder numbers

• Voucher scanner
• Voucher database
• Clinic and retailer database

TNVS
7
Maintain Here is a representation of our voucher
transaction database
8
Maintain We maintain a separate database for
each of our 4,300 clinics with profile data on
each
Code Region Name District Latitude Longitude Type
10426 Arusha Namanga Dispensary Monduli -2.55105 36.78766833 Rch Clinic
10427 Arusha Ngereiyani Dispensary Monduli -2.98109301 36.85513973 Rch Clinic
10428 Arusha Olmolog Dispensary Monduli -2.86671826 37.126472 Rch Clinic
10429 Arusha Selela Dispensary Monduli -3.21059355 35.94780743 Rch Clinic
10430 Arusha Sinya Dispensary Monduli -2.78273293 36.95404351 Rch Clinic
10431 Arusha Tingatinga Dispensary Monduli -2.97728964 36.95686519 Rch Clinic
10432 Arusha TMA Dispensary Monduli -3.3462865 36.45869315 Rch Clinic
10501 Arusha Arash Dispensary Ngorongoro -2.37680742 35.50595641 Rch Clinic
10502 Arusha Digodigo Dispensary Ngorongoro -2.1457512 35.73580563 Rch Clinic
10503 Arusha Enduleni Hospital Ngorongoro -3.20602306 35.27414382 Rch Clinic
10504 Arusha Kakesio Dispensary Ngorongoro -3.37899872 34.98797357 Rch Clinic
10505 Arusha Loliondo Dispensary Ngorongoro -2.05198118 35.62422037 Rch Clinic
10506 Arusha Malambo Dispensary Ngorongoro -2.51106271 35.60578823 Rch Clinic
10507 Arusha N.C.A.A. Dispensary Ngorongoro -3.24539253 35.48083484 Rch Clinic
10508 Arusha Nainokanoka Dispensary Ngorongoro -3.03020963 35.69011688 Rch Clinic
9
Expand Representation of 4,300 government-owned
RCH clinics
10
Maintain And we maintain a yet another database
for each of our 7,000 retailers
Code Region Name District Latitude Longitude Type
1 Arusha Emanuel Bajuto Ngorongoro -3.23672 35.20340 Retailer
2 Arusha Joseph Sendui Ngorongoro -2.10829 35.49736 Retailer
3 Arusha Haruna Kasimu Ngorongoro -3.30468 35.23440 Retailer
4 Arusha Safari Shauri Ngorongoro -3.23327 35.39268 Retailer
5 Arusha Husna Hassan Ngorongoro -3.16899 35.48395 Retailer
6 Arusha Samwel Goyo Ngorongoro -2.17817 35.41268 Retailer
7 Arusha Sammy Huho Ngorongoro -3.12799 35.28058 Retailer
8 Arusha Jonh Clement Ngorongoro -3.21678 35.33834 Retailer
9 Arusha Jonh Darago Ngorongoro -3.14624 35.52682 Retailer
10 Arusha Jonh Machota Ngorongoro -3.22395 35.51290 Retailer
11 Arusha Jonh Tippe Ngorongoro -3.14897 35.49879 Retailer
12 Arusha Halima Mwanga Ngorongoro -2.03261 35.37574 Retailer
13 Arusha Prosper Mosha Ngorongoro -2.30507 35.36384 Retailer
14 Arusha Prevanus Katinhila Ngorongoro -2.09442 35.42066 Retailer
15 Arusha Josephat Ami Ngorongoro -3.26011 35.36409 Retailer
11
Expand Representation of Hati Punguzos 7,000
retail outlets
12
Maintain MEDA TZ is approaching its goal of 100
GPS coverage for all TNVS stakeholders
GPS Coordinates Collection -- Annual Comparison GPS Coordinates Collection -- Annual Comparison GPS Coordinates Collection -- Annual Comparison GPS Coordinates Collection -- Annual Comparison
2007 2008
RCH GPS Coordinates 3,000 3,843
ITN Outlets GPS Coordinates 1,057 4,015
GPS Coordinates Collection Progress as of Dec. 31, 2008 GPS Coordinates Collection Progress as of Dec. 31, 2008 GPS Coordinates Collection Progress as of Dec. 31, 2008 GPS Coordinates Collection Progress as of Dec. 31, 2008
Stakeholders GPS Coordinates Collected
RCH Clinics 4,475 3,843 86
ITN Outlets 6,918 4,015 58
13
IT baseline allows us to adapt program changes
easily

• Malaria objectives changed from at-risk groups to
  household coverage (2 nets per HH) and then
  Universal (all sleeping spaces being covered)
• Change in objectives made possible, and possibly
  fueled by, influx of huge sums of donor money
• GF begins in 2004, Tanzania first grant
  recipient
• PMI begins in 2006
• Govt of TZ decides to catch up the coverage of
  children under five.
• MEDA and other cooperating NGOs finished the
  U5CC in May 2010
• Distribute 7.2 million nets
• Next up is Universal Coverage Campaign with 14MM
  nets
• Key issue remains What happens next? If the
  free net distribution is catch up, how do we
  keep up?

14
Scaling up Technology base allows MEDA TZ to
find new ways
Data Dissemination
Program Management
Data Collection

• Vehicle tracking software improves general
  operations
• Planning TNVS monitoring activities
• Driver performance and vehicle safety
• LLIN issuing points

• Detailed maps can be generated and overlaid with
  other statistics using various GIS software
  platforms
• ESRI
• Google Earth

• Handheld GPS units and a vehicle tracking system
  collect location coordinates for
• Clinics
• Retailers
• District offices
• Villages
• Petrol filling stations

TNVS
U5CC / UCC
15
Expand We can then drill down by geography. Here
is a region.
16
Expand And then to the District level
17
Expand As detailed as we need to. Here is the
ward level.
18
Expand The next step involves appropriating
other mapping technologies into the database.
Here is our data overlaid on Google Earth.
19
Expand We can pinpoint a location. Here is
MEDAs office.
20
Expand Here is profile data attached to the
location
21
Table of Contents

• MEDA TZ
• Maintain
• Expand
• Explore
• MEDA worldwide

22
Explore
Data Dissemination
Program Management
Data Collection
Data Management
Management dashboards
Integrated database (GPS reports, voucher
tracking and statistics, program stakeholders,
LLIN results
Public access data via online wiki-site

• SMS system for key indicators
• Online forms and reports for monitoring
  activities
• SMS voucher

TNVS
U5CC / UCC