The Environmental Divisions of the various Federal, State, Local and even large private agencies are responsible for monitoring and tracking the disposal or reutilization of hazardous and non hazardous wastes from its various locations throughout the country. Previously used legacy stand alone applications for partially automating the business process involved in the accumulation of the waste and turn in of waste profile sheets and disposal turn-in document forms to the disposal agencies (federal, state, local or private). The applications, in this model, were standalone and had to be installed separately on each client/workstation to be used. An upgrade to the server part of the application would typically require an upgrade to the clients installed on each user workstation, adding to the maintenance cost and decreasing the overall productivity.
The clients wanted a system that encapsulates the above functionalities in addition to the following features:
- Easy to maintain
- Scalable and powerful
- Enhanced ability to handle the demanding feature list from their end users
- Easier to integrate/implement with existing systems
- Extensible to other agencies with relative ease
- .Net Compatible for enhanced features
- Ability to access over the internet vs stand alone desktops where application is installed
- A central database for real time status checking and reporting vs scattered data in standalone applications nation wide with no way of generating a nation wide or even regional reports.
The team, which comprised of functional and technical experts from both the client and iLink Systems, designed and developed an enterprise web application to automate the waste information turn in and feedback process information from the disposal agency (including DOT or private transporter funding and tracking information). The system, with its hierarchical and role based security, not only automated the work flow involved but also archived and consolidated the data contained in the central database for easy future mining, reuse and/or reference in the form of BI reports. The solution provided an efficient, maintainable, productive and scalable system. KPI’s and reports, key components, were developed to view/track all the information stored centrally in the server.
Haz Waste Disposal Automation and Tracking System is currently being used by very large Federal Defense agencies and other agencies are in the pipeline for adopting it as their single system for hazardous waste disposal. The relative ease of extending the structure of the application to adapt the hierarchical structure of each of the agencies helps reduce the development and maintenance cost as well.
Features of the system developed include –
- Ability to access data from any computer with a browser and internet connectivity
- Server upgrade wouldn’t require any change on the client side, application is compatible with all major web browsers
- Role based access (system is capable of incorporating a generic organizational hierarchy) and privileges
- Web based Reports
- Scalable & Extensible (follows web 2.0 and xml standards)
- Eliminated inconsistent and redundant data by centralized data consolidation using xml schemas.
- An extremely friendly user interface
- Built-In intelligence
- Extended feature set
- Reduced work from the user’s end
Reduced redundant data entry resulting in minimized data errors
- Reduced Development Cost
- Centralized data storage enables reduced maintenance cost and increased maintainability
- 24X7 access from any web connected PC
- Efficient communication with DRMO for electronic turn-ins and feedback
- Better organization of information resulting in increased productivity
- Easy to integrate with other enterprise applications
- Developed using three tier architecture – easily navigable user interface (UI)
- Business logic and data access from database
- Middle Tier Design: Code behind pages coded in C#
- Data Tier Design: Microsoft .NET Application Blocks, Stored procedures, Views and Tables on MS SQL Server 2012/2008/2005
- Framework: Microsoft .NET Framework 2.0
- Reports: MS SQL Server Reporting Services 2005
- Communication Protocol for electronic turn-ins and feedback: XML