EN
angle-down

Sii Ukraine

SII POLAND

SII SWEDEN

Join us Contact us

Sii Ukraine

SII POLAND

SII SWEDEN

Contact us Join us

About the client

Manufacturer of trucks, buses, engines and machines. The Polish branch of the Group supports all branches of the Group in Europe with IT solutions.

The challenge

Work on many projects, among others in the area of creating reports, maintaining the wholesaler’s and the reporting platform as well as data cleaning.

What we did

Sii’s tasks included:

  • SSRS – creating and modifying reports.
  • Maintaining the wholesaler’s and the reporting platform.
  • SSIS – supplying the wholesaler’s, (a transaction base which is stores data using the star and snowflake model), through staging bases and ODS including profiling and data cleaning, data aggregation from the ASE and Parcaref application.
  • Business report platform development.
  • SQL Server – procedures collecting data for the application.
  • Maintaining a transactional base for the Hubble application.

Effects

Projects:

  • Monitoring Data Ware House – monitoring of IT notifications as well as breakdowns and defects in trucks.
  • Post-sales expenses – analysis and optimization of post-sales costs including mileages, services, repairs and truck damages.
  • An analysis of technical drawings of the truck models in order to analyze the parts used in the vehicles (original, replacement, regenerated part).
  • Defining the wear of the parts, the moment of replacement, the supply of given elements in the warehouses and at dealers’, based on a probability schedule for particular parts and the vehicle mileage.
  • Analysis of truck orders with the purpose of detecting weight and measurement anomalies between the systems of the dealers and the internal systems.
Learn more

We are constantly searching for talents

Join Sii and get a chance to work on similar projects for prestigious customers.

Änderungen im Gange

Wir aktualisieren unsere deutsche Website. Wenn Sie die Sprache wechseln, wird Ihnen die vorherige Version angezeigt.

This content is available only in English version.

Are you sure you want to leave this page?

Цей контент доступний тільки в одній мовній версії.
Ви будете перенаправлені на головну сторінку.

Ви справді бажаєте залишити цю сторінку?