Agenda

1. Agenda • Introductions • Expectations • Problem • Plan • “One Stop Shop” • Organize Application Staff • Implement Portal • Develop Data Warehouse • Tools • Solution • Demo • Keys to Success • Discussion/Questions

2. Introductions/Expectations • Introductions Andy Keyser CIO PA Department of Corrections Camp Hill, PA • Expectations What do you want to know? Introductions Expectations Problem Plan “One Stop Shop” Organize Application Staff Implement Portal Develop Data Warehouse Tools Solution Demo Keys to Success Discussion/Questions

3. Problem • Substantial Investment in legacy Systems • Application Centric not well Integrated • Database design and maintenance • Too many programming languages being supported • Inefficient use of code and resources • Skills sets still in legacy technology • MFC3 phenomenon – more, more, more – faster, faster, faster – cheaper, cheaper, cheaper • Limited Resources Introductions Expectations Problem Plan “One Stop Shop” Organize Application Staff Implement Portal Develop Data Warehouse Tools Solution Demo Keys to Success Discussion/Questions

4. Plan Introductions Expectations Briefly Discuss Problem Solutions Plan Portal Tools Creating the “One Stop Shop” Leveraging Existing Systems Discussion/Questions Introductions Expectations Problem Plan “One Stop Shop” Organize Application Staff Implement Portal Develop Data Warehouse Tools Solution Demo Keys to Success Discussion/Questions Today Tomorrow Future Information Centric Knowledge Centric Application Centric Visitor Tracking Misconducts Inmate Records DOC INTRANET • DSF Portal • Web Interface • Data Warehouse “One Stop Shop” Comprehensive Offender Management System (OMS) RISP Inmate Employment Unit Management Inmate Accounts DC16E PACT 3-5 years

5. Plan • Goal: Build a “One Stop Shop” for Corrections information • To Do List: • Organize application staff more effectively • Create DOC intranet portal • Implement data warehouse for Business Intelligence • Utilize Web tools for application development and migrate all applications to web interface Introductions Expectations Problem Plan “One Stop Shop” Organize Application Staff Implement Portal Develop Data Warehouse Tools Solution Demo Keys to Success Discussion/Questions

6. Plan • Organize application staff more effectively • 2 ways to accomplish – outsource or utilize DOC employees • Decided to use advantages of each • Outsource Advantages: • the ability to throw additional people at the problem • current skills sets and resources • can add staff and resources quickly • Clearly defined costs associated with a project • Advantages of in house staff are: • “local” knowledge – DOC staff know the systems, people, and process and can affect change quickly and effectively. • Can implement new projects that take less than 2 months to develop more quickly and cheaper than vendors Introductions Expectations Problem Plan “One Stop Shop” Organize Application Staff Implement Portal Develop Data Warehouse Tools Solution Demo Keys to Success Discussion/Questions

7. Solutions - Plan Introductions Expectations Briefly Discuss Problem Solutions Plan Portal Tools Creating the “One Stop Shop” Leveraging Existing Systems Discussion/Questions Introductions Expectations Problem Plan “One Stop Shop” Organize Application Staff Implement Portal Develop Data Warehouse Tools Solution Demo Keys to Success Discussion/Questions

8. Plan • Implement DOC Intranet Portal • Single interface for all inmate information • Single interface for application access • Single interface for all DOC Information • Policies, HR, forms, grants, information, news briefs, calendar, etc. • Distributed content management • Automatic alerts • Shared Calendar • Discussion groups • Electronic forms development • Chat/Instant Messaging • etc Introductions Expectations Problem Plan “One Stop Shop” Organize Application Staff Implement Portal Develop Data Warehouse Tools Solution Demo Keys to Success Discussion/Questions

9. Plan • Implement Data Warehouse for Business Intelligence • SQL Server 2000 backend • Business Objects front end • Advantages • Push data to end users through publication manager • Single source for information, keeps answers to data requests consistent and hopefully accurate • Allows end users to quickly and easily get answers to information in a manner that makes sense to them • Disadvantages • Control over release and interpretation of information • Training issues Introductions Expectations Problem Plan “One Stop Shop” Organize Application Staff Implement Portal Develop Data Warehouse Tools Solution Demo Keys to Success Discussion/Questions

10. Plan • Tools Introductions Expectations Problem Plan “One Stop Shop” Organize Application Staff Implement Portal Develop Data Warehouse Tools Solution Demo Keys to Success Discussion/Questions DOC Users (Win 2K) DOC MF Users INTRANET UI (Visual Studio 6.0, HTML, XML) Client Server Apps (VB 6.0, MS Access, FoxPro) Security (Authentication, Authorization and Access Control - Tivoli) IIS 5.0 Component Services (COM+) Dynamic Site Framework Content Manager Mainframe DBs ADO/ODBC/OLEDB Exchange Server Database Server SQL 2K FoxPro Via SQL ODBC Windows 2000 Family of Servers

11. Plan • Solution • DOCNET demo • DOC info demo Introductions Expectations Problem Plan “One Stop Shop” Organize Application Staff Implement Portal Develop Data Warehouse Tools Solution Demo Keys to Success Discussion/Questions

12. Solution Introductions Expectations Problem Plan “One Stop Shop” Organize Application Staff Implement Portal Develop Data Warehouse Tools Solution Demo Keys to Success Discussion/Questions

13. Solution Introductions Expectations Problem Plan “One Stop Shop” Organize Application Staff Implement Portal Develop Data Warehouse Tools Solution Demo Keys to Success Discussion/Questions

14. Solution Introductions Expectations Problem Plan “One Stop Shop” Organize Application Staff Implement Portal Develop Data Warehouse Tools Solution Demo Keys to Success Discussion/Questions

15. Solution Introductions Expectations Problem Plan “One Stop Shop” Organize Application Staff Implement Portal Develop Data Warehouse Tools Solution Demo Keys to Success Discussion/Questions

16. Solution Introductions Expectations Problem Plan “One Stop Shop” Organize Application Staff Implement Portal Develop Data Warehouse Tools Solution Demo Keys to Success Discussion/Questions

17. Solution Introductions Expectations Problem Plan “One Stop Shop” Organize Application Staff Implement Portal Develop Data Warehouse Tools Solution Demo Keys to Success Discussion/Questions

18. Keys to Success • Find champions outside IT department • Press • HR • Etc • Get Something up quickly • Photos help • Utilize www technologies so all end users need is a browser • Commercial portal tools tend to have good functionality out of the box – don’t reinvent the wheel • Mentor local staff to be able to support and develop quick applications Introductions Expectations Problem Plan “One Stop Shop” Organize Application Staff Implement Portal Develop Data Warehouse Tools Solution Demo Keys to Success Discussion/Questions

19. Discussion/Questions Introductions Expectations Problem Plan “One Stop Shop” Organize Application Staff Implement Portal Develop Data Warehouse Tools Solution Demo Keys to Success Discussion/Questions