Nafa Quick MIS
Client: National Nutrition Agency (NaNA) |
Project Name: Nafa Quick MIS (Kaarange)
Dates: Jun 2020 – Jan 2021
Short Description
Under the Nafa Quick Cash Transfer Project, 2M Corp was hired to build a Management Information System to help NaNA in its cash distribution during the Nafa Quick and the 4 years main Nafa Project. In addition, 2M Corp also helped NaNA clean the NDMA household list gathered from the COVID-19 Relief distribution. This was meant to help speed up the process of identification and estimating the number of households to receive cash transfer per district.
- Beneficiary registration and management
The Beneficiary management module was built with the following capabilities.
- Manual creation of a household
- Bulk importation of beneficiaries using an excel file with the details of the beneficiaries
- Add household members to a household and define which of the members can collect the funds on behalf of the main household head (beneficiary to a program)
- Associate a household to a program
2. Program Management module
The program management component allows the agency to define multiple cash disbursement programs. A program has the following attributes.
- Frequency of payment
- Amount to be disbursed per beneficiary
- Start and closing date of a program; preventing beneficiaries from being added to a program after the closing date
- Program status
3. Payroll Management
Payroll are generated depending on a frequency of a program. The payroll management follows an approval process. The following functionalities are within this module.
- Create a payroll cycle with a start and end date and specifying whether it’s national or regional. A program is also associated to a cycle.
- The ability to generate a payroll for the period specified for a particular program. This creates the payroll records for all the beneficiaries associated to that program within the start and end date specified.
- Review and approval of the payroll
- Exporting the payroll with a read-only option to key columns in excel to be given to the payment service provider.
- Import Payment Service Provider updated payroll file for reconciliation
4. Reporting
- Like windows crystal reports, windows report viewer technology was used in creating reports. All reports have the functionality to group by and be able to export data to PDF, EXCEL and WORD.
Programing languages: C#, ASP.NET, VB.NET, JavaScript, TSQL Programming
Database: Microsoft SQL Server
API Based: Yes
Reporting Server: Microsoft SQL Server Reporting Services, SQL Server mobile reporting