Location: Lansing Michigan
Duration: 1 year
Positions: 1
Prefer 2 or more years criminal justice experience.
At least 2 years programming experience in Oracle DB and PL/SQL.
At least 2 years programming experience programming experience in Crystal Reports At least 5 years programming experience in Java with experience developing web services, MyEclipse development environment, Struts framework, and Google Web Toolkit (GWT).
This request for a Senior Application/Software Engineer to assist in automating manual tasks, will make the capturing of data more user- friendly and more efficient.
Objectives
• Capture additional file classes required by FBI
• Capture additional data elements required by FBI and as needed for
MICR crime reporting.
• Capture new lookup table codes and allow for maintenance of those
tables by section personnel.
• Capture law enforcement agency demographic, contact, vendor and
other historical information
• Capture law enforcement agency errors that are deleted if new
submission is accepted into database..
• Develop tools to track and trend crimes by law enforcement agency,
file class, error rates, and identify statewide fluctuations.
Develop a system to track different types of errors and their frequencies.
Develop a system to track warnings, if and when corrected
Develop a suspense file for incidents in need of attention due to errors or
warnings
Develop system to capture number of submitted incidents for different time
frames.
• Program edits and/or changes needed for MICR and National Incident
Based Reporting System (NIBRS) reporting.
• Make program changes needed for crime mapping of address
information.
• Allow XML data input formats to be accepted by MICR/NIBRS.
• Develop testing environment for vendors to use when conducting
system testing of their product.
• Identify and make changes needed for MICR portal, crime statistics
website, and Crime Reporting Database (CRDB).
Technical environment:
All work will be performed within the Criminal Justice secure network (CJIS Zone 3). The MICR system is written in Java, with an Oracle database. Ad hoc reports are written using Crystal Reports.
Description of the requested work, including deliverables and knowledge transfer The Senior Programmer/Analyst will work under the direction of DTMB, and with Crime Reporting Section (CRS) staff, to understand business needs and conduct research for improvement to the existing system.
They will review existing documents developed for improving the MICR system and specification documents developed by the FBI for state
certification to be used as guides in programming. Programmer/
Anlaysit will assist CRS staff in development of new MICR compliant specifications for agencies with vendor records management systems.
The Senior Programmer/Analyst will be required to:
• Review FBI “Property” specification document. Determine and make
changes within MICR/NIBRS program. Conduct system testing and work with CRS staff through final acceptance testing. Document changes.
• Review FBI “Location” specification document. Determine and make
changes within MICR/NIBRS program. Conduct system testing and work with CRS staff through final acceptance testing. Document changes.
• Review FBI “Cargo Theft” specification document. Determine and make
changes within MICR/NIBRS program. Conduct system testing and work with CRS staff through final acceptance testing. Document changes.
• Review FBI “File Class” specification documents (Human Trafficking/
Prostitution, etc.). Determine and make changes within MICR/NIBRS program. Conduct system testing and work with CRS staff through final acceptance testing. Document changes.
• Review existing Agency Contact, Tracking Tolerance and Suspense
(ACTTS) document. Determine ways to store all existing agency information captured in the section’s Access Database and to improve tracking and trending of each agency’s crime data. Create method for capturing errors in a suspense file until they are corrected by new agency submissions. Work with DTMB Database Administration (DBA) staff to develop system changes to the MICRDB and other databases that might be affected. Conduct testing through final acceptance and write up all related documentation.
• Enhance MICR portal application with the use of drop down choices.
Modify administrative portion with the ability to inquiry, extract a report, and modify lookup table codes for maintenance of those tables by section personnel when program edits are not required.
• Conduct research along with CRS staff on existing mapping options
currently in use and different geo-coding options. Determine if these options could be used as a layer to an existing system to map crimes by creating address data fields in MICR.
• Research, program, and document the option for vendors to submit
data in XML data input formats. Implement XML formats within MICR
transfers to NIBRS, MICR website, and CRDB if improvements to system performance can be realized.
• Develop testing environment for law enforcement Records Management
vendors to use 24 hours a day that will generate a status report of the file that was processed and whether errors occurred. The system will allow a vendor to indicate how to conduct processing prior to a file submission such that a vendor can test a single file or multiple files and be able to indicate whether or not previous files must be deleted prior to processing or appended in sequential order.
Make programming changes needed for MICR portal, crime statistics website, and CRDB due to format structures being changed by new data
elements added to the Oracle DB. Correct or add any programming
elements to stay compliant with FBI requests.
Work with section analysts to develop a new version of the MICR handbook/specification book for each program change.
Expectations for proper documentation as per DTMB’s SUITE process is required. User acceptance testing and all associated efforts must be included in the scope above.
No comments:
Post a Comment