The Caribbean Community and Common Market (CARICOM) has been approved as the Principal Recipient of the PANCAP R9 Round Global Fund Grant. Both the Centre for Integrated Training and Research (COIN) and the Caribbean Vulnerable Communities Coalition (CVC) have been instrumental in elaborating the Most at Risk Populations component of the PANCAP Global Fund proposal. COIN has been nominated as the Sub-Recipient for this component of the grant representing approximately a third of the total funds (excluding those used by the PR). COIN will lead an umbrella sub-grant covering Caribbean Vulnerable Communities Coalition (CVC) and the local implementing partners, as well as the International Federation of Red Cross and Red Crescent Societies (IFRC) and the Caribbean Family Planning Association (CFPA).
The vulnerable groups component of the GF grant sets out to develop model outreach programs to reach key vulnerable groups, targeting MSM, local and migrant SW, prison inmates, drug users, and marginalized youth through four population-based projects. E ach of these projects has an operational research component to assist the project establish a project baseline, collect critical data to fill-in knowledge gaps to facilitate evidence-based programming, and to gauge project progress and impact throughout implementation.
The M&E System for the Vulnerable Groups Component of the PANCAP R9 GF Project has adopted a results-oriented, web-based approach which monitors, evaluates, reviews and reports on the outcomes and impacts of the strategic goals and objectives of the project via key strategic priorities. The region-wide M&E System, reports against the progress of the programs and projects as specified in the work-plan and objectives of the Vulnerable Groups Component of the PANCAP GF Project. The M&E System is structured around various components namely the Indicator Framework of the R9 PANCAP GF Project and the COIN/CVC specific M&E elements, mechanisms and tools as well as the established reporting cycle.
The main objectives of the M&E system of the Vulnerable Groups Component of the PANCAP R9 GF Project is to monitor, evaluate, review and report on the strategic goals and objectives of the 5 year Vulnerable Groups Component of the PANCAP R9 GF Project using indicators as the key instrument of measurement. Aspects of the M&E system of the Vulnerable Groups Component of the PANCAP R9 GF Project include but are not limited to:
• Indicators: impact, outcome, output and inputs.
• Data sources: program monitoring, financial monitoring, institutional data, behavioral surveillance data, base line studies, essential research data and other studies.
• Information products: quarterly monitoring reports, financial management reports, procurement reports, audit reports and annual M&E reports.
An electronic, web enabled, region-wide M&E system is required to effectively assist with managing, collecting data and reporting on the Monitoring and Evaluation activities of the Vulnerable Groups Component of the PANCAP R9 GF Project. The planned system is to enable a seamless flow of information and data between various sources in at least three countries in the Caribbean, Jamaica, Trinidad Tobago, and the Dominican Republic.
The M&E system will draw information from a range of sources and present this in user-friendly and accessible formats tailored to the needs of different users such as the project management hubs, the administrative sub-units, the local implementing NGOs, etc. The system should make use of a web-based system onto which these different entities will be expected to post or submit their information or reports. The system should make it easier for project management staff to have a snapshot view of the progress and problem areas as per the approved work plan and budget.
COIN/CVC requires a consultant who can execute specific tasks as a Web & Database Programmer in order for the project to complete work that it has already started on the web-based M&E platform and database system.
General scope of the job
The consultant selected as the Web & Database Programmer will work jointly with the project’s M&E unit to develop the web-based system and all its components, assist in the piloting and refinement of the system, and after the system is fully operational, perform regular maintenance and refinements to the system.
Organizational relationships
The Web Database Programmer will be answerable to the M&E Officer, with the majority of his/her tasks to be undertaken in collaboration with the M&E team. The M&E consultant is expected to coordinate his/her efforts with two M&E assistants but will not be directly supervised by them nor have supervisory responsibility over them.
General Tasks to be performed
• Develop relational MS SQL Server database with tables based on the project’s data collection tools.
• Program a web-based application that applies the necessary validations and security procedures.
• Program specific queries, project specific reports, and summarized reports.
• Pilot test and refine the system.
• Develop detailed user’s manual.
• Develop detailed developer’s guide.
• Provide periodic maintenance and enhancements to system.
Please click here to see Addendum 1: Specific Tasks to be Performed – Web and Database Consultant, for a more detailed description of the tasks to be completed.
Duration and Timing
The timeline for the completion of this work is 1 month, beginning from the date of consultant contract is signed. The 1 month timeline covers all tasks, pilot testing, and post pilot refinements to the system.
A separate contract will be negotiated for periodic maintenance and enhancements to the system after it is fully operational.
Qualifications and Experience Required
The consultant must have the following skills, experience and qualifications:
Skills
• Demonstrate ability to effectively communicate by phone/email/IM or in person
• Show initiative and work independently and/or with team members to resolve problems
• Demonstrate ability to manage multiple priorities and follow through on projects to completion
• Ability to work within a team-based environment, with strong sense of urgency.
• English & Spanish speaking and writing ability is an additional and welcomed asset
Experience
• Development of complex web applications using ASP.Net / MVC, .Net 3.0 framework and above
• Programming under MS Visual Studio 2010 and C# language
• Design of web-based queries and reports using Crystal Reports
• SQL Server 2008 database design, management and operation
Education
• BS in Computer Science or 2 years of equivalent background experience
Deadline for Submissions
Interested applicants are asked to read the information presented above carefully before applying. Applicants must submit a consultancy proposal along with a CV that clearly identifies their qualifications. Applicants should also submit a listing of web-based database projects they have been involved with as a programmer.
The aforementioned documents should be e-mailed to:
coin.cvc.human.resources@gmail.com
The deadline for receiving consultant applications is 23 February, 2012.