Data Management Case Study
This government agency mission is to promote access to primary health care services, especially among the low-income and underserved. This is accomplished this through multiple strategies including: research and other information gathering techniques to collect and compile qualitative and quantitative information to recommend to Health Resources Services Administration-US Department of Health and Human Services (HRSA-DHHS) areas for federal designation as Health Professional Shortage Areas (HPSAs) and Medically Underserved Areas/Populations (MUAs/MUPs). The agency needed a system to compile statistics and other information and present it in tables, charts, maps, and narrative reports that are distributed to the provider community and other primary health care advocates/ partners at the local, regional, and national levels in response to information requests, to inform policy and decision making and to respond to reporting/update requirements of federal and DHMH oversight entities.
TMI provided full Software Development Lifecycle (SDLC) for a Health Tracking System. The system delivered Data Aggregation from three disparate data sources. Offered secure login and data access; calculation of provider Full Time Employees and Medicaid payments; delivered dynamic querying of the data; and generated of reports in MS Word and MS Excel, formatted for Federal Submission.
The Benefit to Government
The functionality delivered dramatically reduced the time necessary to gather information and respond to federal data calls to the Health Resources and Services Administration (HRSA). Since deploying the initial system, TMI has provided multiple system enhancements to accommodate expanded usage within the agency.