Transcript Intro to PMIS ICT4D Chibuzo Dangana

Integrated Project Management Information
System (PMIS) for Partner Capacity
Strengthening
Dangana Chibuzo (Database Manager)
CRS Nigeria Country Program
18-19th May,2016
Presentation Outline
•
•
•
•
•
•
Project Background
Why PMIS?
Solution
Key Successes
Key Issues/Challenges
Summary
Project Background
•
SMILE is funded by PEPFAR through USAID
•
Catholic Relief Services (CRS) leads the consortium with ActionAid and Westat
•
Goal is to improve the well-being of OVC and caregivers through a sustainable,
comprehensive and coordinated program
•
5 year project (2013 -2018)
•
600,000 OVC and 150, 000 Caregivers
•
To strengthen organizational and technical capacity of State, LGA and Civil society
organizations to manage integrated programs for OVC and their households
Geographical Spread
Why PMIS?
Partners
 42 CSO
 39LGAS
 5
SMWASD
Scope
 Organizational
 Technical
 Finance
Tools
 OCAT
 SRFMT
 Workplan
Assessment Tools
S/N
1
OCAT
2
Experience, knowledge and
skills
Networking and referral
systems
Resource mobilization
Human resource
management
Service delivery
Financial Management
System and Procurement
Gender management system
Knowledge Management
/Monitoring and evaluation
system
3
4
5
6
7
8
9
Governance
SRFMT
Financial
Personnel
Financial Systems
WORKPLAN
Strategic
Objectives
Intermediate
Results
Deliverables
Documentation
& Recordkeeping
Internal Control Outputs
Financial
Reporting
Fixed Assets
Receivables
Procurement
One System
SRFM
Financial
Capacity
Assessment
Partner work
plan
implementation
PMIS
Partner
Capacity
Assessment
(OCA)
ICT4D Solution
• In partnership with Westat and CRS GKIM, we developed a web based
Project Management Information System (PMIS).
• The SMILE PMIS is a Microsoft ASP .NET MVC 5 web application which
uses an SQL Server 2012 database for data storage.
• The Server is hosted on Rack space in Baltimore (CRS HQ).
• The system requires the support of a Server administrator as well as a
Database administrator.
• Microsoft Excel based partner information (OCAT, Annual Workplan,
SRFMT) uploaded to the system.
• It generates custom reports from the assessments.
PMIS Modules
Use Cases:
Use cases are designed to provide a high
level description of users’ expected
interaction with the PMIS system. The use
Case Diagram shows the defined use cases:
Dataflow
Reports
Reports
Reports
Key Successes
• Repository of program information needed to monitor
improvement in partner capacity.
• Program
Managers
effectively
monitor
program
implementation rates in a timely and efficient manner.
• It is acceptable by the users, sustainable and requires minimal
support services.
• We can carry out holistic assessment of partners.
• Solution scaled to other partners.
Key Issues/ Challenges
• Lack of connectivity.
• High degree of precision required for excel data files.
• Unstable power supply.
Summary
• The PMIS was locally built by the CRS Nigeria SMILE team and
Westat following a PROJECT MANAGEMENT NEED.
• It provides a one stop shop for monitoring partner capacity
and workplan implementation.
• The PMIS is a cross-cutting solution, as it can be used across
different sectors.
Any more Questions?
• Chibuzo Dangana
• Database Manager (CRS Nigeria Country
Program)
• [email protected]
FURTHER PROJECT DETAILS
Why PMIS?
The PMIS offers a coordinated approach of managing partner data over time.
The system aids the following on the project:
• Ability to monitor partner capacity and program management score card
• Reporting functionality which collates partner achievements holistically,
graphically over different periods.
• Single platform that manages partner information as relates to program
management, organizational capacity and financial management
– Monitoring the Workplans through real time tracking of program activities.
– Structured approach to tracking changes in partner capacity across several domains (e.g.
Governance, Knowledge Management /M&E system, Human Resource Management,
Service Delivery etc.)
– Tracking the Sub Recipient Financial Monitoring tool (SRFMT) and implementation of the
Institutional Capacity Improvement Plans (ICIP).
ICT4D Solution
• In partnership with Westat (a consortium member on SMILE) and working
with GKIM (Global Knowledge & Information Management), CRS
developed a web based Project Management Information System (PMIS).
• The SMILE PMIS is a Microsoft ASP .NET MVC 5 web application which
uses an SQL Server 2012 database for data storage.
• The Server is hosted on Rack space in Baltimore (CRS HQ).
• It requires two server configurations, the first is an SQL Server 2012 or
later database server and the second is an IIS ASP .NET 4.5 web
application server.
• The system requires the support of a Server administrator as well as a
Database administrator.
• Microsoft Excel based partner information on capacity assessments,
SRFMT’s and the Workplans are uploaded into the PMIS following
scheduled assessments.