420 likes | 581 Views
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
E N D
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 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 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