IT Company or Team of Consultants to Design Market Resource Guide Tender, Lebanon - 26913934

Procurement Summary

Country : Lebanon

Summary : IT Company or Team of Consultants to Design Market Resource Guide

Deadline : 25 Sep 2018

Other Information

Notice Type : Tender

TOT Ref.No.: 26913934

Document Ref. No. :

Competition : ICB

Financier : Other Funding Agencies

Purchaser Ownership : -

Tender Value : Refer Document

Purchaser's Detail

Purchaser : CONCERN WORLDWIDE
Concern office in Halba, HDYS Building (Opposite Abdel Karim Rifai Petrol Station), Halba, Akkar
Lebanon
Email :lebanon.consultancy@concern.net

Tender Details

Tenders are invited for IT Company or Team of Consultants to Design Market Resource Guide.

The ARC programme implemented by Concern Worldwide in Akkar and T-5 as part of Alliance 2015 consortium of 4 NGOs in Lebanon needs to design market resource guide based on the data collected from 61 municipalities under the catchment of 5 Social Development Centres (SDCs); Bebnine, Meshmesh, Bakhoun, Meryata and Qalamoun

WORK SCOPE AND KEY DELIVERABLE

The ARC programme implemented by Concern Worldwide in Akkar and T-5 as part of Alliance 2015 consortium of 4 NGOs in Lebanon needs to design market resource guide based on the data collected from 61 municipalities under the catchment of 5 Social Development Centres (SDCs); Bebnine, Meshmesh, Bakhoun, Meryata and Qalamoun. Under the project Concern along with other partners has committed to Job placement, skill matching, apprenticeship and connecting beneficiary with correct employer as one of the major outcome among the others. Concern with the help of surveyors collected following data;

1- Coordinates of markets in each of 61 municipalities

2- Consumer Survey

3- MSME survey

Hence Concern intends to recruit a MIS Freelancer consultant with software architect background, ability to think creatively and out of box, previous experience with designing interactive user-friendly interface to interact with data, designing real maps, date projection and excellent English and Arabic writing abilities to deliver

- Market maps of each municipality with all the coordinates collected by the surveyors. Maps should have single-out and consolidated interphase to zoom in and out of each municipality up to the governorate level.

- Statistical data analysis projection for each municipality or cluster of municipalities based on the data collected.

- Printed MRG in an agreed upon template holding names and addresses of key business, product, skills and services gaps in the catchment of each SDC, most popular and least popular businesses



Problem Analysis: The MRG is to assist users like SDC directors, National Employment Centres, job seeker and anticipating entrepreneur to look up potential employers, skills most in demand in specific market, product gaps and available services. The key challenge of the MRG is to become a user-friendly system that can be used by Concern (open access) and important stakeholders (restricted access to easily obtain needed information.



Objective(s)

Web-based MRG:

- To develop an online platform with offline data entry access where Concern can feed in and update relevant market data data to ensure harmonized and up-to-date information on markets.

- Concern should be able to download pre-set excel sheets for offline data entry which can be uploaded with automatic data extraction facility.

- External stakeholders should be able to zoom in and out of the maps, view graphs and charts for different catchments areas respective of sectors i.e. product gaps for dairy, skill gaps in construction, quality gap for fresh products etc.

Paper-based MRG for printing:

- Printed Market Resource Guide in agreed upon template (maximum 35 pages long both side).

- Graphic designing and data analysis for the presentation

- Desk research for missing information to pull information from other resources

Identification of Data Gaps:

- Consultant will identify the data gaps and will coordinate with marketing officer to help her collect missing data.

- S/he will design standard template and structure for data cleaning, review, update and consolidation.

1. Specific Tasks and Responsibilities:

The specific responsibilities of MIS freelancer/consultant (s) are given below:





1. The application is developed in following:

Ø Database SQL Server 2012

Ø Programming Language C#, JavaScript

Ø Web Framework ASP.Net 4.0

2. Debugging of MIS functioning to ensure its efficient operations;

3. Support in MIS hosting on unique internal IT systems of Concern

4. Technical capacity building of select Concern staff and stakeholders on MIS upgradation (C#,

databases, ASP.net etc.

5. Support in software testing, debugging, data editing/cleaning as per requirements;

6. Any other tasks may ask by Concern regarding MIS features, designs and outputs till full satisfaction of the required deliverable.

The main tasks related to maintaining MIS application are:

• Comprehensively understand MRG to develop logical flow, database structure, administration module and other essential elements in the web-based application;

• Modify and edit application from time to time as requested by Concern based on experiential learning after lunch of application.

• Identify flow blockades, user interface issues, networking problem and security concerns. Resolve and rectify these identified items over time;

• Provide server support smooth running of application.

• Provide support in online hosting, access and user interface of external stakeholders.

2. General tasks and responsibilities.

Documents

 Tender Notice