Monthly Status Report
Project Name: Project Manager: Project Sponsor: Project Owner: ITS Manager: Project Description: Student Direct Deposit William O’Brien Laura King Tim Stoddard Mark Malecek Reporting Period: June 23rd, 2009 Est. Proj. End Date: Jun. 20th, 2009 DELAYED Rev. Proj. End Date: October 15th, 2009
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
Status
Green (Controlled) Yellow (Caution) Red (Critical) Schedule Project was officially started on October 21, 2008. Schedule has been continually adjusted (lengthened). Application pilot has been delayed Schedule remains dependent on data security issues ITS has completed a predeployment 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).
Description
Reason for Deviation
07/31/2009
Monthly Status Report
Page 1 of 5
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 studentfinancial web application.
New/Updated Issues
Issues
Status (New, Newly Completed)
Mitigation Plan
The PM and the ITS development supervisor involved with the project formally requested the ITS Technology Integration & Design group for a system-wide data encryption solution. 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 14, 2009
There is a need to encrypt student bank account information as it will now be accessed via a web application.
Newly Completed
ITS has raised security concerns about current and proposed front- and back-end processes involving student bank account information.
New
The project team developed deployment strategies to propose to project owner and ITS Security Interim and long-term project deliverables and deployment strategy were established for the project
ITS has raised additional concerns about data encryption key management (a process and standards for “wallet” maintenance)
All future project deliverables are AT RISK until ITS DBA/Security resolves the data encryption management issue.
Milestones / Deliverables
Milestones/Deliverables
Estimated Completion Date NEW: June 24 Tentative: July 31 Tentative: Aug 3 Aug 14
Actual Completion Date
Status (On Schedule, Complete, At Risk) Complete
ITS Deploy Transparent Data Encryption (TDE) to Development Environment ITS Deploy Transparent Data Encryption (TDE) to QA/Test Environment Re-Test Student Direct Deposit (Interim Deployment Deliverables) in Test Environment with TDE 07/31/2009
Monthly Status Report
At Risk
At Risk
Page 2 of 5
Minnesota State Colleges and Universities
QA Approval/Sign-Off
Tentative: Aug 18 Tentative: Aug 20
At Risk
Deploy Application for User Pilot Delivered web functionality: Web-based delivery of student payment and deposit advice, student and administrative facing (interim deployment). Student self-service functionality for direct 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 Pilot of deployment) Deposit web functionality Student Direct
At Risk
Tentative: Aug 20
At Risk
Tentative: Aug 20 Sept 17 Tentative: Sept 24 Tentative: Sept 24 – Oct 15 Tentative: Oct 15
At Risk
System-wide roll-out
At Risk
Post-Roll-Out Maintenance Support
At Risk
Project Completion Date
At Risk
07/31/2009
Monthly Status Report
Page 3 of 5
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
Monthly Status Report
Page 4 of 5
Minnesota State Colleges and Universities
Student Direct Deposit Project Time-Line
6/19/09 Planned 5/5/09 Project QA Signoff Completion DELAYED 6/15/09 Date DELAYED DELAYED Planned Owner 5/20/09 DELAYED 3/24/09 4/6/09 Acceptance of 4/29/09 User Meeting #3 QA Approval Quarterly Student DD 6/24/09 Pre-Pilot Late-Pilot Review Application for April 6 ISRS User Sign-Off (ITV) ITS Deploys ISRS Release Release DELAYED (WebEx) TDE to DELAYED DELAYED Dev Site 4/10/09 3/26/09 User Feedback Deadline to Session #2 Submit Code for QA Review 6/1/09 Planned Roll-out 7/31/09 Tentative ITS Deploys TDE to QA Site
DELAYED
8/20/09 Tentative Deployment For Pilot
8/18/09 Tentative QA Signoff
10/14/09 Tentative Owner Acceptance of Student DD Application 9/24/09 10/15/09 Tentative Tentative System-wide Project Rollout Completion Date
4/1/09 3/15/2009 3/23/09 - 4/10/09 Development Iteration #10
5/1/09
6/1/09
7/1/09
8/1/09
9/1/09
10/1/09 10/15/2009
4/20/09 - 5/1/09 QA Final Regression Test Web/ Uniface/COBOL
DELAYED
6/1/09 - 6/19/09 Planned Maintenance Support
DELAYED
4/6/09 - 4/17/09 QA Testing Web/ Uniface/COBOL
DELAYED
5/7/09 - 5/29/09 Planned Pilot
DELAYED
8/3/09 - 8/14/09 Tentative Re-Test Application In TDE Environment
8/20/09 - 9/18/09 Tentative Pilot
9/24/09 - 10/15/09 Tentative Maintenance Support
Note that QA is integrated in application development iterations.
Page 1
07/31/2009
Monthly Status Report
Page 5 of 5
Minnesota State Colleges and Universities