Agenda
1)
Introductions
2)
Expectations
3)
Problem
4)
Plan

“One Stop Shop”

Organize Application Staff

Implement Portal

Develop Data Warehouse

Tools
Solution
5)

Demo
6)
Keys to Success
7)
Discussion/Questions
Introductions/Expectations
Introductions
Expectations
1)
Problem
Andy Keyser
Plan
CIO
“One Stop Shop”
Organize Application Staff
PA Department of Corrections
Implement Portal
Develop Data Warehouse
Camp Hill, PA
Tools
Solution
Demo
Keys to Success
Discussion/Questions
Introductions
2)
Expectations
What do you want to know?
Problem
Introductions

Expectations
Problem
Plan

“One Stop Shop”
Organize Application Staff
Substantial Investment in legacy
Systems
Application Centric not well Integrated

Implement Portal
Develop Data Warehouse

Tools
Solution
Demo

Keys to Success
Discussion/Questions
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
Plan
Introductions
Introductions
Expectations
Today
Problem
Expectations
Application
Centric
Plan
“One Stop Shop”
Organize Application Staff
Implement Portal
Develop Data Warehouse
Tools
Solution
Demo
Keys to Success
Discussion/Questions
Briefly Discuss
Problem
Visitor
Misconducts
Tracking
Inmate
Records
Solutions
Plan
RISP
Inmate
Unit
Employment Management
Portal Tools
Creating the
DC16EShop”PACT
Stop
Inmate
“One
Accounts
Tomorrow
Future
Information Centric
Knowledge Centric
DOC
INTRANET
-DSF Portal
-Web Interface
-Data Warehouse
“One Stop Shop”
Leveraging Existing
Systems
Discussion/Questions
3-5 years
Comprehensive
Offender
Management
System
(OMS)
Plan
Introductions
Expectations
Goal: Build a “One Stop Shop” for
Corrections information
Problem
Plan
“One Stop Shop”
To Do List:
Organize Application Staff
Implement Portal

Organize application staff more effectively

Create DOC intranet portal
Develop Data Warehouse
Tools
Solution
Demo

Keys to Success
Discussion/Questions

Implement data warehouse for Business
Intelligence
Utilize Web tools for application development
and migrate all applications to web interface
Plan
Organize application staff more effectively
Introductions
Expectations
Problem

Plan
“One Stop Shop”
Organize Application Staff

Decided to use advantages of each

Outsource Advantages:
Implement Portal
Develop Data Warehouse
2 ways to accomplish – outsource or utilize DOC
employees
Tools

Solution

Demo

Keys to Success

Discussion/Questions

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
Solutions - Plan
Introductions
Introductions
Division Chief
Expectations
Problem
Plan
“One Stop Shop”
Expectations
Briefly Discuss
Problem
Project
Organize Application Staff
Implement Portal
Develop Data Warehouse
Tools
Management
Solutions
Plan
Application
Development
Administration
Applications
Development
Supervisor
Administration
Supervisor
Solution
Demo
Keys to Success
Discussion/Questions
Portal Tools
Project Manager
Creating the
“One Stop Shop”
Leveraging
Existing
Project
Manager
Systems
Project Manager
Discussion/Questions
Development
Analyst
Maintenance
Analyst
Developer
Development
Analyst
Maintenance
Analyst
Developer
Development
Analyst
Maintenance
Analyst
Developer
Database Analyst
Database Analyst
Database Analyst
Application
Administrator
Plan
Implement DOC Intranet Portal
Introductions
Expectations
Problem
Plan

Single interface for all inmate information

Single interface for application access

Single interface for all DOC Information
“One Stop Shop”
Organize Application Staff
Implement Portal

Develop Data Warehouse
Tools
Solution

Distributed content management

Automatic alerts

Shared Calendar

Discussion groups

Electronic forms development

Chat/Instant Messaging

etc
Demo
Keys to Success
Discussion/Questions
Policies, HR, forms, grants, information, news briefs,
calendar, etc.
Plan
Implement Data Warehouse for Business Intelligence
Introductions
Expectations
Problem
Plan

SQL Server 2000 backend

Business Objects front end

Advantages
“One Stop Shop”
Organize Application Staff
Implement Portal

Develop Data Warehouse

Tools
Solution

Demo
Keys to Success
Discussion/Questions

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
Plan
Tools
Introductions
Expectations
Problem
DOC
Users
(Win 2K)
DOC MF
Users
Plan
“One Stop Shop”
Organize Application Staff
INTRANET
Implement Portal
Develop Data Warehouse
UI (Visual Studio 6.0, HTML, XML)
Solution
Keys to Success
Discussion/Questions
Client Server Apps
(VB 6.0, MS Access,
FoxPro)
IIS 5.0
Component Services
ADO/ODBC/OLEDB
(COM+)
Exchange
Server
Dynamic Site
Framework
Database Server SQL 2K
FoxPro
Windows 2000 Family of Servers
Content
Manager
and Access Control - Tivoli)
Demo
Security (Authentication, Authorization
Tools
Mainframe
DBs
Via SQL ODBC
Plan
Solution
Introductions
Expectations
Problem
Plan
“One Stop Shop”
Organize Application Staff
Implement Portal
Develop Data Warehouse
Tools
Solution
Demo
Keys to Success
Discussion/Questions

DOCNET demo

DOC info demo
Solution
Introductions
Expectations
Problem
Plan
“One Stop Shop”
Organize Application Staff
Implement Portal
Develop Data Warehouse
Tools
Solution
Demo
Keys to Success
Discussion/Questions
Solution
Introductions
Expectations
Problem
Plan
“One Stop Shop”
Organize Application Staff
Implement Portal
Develop Data Warehouse
Tools
Solution
Demo
Keys to Success
Discussion/Questions
Solution
Introductions
Expectations
Problem
Plan
“One Stop Shop”
Organize Application Staff
Implement Portal
Develop Data Warehouse
Tools
Solution
Demo
Keys to Success
Discussion/Questions
Solution
Introductions
Expectations
Problem
Plan
“One Stop Shop”
Organize Application Staff
Implement Portal
Develop Data Warehouse
Tools
Solution
Demo
Keys to Success
Discussion/Questions
Solution
Introductions
Expectations
Problem
Plan
“One Stop Shop”
Organize Application Staff
Implement Portal
Develop Data Warehouse
Tools
Solution
Demo
Keys to Success
Discussion/Questions
Solution
Introductions
Expectations
Problem
Plan
“One Stop Shop”
Organize Application Staff
Implement Portal
Develop Data Warehouse
Tools
Solution
Demo
Keys to Success
Discussion/Questions
Keys to Success
Introductions

Find champions outside IT department
Expectations

Problem

Plan

“One Stop Shop”
Organize Application Staff

Implement Portal
Tools

Solution
Demo
Keys to Success
Get Something up quickly

Develop Data Warehouse

Discussion/Questions

Press
HR
Etc
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
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
Descargar

No Slide Title