Working with
Download
1 / 42

Minnesota Driver Vehicle Services - PowerPoint PPT Presentation


  • 114 Views
  • Uploaded on

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 Goals. Deliver real-time data to DVS partners

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Minnesota Driver Vehicle Services' - liv


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

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
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
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 clients1
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
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 infrastructure1
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 infrastructure2
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
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 solutions1
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 solutions2
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 solutions3
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
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 yes1
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 yes2
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
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
The Development Environment

Client sends request to Web Server

Web server contacts VHI server

VHI server contacts mainframe

Data returned to VHI server

Com objects written to use com object WRQ ships with product

ASP pages display data via web server

Minnesota Driver & Vehicle Services


How the development process works1
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 works2
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 works3
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
Creating Procedures with WRQ VHI Tool

Minnesota Driver & Vehicle Services


Dvs web information services structure
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 structure1
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
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 services1
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
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 services1
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 services2
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 services3
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
Legacy DL Record

  • Courts/Law Enforcement – DL Record

Minnesota Driver & Vehicle Services


New esupport dl record
New Esupport DL Record

Minnesota Driver & Vehicle Services


New esupport dl record1
New ESupport DL Record

Convictions Only

DWI Only

Minnesota Driver & Vehicle Services


New esupport dl record2
New ESupport DL Record

What do I need to do to get reinstated?

Minnesota Driver & Vehicle Services


Information services coming in june
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 june1
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
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
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
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 vhi1
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
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 system1
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
DEMONSTRATIONS

  • MNDriveInfo.org

    • Public site for citizens

  • www.dps.state.mn.us/esupport

    • Secure site for business partners

Minnesota Driver & Vehicle Services


Demonstrations1
DEMONSTRATIONS

Minnesota Driver & Vehicle Services


ad