Duration: 10 months (June 1, 2025 - March 31, 2026) | Consultant: Data Management Type A
BackProject: PXD Yangon
Partners: IOM Myanmar, Eden Myanmar, local governmental and non-governmental partners
Key Systems: MiMOSA, Power BI, VOT/PxD Database, Incidents Database, KoBoToolbox
Reporting: Monthly reports with analytical products, dashboards, and data analysis reports (minimum 3 analytical reports)
| # | Task | Technical Requirements | Task Description | Expected Outcome | Report/Deliverable | Start Date | End Date | Progress |
|---|---|---|---|---|---|---|---|---|
| PHASE 1: SETUP & ASSESSMENT (Jun-Jul 2025) | ||||||||
| 1 | Initial Data Landscape Assessment | Database management, data mapping tools, MiMOSA access | Conduct comprehensive assessment of existing data systems, identify data gaps, map current data flows, and evaluate data quality in MiMOSA and VOT databases | Complete data landscape map with identified gaps and improvement areas | Data Assessment Report | Jun 1, 2025 | Jun 30, 2025 | |
| 2 | Coordinate data collection framework setup | Database management, data encoding tools, KoBoToolbox/ODK | Establish structured data collection processes, implement encoding standards, set up data storage protocols, and create data processing workflows for TIP-related information | Operational data collection framework with standardized processes | Data Collection Framework Documentation | Jun 1, 2025 | Jul 31, 2025 | |
| 3 | Review and update VOT database structure | MiMOSA, database design, current screening forms | Review CO VOT database alignment with current screening forms, update database structure to meet research and analytical reporting needs | Updated VOT database aligned with current forms and analytical requirements | Database Update Report | Jun 1, 2025 | Jul 31, 2025 | |
| PHASE 2: SYSTEM DEVELOPMENT & TRAINING (Jul-Sep 2025) | ||||||||
| 4 | Design and build interactive dashboards | Power BI, SQL, data visualization tools, KPI frameworks | Create user-friendly dashboards and dynamic reporting tools displaying TIP trends, patterns, and key performance indicators using Power BI and other visualization platforms | Operational dashboard with regular updates and visualization outputs for TIP trends | Dashboard Implementation Guide | Jul 1, 2025 | Sep 30, 2025 | |
| 5 | Develop SOPs for information management | SOP drafting, training materials, IOM standards compliance | Create and revise internal Standard Operating Procedures for data collection, processing, security protocols, and information management workflows | Comprehensive SOPs ensuring standardized data handling practices across all stakeholders | Information Management SOPs | Jul 1, 2025 | Aug 31, 2025 | |
| 6 | Conduct capacity-building training | Training facilitation, KoBoToolbox/ODK, data quality frameworks | Deliver comprehensive training to local partners and staff on standardized tools, data collection methodologies, quality assurance protocols, and dashboard usage | Enhanced partner capacity for reliable, high-quality TIP data collection and management | Training Completion and Evaluation Report | Aug 1, 2025 | Sep 30, 2025 | |
| PHASE 3: DATA MANAGEMENT & ANALYSIS (Aug 2025 - Jan 2026) | ||||||||
| 7 | Maintain and manage VOT database | MiMOSA, secure data systems, data protection protocols | Ensure secure data entry, management, and protection of VOT/AVR beneficiary data including demographic/biographic information, case tracking, and document management per IOM standards | Accurate, up-to-date, and secure VOT dataset with proper case tracking capabilities | Monthly Data Status Reports | Aug 1, 2025 | Mar 31, 2026 | |