<div>Terms of reference for </div><div>Data-Base Designer - Improved Cook Stove Program (ICS)</div><div><br></div><div>POSITION:<span class="Apple-tab-span" style="white-space:pre"> </span>DATA BASE DESIGNER – INTERNATIONAL</div>
<div>ACTIVITY:<span class="Apple-tab-span" style="white-space:pre"> </span>Develop a database </div><div>TIMEFRAME:<span class="Apple-tab-span" style="white-space:pre"> </span>OCTOBER-DECEMBER 2012 (20 days)</div><div>LOCATION:<span class="Apple-tab-span" style="white-space:pre"> </span>Distance</div>
<div><br></div><div><div>A.<span class="Apple-tab-span" style="white-space:pre"> </span>GENERAL</div><div>The improved cook stoves (ICS) program implementation started in 2011 to develop the value chain of ICS in Lao PDR. Over a period of 8 years, the objective is the dissemination of 420,000 ICS. Program design is still under development during the first phase - 2011 to 2013 – as it involves accumulation of technical and value chain knowledge, fine-tuning of methodologies and M&E design, capacity building as well as ensuring enabling environment with the government.</div>
<div><br></div><div>Oxfam Novib, Blue Moon Fund and SNV support this project. The Non-profit Association for Rural Mobilization and Improvement (NORMAI) is responsible for implementing the activities in Savannakhet. SNV Lao PDR provides direct support to NORMAI.</div>
<div><br></div><div>The objective of the program is to reduce smoke from cooking, fuel consumption and greenhouse gas emission through a sustainable market-based ICS sector. The project team designs new type of stove and builds the capacity of private and public partners to test, standardise, produce and increase the market share of these stoves. This involves increased quality and capacity of ICS production by producers, increase of the ICS market by retailers, and increase number of stoves used in houses of customers.</div>
<div><br></div><div><br></div><div>B.<span class="Apple-tab-span" style="white-space:pre"> </span>OBJECTIVES</div><div>To monitor progress properly the programme requires a solid monitoring system, that contains data on stoves produced, sold and used. The programme developed a database for trial in MS Excel that gives a good overview of the patterns and queries needed for the future database. </div>
<div><br></div><div>The key objectives of this assignment is to design a database which needs to be user-friendly, simplistic and stable and allows a large number of entries to be analysed on different levels:</div><div>-<span class="Apple-tab-span" style="white-space:pre"> </span>The producers (evolving, up to 30)</div>
<div>-<span class="Apple-tab-span" style="white-space:pre"> </span>The production and sales to retailers (per batch of stoves, up to 20,000 stoves/year/producer)</div><div>-<span class="Apple-tab-span" style="white-space:pre"> </span>The retailers (evolving)</div>
<div>-<span class="Apple-tab-span" style="white-space:pre"> </span>The customers (individually, constantly increasing)</div><div><br></div><div>The dbase needs to run several queries in simple manner, according to criteria (such as period of time, per producer, per geographical area, per stove type), such as the following: </div>
<div>-<span class="Apple-tab-span" style="white-space:pre"> </span>inform the Point of Sale Time (or POST, meaning average time between production and sale to user).</div><div>-<span class="Apple-tab-span" style="white-space:pre"> </span>provide basic information about the customers (to track the utilization of stoves).</div>
<div>-<span class="Apple-tab-span" style="white-space:pre"> </span>the production and sales to retailer</div><div><br></div><div><br></div><div>C.<span class="Apple-tab-span" style="white-space:pre"> </span>DUTIES AND RESPONSIBILITIES:</div>
<div>The principles of the database are relatively simple but needs to fit to specificities of the value chain and of the project team. The database specialist will always work in a participatory manner to make sure his/her work fits to the capacities of the staff. The project team will provide guidance and available information. This assignment will be under the supervision of SNV staff with one referent person.</div>
<div><br></div><div>This assignment includes: </div><div>-<span class="Apple-tab-span" style="white-space:pre"> </span>Analyse the forms used on the field which provides the layout of the required data entry</div><div>-<span class="Apple-tab-span" style="white-space:pre"> </span>Analyse the existing database on Excel and Access which provided good overview of the patterns required</div>
<div>-<span class="Apple-tab-span" style="white-space:pre"> </span>Regularly liaise with the team referent for additional information on requirements and realities (e.g. about the synthetized data report required, use of Lao language and script, available skills in the team, pattern of production and sales)</div>
<div>-<span class="Apple-tab-span" style="white-space:pre"> </span>Discuss and confirm the use of MS Excel or MS Access</div><div>-<span class="Apple-tab-span" style="white-space:pre"> </span>Develop further the existing MS Access database or to develop a new one</div>
<div>-<span class="Apple-tab-span" style="white-space:pre"> </span>Have the team running trials for a representative number of data entry and make the required modifications</div><div>-<span class="Apple-tab-span" style="white-space:pre"> </span>Provide guidance and documentation for the use, maintenance and security of the database</div>
<div>-<span class="Apple-tab-span" style="white-space:pre"> </span>Advise on possible use of mobile monitoring devises</div><div>-<span class="Apple-tab-span" style="white-space:pre"> </span>Present the Dbase to the ICS staff and provide a training on the use, data entry and analysis of data in the dbase, as well as on how to make optional adjustments to the structure (if based in the region).</div>
<div><br></div><div><br></div><div>D.<span class="Apple-tab-span" style="white-space:pre"> </span>LOCATION</div><div>The assignment will be done by distance, as well as at the office of Normai in Savannakhet if the consultant is based in the SE-Asia region.</div>
<div><br></div><div><br></div><div>E.<span class="Apple-tab-span" style="white-space:pre"> </span>DELIVERABLES</div><div>I. After analysing the available forms, database and information, the consultant will provide proposition about the software to use and the frame of the database</div>
<div><br></div><div>II. After developing it the consultant will provide a draft of the database for a serial of trials and modifications</div><div><br></div><div>III. After final development of the database the consultant will deliver synthetic and pragmatic user documentation.</div>
<div><br></div><div>IV. The consultant will train designated staff on practical use, and the management of the dbase</div><div><br></div><div>V. By the end of the assignment a ppt presentation will be provided on the structures, management and usage of the dbase.</div>
<div><br></div><div><br></div><div>F.<span class="Apple-tab-span" style="white-space:pre"> </span>QUALIFICATIONS AND EXPERIENCE:</div><div>•<span class="Apple-tab-span" style="white-space:pre"> </span>Education: IT, computer sciences or related field</div>
<div>•<span class="Apple-tab-span" style="white-space:pre"> </span>Experience in database design and maintenance. </div><div>•<span class="Apple-tab-span" style="white-space:pre"> </span>Fluent in English</div><div>•<span class="Apple-tab-span" style="white-space:pre"> </span>Experience in development context is an asset</div>
<div>•<span class="Apple-tab-span" style="white-space:pre"> </span>Being based in Laos or SE-Asia region is an asset.</div><div>•<span class="Apple-tab-span" style="white-space:pre"> </span>Excellent analytical skills and problem solving capabilities.</div>
<div><br></div><div><br></div><div><br></div><div>G.<span class="Apple-tab-span" style="white-space:pre"> </span>TIME FRAME</div><div>This assignment will be conducted during the period of October- November 2012. The final report will be delivered before 30 November.</div>
<div><br></div><div>H.<span class="Apple-tab-span" style="white-space:pre"> </span>HOW TO SUBMIT AN OFFER</div><div>Interested consultants or companies are invited to send:</div><div>1.<span class="Apple-tab-span" style="white-space:pre"> </span>A motivation letter </div>
<div>2.<span class="Apple-tab-span" style="white-space:pre"> </span>Comments on this ToR</div><div>3.<span class="Apple-tab-span" style="white-space:pre"> </span>CV(s)</div><div>4.<span class="Apple-tab-span" style="white-space:pre"> </span>A short description of relevant assignments </div>
<div>5.<span class="Apple-tab-span" style="white-space:pre"> </span>Tentative time planning</div><div>6.<span class="Apple-tab-span" style="white-space:pre"> </span>Budget.</div><div><br></div><div>before the October 12th 2012, to the SNV Associate Advisor, Mr Damien Delaplace <a href="mailto:DDelaplace@snvworld.org">DDelaplace@snvworld.org</a> cc. to the NORMAI ICS Project Manager, Ms. Khamlet Sengsourichanh <a href="mailto:khamleth15@gmail.com">khamleth15@gmail.com</a> and Ms. Vilayluck THAMMAKHANTY (HRO) <a href="mailto:vilaylack.vlt@gmail.com">vilaylack.vlt@gmail.com</a> </div>
</div><div><br></div><div><br></div>