Surveillance Data System

Client:

Government

Category:

Data Management

Year:

2013

Surveillance Data System

Software: MS Access, MS Excel
Database: SQL Server
Programming: SAS, VBA, C#

Objectives

Develop a centralized database system for a surveillance program.
Enable secure storage and retrieval of case report and study forms.
Facilitate automated data analysis, validation, and reporting using SAS and structured data storage.
Integrate business rule validations for enhanced data accuracy and quality.

Solution

Implemented SQL Server for secure and scalable data storage.
Designed a searchable database to retrieve specific case reports and study forms.
Linked data by unique identifiers to maintain consistency across multiple datasets.
Developed SAS programs for automated analysis, reporting, and business rule validation.
Created tools to import and export data between spreadsheets, Access, and SQL databases.
Built a front-end interface, streamlining data entry and management.
Enabled data transfer and updates between tablets and desktop databases.
Provided pre-built data analysis algorithms for efficient visualization and decision-making.

Benefits

Supports thousands of records, ensuring efficient case management.
Serves US government departments, enabling streamlined surveillance.
Enhances data integrity and validation through automated business rules.
Improves reporting efficiency with built-in analysis and visualization tools.
Facilitates seamless data synchronization across mobile and desktop environments.
Checkout Recent Cases

Our Similar Work

Data Management

Patient Data System

Data Management

Lab Database

Data Management

Study Data Management

Transforming complex data into actionable insights that drive better decision-making.

CAGE Code: 10WU9
Unique Entity ID (UEI): G7LHFL7UFRD5
NAICS Codes: 541511, 541512, 541690, 541720, 541611

Links

About
Contact
Services
Portfolio

Contact

mcglonedatasolutions@gmail.com

© All Copyright 2025 by McGlone Data Solutions, LLC