Monthly Status Report
Project Name: Student Direct Deposit Reporting Period: June 23rd, 2009
Project Manager: William O’Brien Est. Proj. End Date: Jun. 20th, 2009
Project Sponsor: Laura King DELAYED
Project Owner: Tim Stoddard
ITS Manager: Mark Malecek Rev. Proj. End Date: October 15th, 2009
Project Description:
This project will develop:
Web-based delivery of student payment and deposit advice.
Student self-service functionality for direct deposit sign-up and maintenance
Administrative portion of direct deposit sign-up and maintenance.
Executive Summary
Description
Status Reason for Deviation
Green (Controlled)
Yellow (Caution)
Red (Critical)
Schedule remains dependent on
Schedule Project was officially started on October 21, 2008.
data security issues
Schedule has been continually adjusted
(lengthened). ITS has completed a pre-
Application pilot has been delayed deployment security assessment
(draft report was delivered to the
project team on May 14, 2009).
Project team proposed interim
and long-term project deliverables
and deployment strategy
See attached Timeline
Scope Original project scope was expanded to include
student sign-up for direct deposit.
User group requested tighter integration with the
existing “Bills and Payment” functions.
Revised deployment strategy scales back
interim project deliverables
Budget Project budget supplement approved by EIC in
February. Project expected to complete at
revised budget.
Supplemental funds provided by IT
management for continued project development
and deployment (interim and long-term)
Comments:
Project creates a platform for additional student facing on-line applications (1098-T & Student W-2 forms).
07/31/2009 Page 1 of 5
Monthly Status Report Minnesota State Colleges and Universities
For Future Consideration: IT Architecture group is requesting development of a common framework and
consolidation between the student financial applications, possibly resulting in a single deployable student-
financial web application.
New/Updated Issues
Issues Status (New, Mitigation Plan
Newly Completed)
The PM and the ITS development supervisor
involved with the project formally requested
the ITS Technology Integration & Design
There is a need to encrypt student bank group for a system-wide data encryption
account information as it will now be Newly Completed solution.
accessed via a web application.
This issue has grown into a broader issue of
data and application security (see next
issue)
ITS has performed a pre-deployment
security assessment of the Student Direct
Deposit web application. The draft report
was delivered to the project team on May
ITS has raised security concerns about 14, 2009
current and proposed front- and back-end
New The project team developed deployment
processes involving student bank account
strategies to propose to project owner and
information.
ITS Security
Interim and long-term project deliverables
and deployment strategy were established
for the project
ITS has raised additional concerns about All future project deliverables are AT
data encryption key management (a process RISK until ITS DBA/Security resolves the
and standards for “wallet” maintenance) data encryption management issue.
Milestones / Deliverables
Status (On
Estimated Actual
Schedule,
Milestones/Deliverables Completion Completion
Complete, At
Date Date
Risk)
ITS Deploy Transparent Data Encryption (TDE) to NEW:
Complete
Development Environment June 24
ITS Deploy Transparent Data Encryption (TDE) to Tentative:
At Risk
QA/Test Environment July 31
Tentative:
Re-Test Student Direct Deposit (Interim Deployment
Aug 3 - At Risk
Deliverables) in Test Environment with TDE
Aug 14
07/31/2009 Page 2 of 5
Monthly Status Report Minnesota State Colleges and Universities
Tentative:
QA Approval/Sign-Off At Risk
Aug 18
Tentative:
Deploy Application for User Pilot At Risk
Aug 20
Delivered web functionality:
Web-based delivery of student payment and
deposit advice, student and administrative facing
(interim deployment).
Tentative:
Student self-service functionality for direct At Risk
Aug 20
deposit sign-up and maintenance (delayed –
long-term deployment)
Administrative portion of direct deposit sign-up
and maintenance.
Appropriate documentation and training materials
to support the new functionality (interim Tentative:
Pilot of deployment) Deposit web functionality
Student Direct Aug 20 - At Risk
Sept 17
Tentative:
System-wide roll-out
Sept 24 At Risk
Tentative:
Post-Roll-Out Maintenance Support Sept 24 – At Risk
Oct 15
Tentative:
Project Completion Date At Risk
Oct 15
07/31/2009 Page 3 of 5
Monthly Status Report Minnesota State Colleges and Universities
Project Assumptions and Dependencies
Assumptions No significant assumptions were identified for this project – the technology
is well established. (assumption was weak concerning encryption of
student bank account information accessed via a web application)
Dependencies Maximum benefits are dependent upon and constrained by system’s
ability to require or otherwise significantly increase student
participation in direct deposit and use of electronic payment and
deposit advice. (no impact on project deployment)
Project roll-out is dependent on Rdb to Oracle migration project
(expected to be completed by February 2008). Oracle migration
successfully completed in early March: Student Direct Deposit web
application pilot, roll-out and completion date have been delayed by a
few weeks respectively.
NEW: ITS DBA/Security resolving the Data Encryption Key Management
th
issue prior to July 6 , 2009 is critical to project completion.
NEW: ITS DBA/Security deploying Transparent Data Encryption (TDE) to
st
the QA/Test environment by July 31 , 2009 is critical to meet the
revised/tentative project schedule.
07/31/2009 Page 4 of 5
Monthly Status Report Minnesota State Colleges and Universities
Student Direct Deposit
Project Time-Line
3/26/09 4/10/09 6/1/09
6/19/09 7/31/09 8/20/09 10/14/09
User Feedback Deadline to Planned
Planned Tentative Tentative Tentative Owner
Session #2 Submit Code 5/5/09 Roll-out
Project ITS Deploys Deployment Acceptance of
for QA Review QA Signoff Completion TDE to For Student DD
DELAYED 6/15/09
DELAYED DELAYED Date QA Site Pilot Application
Planned Owner
5/20/09 DELAYED DELAYED 9/24/09 10/15/09
3/24/09 4/6/09 Acceptance of
4/29/09 User Meeting #3 Tentative Tentative
QA Approval Quarterly Student DD 8/18/09
Pre-Pilot Late-Pilot Review Application 6/24/09 System-wide Project
for April 6 ISRS Tentative
User Sign-Off (ITV) ITS Deploys Rollout Completion
ISRS Release Release DELAYED QA Signoff
(WebEx) DELAYED TDE to Date
DELAYED Dev Site
4/1/09 5/1/09 6/1/09 7/1/09 8/1/09 9/1/09 10/1/09
3/15/2009 10/15/2009
3/23/09 - 4/10/09 4/20/09 - 5/1/09 6/1/09 - 6/19/09
Development QA Final Planned
Iteration #10 Regression Maintenance
Test Web/ Support
Uniface/COBOL DELAYED
DELAYED
4/6/09 - 4/17/09 5/7/09 - 5/29/09 8/3/09 - 8/14/09 8/20/09 - 9/18/09 9/24/09 - 10/15/09
QA Testing Planned Tentative Tentative Tentative
Web/ Pilot Re-Test Pilot Maintenance
Uniface/COBOL Application Support
DELAYED
DELAYED In TDE
Environment
Note that QA is integrated in application development iterations. Page 1
07/31/2009 Page 5 of 5
Monthly Status Report Minnesota State Colleges and Universities