Transcript Minnesota Vehicle and Driver Information Now “MinnVinn”

Working with
Business Partners
and Citizens
To provide driver and vehicle information in
web format to increase timeliness, accuracy, and
clarity of information
Minnesota Driver & Vehicle Services
DVS Information Service
Goals

Deliver real-time data to DVS partners
 Enable real-time transactions for DVS
partners – both to query and update records
 Increase communications between DVS
staff and partners
 Improve citizens’ ability to access their
motor vehicle and driver license records
Minnesota Driver & Vehicle Services
DVS Clients

Business Partners
– Deputies/DL Agents (private firms) take in
paperwork for transactions


174 Deputies
160 DL Agents
– Dealers / Insurance / Lending

Law Enforcement
 State Agencies
Minnesota Driver & Vehicle Services
DVS Clients

DVS Staff in Greater Minnesota
– Exam stations

Commercial Vehicle Companies
 Citizens
 Ambulance Chasers! – i.e. -- Anyone who
wants Driver License/Motor Vehicle
information
Minnesota Driver & Vehicle Services
2001 Information
Infrastructure

Motor Vehicles and Drivers License databases
stored in Supra (Cincom) database
– CICS transaction screens
– 500+ Cobol programs
– Created 25 years ago/minimal documentation
– On S390

Supra database is not an Open system
– No way to access data with other
programs/APIs/engines
Minnesota Driver & Vehicle Services
2001 Information
Infrastructure

Issues
– All reports, queries must be done by Cobol
–
–
–
–
programmers
All modifications to transactions must be done
by Cobol programmers
Screen entry did not always flow naturally
Not enough system edits for data-entry
Changes were time intensive
Minnesota Driver & Vehicle Services
2001 Information
Infrastructure

Information/Process Needs
– Complaints that data was not out-of-date or
inaccurate
– Huge paper process



All transactions involve paper being sent to St Paul
Information requests and updates had to flow
through St Paul
Time intensive to process and file paper/Huge
backlog
Minnesota Driver & Vehicle Services
Information Solutions?

Long Term Vision (“Invasive”)
– Move Supra database to Open system
 Estimate 2 – 4 year process
– Legislature designated $3.8 million to provide
accurate data on problem drivers


Gartner study agreed that this would first require
analysis/redesign of business process
Currently hiring project manager
Minnesota Driver & Vehicle Services
Information Solutions?

Long Term Vision (“Invasive”)
– DVS staff had minimal exposure to any
information systems not on mainframe
– COBOL programmers had no other experience
– External businesses sell DVS data

Pressure/necessity to have State provide accurate
data in new format for customers
Minnesota Driver & Vehicle Services
Information Solutions?

Short Term Vision (“Non-invasive”)
– Web-enable legacy system
– Use existing business logic represented by
legacy system
– Build on VB programming skills of DVS staff
– Suggested an EAI tool

Which could access data coming from mainframe
Minnesota Driver & Vehicle Services
Information Solutions?

Short Term Vision (“Non-invasive”)
– Looked for EAI Tool – Chose WRQ’s Verastream Suite
(VHI)

–
–
–
–
–
Previous experience with vendor for terminal emulation
suggested strength in accessing data on mainframes
Started development in September (2 programmers)
Production in November
1-2 mo turnaround on new products
MNDRIVEINFO.ORG for citizens
www.dps.state.mn.us/esupport for partners
Minnesota Driver & Vehicle Services
Information Solutions? -- YES

For first time business partners do realtime
updates of legacy system
 Online transactions
– Reduce data errors
– Reduce time to deliver (driver license)
– Eliminate paperflow to St Paul
Minnesota Driver & Vehicle Services
Information Solutions? -- YES

Law Enforcement/Courts/State
Agencies/Companies can now read the
Driver License Record
 Citizens can access DVS records
 DVS staff envisioning new ways to
approach data, data entry, and access to data
 Information technology now enables new
business processes
Minnesota Driver & Vehicle Services
Information Solutions? -- YES

DVS Web Sites now
 HOW Did We Accomplish This?
 The VERASTREAM Integration Tools
from WRQ
 (and programming staff (2 DVS, 1
contractor) ready to adapt to new schedules,
processes!)
Minnesota Driver & Vehicle Services
How the Development
Process Works

Development Environment
– Web: MS2000 with IIS
 Considering move to Linux
– Visual Interdev creating ASP pages
 VB Script on Server; some Javascript on client
– Install VHI (from WRQ) on server
 Development/management tools on programmers’
workstations
Minnesota Driver & Vehicle Services
The Development
Environment
Client sends
request to
Web Server
Web server
contacts
VHI server
VHI server
contacts
mainframe
Com objects written to use com
object WRQ ships with product
Minnesota Driver & Vehicle Services
ASP pages display
data via web server
Data
returned to
VHI server
How the Development
Process Works

Programmer develops business model using
VHI tools
– Maps CICS screen navigation areas
Minnesota Driver & Vehicle Services
How the Development
Process Works

Programmer develops business model using
VHI tools
Individual fields are mapped
to named attributes which
are available for reading,
Writing at runtime
A record set can be defined
to span multiple screens
Minnesota Driver & Vehicle Services
How the Development
Process Works

Programmer develops business model using
VHI tools
* Record sets can be used to
define a procedure
* Record sets can be combined
into complex procedure
to return a single table
Minnesota Driver & Vehicle Services
Creating Procedures with
WRQ VHI Tool
Minnesota Driver & Vehicle Services
DVS Web Information
Services Structure

Security
– Unique username/password for each person
using system
– SSL for encryption

“Communities” for each set of business
partners
– Access to services based on functional need
Minnesota Driver & Vehicle Services
DVS Web Information
Services Structure

Web-application
– Minimal training required
– Real-time connection to mainframe
– Straightforward modifications to roll-out to
citizens
– Databases behind interface are transparent to
end-users
Minnesota Driver & Vehicle Services
Current Web Information
Services

For Citizens: www.dps.state.mn.us/mndriveinfo
– (mndriveinfo.org)

Change Motor Vehicle Address*
 Status of DL *
– (can I drive?)

Renew Tabs*
 MV Tax*
* Real-time with mainframe
database (VHI)
Minnesota Driver & Vehicle Services
Current Web Information
Services

Internet Renewal of Tabs – Example of
flexibility that VHI Tool provides for DVS
– Previous implementation required monthly
download from mainframe, import into SQL


Did not reflect current status of vehicle
Batch load at night of registrations renewed
– May implementation goes live to mainframe
 Enter DL, returns all vehicles registered
 Choose plate and registration is updated real-time
Minnesota Driver & Vehicle Services
Current Web Services

DL Agents:
– Exam Scheduling



Access to all exam locations
Modified to schedule
evaluation appointments
Minimize citizen wait time
– DL Online *



Renewals and Duplicates
New data entry edits built into web interface
Citizen receives in 1 week instead of weekss
* Real-time with mainframe
database (VHI)
Minnesota Driver & Vehicle Services
Current Web Services

Deputies:
– Title/Vehicle Queries*


Shows suspenses/flags without codes
Do Held for Resale for dealers
– Cash Receipts
– Online Registration Renewals*

Dealers:
– Hold for Resale/Junked*
* Real-time with mainframe
database (VHI)
Minnesota Driver & Vehicle Services
Current Web Services

Courts/Law Enforcement
– Readable DL Record*
– First application with C++ com
– First VHI model using record sets and complex
procedures (as defined by WRQ)
* Real-time with mainframe
database (VHI)
Minnesota Driver & Vehicle Services
Current Web Services

Courts/Law Enforcement
– Pages can be much more than realigning fields
on CICS screens
– First application with C++ com
– Consultant programmer walked in, handed
documentation from WRQ and DVS
programmers and in 30 minutes was displaying
results
Minnesota Driver & Vehicle Services
Legacy DL Record

Courts/Law Enforcement – DL Record
Minnesota Driver & Vehicle Services
New Esupport DL Record
Minnesota Driver & Vehicle Services
New ESupport DL Record
Convictions Only
DWI Only
Minnesota Driver & Vehicle Services
New ESupport DL Record
What do I
need to do
to get
reinstated?
Minnesota Driver & Vehicle Services
Information Services coming
in June

Deputies:
– Online Duplicate Plate*
– Online Duplicate Stickers*
– Online Duplicate Titles*
– This changes business practices for deputies
– Reduces 20-30% of current workload for DVS staff
* Real-time with mainframe
database (VHI)
Minnesota Driver & Vehicle Services
Information Services coming
in June

Deputies/Dealers:
– Online Title Transfer application*

Workflow from Dealer to Deputy to DVS
– Fee Calculator for Registrations

DL Agents:
– Online Renewals/Duplicates for CDLs/IDs*
– Online First Time Applicants for DL, under 18*
* Real-time with mainframe
database (VHI)
Minnesota Driver & Vehicle Services
Information Services coming
in 2002

PIN #s
– Citizens can then request/update private information –
for both Motor Vehicle and Driver License*





Online DL Application*
DWI Arrest Processing*
New MV Titles Online*
Crash Records*
Name Searches
* Real-time with mainframe
database (VHI)
Minnesota Driver & Vehicle Services
Web Enabling Legacy System
with WRQ’s VHI

Build on existing/tested business logic
–
–

DePaul University study finds that enabling legacy
systems can produce results 25 times faster than
recoding*
Produce new applications in 1 – 3 months
Add new data entry edits for online transactions
–
Information gathered where citizen is can be more
accurate and/or complete
*Enterprise Systems, April 2002
Minnesota Driver & Vehicle Services
Tool Grows with Complexity of
Problem

First VHI models went against one screen
– Used Components Model

Newest applications are linking more than
one screen
– Use Record Set Model
– Use ‘Complex Procedures’ Model
– Use WRQ’s Development Web site
Minnesota Driver & Vehicle Services
Web Enabling Legacy System
with WRQ’s VHI

Capture new types of information to integrate with
existing system
– Ex: in June/July, will break name into three fields, store
in SQL/db2 – enabling new search capabilities


Locate DL# from name search then get record from
mainframe*
Reusability of business models
– Have modeled 6 screens to give 12 applications
*VHI from WRQ
Minnesota Driver & Vehicle Services
Web Enabling Legacy System

DVS Staff “can not believe” where we have gone
in 8 months
– Delivering information
– Updating transactions
– Evaluating processes
– Are proud that ‘State Government’ is delivering
services that taxpayers and business partners – both-appreciate
Minnesota Driver & Vehicle Services
Web Enabling Legacy System

Provides opportunities to build a more
integrated/flexible system as we move from
Supra platform
– Provides time to concentrate on
analysis/reengineering of processes
– Develops new skills of programmers
– Understand options for working with systems
Minnesota Driver & Vehicle Services
DEMONSTRATIONS

MNDriveInfo.org
– Public site for citizens

www.dps.state.mn.us/esupport
– Secure site for business partners
Minnesota Driver & Vehicle Services
DEMONSTRATIONS
Minnesota Driver & Vehicle Services