Project ORION Executive Summary

November 26, 1997

Background

The University of Louisville has defined excellence as its goal; however, the current capabilities of the Student Administration and Human Resources systems and business processes can't efficiently provide the functionality required to support the University's long term goals.

The existing systems have become costly to maintain and lack flexibility to keep up with the changing requirements and business processes; furthermore, the majority of these systems are not Year 2000 compliant.

Recognizing these factors, the university conducted a software evaluation and selected PeopleSoft as a replacement for the Human Resources and Student Administration systems. Cambridge Technology Partners was selected as the integration partner to assist with the implementation of the system and the re-design of these processes.

^

The Scoping Process

A joint U of L/CTP team conducted a four week scoping analysis to assess the Human Resources / Student Administration processes across the following dimensions:

Process Flow Analysis - high-level work flows that illustrate the operations of the Human Resources, and Student Administration business processes.

Functionality Analysis - A map of the business processes to their associated functions; includes lower level detail to identify required functionality.

Benefits Analysis - For each function identified benefits as High, Medium, or Low.

Package Functionality Assessment - Degree of fit between functionality required and PeopleSoft capabilities.

Implementation Strategy - An overall implementation strategy: phasing, prototyping workplans, prototyping calendars, and support infrastructure.

Strategic Context

The following project strategic drivers were identified which support the long term goals and strategies of the university.

Strategic Allocation of Resources

People must be relieved of the clerical drudgery imbedded in the current systems and processes and be allowed to focus on high impact, pro-active tasks that will move the university towards its strategic goals.

Service Excellence

By providing a technical basis for process re-engineering, Project ORION must allow the university to provide previously unavailable levels of service.

The Right Information, Available To The Right People, At The Right Time

Accurate information must be made accessible to decision makers in the right format and on a timely basis to allow them to monitor, control, and respond to the effectiveness of their programs.

Critical Success Factors

  • Executive commitment to the foundation and enrichment process
  • Timely decision making
  • Well-defined scope and objectives
  • Retention of key personnel
  • Successful campus-wide training program
  • Availability of functional and technical staff
  • Adequate technical staffing for migration to new technology (i.e., client server, web enabled processes)

Implementation Plan

The project will be executed in two major phases:

Foundation phase - focusing on the replacement of the aging HR and Student Administration systems to address the Year 2000 problems

Enrichment Phase - building on the foundation systems through more aggressive process re-engineering and implementation of more sophisticated enabling technologies

Foundation Phase

This phase will be executed over the next 21 months and will achieve the following:

Implementation of PeopleSoft base modules:

Student Administration

  • Campus Community
  • Admissions
  • Financial Aid
  • Student Records
  • Student Financials

HRMS

  • HR
  • Payroll
  • Benefits Administration
  • Time and Labor

Establishment of PeopleSoft technical infrastructure

Touch Tone Services

Centralized Graphical Reporting

Opportunistic process re-engineering

Replacement of targeted shadow systems

Organizational Scope for Foundation Phase

The foundation phase will address the in-scope functionality for the following organizations:

Student Administration

Undergraduate and graduate colleges

Professional schools: Medical, Dental, Law

Employee Groups in Scope for Foundation Phase

The foundation phase will address the in-scope functionality for the following employee groups:

HRMS

  • Faculty
  • Professionals and Administrative Staff
  • Administrators
  • Classified Staff
  • Student Employees
  • Temps and Work Study Employees

Enrichment Phase

This phase will be executed over the succeeding 24 months and will build on the foundation phase to achieve the following:
  • Upgrade in foundation-level functions
  • Process re-engineering
  • Desktop integration (e-mail, Excel, etc.)
  • Imaging
  • OLAP technology
  • Decentralized Graphical Reporting
  • Workflow
  • Expanded WWW functions
  • Replacement of targeted shadow systems

Project Milestones

Scope Phase Completed 12/1/97 HRMS Prototype Completed 4/27/98

SAS Prototype Completed 5/14/98

Student Records Go Live 11/2/98

Financial Aid Go Live 1/1/99

HR/Payroll Go Live 1/1/99

Admissions Go Live 2/1/99

Salary Admin Go Live 4/1/99

Time and Labor Go Live 4/1/99

Student Financials Go Live 7/1/99

Benefits Admin Go Live 7/1/99

Next Steps

1. Execute the Business Process Prototype activities:
  • Build foundation level tables
  • Iteratively map business processes to the software package
  • Generate standard reports for prioritized business processes
  • Identify and prioritize customizations
  • Develop approach documents for testing, training, security, conversion
  • Review/revise Assimilation Plan
  • Identify Next Steps

2. Upgrade to PeopleSoft release 7



Risks

Risk Abatement Strategy
Delays in Release 7 upgrade Develop a very detailed, aggressive upgrade plan to commence at the earliest possible start date

Acquire targeted consulting expertise to assist with upgrade

Impact of parallel initiatives Identify specific project dependency dates

Establish explicit liaison responsibilities

Monitor parallel initiative progress for project impact

Loss of key personnel Evaluate project team members for risk of leaving and potential project impact

Design program for enhancing non-monetary motivators

Establish contingency / succession plans

Begin assimilation of back-up resources





Strategic Context

Vision

An analysis session was conducted with the University executives to understand the strategic context of Project Orion relative to other major strategic initiatives underway. The discussion focused on project strategic drivers which support the long term goals and strategies of the university.

Strategic Allocation of Resources

In order for the university to maximize the value of the administrative functions, people must be relieved of the clerical drudgery imbedded in the current systems and processes and be allowed to focus on high impact, pro-active tasks that will move the university towards it's strategic goals.

Because of the lack of integration and functionality in current systems, administrative processes are inordinately clerical and labor intensive. Excessive effort is spent on manual error checking, error correction, duplicate data entry, reconciling information in redundant systems, and manually collecting, manipulating, and analyzing data.

Project ORION must enable administrative resources to focus on more strategic activities by proving a single integrated database for HR and Student Administration information. The PeopleSoft system will serve as an enabling technology to allow business processes to be re-engineered and extended to the source of data on input and to the consumer of the information on output.

Staff reduction is not an objective of Project Orion; however, excess staff capacity may be identified as part of the process re-engineering effort. In order for the University to achieve it's overall strategic initiatives, these resources must be re-allocated to more strategic activities both within and across functions.

Service Excellence

The higher education environment is becoming more competitive. Students, prospects, faculty, and employees expect much higher levels of service from top tier universities. In order for the University to reach it's goals, it must be able to provide a high level of service excellence to both internal ant external customers.

Even with the talents, dedication, and hard work of the administrative staff, the current systems and processes lack the functionality and flexibility to keep up with changing requirements needed to provide efficient services to students, employees, and the rest of the university community.

By providing a technical basis for process re-engineering, project Orion will allow the University to provide previously unavailable levels of service. Service will be improved through more streamlined processes, better access to more timely and accurate information, and more administrative staff capacity available to focus on valued services vs. clerical activities.

Project Expectations

The following project expectations were built through working sessions with the university executives and the members of the Project Orion team. The purpose of this list is to provide project participants with a sounding mechanism with which to gauge project success. These will be revisited through-out the project to ensure adherence and/or ongoing applicability.

  • Implement base system as delivered in the foundation phase, 1997 - 1999
  • Support the Challenge for Excellence and the Undergraduate Quality Initiative
  • Re-engineer (and, where appropriate, decentralize) business processes in the enrichment phase, 2000-2002
  • Automate business processes through workflow
  • Bring project in on time and on budget, but not at the expense of project staff
  • Allow University to adapt quickly to changes in university mission
  • Enhance management decision-making by improving data quality, accessibility, query-and-report capabilities
  • Integrate databases and standardize data
  • Simplify business processes by streamlining, eliminating redundancy, and reducing reconciliation of shadow systems
  • Resolve Year 2000 issues for "in scope" systems
  • Maintain current systems during transition to the new architecture
  • Provide better service for transfer students
  • Identify realistic resource requirements for units and departments (e.g., new or updated workstations and system-specific training for department end-users)
  • Provide appropriate outcomes assessments
  • Document system functions and procedures
  • Prepare system environment to manage research space, productivity, and equipment
  • Begin transition to CAR funding of system requirements
  • Use improved system efficiency to permit reallocation of staff to mission-critical effort

Critical Success Factors

The following critical success factors were built through working sessions with the university executives and the members of the Project ORION team. The purpose of this list is to define project elements which, if present, will likely result in project success. These will be revisited through-out the project to ensure adherence and/or ongoing applicability.

  • Executive commitment to the foundation and enrichment process
  • Timely decision making
  • Well-defined scope and objectives
  • Retention of key personnel
  • Successful campus-wide training program
  • Availability of functional and technical staff
  • Adequate technical staffing for migration to new technology (i.e., client server, web enabled processes)
  • Guiding Principles

    The following guiding principles were built through working sessions with the university executives and the members of the Project Orion team. The purpose of this list is to provide project participants with a set of principles they can use to guide them in tactical decision making through the life of the project. These will be revisited through-out the project to ensure adherence and/or an ongoing focus on making the system work as delivered (minimize modifications)

    • Make timely decisions
    • Address implementation issues to stakeholders (e.g. faculty, administrators, staff) concurrently, not serially
    • Make operational decisions at lowest appropriate level in the organization
    • Eliminate duplicate data (e.g, shadow systems) wherever possible
    • Challenge current processes with value-added standard
    • Avoid temporary reassignment of project resources to other tasks except in emergencies
    • Implement system "best practices" wherever possible
    • Honor thy scope
    • Honor thy Client: serve students/users/customers, not the provider
    • Maintain open communication with constituents
    • Evaluate shadow systems for potential replacement
    • Eliminate turf-tending: the university owns the data, not individuals or departments
    • Recognize project milestones
    • Ensure appropriate people are present and on-time to project meetings




    Implementation Plan

    Overview

    A detailed implementation plan was created based on the data gathered during the scoping process. The implementation plan shows the schedule for Human Resources and Student Administration prototyping, deployment and production sub phases for the foundation phase of Project Orion. The prototype sub phase is for a fixed time period. The deployment and production sub phase remains an estimate at this time. Additional data, at a more detailed level, will be gathered during the prototyping sub phase which could change the deployment and production sub phases estimates. At the completion of the prototype sub phase, a more detailed implementation plan will be created to further define the deployment and production sub phases.

    Prototype

    The prototype sub phase is broken up into three tasks: Campus Community and Academic Structure, Human Resources and Student Administration. The prototype begins December 1, 1997 with joint sessions conducted with Human Resources and Student Administration members discussing Campus Community. Human Resources begins on December 8, 1997 while Campus Community and Academic Structure continues for Student Administration. Human Resources is scheduled to complete by April 27, 1998 and Student Administration is scheduled to complete by May 18, 1998.

    A detailed prototyping schedule for Human Resources and Student Administration will be available for all Project Orion members.

    Deployment

    The deployment sub phases is broken up into four tasks: Development, Testing, User Procedures and Training. This sub phase will be managed by the University. It is anticipated that the University will utilize two Cambridge Technology Partners technical consultants during the Deployment sub phase. The deployment sub phase is scheduled to begin on March 6, 1998 and end on June 23, 1999.

    The development task consists of creating data conversions, interfaces, reports and further enhancing and customizing the PeopleSoft Human Resources and Student Administration systems to meet the Universities requirements.

    The testing task consists of technical and functional personnel testing the data conversions, interfaces, reports, enhancements and customizations in a controlled manner to ensure that the system is meeting the needs of the University. During the testing, scenarios will be created to ensure the results.

    The user procedures task is the creation of user procedures and documenting the data conversions, interfaces, reports, enhancements and customizations that were created during the development task.

    The training task is the task to train all functional users in how to use the system. PeopleSoft educational classes will be utilized as well as the user procedures developed during the user procedures task as well as existing PeopleSoft documentation.

    Production

    The production sub phase is bringing various parts of the system, in a phased approach, live for the University to begin using the PeopleSoft system. These dates were based on discussions with the Project Orion team members during the scoping.

    Student Administration modules were split amongst themselves to have certain parts live before other parts. This is detailed as Student Records I which is building courses and classes and Financials I which is the setup of Item Type data. The remainder of Student Records and Financials will be completed at a later date according the plan.



    Estimate of interfaces, conversions, reports and customization

    To determine the length of time to estimate the deployment phase, the following chart details the amount of time for interfaces, conversions, reports and customization:

    Task Total Effort (hours) Total Work Days Total Work Weeks Total for Module (Weeks) Total for Module (Days)
    Recruiting & Admissions Customizations 303.60 37.95 7.59
    Reports 246.00 30.75 6.15
    Interfaces 466.40 58.30 11.66
    Conversions 248.80 31.10 6.22 31.62 158.10
    Financial Aid Customizations 759.00 94.88 18.98
    Reports 246.00 30.75 6.15
    Interfaces 466.40 58.30 11.66
    Conversions 122.40 15.30 3.06 39.85 199.23
    Student Records Customizations 825.00 103.13 20.63
    Reports 246.00 30.75 6.15
    Interfaces 466.40 58.30 11.66
    Conversions 373.20 46.65 9.33 47.77 238.83
    Student Financials Customizations 132.00 16.50 3.30
    Reports 246.00 30.75 6.15
    Interfaces 466.40 58.30 11.66
    Conversions 311.00 38.88 7.78 28.89 144.43
    Human Resources Customizations 595.20 74.40 14.88
    Reports 328.00 41.00 8.20
    Interfaces 169.60 21.20 4.24
    Conversions 795.60 99.45 19.89 47.21 236.05