DHL Global Yield Management System (GYMS 2.0)

DHL Global Yield Management System (GYMS) is a crown jewel among a series of similar DHL Business Intelligence projects in SSD portfolio. Developed under the brand of Teradata company in scope of its multifaceted collaboration with the world's largest international express mail provider, GYMS represents an exemplary fuse of quality, professionalism, and teamwork between Teradata, DHL and SSD professionals. Teradata, the world's most well-known data warehousing and analytical solutions provider, has been partnering with SSD for several years for the development of highly sophisticated Business Analysis systems and reports for their DHL client.

Action
Working on this project required not only an immense breadth and depth of technical expertise but also superior teamwork and cross-cultural collaboration skills. SSD specialists were supposed to work as an integral part of Teradata in-house team of business professionals, and together with them extensively communicate with DHL business analysts and managers located in different business units all over the world. To succeed in this project, SSD

• Engaged its best Business Analysts with multi-disciplinary skills in enterprise data warehouse management, database design, data consistency analysis, query performance optimization, analytical processing, statistics, and business modeling with 8-15 years of relevant work experience in their areas of expertise.
• Sent SSD technical directors on-site to Teradata office in Prague, Czech Republic in order for them to become familiar with the system's technical architecture, get acquainted with the key people involved in the project, and learn Teradata internal company processes.
• Fully adopted Teradata project management and business procedures with a number of SSD-proposed enhancements originating from its prior experience with establishing effective business communication, as well as centralized bug tracking and change request management.
• Tightly cooperated with Teradata business and technology professionals at all stages.
• On behalf of Teradata, regularly interacted with globally-distributed DHL business analysts to actively elicit important information and feedback regarding the current and the required functionality, DHL business processes, as well as their immediate and future Business Intelligence needs.
• Kept the appropriate stakeholders informed about the data inconsistencies, tracked the details, and asked timely questions to ensure accuracy, precision and clarity of the generated reports. Tracked and effectively prioritized functionality extension requests and QA issues.
• Actively sought feedback from cross-functional Teradata and DHL professionals regarding the delivered functionality, the relevancy, accuracy and clarify of the generated reports, as well as the reliability and quality of the new system.

Product Highlights
As a result of the combined effort of Teradata and SSD professionals, the existing Global Yield Management System (GYMS 1.0) used by DHL was replaced with a substantially superior GYMS 2.0 in an extremely tight schedule with minimum to none integration & deployment issues. The distinguishing features of the new system are:

• Data Approval and Load Monitoring Tool for the consistent management and monitoring of the data load process by the responsible personnel. The tool allows for timely error detection and correction, eliminating this way the cross-divisional data consistency gaps and raising the quality of business reports.
• Redesigned Full Tariff Revenue and Effective Discounts module allowing for sophisticated groupings and calculations based on historical changes in zoning and rates data.
• Upgraded Volumetric Weight Compliance module for detecting the potential revenue loss from the incorrectly billed weight and generating many important accounting, business, and sales reports.
• Ideal Contract Tariff Revenue module allowing DHL Pricing and Yield team to assess the difference between the actual and ideal price according to the approved discount policy.
• Contract Management Reports for the assessment of customer compliance with DHL contract terms and conditions.
• Extra Charge Mapping Reports to add transparency into how the various extra charges are billed and to ensure they are mapped correctly.
• Clean Up Reports providing a high-level view to General Managers less familiar with the technical structure of the system.
• Preview Reports giving the brief description, general outline and layout of each report so that users could quickly evaluate how relevant a given report is for their immediate business needs.
• Remote Area Service Performance Reports to enhance visibility, measure the performance, assess variances and compliance of Remote Area Service with regional and global policies.
• Management Reports bringing easy-to-use standardized profitability analysis to high-level executives.
• Line Haul Simulation of transport systems allowing for the evaluation of the impact of various process changes with high aggregation level.