working with

Minnesota Driver & Vehicle Services

Working with

Business Partners and Citizens

To provide driver and vehicle information in web format to increase timeliness, accuracy, and clarity of information


DVS Information Service DVS Information Service GoalsGoals

Deliver real-time data to DVS partnersEnable real-time transactions for DVS

partners – both to query and update recordsIncrease communications between DVS

staff and partnersImprove citizens’ ability to access their

motor vehicle and driver license records


DVS ClientsDVS Clients

Business Partners– Deputies/DL Agents (private firms) take in

paperwork for transactions 174 Deputies 160 DL Agents

– Dealers / Insurance / Lending

Law EnforcementState Agencies


DVS ClientsDVS Clients

DVS Staff in Greater Minnesota– Exam stations

Commercial Vehicle CompaniesCitizensAmbulance Chasers! – i.e. -- Anyone who

wants Driver License/Motor Vehicle information


2001 Information 2001 Information InfrastructureInfrastructure

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



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



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


Information Solutions?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



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



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



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


Information Solutions? -- YESInformation 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



Law Enforcement/Courts/State Agencies/Companies can now read the Driver License Record

Citizens can access DVS recordsDVS staff envisioning new ways to

approach data, data entry, and access to dataInformation technology now enables new

business processes



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!)


How the Development How the Development Process WorksProcess 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


The Development The Development EnvironmentEnvironment

Client sends request to Web Server

Web server contacts VHI server

VHI server contacts mainframe

Data returned to VHI server

ASP pages display data via web server

Com objects written to use com object WRQ ships with product



Programmer develops business model using VHI tools– Maps CICS screen navigation areas



Programmer develops business model using VHI toolsIndividual fields are mapped to named attributes whichare available for reading, Writing at runtime

A record set can be definedto span multiple screens



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


Creating Procedures with Creating Procedures with WRQ VHI ToolWRQ VHI Tool


DVS Web Information DVS Web Information Services StructureServices 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


DVS Web Information DVS Web Information Services StructureServices 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


Current Web Information Current Web Information ServicesServices

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)


Current Web Information Current Web Information ServicesServices

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


Current Web ServicesCurrent 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



Current Web ServicesCurrent 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*




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)



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


Legacy DL RecordLegacy DL Record

Courts/Law Enforcement – DL Record


New Esupport DL RecordNew Esupport DL Record


New ESupport DL RecordNew ESupport DL RecordConvictions Only

DWI Only


New ESupport DL RecordNew ESupport DL Record

What do I need to do to get reinstated?


Information Services coming Information Services coming in Junein 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)


Information Services coming Information Services coming in Junein 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*



Information Services coming Information Services coming in 2002in 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



Web Enabling Legacy System Web Enabling Legacy System with WRQ’s VHIwith 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


Tool Grows with Complexity of Tool Grows with Complexity of ProblemProblem

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


Web Enabling Legacy System Web Enabling Legacy System with WRQ’s VHIwith 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


Web Enabling Legacy SystemWeb 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


Web Enabling Legacy SystemWeb 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


DEMONSTRATIONSDEMONSTRATIONS

MNDriveInfo.org– Public site for citizens

www.dps.state.mn.us/esupport– Secure site for business partners


DEMONSTRATIONSDEMONSTRATIONS

working with

Documents

accurate data

dvs data pressurenecessity

dvs recordsdvs staff

st paulinformation solutions

information systems

customersinformation

mainframeinformation

partnersinformation