1 / 20

Enterprise Computing Steering Committee Meeting

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

miller
Download Presentation

Enterprise Computing Steering Committee Meeting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Enterprise Computing Steering Committee Meeting Information Systems Projects Diana BrownMay 13, 2002

  2. Information Systems ProjectsOutline • 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

  3. IT Systems Operating Architecture User Interface Data WarehousingandReporting Applications Security Data Base System Software Server Hardware Infrastructure Components

  4. 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

  5. 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

  6. 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

  7. 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

  8. Data Warehousing and ReportingCurrent Processing Environment FMS Project ID Purchasing Account No. Maximo Work Order No. DW Project ID AMS Structure Odyssey Building No. DW Location • 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:

  9. Data Warehousing and ReportingCurrent 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

  10. Data Warehousing and ReportingCurrent 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

  11. Data Warehousing and Reporting End User Types • Decision Makers • Operational Managers • Principal Investigators • Planners • Analysts • Technical Support Staff

  12. 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

  13. Data Warehousing and ReportingProposed Systems Financial HumanResources EHS Facilities Business FMS Janus Maximo AMS HRIS Payroll SAAR HEAR Travel Phone PRP RAPID Odyssey Data Acquisition Integrated Data Warehouse End User

  14. Data Warehousing and ReportingProposed Systems Financial HumanResources EHS Facilities Business FMS Janus Maximo AMS HRIS Payroll SAAR HEAR Travel Phone PRP RAPID Odyssey Data Acquisition Integrated Data Warehouse Queries PredefinedReports DecisionSupportAnalysis End User PIsAnalystsTechnical Staff PlannersDecision MakersOperational Managers Operational ManagersAnalysts, PIs

  15. Data Warehousing and ReportingProposed Systems Financial HumanResources EHS Facilities Business FMS Janus Maximo AMS HRIS Payroll SAAR HEAR Travel Phone PRP RAPID Odyssey Data Acquisition Integrated Data Warehouse Queries PredefinedReports DecisionSupportAnalysis Reporting Portal End User PIsAnalystsTechnical Staff PlannersDecision MakersOperational Managers Operational ManagersAnalysts, PIs

  16. Berkeley Lab Information Systems(BLIS) Financial HumanResources EHS Facilities Business FMS Janus Maximo AMS HRIS Payroll SAAR HEAR Travel Phone PRP RAPID Odyssey Data Acquisition Integrated Data Warehouse Queries PredefinedReports DecisionSupportAnalysis Reporting Portal End User PIsAnalystsTechnical Staff PlannersDecision MakersOperational Managers Operational ManagersAnalysts, PIs

  17. Data Warehousing and ReportingRecommended 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

  18. 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

  19. BLIS Reporting Portal A-Z IndexSearchHome Alerts and Bulletins Soft Close Data Current as of May 8 2002ABB Summary by Division Report Now Available BLIS Home 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 My Queries GPE Balance Staff by Seniority Travel Costs My Decision Support Analysis Contact Us Help Log Off Salary Trends (Cross FY) Org Burden Rate Change

  20. 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

More Related