Transcript Slide 1
Donor Assistance Database Dr. Ashot Hovanesian Synergy International Systems, Inc. www.synisys.com 16 April 2005 Manila, Philippines Donor Assistance Database • The Donor Assistance Database (DAD) is an Aid Management and Coordination tool used in national reconstruction environments that strengthens the effectiveness and transparency of aid assistance. • DAD is a powerful, Web-based information collection, tracking, analysis and planning system for use by national governments and the broader assistance community, including multilateral and bilateral donors, international organizations, and non-governmental organizations. The Donor Assistance Database (DAD) has been installed in fifteen countries around the world in close cooperation with the United Nations Development Programme (UNDP). Russia Ukraine Macedonia Georgia Armenia Iraq Guatemala Honduras Sierra Leone Zambia Kazakhstan Uzbekistan Kyrgyzstan Turkmenistan Afghanistan DAD Afghanistan http://www.af./dad/ • Through the financial support of the United States, Italy and the Netherlands, DAD was delivered to the government of Afghanistan in close cooperation with UNDP. • DAD-Afghanistan is owned by the Government of Afghanistan and fully operational in English and Dari. • DAD is recognized as the definitive source of information on international assistance rendered to Afghanistan. • DAD – Afghanistan is the primary tool for the government to track donor contributions, Trust Funds and projects within the National Development Budget. DAD: Tracking effectiveness of aid • Powerful information management tool with a built-in capacity to integrate data on programs funded from different sources: national government, assistance community and NGOs • Facilitates tracking for both ODA and non-ODA, including MDGs and PRSPs DAD Iraq: Partnership with UNDP • Synergy has delivered a web-based system for tracking all economic assistance and reconstruction programs in Iraq. • Training provided to Ministry of Planning and Development Cooperation through UNDP efforts • Automated information management system which is designed to improve efficiency and coordination of donor activities in the country. • Serves as the main database and data collection and reporting system for the donor and NGO community as it ensures effective access to comprehensive aid data. DAD Capabilities • On-Demand Querying: DAD allows the user to view data on requests and ongoing projects organized into lists, reports, charts, and maps. • Analytical Reporting, Charting, GIS: DAD provides the tools for producing a wide range of analytical reports, charts and geographic project information based on flexible search criteria. • Versatile Reporting Options: In DAD the user is able to create, execute, view, edit, and memorize/save ad-hoc queries, print results, and export results into PDF / MS Word / MS Excel format files. • Multi-lingual and Software Localization: DAD is a bilingual application and can be presented either in English and / or in the national language. DAD 5.0 New Technical Enhancements • • • • • • • More intuitive user interface More robust On-line data entry Off-line data entry module to ensure seamless project and aid data entry regardless of the quality of the Internet connection Executive Dashboard Features to easily view and assess analytical results More powerful Reporting capabilities for building, viewing and managing reports Flexible options for exporting reports into PDF, MS Word and MS Excel More interoperable with other financial and data management systems DAD Architecture User Community Internet Intranet LAN Synergy DAD Architecture Portal Data Structure & Presentation Content Publishing M&E, Analytics & Reporting Executive Dashboard Content and Service Management GIS Engine Data Workflow & Collaboration S User & Security Management Data Interoperability Tier External Systems and Data Sources Data Exchange Financial Management Statistical Systems Internet Intranet LAN Data Exchange Donor Databases Other Systems Requests Ongoing Projects Follow Up DAD helps in tracking, analyses and reporting on: • • • Requests for Funding: project requests pending approval / authorization and appropriate financing, which are still in the pipeline. Ongoing Projects: approved projects under implementation with allocated budgets. Follow Up: tracking and monitoring of actual disbursements / expenditures, progress reports, volume of the work completed, and project outcomes. Note: When a particular project is approved and the corresponding financing is made available, the status of the project changes from “request” to “ongoing”, and the system automatically moves the particular project from Requests to the Ongoing Projects section. Project Authorization • The Government / Donors will review submitted project requests within the scope of national programs, and approve, reject, or request further clarifications. Analysis Screen In the Analysis Screen of the DAD application, the user can create and execute ad-hoc queries on requests and ongoing projects data, and acquire results in the form of a list, a report, a chart, or a map. Analysis Screen: List The query results can be presented in a form of a list. • A list consists of at least one group and one column, but the actual quantity of groups and columns is defined by user’s choice of the view. • It is possible to modify currently displayed list. The user can add new groupings to it or remove the selected ones, (un-) select columns, re-order them, etc. Example: Modified View Analysis Screen: Chart The system provides for the opportunity to present data in the form of different charts. To create a chart report, user should define: • Category • Series • Value • Chart Type Example Chart Report User has selected: “Governorate” as a chart Category, “No. of Requests” as a value to be shown on the map and 3D –pie as a chart type. Scaling Map Category-based Map Analysis Screen: Report • The system gives an opportunity for visual representation of the data in the form of different reports. • The system is incorporated with a built-in Report Designer which allows for straight-forward report generation. Example: List Report User has indicated: “Donor Assistance by Sectors” as a Report Title, “Donor”, “Assistance Form”, and “Sector” as a Row Groupings, and “Donor Committed”, “Donor Disbursed”, and “Total Project Requested” as Measures. Example: Filtering Results • • The system allows for data filtration to narrow down the information displayed in the reports. The picture presents the results of applying Filtering by Location. Details Subsection In the Details Sub-section the user can view more detailed information about the Project / Chart Constituents / Map Categories. The following functions are supported: • Browsing among List Items • Printing the List Item Details • Exporting the List Item Details • Adding a New Project • Editing an Existing Project • Deleting an Existing Project Online and Offline Data Entry The Donor Assistance Database (DAD) application contains a built- in on-line Data Entry subsystem (DE), which allows for entering new and modifying the existing information. Depending on the user’s choice, data can be entered related to either of the following: • Requests – These are the projects identified by the local ministries and ready for implementation as soon as the appropriate funds are made available. • Ongoing Projects – These are the projects that are currently being implemented. Data Entry: General Info General Info Section for Ongoing Projects consists of the following fields: • Project Code • Program • Project Title • Form Assistance • Channel Assistance • Recipient • Start / End Date • Description • Total Project Requested • Requested Currency • Req Currency Rate • Requested Date • Total Project Committed • Total Project Disbursed • CF Future • Sector • Location • Implementing Organization Data Entry: Additional Info Additional Info Section for Ongoing Projects consists of the following fields: • Status • Percent Complete • Work Processing • Contact • Comment • Created Date • Verified with Country • Record Created by • Updated Date • Last Updated by Note: User can add Contact information by clicking Add button at the bottom of the Contact section, and edit existing Contact by clicking on a particular Contact name. Offline Data Entry DAD Server Internet / Intranet / LAN Project List Check Out Check In Edit Save Predefined Reports: View / Edit • In the Reports screen, the user can view the pre-defined reports stored in the system. In order to view a report, the user must click on the report’s name in the main reports’ table in the Reports screen. • Clicking on the Edit button in the top toolbar above the report screen directs the user to the appropriate sub-section of the Analysis section where the report data will be displayed in the design mode. Executive Dashboard Executive Dashboard features are now available: • Single point of entry into entire database for an executive overview • Analytical results such as reports, charts or maps are automatically updated and presented to the user DAD: Next Generation DAD: A Development Policy Instrument • Institutionalize Transparency and Accountability through Web-based DAD • Foster Enduring Partnerships between Stakeholders • Focus on Performance and Results • Maximize Aid Effectiveness and Program Harmonization among donors DAD: Building National Capacity • Every implementation of DAD has been customized to country-specific requirements • Synergy International Systems, Inc. provides comprehensive training to build a sustainable national capacity • Complete technical support provided to ensure the maximum effectiveness of the DAD Donor Assistance Database Thank You!