Case Studies
Managing Transportation Aid Calculations Through a Secure Web Platform
Netkinetix partnered with the Wisconsin Department of Transportation to modernize WebTAS, a secure web-based platform for managing complex transportation aid calculations and funding administration across the state. The centralized solution replaced legacy systems to improve accuracy, transparency, and efficiency while streamlining program workflows.
Client Overview
WisDOT WebTAS supports the administration of transportation aid programs by managing complex calculations, eligibility rules, and funding data for local governments across Wisconsin. Netkinetix partnered with the Wisconsin Department of Transportation to design and develop a secure, web based WebTAS application that modernized program administration, improved calculation accuracy, and increased transparency. The solution streamlined data management, enforced consistent business rules, and provided reliable tools to support informed funding decisions.
- Client: Wisconsin Department of Transportation (WisDOT)
- Industry: Government and Transportation
- Solution: WebTAS Transportation Aids Management System
Results Snapshot
A secure web platform modernized transportation aid calculations while improving accuracy, transparency, and administrative efficiency.
Improved Calculation Accuracy
Automated validation and centralized data management ensure reliable transportation aid calculations.
Modernized Program Administration
A web-based platform replaced legacy mainframe tools and manual processes.
Greater Transparency and Auditability
Detailed reporting and full audit tracking provide visibility into funding calculations and approvals.
The Challenge
WisDOT administers the Transportation Aids System, which supports the calculation and distribution of General Transportation Aids and Connecting Highway Aids to local governments throughout Wisconsin. These programs require precise statutory calculations and strict validation of population, mileage, and cost data. Maintaining full auditability and data integrity is essential because funding decisions involve public resources and regulatory oversight. Legacy mainframe systems and fragmented data sources limited flexibility and increased operational risk. The existing environment made it difficult to adapt to legislative changes, support scenario modeling, and provide transparency into calculation methods and payment outcomes.
Key Challenges
- Legacy mainframe systems limiting system flexibility
- Complex statutory formulas governing transportation aid calculations
- Manual data validation processes increasing operational risk
- Limited visibility into calculation logic and payment results
- Difficulty adapting the system to legislative or program changes
WisDOT required a secure and flexible platform capable of supporting complex funding calculations while improving transparency and operational efficiency.
Our Approach
Project Approach
- Discovery sessions analyzed calculation rules, datasets, and reporting requirements
- System architecture was designed to support complex scenario modeling and validation workflows
- The platform was delivered iteratively to ensure calculation accuracy and preserve historical data
Netkinetix worked closely with WisDOT stakeholders to understand statutory requirements, legacy system behavior, and the operational workflows used to administer transportation aid programs.
This approach ensured the new system could modernize infrastructure while maintaining continuity with existing funding programs.
The Solution
Netkinetix designed and implemented WebTAS, a secure web-based application that manages the full lifecycle of transportation aid calculations and program administration. The platform centralizes data management, calculation scenarios, validation workflows, reporting, and payment exports into a single system. Role-based access controls ensure sensitive administrative processes remain secure while allowing authorized staff to manage calculations, review data, and generate funding outputs. By consolidating these capabilities into one platform, WebTAS improves both the efficiency and transparency of statewide transportation aid distribution.
Calculation & Scenario Management
The system supports complex funding calculations and scenario modeling required for transportation aid programs
- Calculation scenario management for General Transportation Aids and Connecting Highway Aids
- Automated application of statutory formulas and calculation logic
- Scenario modeling to evaluate funding distribution outcomes
Data Management & Validation
Centralized data management ensures the accuracy and consistency of the datasets used in aid calculations.
- Centralized management of local government, population, mileage, and cost data
- Data import workflows with automated validation and error detection
- Notifications and alerts for data inconsistencies or validation failures
Program Administration & Reporting
Administrative tools and reporting capabilities support program oversight and transparent funding decisions.
- Administrative tools for managing default values, line codes, population factors, and notifications
- Payment processing support including schedules, letters, and PeopleSoft export files
- Comprehensive reporting with Excel and PDF exports
- Full auditability of data changes, calculations, and approvals
The Result
WebTAS replaced a legacy mainframe system with a modern, secure web application. Accuracy and transparency improved across transportation aid calculations, manual effort was reduced through automation, and WisDOT gained greater flexibility to model scenarios and respond to legislative changes. The platform provides a reliable foundation that supports long term maintainability and program evolution.