Friday, April 03, 2015

Performance Management Information System Development Project

I want to document my efforts to develop our performance management information system (my second attempt, after using Google Fusion). As my attempt to outsource the project does not seem to yield fruits (because student developers are not familiar with the performance demands of our organization), I have to do this on my own.

While I previously wanted to develop a web-based, database-driven, enterprise-wide information system, that plan probably won't happen. For this year, my target is to develop an inter-related database process that will mimic that enterprise-wide, web-based information system.

I will use, with much hesitation and fear of regret, Microsoft Access 2013 (the software used in the office). But for development, I will use LibreOffice Base. I hope that everything that Base can do can be replicated in Access.

My plan for this project:

Phase I - Requirements and Process Analysis (Target: End-April 2015; Weight: 25%)
  1. Software purpose 
    • Baseline 
    • Intended Outcome
  2. Stakeholder requirements identified
  3. Processes (including business rules) identified
Phase II - Database Development (Target: End-June 2015; Weight: 40%)
  1. Entity relationship model 
  2. Database logical and physical design 
  3. LibreOffice Base prototype
    • Database back-end
    • Version per user-type
    • Reports
Phase III - Implementation Conversion (Target: End-July 2015; Weight: 25%)
  1. Microsoft Access 2013 version
  2. FMPS-level testing
  3. System marketing, to include feedback management
    • End-user offices and staff
    • Process-owner offices and staff (i.e., FMPS, HRDMS)
    • Management offices and staff (PMT)
Phase IV - Cascading and Maintenance (Target: August 2015; Weight 10%)
  1. Software installed in all offices that indicated interest
  2. Feedback continuously gathered for improvement
Resources: All open source software:
  • ProjectLibre - For project monitoring (even if this is a self-monitored project, I have to monitor my progress against my targets, for reporting to my supervisors)
  • LibreOffice - For the database development (Base) and project documentation (Writer)
  • FreeMind - For various concept and role-mapping tasks
  • Dia - for database design