About Sybase Customer Success Stories Success Stories | ||
Customer Success Story | ||||||||||||||||||||||||
S&H Solutions |
||||||||||||||||||||||||
Industry
The Modernization of an American Tradition A Sybase IQ customer since 2001, S&H Solutions has recently added an entire new layer of buying pattern analytics to the established loyalty formula. As a result, it gives S&H Solutions a leading competitive position in providing retailers with proprietary customer loyalty solutions, where retail partners can now better analyze the precise buying patterns of repeat customers.
Focused Synthesis Arises from Highly Granular Data Capturing this data at the most detailed level from the point of sale requires processing more than three and a half million customer item purchases from hundreds of stores every day. Sybase IQ provides the level of performance necessary to recognize and extract an in-depth understanding from the large accumulated reservoirs of information. Customer purchase information data is captured in detail, and stored in the S&H proprietary data warehouse, regardless of the customers’ membership status. This information can be reviewed historically to provide retailers with information on customer shopping behavior patterns and promotion acceptance. Data collection can also allow for product-type reporting including inventory management and customer response effectiveness. The various reporting that retailers have access to can provide answers to a question like: What was the promotional sales lift retention? S&H Solutions has developed very flexible reporting tools which include various drill-down capabilities for diverse user groups. The cornerstone of the analytics solution is information – massive amounts of it. The S&H data warehouse stored in Sybase IQ is close to 1.5 terabytes, compressed, which if it were uncompressed in a raw format, would require at least 3 terabytes (double the compressed size). The main individual item detail table has 4 billion rows, and joins with a 500,000 record Universal Product Code (UPC) table of product lookups. This transaction table also cross references 10 million customers selected across different combinations of hundreds of individual stores. This volume of information not only allows global trend analysis, it also provides analytics at the individual product and consumer level. Based on report results, customers can be individually identified, segmented, and offered behavior specific messaging and promotions. Each customer is identified with a member number through the S&H system located at the point of sale register. The system will notify the cashier in real-time with shopper specific details such as if the customer is a loyal or high-spending shopper. Real-time connectivity and one-to-one customer communication allows the retail partner to track customers on a continuous basis and develop high-level customer promotions and messaging to increase shopper frequency and loyalty.
Taking it Up a Notch Therefore, for competitive and operational reasons, S&H Solutions’ data team set out to increase both the speed and the flexibility of the system. The team decided to address the situation on multiple fronts: upgrade server hardware, produce a new database model, and enhance reporting capabilities.
Sybase IQ and IBM System p5™ Servers Make a Great Combination It was a wise decision. Upgrading to the IBM servers and revamping the data model dramatically increased overall system performance. This upgrade improved system responsiveness as well as allowed for substantial user-base growth. S&H Solutions also received excellent technical advice and ongoing support from Sybase. Morales recalls, “Sybase worked very effectively with us; our original configurations required specific tuning and other setting adjustments. With the initial implementation, we didn't see the performance we expected. Sybase continued to work with us and outlined adjustments that needed to be made. Immediately our performance increased dramatically.” The combination of IQ and IBM p5™ has paid a handsome dividend in the form of increased speed and capacity. The entire end-to-end process delivered a performance increase of 500%. Specifically, the pool of historical information feeding into the analytics and trend reports increased by 50%, with no impact on performance. With this improvement, S&H Solutions is able to maintain three years worth of transactional data and can immediately access it. “The IBM and Sybase IQ combination offers unbeatable cost/performance and gives S&H a competitive edge in retail analytics”, stated Steve Ritacco, chief technical officer at S&H Solutions. These changes have been well received by S&H Solution’s partners. The performance increase was certainly noticed and appreciated. The new reporting capabilities made a profound difference, especially with partner advertising campaigns. Instead of reconciling report dates with each advertising cycle, retail partners have the ability to run reports real time and assign any date period. Additionally, new software was added to the report suite to allow retailer partners the option to build unique, custom ad hoc reports. This capability has saved time and has improved their ongoing analysis capabilities. Internally, at S&H Solutions, the upgrades completely satisfied management’s requirements and the performance results were very apparent. In fact, Morales and his team gave a well received presentation discussing their successful Sybase IQ implementation at one of Sybase’s user group conference. Sam Morales stated, “Sybase IQ gives you a performance advantage and it’s also very stable. It’s been a wise investment for us. Compared to other available solutions, it's very reasonably priced.”
Increased Retailer and Consumer Loyalty
About S&H Solutions
About S&H greenpoints® |
|