Patient Data System

Client:

Government

Category:

Data Management

Year:

2016

Patient Data System

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

Objectives

Develop a centralized database system for a surveillance program.
Enable secure and efficient data collection, management, and analysis.
Ensure seamless data transfer between field and desktop environments.
Facilitate multi-user access with role-based functionalities.
Facilitate automated data analysis, validation, and reporting using SAS and structured data storage.

Solution

Designed a secure login system that customizes access levels based on user roles.
Developed case report and additional study forms for data entry and analysis.
Implemented functionalities to import and export data between Access tables and spreadsheets.
Enabled real-time data validation with business rule enforcement for improved accuracy.
Built a front-end interface, streamlining data entry and management.
Created automated data reporting tools for document generation and analysis.
Designed a data synchronization mechanism between tablets and desktop databases.
Integrated document management to view and track associated files within the database.
Developed SAS programs for automated analysis, reporting, and business rule validation.
Created tools to import and export data between spreadsheets, Access, and SQL databases.
Provided pre-built data analysis algorithms for efficient visualization and decision-making.

Benefits

Supports thousands of records, enhancing surveillance data management.
Enables US government departments to efficiently collect and analyze data.
Improves data integrity through automated validation and structured workflows.
Streamlines report generation, reducing manual effort and improving reporting accuracy.
Enhances collaboration by allowing secure access and data transfer between devices.
Checkout Recent Cases

Our Similar Work

Data Management

Surveillance 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