Location: Columbus, OH MANDATORY REQUIREMENTS: One (1) Database Administrator and one (1) Senior IT Technical Consultant, a total of two individuals, are required to complete the Work outlined in this RFQ. In order to be eligible for further consideration, the candidates must meet the minimum requirements as indicated below: 1) Database Administrator a) Five years experience with Oracle databases, including two years experience with Oracle 8i. b) Experience with configuring Oracle Message Queuing c) Technical working knowledge of Oracle database links d) Two years technical experience developing stored procedures 2) Senior Information Technology Technical Consultant a) UNI technical configuration knowledge and experience b) Knowledge of UNI application parameters c) Three years experience using Oracle Developer Forms d) Three years experience using Oracle Developer Reports Purpose:The Ohio Department of Public Safety (ODPS) will deliver changes to the ODPS Automated Title Processing System (ATPS) and develop new system components to enable the State of Ohio to become an online update participating jurisdiction with the National Motor Vehicle Title Information System (NMVTIS). Through this effort, the State of Ohio, Bureau of Motor Vehicles (BMV) will be better prepared to fight fraudulent titling activity by identifying attempts to obtain titles for stolen vehicles or attempts to launder brand data from a legitimate vehicle title. Overview of Scope of Work: This initiative is to complete the effort to deliver changes to ODPS’ Automated Title Processing System (ATPS) and to develop new system components to enable Ohio to become an online update participating juristiction with the National Motor Vehicle Title Information System (NMVTIS). Through this effort, Ohio will be better prepared to fight fraudulent titling activity by identifying attempts to obtain titles for stolen vehicles or attempts to launder brand data from a legitimate vehicle title. Ohio is the first state to implement a true on-line update process with NMVTIS, which has resulted in problems getting the NMVTIS database synchronized with ODPS’ title database. Working to resolve these problems has lead to significant changes within the ODPS processing logic. These problems have resulted in delays designing, developing and implementing those changes. The delays have affected the ability of Ohio to proceed with performing online updates to NMVITS. As a result of these problems and delays, AAMVA has made recommendations to ODPS regarding their continuing support of Ohio’s participation with NMVTIS. As actual experience has been gained with NMVTIS, AAMVA has requested several changes be made to the ODPS system. ODPS and AAMVA have determined the extent of the needed changes and the effort needed to finish this on-line update process between ODPS and NMVTIS. To provide for reliable and efficient service, ODPS agrees that the identified changes are necessary. The Scope of Work will entail the five (5) areas listed in Objectives. The Work in these five areas will comprise the 1,100 hours needed to upgrade the ODPS system. Objectives: 1) Implementation of On-Line Updates to NMVTIS To resolve the data inconsistencies between ODPS and NMVTIS, changes are needed to the match logic in the application, to address functional issues that are directly attributable to the differences between Ohio’s titling application and the AAMVA NMVTIS model. AAMVA is requiring the changes to be made and also requiring that a full structure test be completed due to the extent of the identified changes. 2) Production Support Any time there is an outage in service between ODPS and NMVTIS, root cause analysis must be completed quickly to determine if the problem is at ODPS or NMVTIS. To provide better problem determination, the ODPS system needs to be hardened in the application and utility areas. This hardening will help ensure against problems being caused by Ohio’s system which ultimately affect AAMVA and other NMVTIS participating states. 3) Helpdesk Tool Support & Enhancements The current version of the Helpdesk tool has been designed and developed based on functionality in the application with respect to inquiries and title issuance. Since the initial design, numerous updates have been made to the tool based on ODPS’ experience and use within the Bureau of Motor Vehicles (BMV) Title Division. 4) AAMVA Requested System Changes AAMVA has requested changes be made to the ODPS system as experience with NMVTIS is gained which is showing these changes are needed to match the logic in application and to address functional issues resulting from differences between the Ohio titling application and the AAMVA NMVTIS. 5) Post Implementation Support & Training Ensure the updated processes are operating properly and will provide needed support to perform emergency problem determination and resolution. Contractor is to instruct ODPS staff in details of problem resolution involving NMVTIS as they are working together. Scope of Work: The Ohio Department of Public Safety, Administration Division, Information Technology Office (ITO) or its designee will manage the work effort to complete the development and implementation of several system changes and enhancements. The Consultant development staff shall work at the direction of the management and supervisors of the ITO or its designated project manager. Other Information Technology staff will work in conjunction with the Consultant development staff to complete the tasks to implement the enhancements and changes, and to gain knowledge transfer from the Consultants. The following outlines the major tasks to be completed within the scope of work of this contract. 1) Implementation of On-Line Updates to NMVTIS (240 hours estimated) a) Changes are needed to the match logic in the application, to address functional issues discovered during the root cause analysis of the problem. b) Repeat AAMVA-mandated structure testing for the online update modules. c) Code changes and enhancements resulting from the changes needed for existing match logic as well as any issues discovered during structure testing. d) Deployment support for the pilot and production roll-outs of the online update functionality. 2) Production Support (160 hours estimated) a) To provide better problem determination, the ODPS system needs to be hardened in the application and utility areas. This hardening will help ensure against problems being caused by the State of Ohio’s system. Additional knowledge transfer will also benefit ODPS’ staff in learning efficient problem determination. b) Changes and enhancements to existing production modules for online and unsolicited inquiries. c) Identify and resolve any defects, and enhance the online update components as may be required to move these components into production. d) Perform root cause analysis of outages, determine the impact on the application from these outages, and draft recommendations for improving and hardening the application to eliminate further occurrences of the identified outages. 3) Helpdesk Tool Support & Enhancements (200 hours estimated) a) Numerous updates have been made to the Helpdesk tool based on ODPS’ experience and use within the Bureau of Motor Vehicles (BMV). Additional enhancements, based on usage and experience are needed, and will continue to be needed for the foreseeable future. b) Change and enhance the existing Helpdesk tool to support the latest functionality deployed for online updates. c) Enhance the Helpdesk tool to pick up support for new business processes. d) Helpdesk training will be needed for the users to learn new functionality. 4) AAMVA-Requested System Changes (340 hours estimated) a) As experience has been gained with NMVTIS, AAMVA has requested several changes be made to the ODPS system. To provide for reliable and efficient service, ODPS agrees that the requested changes are necessary. The State of Ohio currently uses an AAMVA provided software product called UNI 3.1, which was the latest version of UNI available at the time the State of Ohio implemented the NMVTIS process. UNI version 4.0 is now available, and AAMVA is recommending the State of Ohio upgrade to it, and redesign the re-submit process. b) Upgrade the UNI software from version 3.1 to version 4.0. This task will require: 1. An impact analysis of the UNI software upgrade; 2. An impact analysis of the changes necessary to existing production components and changes to support processes currently in use; 3. A study of the benefits related to improved system availability; 4. Consideration of the removal of the current requirement for manual intervention when restarting UNI communications services following an outage. 5. Redesign the NMVTIS transaction re-submit process. 5) Post Implementation Support & Training (160 hours estimated) a) Post implementation support will help ensure the updated processes are operating properly, and will provide as-needed support to perform emergency problem determination and resolution. ODPS staff will work closely with the contractor to learn the details of problem resolution involving NMVTIS. The CareWorks Family of Companies is committed to providing career opportunity and growth to all Associates without regard to race, color, religion, sex, national origin, age, marital or veteran status, medical condition or disability.