Return to the Home Page
 

Not only did Estrada
Consulting have both knowledge and a clear understanding of our requirements, but their knowledge and adherence to Project Management principals were critical to the success of this project as well.

 

State of CA – Dept of Mental Health, Office of HIPAA Compliance

 

State of Colorado – Dept. of Wildlife – Refunds Processing Migration

 

Background
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.

 

Business Case

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.

 

Solution

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).

 

Highlights

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 Role

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
Technologies

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



 

 

Home | Services | Solutions | News & Events | Jobs
Systems Integration | Business Intelligence | Microsoft Solutions | Legacy | Project Management