Call for Expression of Interest – Consultant


Call for Expression of Interest – Consultant

Terms of Reference (ToR)
Development of a Cloud-based Catch Assessment Survey (CAS) Database
for Lake Tanganyika

1           Background

The Nature Conservancy (TNC) and Pathfinder International in Tanzania are jointly implementing an integrated project known as Tuungane that addressescollaborative fisheries management as part of Population, Health and Environment (PHE) issues for communities living in 17 villages along Lake Tanganyika in Kigoma and Rukwa Regions. One of the project goals is to achieve sustainable fisheries through, among other things, formation and capacity building of Beach Management Units(BMUs) as provided by Tanzania’s Fisheries Policy.
TNC is working closely with the Fisheries Development Division in Tanzania’s Ministry of Agriculture, Livestock and Fisheries to establish and build capacity of the BMUs. A key outcomedesired from the BMU capacity-building initiativeis the ability of BMU members to collect reliable Catch Assessment Survey data along with timely submissionto inform fisheries management.
TNC is also collaborating with the Lake Tanganyika Authority (LTA) to build a Lake Tanganyika Freshwater Atlas, which organizes, synthesizes, and displays spatial data and information for use by multiple stakeholder groups. A priority for this collaborating is improving fisheries data collection lake-wide.
Collecting fisheries data in few areas or just one country does not allow of the lake-wide fisheries management needed to effectively manage fish stocks in Lake Tanganyika, however. A functioning Catch Assessment Surveyapplication and database would allow the LTA – tasked with coordinating information exchange onthe lake’s fisheries –and riparian country national fisheries agenciesto access fisheries data pertaining to:
(i)            Quantity of fish landed in the riparian local administrative units and countries at large;
(ii)          Estimated monetary value of the fish landed;
(iii)         Commonly landed fish species and their contribution to total catch;
(iv)        Contribution of different types of fishing gearor boats to total catch;
(v)          Changes in catch rates for different fish species among areas, seasons, gear types, gear sizes, and boat types; 
(vi)        Trends in fish catch rates and total catch in relation to total fishing effort;
(vii)       A view of emerging or disappearing fish species as an indicator of conservation needs.
TNC presented a tablet-based Catch Assessment Surveyprototype to the LTA Management Committee during their Second Extra-Ordinary Meeting held in Nairobi, Kenya (15-16 December, 2015). The Management Committee approved the further development of acloud-based Catch Assessment Surveyto accommodate the four Lake Tanganyikariparian countries (Burundi, Democratic Republic of the Congo, Tanzania, and Zambia),with an initial pilot phase in Tanzania.

2           Consultancy Rationale

Effective fisheries management requires accurate information that is easily collected, stored, accessed,and continuously updated. Collected data need to be safely stored and efficiently processed in a relational database management system to generate required estimates and reports. 
LTA, in collaboration with the Tanzania Ministry of Agriculture, Livestock and Fisheriesand other riparian countries (Burundi, Zambia and the Democratic Republic of Congo), developed a standalone front-end lake-wide Catch Assessment Survey (CAS) database in 2012. This database is linked with the Frame Survey Database established in 2011. This database has some noteworthy limitations:
ü  It does not accommodate data communication among Districts or Regions, so neighboring areas cannot see what others are catching;
ü  Installation is required on individual computers and data are transferred from field-based computers to the central database(i.e., it is not cloud-based);
ü  It cannot be easily scaled up and does not accommodate all countries across the Lake Tanganyika 
ü  It is currently limited to only English, leaving out French and Swahili which are commonly used in other riparian countries.
TNC in collaboration with LTA and the Tanzania Ministry of Agriculture, Livestock and Fisheries (Fisheries Development Division) is seekingaService Provider to develop acloud-based Catch Assessment Survey application and database to addressthese limitations.

3           Objective

Improve the LTA fisheries Catch Assessment Survey (CAS) databaseresulting in a reliable and robust Fisheries Information Management System (FIMS) that will serve as a tool for effective fisheries management across the Lake Tanganyika riparian countries.

4           Scope of Work

Throughout this contract, the Service Providerwill work under the supervision and guidance of the Tanzania Fisheries Development Division in theMinistry of Agriculture, Livestock and Fisheriesandcollaborate closely with TNC and LTA. The Service Providerwill not be allowed to alter or change any statistical formula already installed in the previous stand-alone database. The work is divided into three phases.

Phase I: Database Development

During this phase, the Service Provider will work with the Tanzania Fisheries Development Division, TNC, and LTA to fulfil the following responsibilities and functions:
4.1         Review the existing CAS database design and develop a cloud-baseddatabasethat can integrateexisting data and addresses informationmanagement and report output needs;
4.2         Design user data input interfaces in English for Android OS tablets, smart phones, and Microsoft desk-top computing systems;
4.3         Perform data transfer from the previous standalone CAS database to the new cloud-based CAS database;
4.4         Work with LTA, Riparian country Fisheries Ministries and TNC to determine and set data access roles.
4.5         Submit all administrator passwords to the LTA secretariat for easy application of the database.

Phase II: CAS and Database Pilot

4.6         Train selected Tanzania Fisheries Division, TNC, and LTA staff on electronic data collection in Uvinza District;
4.7         Train selected Tanzania Fisheries Division, TNC, and LTA staff to transfer data collected into the cloud-based CAS database;
4.8         Train selected Tanzania Fisheries Division, TNC, and LTA staff on reports generation from the cloud-based CAS database;
4.9         Developdraft database administrator and user manuals in English and submit them to LTA;
4.10      Work with TNC expert to evaluate pilot data collection, transfer, refine the user manuals, management processes and make changes or modifications as needed based on recommendations from users and experts.
4.11      Submit initial database and administrator and user manual products for approval from LTA Secretariat to begin scaling up phase.

Phase III: Scaling up

4.12      Translate approved final products (interfaces, user manuals) into Kiswahili and French so the system can subsequently be scaled up to all four riparian countries;
4.13      Generate guidelines and recommendationsfor scaling up to the other three riparian countries;
4.14      Prepare the final versions of the database administrator in English, Kiswahili and French and submit them to the LTA Secretariat;
4.15      Launch and submit to LTA, the cloud-based CAS Database.

5           Deliverables

5.1         A work plan that provides details on methods and processes by which the assignment will be carried out along with a realistic timeline with major milestones.
5.2         A functioning cloud-based CAS database that supports field data through tablets, smartphones, or other computers in English, Kiswahili,and French.
5.3         Administrative and user manuals in English, Kiswahili, and French.
5.4         A final report outlining the main activities carried out, achievements, priority tasks and other issues that may require additional attention of the Fisheries Development Division and LTA.

6           Timeframe

The desired completion date for the assignment is March 2017.  The Service Provider should submit an anticipated time line for the accomplishment of the assignment. Anticipated time lines that extend beyond March 2017 will be reviewed, but not preferred.

7           Co-ordination of Interviews or Travel

Service Provider is financially responsible for their own travel; however, TNC and LTA can assist with logistics, arranging meetings, transport, and accommodation if required. Service Providers should considerthis when composing their bid. 

8           Supervision Responsibility 

The Service Provider will work under the supervision of TNC and LTA and in close collaboration with the Assistant Director of Fisheries Resource Development (FRD) – of Tanzania Fisheries Development Division – (Ministry of Agriculture, Livestock and Fisheries).

9           Payment

Payment schedule will most likely be structured as the following:
10% upon signing the contract, 25% at end of Phase 1,25% at end of Phase 2, and 40% upon completion and submission of the assignment.

10        Skills and Qualifications

Service provider should have demonstrated knowledge and experience in the following areas:
10.1      At least 5 years of professional experience in database programming and extensive knowledge in relational database design and management; Experience with Amazon web services for database management is an advantage.
10.2      Demonstrated experience illustrating the design of complex database systems and proceduresand documenting procedures. Experience developing GIS-based database systems is an advantage;
10.3      Experience in fisheries sample based survey data collectionor experience in developing fisheries management systems and knowledge of Catch Assessment Survey and fisheries Frame surveys is highly advantageous;
10.4      Experience working with government institutions and assets;
10.5      Good communication skills, both orally and in writing;

10.6      Fluency in both written and spoken Englishand capacity, either internally or through a subcontract, to translate work into Kiswahili and French.