Expert Details
Data Quality, Data Analysis, E-discovery
ID: 725771
Pennsylvania, USA
Police departments use large volumes of information which is quite different from that of a payroll or finance system. For example, a person may use several identities (names, birth dates, social security numbers). In a police inventory system, one needs to know, e.g., that two five dollar bills are evidence, but risk management wants a total dollar value. Expert has worked in both environments.
The payroll systems (Charleston and MDS) involved about two to three thousand individuals in each. The police systems had: microfilm index (1,500,000), inventory (85,000), and person (65,000).
Education
| Year | Degree | Subject | Institution |
|---|---|---|---|
| Year: 1965 | Degree: BS | Subject: Mathematics | Institution: Case Institute of Technology |
| Year: 1968 | Degree: MS | Subject: Mathematics | Institution: University of Kentucky |
| Year: 1974 | Degree: | Subject: Operations Research | Institution: Georgia Institute of Technology |
Work History
| Years | Employer | Title | Department |
|---|---|---|---|
| Years: 2000 to 2002 | Employer: Montgomery Data Services, Inc. | Title: Consultant | Department: |
Responsibilities:He cleaned and prepared payroll data, mostly for shipping companies. |
|||
| Years | Employer | Title | Department |
| Years: 2001 to 2001 | Employer: Armstrong Atlantic State University | Title: Adjunct Faculty - Graduate School | Department: Criminal Justice, Social and Political Science |
Responsibilities:He taught: Advanced Research Methods (a required course for a Master's degree in Criminal Justice.) |
|||
| Years | Employer | Title | Department |
| Years: 1986 to 1995 | Employer: City of Savannah, Georgia | Title: Senior Systems Analyst | Department: Police Department |
Responsibilities:He coordinated data processing operations with the City Data Processing department and the Georgia Crime Information Center (GCIC). Some projects include: a PC reporting system to use mainframe data, a program to clean CAD data (allowing it to be transferred to the mainframe, and converting mainframe data to a relational database on a PC network. |
|||
| Years | Employer | Title | Department |
| Years: 1981 to 1986 | Employer: City of Charleston, South Carolina | Title: Data Processing Manager | Department: Administrative Services |
Responsibilities:He supervised the installation of personnel, payroll, and finance systems; tested and maintained systems; supervised computer programmer and computer operator. |
|||
| Years | Employer | Title | Department |
| Years: 1978 to 1981 | Employer: City of Charleston | Title: Law Enforcement Planner | Department: Police |
Responsibilities:He served as Director of Planning and Research. This included supervising crime analysis; researching, writing, and administrating law enforcement grants; serving as liaison with Charleston County Data Processing; serving as a member of the City computer selection committee. |
|||
Additional Experience
| Vendor Selection |
|---|
| He was involved in the evaluation and selection of three computer system: in Charleston, SC, a police sytem and City-wide system; in Savannah, GA, the police system. |
| Other Relevant Experience |
|---|
| He cleaned and re-formatted data involving multimillion microfilm index, property room inventory, and criminal history persons system (Savannah PD); wrote a program to clean street data for transfer of CAD (dispatch data) to mainframe (Savannah PD). Both with Montgomery Data Services and the City of Charleston, he ensured data quality. |
Fields of Expertise
computer language, database, text database, hierarchical database, data conversion, information management, e-discovery, disaster recovery, awk programming language, database design, database searching, computer processing, database programming language, batch programming language, database management, data management, information technology, high-level programming language, database management system, algorithm, management information system, data dictionary, computer software