In a liberalised electricity market consumers are free to choose their supplier,
yet offers are hard to compare and suppliers often handle incoming inquiries
manually through e-mail and spreadsheets. This thesis presents the development of a web application that captures an inquiry in a structured form,
forwards it to several suppliers at once, and supports the entire handling
process up to the conclusion of a contract.
Requirements were captured in a use case model built in PowerDesigner,
from which the data model and the user roles were derived: customer, sales
agent, sales team leader and administrator. The application is implemented
in Node.js using the Express framework and an SQLite database. The main
contribution is a distributed handling model in which the same inquiry is
received by several competing suppliers, each processing it separately and
without visibility of the others’ work. The solution also supports uploading
scanned bills, tracking the contractual lock-in period of a metering point, live
notifications using server-sent events, and data export to CSV and XLSX.
The solution was verified with automated server-side tests and browser-
based tests. The result is a working prototype covering all modelled use cases,
showing that the proposed model is feasible provided that data separation
between competitors is strictly enforced
|
