Web Database Developer at AIDS Healthcare Foundation (AHF)

Purpose

To support monitoring, Global HMIS maintains robust cloud-based M&E databases that are accessible to all AHF-supported countries and facilities. The main purpose of the consultancy is to develop/review the user-friendly (both on the front and back end) design, layout, and structure based on the current web-based data entry interfaces/modules. The consultant will also improve on the current data visualization and generation of reports as per the needs of AHF.

Deliverables

The consultant will work closely with Global HMIS managers and assist in developing a user-friendly web portal for all AHF Global Quality reporting requirements translated in different languages with varying levels of access by facility, country, bureau, and global teams. The expected system must be developed in a way that will support all AHF M&E data tasks undertaken by the users. It should also allow necessary data entry or importing of data from Microsoft Excel and should work both offline and online.

Some of the expected features/modules include:

1. Data entry and notifications system
2. Export in various formats
3. Reporting – geographical view (regional and global), reports, graphs, and ad-hoc custom reporting capability
4. Role-based user dashboards that cumulate data, for easy-to-use data visualization and highlighting programs and tasks that require attention; and

The improved AHF Global M&E system should also:

1. Have web-based front end data entry tools using appropriate and efficient web technologies as well as web-based querying tools for data retrieval
2. Have relevant import/export capabilities to pre-designed templates or databases
3. Display summary pages showing data from all available sources, aggregate statistics, and summary visuals which illuminate areas that need attention
4. Present summary dashboards showing progress towards facility/country/bureau level objectives as well as global progress
5. Provide a database administration module, allowing for advanced user management, with a staggered set of privileges for different users as well as user authorization, tracking/authorizing changes to results hierarchy, database download, online backup, and other necessary features; and
6. Allow for Integration with a Knowledge Management platform (yet to be developed)

Time Frame

The assignment is for 60 full-time working days from the date the contract is signed. The consultant will be required to work closely with the Global HMIS Manager at AHF Plaza Parklands for the entire period.

Required skills and experience

Educational Qualifications:

Interested consultants should hold:

· Bachelor’s degree (minimum) in Computer Science/ Engineering, Electrical Engineering, Applied Physics or relevant subject from a reputed university.

Experience:

Interested consultants should have:

• Extensive working knowledge of coding using .NET languages (C+, VB, NET)
• Familiarity with ASP.NET framework and SQL servers
• Familiarity with architecture styles/APIs (REST, RPC)
• Experience in JavaScript, HTML5, CSS3, or responsive web would all be beneficial
• At least seven years experience in developing IT solutions and providing IT support and maintenance services
• Proven professional experience in developing and managing databases within the non-profit sector
• Proven professional experience in web technologies, including their development and deployment, and development of web-based information systems
• Good understanding of development results and Results-Based Management Concepts