Showing 0 projects in 00 States

Filter

FilterClose

Focus Areas

Services

Products

Other

  By State By Project
  • Air Permit Management Oregon Dept. of Environmental Quali...
    • Zoom Out
      There are no projects in this viewport.
      Zoom out to see more.
USA

Air Permit Management

The Oregon Department of Environmental Quality (DEQ) needed help in migrating and re-engineering two COOL:Gen and Oracle based information systems to a Microsoft .NET, Microsoft SQL based application architecture. Windsor Solutions provided DEQ with an enhanced Tracking, Reporting and Administration of Air Contaminated Sources (TRAACS) system that is designed to accurately and efficiently track permitting, compliance, emissions inventory and more.

BACKGROUND

The Oregon Department of Environmental Quality (DEQ) is a regulatory agency whose job is to monitor the quality of Oregon’s environment. DEQ is responsible for protecting and enhancing Oregon’s water and air quality, for cleaning up spills and releases of hazardous materials, and for managing the proper disposal of hazardous and solid wastes.

THE CHALLENGE PRESENTED

As a long-term user of the Information Engineering (IE) software development methodology and its supporting CASE tool, COOL:Gen, DEQ revised its strategic technical direction. This revision resulted in the adoption of a Microsoft centric approach to systems development, which prompted DEQ to begin the process of migrating its legacy applications from a COOL:Gen / Oracle platform to Microsoft’s .NET framework and SQL Server database environment. The final major DEQ system migration and application re engineering effort was an integrated information system used by the Air Quality program to track permitting, compliance, invoicing and emission inventory activities for regulated contaminated sources. The new application is known as the Tracking, Reporting and Administration of Air Contaminated Sources (TRAACS) system.

WINDSOR AT WORK: OUR SOLUTION

Along with the migration and re-engineering of two COOL-Gen and Oracle-based information systems, DEQ wanted Windsor to test and implement the new Tracking, Reporting and Administration of Air Contaminated Sources (TRAACS) system.

This new system had to support the following business functions:

Windsor Solutions’ approach to this large-scale migration and re-engineering effort began by gaining a detailed understanding of the data, functions and business processes supported by the current systems. Coming to this understanding required a current systems analysis, a detailed business process, and new requirement analysis activities.

Findings from the system analysis and requirement gathering activities provided Windsor and DEQ with the basis for the new application design. Design activities focused on:

  • Defining a technical architecture capable of supporting the user requirements
  • Consistency with the DEQ standards
  • Specification of a user interface and application logic that fully supported the program requirements
  • Creation of a new data structure and migration plan to move data from historical systems into TRAACS

RESULTS THAT REWARD

The Windsor-developed TRAACS application provided DEQ with a handful of benefits:

  • An integrated source of Air Quality program data
  • Drastic usability and performance improvements
  • Ability to link permitting activities with emissions inventory and invoicing data
  • Reduced maintenance cost and removal of legacy architecture dependency
  • Consistency with DEQ application architectures and standards


Details

CLIENT: Oregon Dept. of Environmental Quality
DISCIPLINES: Air
SERVICES:
PRODUCTS:

Interested in learning more?

Jason Bunker

Contact Jason Bunker
Windsor Solutions
808.447.3100 x203
Email