Skanska CD-Control System

COUNTRY: Poland, International project

SECTOR: Real estate

SERVICES: Business Intelligence, Data warehouses, Dedicated solution

AREA: .NET, Microsoft SQL Server, QlikView

Skanska CD-Control System

As part of the greenfield project, a system was developed that standardized the methods of analysis and reporting in various European company’s branches. The office space developer operating within the Skanska group was looking for a solution that would unify the methods of project management within the company’s European branches in Poland, Hungary, Romania, and the Czech Republic.

The need

As part of the greenfield project, a system was developed that standardized the methods of analysis and reporting in various European company’s branches.

The office space developer operating within the Skanska group was looking for a solution that would unify the methods of project management within the company’s European branches in Poland, Hungary, Romania, and the Czech Republic.

Goal

The main task in the project was to create an application that would support the forecasting, planning and budgeting processes. The system was to consist of three separate modules:

  • Web application for data input, written in .NET.
  • Data warehouse based on MS SQL Server solutions,
  • Reporting environment based on the QlikView platform.
Challenges

During this implementation, a team of JCommerce specialists had to deal with the limited time schedule and changes introduced during the project. The system itself had a complicated business logic, which was to meet the expectations of various user groups, both at the central level and in the multinational branches of the company.

Solution

JCommerce’s project team consisting of .NET developers, Business Intelligence specialists in QlikView technology, and data warehouse engineers fulfilled the client’s vision within the assumed time. Our team was responsible for the entire solution, both in terms of technological development and implementation. During the project, JCommerce coordinated the work carried out by other external companies.

The developed system is integrated with the client’s external systems (Korab, Axapta, ExOpen, HFM) and has functionalities that are key from the business perspective:

  • Forms for input of data on planned and ongoing projects
  • List of tenants
  • Project profit report
  • Posted and planned costs report
  • A set of financial reports in QlikView

The implementation of the system has resulted in the unification of project management methods within European branches (Poland, Hungary, Romania, and the Czech Republic). A centralized space for data storage was created (previously, data was scattered over many systems and spreadsheet files). Thanks to QlikView, managers gained quick access to clear reports in real time.

We appreciated mutual trust and transparent strategy in the project realization. Some phases of the projects have been accomplished under very strict time constraints and we were pleased with the flexibility of JCommerce to scale up the project resources when needed.

Peter Beres, BU Controlling Manager at Skanska
Business benefits
  • All branches within CDE use one project planning system
  • Employees in all branches of CDE work in the same way
  • A centralized place for data entry (previously data was spread out over many systems and spreadsheet files)
  • Easy access to clear reports thanks to QlikView
Technologies

ASP.NET MVC 5, Telerik Controls, jQuery and MS SQL Server 2012 technologies were used to develop the web application. The data warehouse was based on MS SQL Server Database and MS SQL Server Integration Services, and the QlikView Server 12 platform was used to create the analytical and reporting system.

About the client

Skanska Property Poland Sp. z o.o. – a leader in the construction and development industry, operating on selected markets in Europe and North America. Skanska Property in all its projects focuses on innovation, sustainable development and harmonious integration of its buildings with the existing urban infrastructure.

Other clients' projects

OUR CLIENTS

Looking for developers or experienced team?

Contact us