# Presentation: 767904

## Enterprise Computing Steering Committee Meeting

**Information Systems Projects**
**Diana Brown****May 13, 2002**

## Information Systems ProjectsOutline

**IT Systems Operating Architecture**
**Information Infrastructure Projects**
**Security Projects**
**Data Warehousing and Reporting**
- Current Processing Environment
- End User Types
- Information Delivery Considerations
- Proposed Systems
- Recommended Approach
**User Interface Projects**
**Summary**

## IT Systems Operating Architecture

**Applications**

**Data ****Warehousing****and****Reporting**

**Data Base**

**System Software**

**Server Hardware**

**Security**

**User Interface**

**Infrastructure Components**

## Information Infrastructure Projects  

**Information Infrastructure Projects****  **

**Administrative Systems Computer Upgrades **(GPE #22982)
- Support applications (Accounts Payable, Grants, Travel) moving from decommissioned IBM mainframe
- Sustain the performance and availability of other applications (e.g. Chemical Inventory, HRIS, FMS, MAXIMO)
**Additional Disk Storage for Administrative Systems **(GPE #22985)
- Accommodate increased application usage and data growth

## Information Infrastructure Projects  

**Information Infrastructure Projects****  **

**Backup System Expansion **(GPE #22912)** **
- Protect institutional and administrative data from loss
**937-747 Cooling Control System Upgrade**
- Increase ISS staff productivity
- Increase hardware lifespan
**Application Job Scheduler Evaluation**

## Information Infrastructure Projects  

**Information Infrastructure Projects****  **

**Create a Stand Alone User Acceptance Testing Environment**
- Controlled environment mirroring production
- Greater user participation before systems are placed in production
- User driven test scripts
- Official signoffs
- Full volume testing made possible
- Longer lead time for system implementation or upgrade
- Fewer production system failures
- Better system performance

## Security Projects

* *

**Separate Development environment from Production computing environment**
**Implement DMZ network to separate web servers and database servers**
**Add additional firewalls and intrusion detection system to NT and Novell environment**

## Data Warehousing and ReportingCurrent Processing Environment

**Data Warehousing and Reporting****Current Processing Environment**

**Getting data into the Data Warehouse is labor intensive, and the process must be “rewritten” each time the source systems are upgraded**

**Home grown programs are used to “transform” data. These programs are more prone to errors and slower than commercially available transformation tools **

**Current data transformation:**

## Data Warehousing and ReportingCurrent Processing Environment

**Data Warehousing and Reporting****Current Processing Environment**

**Users maintain many “shadow” systems to produce division-centric reports that ISS staff cannot create**
**Current reporting tool (Oracle Report) is programming intensive and cannot be used by end users**
**Current data structure does not support ad hoc reporting or trend analysis**
**Data aggregates are not maintained for management reporting. Detailed data is gathered and totals recomputed each time a report is generated**

## Data Warehousing and ReportingCurrent Processing Environment

**Data Warehousing and Reporting****Current Processing Environment**

**Drill down from aggregates to summary details are limited to cost browser.**
**Current reporting tools cannot produce charts and graphs which are desirable for trend analysis and decision making.**
**Users are required to enter multiple parameters to get their desired reports. Service offerings are not integrated. The complexity of the interface makes the system useful only to one type of user - analysts**
**Technology used in IRIS Report Subscription Service is outdated and must be replaced within 1 year**

## Data Warehousing and Reporting End User Types

**Data Warehousing and Reporting ****End User Types**

**Decision Makers**
**Operational Managers**
**Principal Investigators**
**Planners**
**Analysts**
**Technical Support Staff**

## Data Warehousing and Reporting Information Delivery Considerations

**Data Warehousing and Reporting ****Information Delivery Considerations**

**Ad hoc queries**
**Queries by example**
**Predefined queries**
**Scheduled reports **
**Charts and graphs**
**Point and click method to obtain highly summarized management reports**
**Subscription capability**

## Data Warehousing and ReportingProposed Systems

**Data Warehousing and Reporting****Proposed Systems**

**Financial**

- FMS

- Janus

- PRP

- RAPID

**Human****Resources**

- HRIS

- Payroll

**EHS**

- SAAR

- HEAR

**Facilities**

- Maximo

- AMS

- Odyssey

**Business**

- Travel

- Phone

**Data Acquisition**

**Integrated Data Warehouse**

**End User**

## Data Warehousing and ReportingProposed Systems

**Data Warehousing and Reporting****Proposed Systems**

**Financial**

- FMS

- Janus

- PRP

- RAPID

**Human****Resources**

- HRIS

- Payroll

**EHS**

- SAAR

- HEAR

**Facilities**

- Maximo

- AMS

- Odyssey

**Business**

- Travel

- Phone

**Data Acquisition**

**Integrated Data Warehouse**

**Predefined****Reports**

**Queries**

**Decision****Support****Analysis**

**End User**

**PIs****Analysts****Technical Staff**

**Operational Managers****Analysts, PIs**

**Planners****Decision Makers****Operational Managers**

## Data Warehousing and ReportingProposed Systems

**Data Warehousing and Reporting****Proposed Systems**

**Financial**

- FMS

- Janus

- PRP

- RAPID

**Human****Resources**

- HRIS

- Payroll

**EHS**

- SAAR

- HEAR

**Facilities**

- Maximo

- AMS

- Odyssey

**Business**

- Travel

- Phone

**Data Acquisition**

**Integrated Data Warehouse**

**Predefined****Reports**

**Queries**

**Decision****Support****Analysis**

**End User**

**PIs****Analysts****Technical Staff**

**Operational Managers****Analysts, PIs**

**Planners****Decision Makers****Operational Managers**

**Reporting Portal**

## Berkeley Lab Information Systems(BLIS)

**Financial**

- FMS

- Janus

- PRP

- RAPID

**Human****Resources**

- HRIS

- Payroll

**EHS**

- SAAR

- HEAR

**Facilities**

- Maximo

- AMS

- Odyssey

**Business**

- Travel

- Phone

**Data Acquisition**

**Integrated Data Warehouse**

**Predefined****Reports**

**Queries**

**Decision****Support****Analysis**

**End User**

**PIs****Analysts****Technical Staff**

**Operational Managers****Analysts, PIs**

**Planners****Decision Makers****Operational Managers**

**Reporting Portal**

## Data Warehousing and ReportingRecommended Approach

**Data Warehousing and Reporting****Recommended Approach**

- Upgrade IRISv2 Report Subscription Services
- Form BLIS administrative and technical working groups
- Gather requirements for BLIS
- Evaluate and purchase an ETL (Extract, Transform and Load) tool for data acquisition
- Evaluate and select an ad hoc query tool
- Evaluate and select a Decision Support tool
- Replace current data acquisition method with the selected ETL tool

## User Interface Projects

**User Interface Projects**

**Create BLIS Reporting Portal Pilot**
- Provide an integrated front end for easy access to BLIS
- Enable users to create their own information universe

## BLIS Reporting Portal

**Personalize My Portal**
**Predefined Reports**
**Queries**
**Decision Support**

**My Reports**

**Financial**
**	****Budget vs. Actual Costs**
**Subcontracts and Grants**
**	****Subcontracts by Department**
**	****Grants by Division**
**Human Resources**
**	****Employee Salaries by Department**
**	****Employees by Department**

**A-Z Index****Search****Home**

**Contact Us**
**Help**
**Log Off**

**BLIS Reporting Portal**

**My Queries**

**GPE Balance**
**Staff by Seniority**
**Travel Costs**

**My Decision Support Analysis**

**Salary Trends (Cross FY)**
**Org Burden Rate Change**

**Soft Close Data Current as of May 8 2002****ABB Summary by Division Report Now Available**

**Alerts and Bulletins**

## Summary

_** **_

_** **_

**Create a stand alone user acceptance testing environment**
**Upgrade IRISv2 Report Subscription Services**
**Develop Berkeley Lab Information Systems (BLIS) and Implement Reporting Portal Pilot**
- Data Acquisition Tool
- Staff (FTE and Consultants)

- $125k

- $50k

- $150k

- $580k