Scalefree – Case Studies – Faster Generation of Business Documents for a Tech Company

About the Client

The client was one of the world’s leading technology companies for innovative digital meter technology in the energy industry. The German based company with 300 employees operates in more than 50 countries and has installed more than 8 million devices worldwide.

Problem Statement

The client needed faster generation of electronic bills to optimize and accelerate business processes.

The problems the companies faced were:

  • The client wanted to format their electronic delivery bills from one format to another. 
  • For this, they used an automation tool, but the process was not very time efficient and the reformatting took too much time.

The Challenge

  • A solution was already available but not efficient enough. A complete solution had to be reworked.
  • There needed to be a change from relational format to hierarchical format for fast generating processes.
  • It was necessary to move customers away from the automation tool and introduce a new solution.

The client and Scalefree decided to face these issues together and implement an ideal solution.

The Solution

The client selected Scalefree as its consulting partner and: 

  • Instead of an ETL tool (Extract, Transform, Load), a pure SQL script was implemented.
  • The SQL script is based on an Oracle PL/SQL extension that uses Oracle functions to format electronic delivery bills from SQL into the target XML format.
  • The script exports the electronic delivery bills in a much faster time, previously with the ETL tool the time it took to generate the was several hours. With the SQL script, exporting takes only minutes.

Tangible Results for the Client

The quicker generation of electronic delivery bills allows the company to work more efficiently. Business processes have been optimized and accelerated.

In addition, the know-how of the power users has been expanded and they are now in a position to continue to proceed with the solution independently.

Technologies used

  • SQL
  • Oracle

Interested in learning more? Get the detailed case study!

Julian Brunner Senior Consultant

Julian Brunner
Senior Consultant

Phone: +49 511 87989342
Mobile: +49 171 9127711

Schedule Your
Free Initial Consultation