Register

Client
Creative Web
Date of realization
2013
Technologies
ScalaJavaSquerylPostgreSQLMondrian OLAP serverApache WicketAkkaApache POIMondrian OLAP serverSaikujQueryApache ShiroCXF REST WebservicesFlying SaucerFreemarkerNGINXJetty
Services
Architecture Analysis Development Integrations Web design Server management

The Register project is a comprehensive accounting and CRM system. We built it for Creative Web, which uses it to manage its successful projects such as obedovat.sk (sold), zzz.sk, kam.sk, camarero.sk, bookio.sk, bookio.cz, lunchtime.cz.

Challenge

Creative Web runs several successful projects with a very similar business model. It employs multiple marketers who are actively selling web presentations in different segments. With the increasing popularity of these projects, the cost of managing has been disproportionately increased and therefore Creative Web had to to solve this problem.

Analysis

In the first place, we focused on the mapping of core processes. We organized meetings with several employees in different positions. After that we were able to understand the actual problems and design the appropriate software solution. For a better mutual understanding, we've sketched the entire system as wireframes. This helped us greatly - the customer knew what he'll get and we knew what he wanted.

Solution

We designed the core of the system and the functionality of the whole ecosystem. Each module had a clearly defined responsibilities. The development of the Register had to take place in the shortest possible time. To implement the core of the system, we've chosen Scala programming language together with Squeryl ORM. We also created a templating engine based on Flyingsaucer and Freemarker in order to quickly and easily create email, order and invoice templates. One of the most crucial requirements was a comprehensive business analytics feature so we've built an OLAP database and provided a Business Inteligence tool for advanced multidimensional analytics. User authorization and authentication was built using the Apache Shiro library.

Integrations

Automated processes included payment, so we've integrated with payment gateways of several slovak banks (Tatra banka, Slovenská sporiteľňa, ČSOB, TrustPay). The implementation included integration with Flexibee and MRP accounting software for automatic, error free bookkeeping. Register was also integrated with each of the end products (obedovat.sk, zzz.sk, ...) to which it sent information about the paid services, products and received orders for new or renewed services.

Benefits for the client

After the deployment of the Register and training of the staff, the positive results came almost immediately. The time for order processing was shortened and the invoices were sent immediately to the customer. The customers data has been unified, duplicates and errors have been eliminated. Comprehensive statistics and reports have helped managers to better assess the current situation and to take appropriate measures. We have also integrated Register with accounting software, which enabled automatic invoicing.