Voor een media-bedrijf in Hilversum hebben we een online applicatie ontwikkeld om via webinterface een call-agent console instant toegang te geven tot klantendata uit verschillende lokaties.
Technieken: Java, ZK, iBatis en Spring. Ontwikkeld met MySQL, SQL Server, Talend ETL en Squirrel.
Bijzonderheden: Een centrale database geeft de klant de mogelijkheid om analyses en batch opdrachten uit te voeren terwijl het systeem door blijft werken met een eigen database. De centrale database wordt gesynchroniseerd met ETL software (Extract, Transform, Load).
Solution Components
a) Central Database
In the middle of several databases (website, call center, and others), Solvedo has designed and developed a central database
that functions as a central point of synchronization. External systems contribute to our complete knowledge of the customer, and external systems get frequent updates from whatever we changed in the central system. In this way, we get a complete idea of who our customers are, and we have created a highly robust database landscape thanks to data replication between systems. Third, each external system gets only that piece of customer data that is needed for that particular system: no leakage of potentially sensitive information is an important aspect of any information system.
that functions as a central point of synchronization. External systems contribute to our complete knowledge of the customer, and external systems get frequent updates from whatever we changed in the central system. In this way, we get a complete idea of who our customers are, and we have created a highly robust database landscape thanks to data replication between systems. Third, each external system gets only that piece of customer data that is needed for that particular system: no leakage of potentially sensitive information is an important aspect of any information system.
b) Web Application
On top of the central customer database, we designed and developed a user friendly web2.0 application with different user roles:
call agents can see who is calling and they can update caller information; headquarter personnel can create new customers and manage customer groups.
call agents can see who is calling and they can update caller information; headquarter personnel can create new customers and manage customer groups.