Architect and developed a complete cloud based solution to manage Beneficiaries, Groups, Project Activities, Budget, Outcomes, Market information and Input functionalities real-time and off-line.
MIS Key System Features and Innovations
Digital Data Collection Tools: All activity and output tracking tools will be standardized and digitalized using latest mobile data collection software (Kobotoolbox, ODK, Memento). All staff will be able to access and collect data through tablets or smartphones. Data will automatically synchronize with a project database via cloud-based storage.
Cloud-Based for Real Time, Effective Decision Making: System can be installed in multiple computers in multiple locations and will connect to the cloud storage and automatically synchronize available data. This means that the latest information regarding project implementation is readily available, organized and summarized for project stakeholders in different locations, allowing staff to understand project dynamics and performance and make decisions to improve programming.
Off-line Storage & Analysis Platforms: For staff with no access to regular Wi-Fi, coded data can be sent via SMS to a smartphone located within the project office and then uploaded to the cloud storage. Due to slow and limited connectivity in rural areas, the system can be designed to be mainly offline. Data is captured, stored, organized and analyzed offline. Internet connectivity is required to transfer and synchronize data and codes only, which requires very little bandwidth.
Automated Reporting: I can pre-program charts and tables in our system which greatly improves accessibility and timely decision-making. With a click of a button, raw data stored in the database is automatically analyzed and summary reports generated and displayed in an interface, allowing for project staff to have real-time comprehensive information on the status of their project. The data displayed can compare baseline, current status and targets, show trends over time, highlight averages and percentage change and disaggregate data by gender.
Management Dashboards: Innovative dashboards for managers will be built into the data system for automatic and real-time analysis of work plan achievements and budget expenditures. These dashboards, can be easily adapted to suit Managers’ specific needs, track day-to day implementation at the activity, output and outcome level, quickly flagging items that are completed, on track and lagging and highlight high or low burn rates by intervention area.
Linked with Geographic Information Systems: If desired, the system can link with GIS, allowing for the mapping and geographic referencing of data. Project interventions can be geo-referenced (i.e. schools) providing added value by enabling managers to effectively plan and coordinate interventions, improve resource allocation and monitor and evaluate activities.
Overall Approach and Principles
Designed MIS aligned to 7 key principles:
Keep it simple: Tailor to client organization’s resources, time frames and abilities.
Build buy-in and ownership: Ensure field staff and female and male beneficiaries have ownership over the data collection and learning process.
Make it useful: Ensure MEL is primarily for learning and improving programming.
High Quality: Ensure data collected is valid, reliable, sex disaggregated and measures gender change.
Improve Coordination and Consistency: Create standard processes and procedures.
Focused on Accountability: Support client’s in assessing the impact of their programs to ensure they are effective, efficient and making a difference.
Inclusive & Participatory: Embrace a range of stakeholder perceptions, encourage joint analysis of lessons, and catalyze learning within organizations, and amongst project beneficiaries.
In order to ensure high quality data, I put into place specific quality control measures, which include:
Establishing clear questionnaire and interview protocols and guidelines;