Success story Allianz

Optimisation of Group-wide IT reporting – structured | fast | sustainable
Technical environment: SAP BW, SAS VA and Excel Macros

Logo for Allianz

Our client
Allianz SE is the holding company of the Allianz group. It is one of the world‘s leading insurance and financial services providers active in the insurance industry, pensions and asset management.

Allianz is the world‘s largest insurance company and employs a broad range of IT technologies and applications that require cost transparency at all times. The IT Reporting & Controlling department at Allianz Group IT is tasked with providing this transparency and must be able to produce current data at all times.

The target
The target of auticon‘s deployment was to optimise the detailed analysis of global IT costs at Allianz. Each quarter approximately 20,000 data records from different sources are processed for 80 different points of contact. The manual evaluation steps that were previously used needed to be replaced by automatic ones in order to minimise the error rate in reporting.

Project implementation
The auticon consultant Roland Kneer worked for more than one year on site in the „H4 – Group IT – IT Reporting & Controlling“ department. His integration into the existing team was seamless and fast. Interim results were communicated by the auticon consultant and discussed during the team meetings which were held in English. He implemented changes at all times in a very fast and reliable manner. The consultant displayed a particular talent for maintaining a precise overview; any interconnections resulting from adjustments were thought through from the start. With his assistance, the team learned to work in a very structured way with many technical intricacies that made the previous manual and error-prone solutions superfluous.

The solution
Roland Kneer first analysed the data structure for the new evaluations. „He discovered functions in SAP BW we hadn‘t known existed before that made our work a lot easier,“ said Andrea Schulz, project coordinator from Allianz. As a result, manual evaluations were automated and optimised. An external Excel consultant provided the Allianz team with confirmation: The Excel reports created by the auticon consultant are extremely well structured and use complex formulas and macros in an optimal fashion.

Client benefit
The client benefited in two ways: On a professional level the auticon consultant fulfilled the client‘s requirements completely. The solutions he created are now firmly integrated into the client‘s systems and processes. The entire team benefited from the auticon consultant‘s structured working method.

„The auticon consultant‘s technical expertise is now being implemented as best practice in our systems and processes. I can highly recommend the auticon consultant. We look forward to further cooperation
in future projects!“

Andrea Schulz | Head of IT Reporting & Controlling at Allianz Group