Optimizing SAP HANA DB Performance for a Global Audit & Consultancy Company
Faster report generation and higher user satisfaction with improved SAP HANA performance
Purposeful digital tech for businesses
About the Client
One of the leading audit and professional services firms that supports clients globally by providing a full range of consulting, risk management, legal, tax, and financial advisory services.
-
- Location: USA
- Cooperation period: 2008 - present
- Industry: Professional Services
- Employees: 100,000+
Business Challenge
Our customer has multiple DWH and BI solutions deployed on SAP HANA DB. Due to the large size of the company, and the long-term utilization of SAP HANA DB, different teams of software engineers developed the solutions at separate times. This deteriorated the system’s consistency and generated a wide range of dependencies between various reports and ETL processes. Consequently, this hampered the overall SAP HANA DB performance and resulted in:
- Prolonged period of report generation;
- Substantial financial losses due to redundant labor efforts;
- Inefficient use of hardware and IT infrastructure;
- Aggravated service quality that significantly decreased end-user satisfaction
Solution
As a long-term full value chain vendor of SAP services and solutions, Tietoevry Create offered to conduct a SAP HANA DB performance audit, a special service targeted to address the challenges related to SAP HANA DB productivity. During the performance audit, our experts:
- Analyzed the most resource-intensive SAP HANA DB objects;
- Precisely identified the code misalignments that hamper the DB performance;
- Resolved all of the DB issues in accordance with the best practices;
- Conducted an additional in-depth analysis of the general SAP HANA DB configuration for compliance with SAP recommendations.
Technologies
- SAP HANA DB
- PyCharm Community Edition
- Python 3.X.X
- SAP HANA Studio
- wkhtmltopdf tool
Business Value
By conducting the SAP HANA performance audit, our experts managed to identify and resolve all of the existing bottlenecks and mitigate a range of potential issues that could hamper DB productivity.
- Top-notch performance of the SAP HANA DB;
- Error-free DB configuration in accordance with SAP best practices;
- Enhanced analytic operations and reduced execution time of BI reports;
- Improved use of IT infrastructure;
- Significant cost-savings due to reduced labor efforts;
- Excellent service quality that resulted in higher user satisfaction.