SYNC Technologies, Inc.

Detroit Water and Sewerage Department

Completed a large-scale, three-year, $12 million project to develop a new and comprehensive Customer Billing and Management System for the entire Department. Sync Technologies is the prime contractor and project manager for this effort, directing the work of four subcontractors.
Over the past several years, we have provided a wide range of MIS technical support services to DWSD under a multi-year, multi-million-dollar contract, including: system/network design, analysis, implementation, administration, and support. We have also provided systems integration, user support, and project management services as needed.
Designed and developed a new system interface between the Laboratory Information Management System (LIMS) and the Industrial Waste Control Database System (IWCDS) that automates the sending of work orders and parameters to LIMS, automates the sending of parameter results back to IWCDS, and creates bar code labels corresponding to the laboratory sample numbers on work orders.
Designed, developed, and implemented the IWCDS. Responsible for managing all programming, data conversion, and implementation tasks. Provide ongoing technical support for this system as needed.
Assisted in developing an interface between the IWCDS and the LIMS system that provides increased automation of laboratory sample processing. Developed and implemented additional enhancements to the IWCDS system including: merging data on industrial waste dischargers with data on related facilities and waste streams; providing a calendar-month access method for scheduled, active, and completed waste samples; and developing interfaces for various office automation programs.
Trained various types of personnel in basic, intermediate, and advanced computer skills and software applications. Continue to provide user support and training as needed. Conducted training and developed course materials for general users, specialized users, and system administrators.

Detroit Public Schools

Provide ongoing systems analysis, design, troubleshooting, and program-ming services for numerous large administrative applications.
Managed the Southeastern Constellation Project under the direction of the District’s Chief Information Officer. The purpose of this project was to assess the state of information technology in this group of schools, develop detailed, school-level technology standards, and make recommendations for improvement. The methods and standards developed during this project are being used to assist other school constellations in their implementation of technology.
Assisted the Deputy Superintendent for Information Services in long-range technology planning and in developing a comprehensive technology standards manual for the District.
In collaboration with the Office of Student Transportation, redesigned the automated scheduling system for student transportation and provided related technical support.
Conducted systems analysis for school-based local area networks including design and implementation of a prototype LAN for a major high school. The prototype was designed to run in an Ethernet, client/server, Windows/NT environment.
Implemented major enhancements for the student immunization sub-system in collaboration with the City of Detroit Health Department. This project involved satisfying state requirements for immunization including reporting, compliance, and inter-agency data exchange.
Provided ongoing technical support for a wide range of applications that run in the Comprehensive Information Management for Schools (CIMS) environment. These applications included general ledger, budgeting, purchasing, accounting, and student information systems.
Analyzed, evaluated, and improved the performance and effectiveness of administrative information processing for adult education programs.

City of Detroit Health Department

Developed a comprehensive web site for the Detroit Health Department’s Healthy Start program. Project functions include: design and layout, development, implementation, training, and integration with the departmental site. The site includes a mission statement, newsletter, description of programs and services, a resource notebook containing reference links to related resources, quarterly reports, a visitor survey, and a contact function.
Converted a Macintosh-based application to a Windows-based application in order to satisfy the following criteria: network accessibility, multi-user compatibility, Windows-NT compliance, enhanced multi-level system security, enhanced month/year-end logic and procedures, and developing and implementing detailed backup procedures. This project supported the goals of the Department’s Healthy Baby Services program.
Merged the functions of two separate applications (PC and Mac-based) into one PC-based application using MS-Access 97. This new application is now used to register clients, track expenditures, track driver performance, and provide administrative statistics for the Healthy Baby Services program.
Substantially enhanced the Department’s student immunization application in cooperation with the Detroit Public Schools. Numerous operations were converted from batch to on-line modes to facilitate reporting functions and to increase speed and efficiency of the application (e.g., immunization history, registration, billing, WIC appointment scheduling, and vital records).
Provided leadership, system design, system development. and project management for the Healthy Start Project which was jointly administered by the City of Detroit and Wayne State University. Provided technical leadership and management as well as training and planning. Designed and implemented the overall network; managed the selection, purchasing, and installation of systems; designed and coded large parts of the application.

Black and Veatch Corporation

Assisted in the conversion of industrial waste control data used by the Detroit Water and Sewerage Department (DWSD) to a new, Oracle-based Pretreatment Information Management System (PIMS). This project involves the following major tasks: data identification, data validation, assessment of conversion feasibility, data cleanup, field mapping, data extraction, review and initial testing, data loading into Oracle tables, and final unit and system testing.
Assisted in a PIMS data conversion project for the City of Los Angeles Water Department. We are (or soon will be) involved in the following specific tasks: project preparation, acceptance test plan development, data migration and population plan development, data migration and population plan delivery, data migration and population testing, acceptance test plan demonstration, database population, and acceptance testing and parallel operation support.
Analyzed and assessed laboratory instrumentation used by the City of Portland, Oregon Water Bureau and developed a plan to interface existing instruments with a proposed Oracle-based, Laboratory Information Management System (LIMS). Developed recommendations concerning upgrade/replacement of existing laboratory instrumentation.
Conducted a comprehensive Y2K evaluation of two major database systems used by DWSD to monitor and regulate industrial waste discharges. Potential Y2K-related problems were identified and analyzed and a final report was prepared for senior management recommending remedial actions and other precautions.

Urban Consulting Group

Currently engaged with the Urban Consulting Group in a project for the Detroit Public Schools to train school district staff in various types of emergency and hazardous procedures such as emergency preparedness, security awareness, safety precautions, and hazardous materials handling. The project will include a pilot phase, training, and assessment. Training will be conducted on the internet using the latest available web-based educational techniques. A learning management system (LMS) will be used to assess the effectiveness of the project and to monitor individual participation and learning.