Alaska Medicaid JUCE Database Support, State of Alaska, Department of Health and Social Services
Project Brief
Medicaid information is notoriously complex and voluminous, employing numerous systems at the national and state levels. A wealth of information for decision-makers is contained in these systems but accessing the information to provide meaningful reports and graphics can be extremely difficult. The systems that house the data were built to process the data rather than to report from it. To meet data storage and reporting needs, Wostmann, working with the State of Alaska Department of Health and Social Services, created the data warehouse JUCE (Juneau Claims and Eligibility). JUCE draws Medicaid eligibility and claims information dating from 1996 from existing systems.
The data in the JUCE system is used for budget analysis, for example; reporting on Medicaid spending to the State Legislature is accomplished using data extracted from JUCE. On the back end, the data in JUCE is organized and uploaded on a periodic basis using Data Warehouse structures rather than the transactional relational structures in use in typical interactive data systems. The data warehouse structures were optimized by Wostmann for retrieval and analysis of very large data sets (several million records). Wostmann provided several years of support for the JUCE system, including automating backups and assisting with developing new data products.
Deliverables: JUCE Data Warehouse design and implementation. Data system support and as-needed data product development.
Deliverables
Related Work
Cybersecurity IRS 1075 Policy Assistance – Unemployment Insurance
Cybersecurity IRS 1075 Policy Assistance – Unemployment Insurance Project Brief In 2016, the Internal Revenue Service updated security and audit requirements for Personally Identifiable [...]
Alaska DOT&PF Highway Performance Monitoring System (HPMS) and Weigh in Motion System (WIM)
Alaska DOT&PF Highway Performance Monitoring System (HPMS) and Weigh in Motion System (WIM) Project Brief The Federal Highway Administration has maintained the HPMS nationwide [...]
Alaska Medicaid JUCE Database Support, State of Alaska, Department of Health and Social Services
Alaska Medicaid JUCE Database Support, State of Alaska, Department of Health and Social Services Project Brief Medicaid information is notoriously complex and voluminous, employing [...]
State of Alaska DMV Driver Knowledge Testing System
State of Alaska DMV Driver Knowledge Testing System Project Brief The Alaska Division of Motor Vehicles administers various driver examinations for Alaska residents, from [...]
Alaska Land Mobile Radio
Alaska Land Mobile Radio Project Brief The Alaska Land Mobile Radio (ALMR) Communications System is an independent radio network for emergency responders in Alaska [...]
Statewide Enterprise Finance/HR System Implementation Support
Statewide Enterprise Finance/HR System Implementation Support Project Brief The State of Alaska knew that it had to upgrade its legacy financial, payroll, and human [...]
State of Alaska Office of the Ombudsman Requirements Analysis
State of Alaska Office of the Ombudsman Requirements Analysis Project Brief Citizens of Alaska have a recourse when they encounter what they consider improper [...]
Alaska Marine Highway Computer Assisted Crew Dispatch System Organization Review
Alaska Marine Highway Computer Assisted Crew Dispatch System Organization Review Project Brief Most communities in Southeast and Southwest Alaska are maritime, and most are [...]
Corrections – Crime Reform Business Analysis, Project Management, and Software Engineering
Corrections | Crime Reform Business Analysis, Project Management, and Software Engineering Project Brief Responding to ever-increasing costs of Corrections without assurance of the effectiveness [...]
National Marine Fisheries, eFISH Permit and Quota Management System
National Marine Fisheries, eFISH Permit and Quota Management System Project Brief Wostmann developed a public-facing website, called eFISH, for fishermen and processors in Alaska. [...]
State and Local Contracts
Wostmann & Associates has more than 25 years experience in state government technology projects. We have supported the State of Alaska in a variety of initiatives, from website and reporting systems to complex integration and enterprise systems and we welcome opportunities to any state with our experienced, senior technology professionals. We often perform our government services via our joint-venture partnership, Alaska IT Group, which combines our services with those of other leading small technology firms. Wostmann and Alaska IT Group are registered in Alaska for several IT service categories listed below. State agencies and local governments may utilize the Alaska Task Order Procurement System (TOPS) for our services or may contact us directly for more information.