State of Colorado – Dept. of Wildlife – Refunds Processing Migration
The Colorado Department of Natural Resources, Division of Wildlife (CDNR-CDW) maintained
several legacy software applications that utilized outdated technology, and were
no longer efficiently providing the integration capability required to support Department
operations. The primary goal of this project was to re-develop several legacy systems
using modern technology as outlined by the current Division of Wildlife’s Information
Technology Architectural Standards. The redeveloped applications were to inherit
the legacy system’s requirements, specifications and functional capabilities; while
also allowing critical changes to be made in order to satisfy any regulatory requirements,
or unavoidable business process changes.
The Colorado Department of Natural Resources, Division of Wildlife (CDNR-CDW) was spending an inordinate amount of time and money maintaining their collection of legacy applications that included:
Colorado Outdoor Recreation Information System (CORIS): a High Volume Refunds Processing system, Cash Management system, Hunter Education system, and a License Administration system. In addition, CDW required the development of a custom Workflow Foundation for increasing the automation and efficiency of their batch processing activities.
The department’s existing legacy systems did not meet the CDW Information Technology Architectural Standards. This meant that any new application and infrastructure components were to be developed to meet CDNR-CDW’s current Information Technology Architectural Standards.
The CDNR-CDW selected Estrada Consulting, Inc. (ECI) and their team of Service Oriented Architecture (SOA) development experts to design and build a suite of new Microsoft .NET applications to meet the needs of CDNR-CDW as follows:
High Volume Refunds Processing System
ECI worked collaboratively with CDNR-CDW stakeholders and IT resources to co‐develop
a new High Volume Refunds Processing System that provides the same core functionality as the legacy Colorado Outdoor Recreation
Information System (CORIS). The new system uses a custom developed Workflow Foundation Framework that leverages Microsoft
.NET Windows Workflow Foundation (WF), and provides the following functionality:
- Automated refund processing that exceeds
the performance of the legacy CORIS application
- Dual system modes of operation (“Proof” and “Print” modes)
-
“Proof” mode allows an operator to generate a Refunds Register for verifying refund processing
- “Print” mode will generate a Refunds Payment Voucher file, a printable Refunds Register, and initiate customer account transactions to clear the customer account
balance.
- User configurable messaging modes allow for screen messaging to be;
- Turned ON (messages are both displayed on the screen and logged to a file), or
- Turned OFF (messages logged to a file only, and user interaction can be required in some workflow scenarios)
- Refunds can be processed based on various input parameters including:
- Primary Draw
- Leftover Draw
- Species of animal to be hunted
- Re-engineered the Refunds Process that supports the automation goals of the new High Volume Refund Processing System.
ECI successfully implemented this new system by developing a suite of services provided
by Microsoft .NET Windows Communication Foundation (WCF) that support data contracts, message contracts, service contracts,
service implementations, and fault contracts.
ECI also developed a custom user interface using Microsoft .NET / ASP.Net
that allows users to set processing input parameters, and provide feedback to the user during processing. This included
development of Microsoft SQL Server stored procedures for CRUD (Create, Retrieve, Update and Delete) operations, and successful
unit and system testing.
Cash Management System
ECI worked collaboratively with CDNR-CDW stakeholders and IT resources to
co‐develop a new Cash Management System that replaced the legacy processin capability of the Colorado Outdoor Recreation
Information System (CORIS). The new system was developed as a Microsoft .Net Smart Client solution that uses a custom developed
Workflow Foundation Framework which leverages Microsoft .NET Windows Workflow Foundation (WF), and provides the following
functionality:
- User authentication and authorization
- Customer Account Maintenance: allows users to view and maintain customer transaction records associated with a specific draw.
- Post-Refund Account Maintenance
- Landowner Parcel Account Maintenance: provides Parcel Application management and search capability
ECI successfully implemented this new system by
developing a suite of services provided by Microsoft .NET Windows Communication Foundation (WCF) that support data contracts,
message contracts, service contracts, service implementations, and fault contracts. Microsoft SQL Server stored procedures
were developed for CRUD (Create, Retrieve, Update and Delete) operations.
Workflow Foundation Framework
ECI worked collaboratively with CDNR-CDW stakeholders and IT resources to co‐develop a Workflow Foundation Framework using Microsoft .Net Windows Workflow
Foundation (WF). This framework facilitates the development of large scale database batch processing that includes:
- Database Platform flexibility: can easily be configured to run on Informix 9.1 database, Informix Dynamic Server 9.40, or Microsoft
SQL Server 2005 database platforms.
- Allows for asynchronous monitoring and reporting of workflow Activity status by/to
end users.
- Will facilitate development of future batch processes associated with Limited Licensing.
ECI successfully implemented
the framework by developing a suite of services provided by Microsoft .NET Windows Communication Foundation (WCF) that support
data contracts, message contracts, service contracts, service implementations, and fault contracts – as well as a suite
of workflow processes provided by the custom Workflow Foundation Framework developed using Microsoft .Net Windows Workflow
Foundation (WF).
Serviced Oriented Architecture
ECI developed the CDNR-CDW solution by way of a Service Oriented Architecture (SOA) that provides methods for systems development and integration, packaged as interoperable services. A SOA infrastructure allows different applications to exchange data with one another. Service-orientation aims at a loose coupling of services with operating systems, programming languages and other technologies that serve as the framework for applications. SOA separates functions into distinct units, or services, which developers make accessible over a network. This insures that users can combine and reuse them in the production of applications. Communication is facilitated by passing data from one service to another, or by coordinating an activity between two or more services using Microsoft .NET Windows Communication Foundation (WCF).
Workflow Based Solution
The term workflow is used in computer programming to capture and develop human-to-machine interaction. Workflow-enabled software aims to provide end users with an easier way to orchestrate or execute complex processing of data in a visual form, without the need to understand computers or programming. ECI developed the CDNR-CDW solution to enable workflow through the use of the Microsoft .Net Windows Workflow Foundation (WF) allows programmers to define, execute and manage workflows. Workflow communication is facilitated by Windows Communication Foundation (WCF) which provides a service interface for interacting with Workflow activities.
OSHPD realized many expected and unexpected benefits from the development of a new Annual Financial Database including:
ECI’s team of consultants has been instrumental in the successful implementation of the CDNR-CDW applications and infrastructure. ECI’s responsibilities included:
- Systems Analysis and Design
- Application Architecture
- Application Development
- Database Design
- Testing / Quality Assurance
- Documentation
- Knowledge Transfer / Training
ECI’s team of consultants used the latest tools and technologies to deploy the solution at CDNR-CDW including:
- Microsoft Visual Studio.NET 2008
- Microsoft .NET Framework 3.5
- Microsoft C#
- Microsoft Winforms
- Microsoft .Net Windows Communication Foundation (WCF)
- Microsoft .Net Windows Workflow Foundation (WF)
- Microsoft SQL Server 2005 Reporting Services (SSRS)
- Microsoft Enterprise Library
- Microsoft Web Service Software Factory
- Microsoft SQL Server 2005 Database
- Informix 9.x
- Microsoft Windows Server 2003
- Microsoft Visual Source Safe
|