Development of Database for the DRC Wet Feeding Programme - Somalia

BACKGROUND AND CONTEXT

Danish Refugee Council (DRC) is a private independent, non-profit organization (NGO), founded on the basis of humanitarian principles, and human rights in general, to securing the protection of refugees and internally displaced persons (IDPs), and to promoting long term solutions to the problems of forced displacement. DRC has been providing relief and development services in Somalia since 1997.

Using a protection of human rights framework, the programmes have mainly aimed at supporting Somalis who are displaced by conflict. The Somalia programme has activities in Mogadishu, Hiraan, Somaliland, Bossaso and Galkayo programme areas.

Currently, DRC Somalia program focuses on supporting IDP populations and host communities affected by conflict and natural disasters. The main programmes include; Food Security and Livelihoods; WASH and Infrastructure; Protection and Advocacy; Community-Driven Development; as well as Emergency Response. The humanitarian assistance in Somalia focuses on assisting the affected populations get immediate and essential lifesaving needs.

THE WET FEEDING PROGRAMME

The wet feeding is an emergency programme aimed at providing immediate food needs to vulnerable populations, IDPs and urban poor, in Mogadishu. It is operational in 8 districts in Mogadishu with each having a feeding center where the programme is implemented.

The activities of the programme are directly implemented by 6 local NGOs with some partners covering more than one food distribution centre. Specifically, the partners are responsible for preparation and distribution of the meals; and reporting to DRC. In addition, it is responsible for storage, local procurement of all inputs necessary for wet feeding and maintenance of feeding centers. DRC’s role is to oversee the whole implementation processes, including frequent monitoring and reporting to the donors.

The targeting of the beneficiaries is based on a self-selection and there is no registration of beneficiaries. The components of the programme include food distribution, monitoring and evaluation of the programme implementation and hygiene promotion. The programme is multi-donor funded.

RATIONALE

Currently, there are several data collection tools which include site monitoring tools, post distribution monitoring tools, stock summary reports, and weekly head-count data sheet, which are each analyzed and used to generate periodic reports. The rationale is to interrelate and collate the various data collection tools with different parameters of the programme in order to measure its performance at a glance through generation of reports. Currently, data is received electronically in MS Word and Excel format, and then analyzed manually to produce various reports needed for decision making; a process that has proved cumbersome.

PURPOSE

The purpose of the consultancy is to develop a customized database to allow management of the programme data and to produce periodic reports as needed by the various stakeholders.

SPECIFIC OBJECTIVES ARE

• Design and develop a database for use by the Wet Feeding programme for data management purposes

• Develop a relevant user guide/Operation manual

• Train staff on how to operate the database to satisfy the Programme data needs and enable it to address minor troubleshooting problems

SCOPE OF WORK

To fulfill the goal of the consultancy, the Database consultant would need to:

• Attend a briefing session with Wet Feeding Manager and Monitoring and Evaluation Coordinator to obtain a detailed specification of what needs to be developed.

• Develop a set of database specifications and the level of detail that corresponds to the the Wet Feeding programme needs

• Create an open database allowing for upgrades/adaptations in the future if required.

• Liaise with DRC IT department to discuss compatibility and linkages.

• Pilot the database by running a full day demonstration to ascertain whether the database fulfills all of the requirements of wet feeding programme

• Assist the data entry clerk upload all historical data into the database through importing existing MS Excel data, instead of re-capturing data. Install the database onto the designated computers in Mogadishu.

• Write an instruction (Operation) manual that will provide detailed technical specifications and front-end user specifications and that will allow another database specialist to make the necessary changes.

• Train the relevant Wet Feeding and M&E staff on the database on issues of data capturing and how to modify standard reports by developing new queries and new reports.

• Provide technical support to the data entry clerk after the database has been installed in the first 6 months. This will include making the necessary modifications based on lessons learnt and upload the finalized version to a number of computers as will be advised by the Wet Feeding Manager.

EXPECTED OUTPUTS

• A functional Database, addressing the needs of the programme as prescribed in the project documents and guided by DRC Staff

• An Operation manual for the database

• An induction training of the relevant staff on operation of the database

• A report on the whole assignment, including expected limitations, capacity of the Database, observations and any recommendation on capacity of staff.

NB: Protection and security of data in the database must be included to prevent unauthorized access to the system

TIME FRAME

It is anticipated that the assignment will take 2 weeks working full time, with a further 1 week of support. Extension of this period will depend on the arising circumstances, but not limited to 1 week extension and will depend on the consultant’s performance during the first week, as well as the substantive progress.

REPORTING ARRANGEMENTS

During the contract, the consultant will report on a daily basis to the Wet Feeding Manager, with technical oversight by the M&E Coordinator.

DRC’S RESPONSIBILITIES

• Transport to and from the field.

• All necessary project documents that may facilitate the consultant’s work

• Accommodation in the field

• Travel insurance for the consultant for the duration the consultant is in the field

• Payment of the consultancy wages as will be stated in the contract agreement

The terms and conditions of service will follow DRC terms of consultancies. Payment will be done according to the financial procedures of DRC.

PROFESSIONAL QUALIFICATIONS AND EXPERIENCE

• Academic qualifications or equivalent work experience in Information Technology, database management and Management Information Systems

• Relevant experience of IT management, with at least 2 years technical experience in the design of database set up and design of relevant user guides/manual

• Excellent skills in web development and open source operating systems, including open source software and databases

• Excellent and proven ability to manage databases and create innovative solutions for database management. Good understanding of management information system is required

• Experience in the development of databases for recurrent programme or output monitoring systems within the emergency context will be a distinct advantage

EVALUATION AND AWARD OF CONSULTANCY

DRC will evaluate the proposals and award the assignment based on technical and financial feasibility. DRC reserves the right to accept or reject any proposal received without giving reasons and is not bound to accept the lowest or the highest bidder. Only those shortlisted will be contacted.

FURTHER INFORMATION

You are welcome to contact DRC Wetfeeding & Livelihoods Manager, Ms Abigael Nyukuri on email:mgr.wetfeeding@drcsomalia.org for further information or questions on the programme.

PLEASE NOTE that applications are NOT to be sent to Ms Nyukur. Applications sent directly to Ms Nyukuri WILL NOT BE CONSIDERED.

For general information about the Danish Refugee Council, please consult www.drc.dk.

COMMITMENTS

DRC has a Humanitarian Accountability Framework, outlining its global accountability commitments. All staff are required to contribute to the achievement of this framework (http://www.drc.dk/HAF.4265.0.html).

APPLICATION PROCESS

Interested applicants are required to submit the following:

• CV, including similar previously performed and names of three professional referees.

• Technical proposal that summarizes understanding of the TOR and the suggested type of data base to be used.

• Work-plan reflecting all the deliverables.

• Financial proposal providing cost estimates and consultancy fees. Daily rates are negotiable.

Please forward the application and CV to drcjobs@drchoa.org, in English and marked “Development of Wet Feeding Database Consultancy” in the subject line, no later than 9. August 2012.

How to apply:

APPLICATION PROCESS

Interested applicants are required to submit the following:

• CV, including similar previously performed and names of three professional referees.

• Technical proposal that summarizes understanding of the TOR and the suggested type of data base to be used.

• Work-plan reflecting all the deliverables.

• Financial proposal providing cost estimates and consultancy fees. Daily rates are negotiable.

Please forward the application and CV to drcjobs@drchoa.org, in English and marked “Development of Wet Feeding Database Consultancy” in the subject line, no later than 9. August 2012.

Development of Database for the DRC Wet Feeding Programme - Somalia Development of Database for the DRC Wet Feeding Programme - Somalia Reviewed by Unknown on 3:10:00 AM Rating: 5

No comments:

JOBS CATEGORY

Tanzania Kenya NGO JOBS Uganda Best Jobs Consultancy Rwanda ICT JOBS Administrative United Nations Sudan Best Jobs Finance Health - Medical Engineering Ethiopia Education Agricultural Lecturer Human Resources Somalia Media Congo - Kinshasa Legal Jobs Bank Jobs Monitoring and Evaluation Mining World Vision Burundi Procurement African Barrick Gold Accountant Zambia Sales and Marketing US EMBASSY East African Community Mozambique Telecoms Research CARE International Save The Children Plan International Arusha Malawi South Sudan Oxfam Scholarships African Development Bank Finance and Administration SafariCom Aviation The Commonwealth American Embassy Sales Zanzibar Environmental Catholic Relief Services Dar es salaam USAID Operations FHI 360 UNDP Security World Bank Economist TradeMark East Africa Unicef Hospitality Managers International Rescue Committee (IRC) Restless Development Accounting Civil Engineers AMREF Morogoro Utumishi AfDB African Development Bank COOPI - Cooperazione Internazionale Driver - Logistics Path International Mwanza African Union Tigo Jobs Marketing Mbeya Teaching Au African Union PSI Population Services International Pwc PricewaterhouseCoopers East African Breweries North Mara Gold Mine ACTED Djibouti Malaria Consortium Bulyanhulu Gold Mine DFID Driver Buzwagi Gold Mine Jhpiego COMESA FINCA JOBS International Jobs Adeso Danish Refugee Council Kilimanjaro Nairobi Coca-Cola Handicap International Pact International Rio Tinto Solidarités International Tender EGPAF Elizabeth Glaser Pediatric AIDS Foundation Logistics Serengeti Breweries Ltd Nation Media Group Africare Norwegian Refugee Council Samaritan's Purse Chemonics International COUNTRY DIRECTOR ICAP of Columbia University InterShips Precision Air RwandAir Marie Stopes International (MSI) Serengeti Breweries Volunteer Climate Change IGAD Tetra Tech ARD Agriculture Jobs Dodoma Iringa One Acre Fund Project Management Clinton Health Access Initiative (CHAI Technoserve Twaweza East Africa ActionAid Lutheran World Federation SADC Secretariat Tanga Vso International ACDI/VOCA Halmashauri Agha Khan Kenya Commercial Bank World Agroforestry Centre Deloitte East Africa International Organization for Migration (IOM) COMESA Secretariat: Software Engineering Safety and Security Shinyanga Jobs Tanzania Breweries Pathfinder International World Health Organization KPMG TANROADS Tanzania Electric Supply Company British Council Futures Group KCB BANK UN-Habitat WFP World Food Programme Barclays GEITA GOLD MINING TANESCO Electrical Engineer Food and Agriculture Organization GOAL Mombasa Tabora WWF World Wide Fund for Nature Microsoft Tanzania Ports Authority East African Development Bank Family Health International (FHI) IBM EAST AFRICA IntraHealth International Mercy Corps SERIKALINI - GOVERNMENT OF TANZANIA AccessBank Community Development Jobs Data Base Management Google Africa ICAP - TZ KEMRI/CDC Program WaterAid Tanzania Auditor SNV International Stanbic Bank Amnesty Horn Relief Kampala Management Systems International (MSI) Standard Chartered Bank VETA Christian Aid DIAMOND TRUST BANK Helen Keller International Help Age Mtwara Uganda Telecom Airtel Africa Equity Bank Internships Marie Stopes TCRA Web Development B B C WORLD SERVICE Human Rights Kigali Makerere University Nile Basin Initiative Kenyatta University Kigoma Mzumbe University NSSF National Social Security Fund Nile Breweries Limited Tulawaka Gold Mine University of Nairobi kenya Airways Bank of Tanzania Graduates MTN Muhimbili National Hospital Nepad Partners in Health Room to Read SUMATRA UNWOMEN African Wildlife foundation (AWF) KEMRI Kagera Librarian MENTOR Initiative Trainee USAILI - INTERVIEW Uiversity of Nairobi WaterAid International icipe Project CAFOD - Catholic Agency for Overseas Development Egerton University EngenderHealth Goal Ireland Kenyan Banks Lake Victoria Basin Commission Peace Corps TANAPA TASAF Tanzania Social Action Fund Zanzibar University ACB AKIBA COMMERCIAL BANK AGRA Alliance for a Green Revolution in Africa Advans Bank Ethiopian Airlines Freedom House IITA International Institute of Tropical Agriculture Legal Moshi NMB BANK Resolute Tanzania Singida Uganda Uganda National Roads Authority University of Dar es salaam University of Dodoma British High Commission ChildFund EWURA FilmAid International NECTA TPDC Tanzania Civil Aviation Authority (TCAA) United States International University World Concern Aga Khan Foundation CBA Commercial Bank of Africa Ecomist Ernst and Young IUCN International Union for Conservation of Nature International Medical Corps Islamic Relief Kakira Sugar Musoma National Institute for Medical Research OPEN UNIVERSITY OF TANZANIA Relief International TAA Tanzania Airports Authority Trócaire Uganda Revenue Authority VODACOM TANZANIA VSF Belgium Architects Hivos IFC International Finance Corporation Ifakara Health Institute Inoorero University International Commercial Bank Kenya Red Cross Society MADEREVA Medical Oil and Gas Pwani University College SOKOINE UNIVERSITY Tumaini University Water Engineering AWF African Wildlife Foundation Acacia Mining Accounts African Virtual University Altima Africa Ardhi University Bank of Uganda Business Development Concultancy Del Monte Kenya Embassies Kenya Airports Authority Lake Victoria South Water Services Board Mara National Bank of Commerce RECORDS MANAGEMENT JOBS RUKWA Ruvuma Search for Common Ground Songea TTCL Tanzania Telecommunications Company Limited Unilever War Child International Zinduka Afrika ACORD AKU ​Aga Khan University Africa Nazarene University Africa Rice Center (AfricaRice) Aga Khan Health Services CRDB BANK Commercial Bank of Africa Daraja Tanzania Engineers Registration Board (ERB) Fina Bank International Potato Center International Potato Center (CIP) Intrahealth Jomo Kenyatta University Kilimanjaro Christian Medical Centre Kyambogo University Lindi Jobs MCL Mwananchi Communications MUHAS-harvad Moi University NBC BANK National University of Rwanda Ngorongoro Conservation Area Authority Njombe Nuru International Nzoia sugar Company RTI International SUA SOKOINE UNIVERSITY OF AGRICULTURE THE LAW SCHOOL OF TANZANIA TRA Tanzania Revenue Authority Tanzania Postal Bank The Foundation For Civil Society Udhamini wa Masomo Western Union AIR TANZANIA Action Against Hunger (ACF) Agricultural Society of Kenya BRALIRWA Bondo University College Caritas Comoros Concern Worldwide Conservation Jobs Consolidated Bank of Kenya DHL Express Ewaso Ngiro South River Basin Development Authority Geologist Gulf African Bank INSTITUTE OF ADULT EDUCATION Jomo Kenyatta University of Agriculture and Technology Kabale University Kabale University (KAB) Kenya Ports Authority KickStart International MORUWASA Morogoro Urban Water and Sanitation Authority MSH Management Sciences for Health Mumias Sugar Company Nairobi Hospital Nkumba University Rural Electrification Agency SOKINE UNIVERSITY SONGWE STAMIGOLD Stores TACAIDS TARURA TCU Tanzania Commission for Universities Tullow Oil World Lung Foundation (WLF) ALAF Limited Aga Khan Development Network (AKDN) Aga Khan Hospital Air Malawi American Refuge Committee BENKI YA POSTA - TPB BANK BTC Belgian Technical Cooperation Bhttp://www.blogger.com/img/blank.gifank of Tanzania Bioversity International CHF International Customer Service Jobs DANGOTE DIT DAR ES SALAAM INSTITUTE OF TECHNOLOGY Danida Dar es Salaam Institute of Technology Daystar University ECOBANK ETDCO Electrical Transmission and Distribution Construction and Maintenance Company European Union IFM INSTITUTE OF FINANCE MANAGEMENT INSURANCE JOBS - BIMA ITECH Internews® Network KUITWA KAZINI Kenya Accreditation Service Kenya Polytechnic University College Kilombero Sugar Company Kisii University College Kisumu Laboratory Jobs MSD MEDICAL STORES DEPARTMENT MSF Switzerland Management Sciences for Health Manyara Maseno University Ministry of State for Planning Muteesa 1 Royal University Médecins Sans Frontières NIDA National Identification Authority Narok University College OSHA Occupational safety and Health Authority Open Society Initiative for Eastern Africa (OSIEA) PA PAC PEPSI POLICE - POLISI Petroleum EngineerS RWANDA HOUSING AUTHORITY Seychelles Songas TBC TANZANIA BROADCASTING CORPORATION TBS TANZANIA BUREAU OF STANDARDS TFDA TANZANIA FOOD AND DRUGS AUTHORITY TIB - Tanzania Investment Bank Tanzania Mortagage Refinance Company Tanzania Teachers’ Union Transmara Sugar Company Tropical Pesticides Research Institute Tumba College of Technology Twiga Cement UNESCO UNOCHA Umma University University WRP Walter Reed Project ZANTEL ao uga
Powered by Blogger.