Murray City
Murray City, Utah (population approx. 50,000) is adjacent to Salt Lake City. The Murray City web site has recently been redesigned and revamped providing improved information access and on-line applications. The On-Line Utility system was one of the applications that Murray City wanted to move directly onto the iSeries platform. This provides real time access to data and eliminates using another web application server and the associated costs for hardware, software, and programming. Hosting this application on the iSeries also means that the Murray City IS group can maintain the programs using the WebSmart IDE.
David Larsen, Director of Information Systems, and Roy Wall, Senior Programmer, evaluated and selected WebSmart from BCD and subsequently contracted the services of the BCD consulting group to assist with their initial project.
WebSmart Project
The new site includes secure login and payment processing. This allows Murray City residents to access their utility account(s), view current charges and account details and make on-line payments via credit card. Credit card payments are processed real time using a secure connection to Verisign's payment processing. If an individual is responsible for multiple accounts, they can view and apply payments to each account using a single login.
Account details include access to view payment, consumption, billing and service history. The data displayed allows the user to sort by column and drill down to view details. User's also have access to generate on-line graphs of their power, sewer and water consumption providing current period and year over year comparisons by month. Graphs can also be generated to show summaries for each type of service. If a user wants to view or print a copy of their bill they can generate a page that looks identical to the billing statement sent via mail.
Figure: Utility Billing Secured Login (Click to enlarge image and see others)
Client Comments
"ExcelSystems and BCD have been excellent to
work with. This has been one of the most satisfying experiences with a development
project I have ever encountered. The staff and management were very professional
and competent. They accommodated our installation and community needs. Everything
works the way it was planned. ExcelSystems went out of their way to work with
changes Murray City requested late in the project. We are now planning other
applications using WebSmart and ExcelSystems. I would highly recommend ExcelSystems
and BCD WebSmart IDE."
David Larsen, Director of Information Systems with Murray City
|
