EIS Progress Report

1
EIS Progress Report

• Steering Committee Meeting
• December 3, 2008

2
Major Milestones AchievedSeptember - October 2008
Planned milestones Results
Acquisition of EIS hardware Board approved the purchase 7/7/2008. ? Purchase Order issued 7/31/2008. ? Equipment arrived the week of 9/15/2008. ?
Acquisition of EIS implementation services Completed the selection process 6/4/2008. ? Submitted for Board approval 9/8/2008?
Hardware and software installed Technical Architecture Document 9/15/08 ? Banner Pre-install validation 9/22/08? Banner Seed Install 9/29/08 ? System status verified by SunGard 10/26/08 ?
3
Major Milestones AchievedNovember 2008
Planned Milestones Results
Identity Management planning Single sign on study and recommendation 11/5/08. ? Deployment strategy 11/5/08. ?
Luminis Portal platform install Portal hardware operational 11/7/08. ?
Finance Business Process Analysis Business process analysis of the old and new 11/11/08. ? Change strategy recommendation 11/11/08. ?
HR Training Kick Off Training of HR users on Banner system. 11/11/08. ?
Luminis Parallel Deployment Fault tolerant architecture installed 11/14/08?
Luminis Content Planning session Town Hall Meeting (Foothill / De Anza) Deployment recommendation of Luminis portal content 11/18/08?
4
Major Events AheadDecember 2008
Planned activities Dates Expected results
Student Business process Analysis 12/1/08 Business process analysis between the old and new Change strategy recommendation
Finance Technical training 12/1/08 ETS internal technical team training Maintenance of Finance module
HR Training 12/8/08 HR Foundation basic training Employment administration
Financial Aid Business Process Analysis 12/8/08 Business process analysis between the old and new Change recommendation
Report Strategy ODS (Operational Data Store) planning call 12/15/08 Planning the installation of ODS reporting environment in January 2009 Introduction to team leads of ODS
Purchasing training 12/15/08 Purchasing training on Banner purchasing module
Oracle training 12/15/08 ETS technical team training
Disaster Recovery RFP 12/16/2008 11/11 Invitation to Bid release 12/16 Bid response deadline
5
Major Events AheadJanuary 2009
Planned activities Dates Expected results
Oracle training 1/12/09 Oracle database access language training ETS technical team Acquire capability to write query language
Student Implementation Planning 1/19/09 Student module implementation planning Project team task layout and planning
Luminis Data Integration 1/19/09 Lumins core Banner module data integration
HR training 1/26/09 Benefits, deductions, tax administration training Understanding of functionalities of Banner HR module
Luminis Organizational Planning 1/26/09 Luminis deployment role and task assignments Roll out task plan for Luminis module
Data Warehouse installation TBD Installation of Banner ODS and Enterprise Data Warehouse.
Disaster Recovery Board agenda 1/20/09 Outcome of the selection of DR RFP
6
Project Progression Chart
7
Project budgetCurrent budget vs expenditure as
of 11/30/2008
Project Item Budget amount Expenditure Balance
Banner/Oracle Implementation 3 years 6.6M 6.3M 0.3M
EIS Hardware 1.0M 1.1M -0.1M
Backfill 1.7M 0 1.7M
Start up cost year 2/3 1.3M 0 1.3M
Project Contingency 1.2M 0 1.2M
Total 11.8M 7.4M 4.4M
8
SunGard project implementation hoursAs of
11/30/2008
Task Hours used Hours planned of total completed
Project Management 822.5 920 / 4,400 89 / 18.6
Review and validate proposed environment 80.0 80.0 100.0
Banner Installation 179.0 189.0 95.0
HR consulting 92.5 1,036.0 8.0
Finance consulting 36.0 1,045.0 3.5
Luminis 231.0 740.0 31.0
Business Process Analysis 294.5 640.0 45.0
Other tasks 492.0 9,478.0 5.1
Total hours 2,227.5 17,608.0 12.7
Implementation consulting hours for 3 years based
on Sungard RFP 1152 proposed hours 1st year
allocated hours / three years total hours
9
Questions