CLIENT : Petsmart
INDUSTRY : Retail
CLIENT : Petsmart
INDUSTRY : Retail

Background

As a leading specialty retailer of services and solutions for pets, the PetSmart carries a line of more than 10,000 products, with proprietary and exclusive products counting for more than one-third of its net sales. With more than 50,000 employees working in nearly 1,500 stores across the United States and Canada, the company is as focused on caring for its team members as it is on innovating for its loyal customer base of pet owners.

Challenge

The company’s HR division that is charged with a variety of people-related functions, from hiring to internal promotions and encouraging sign-ups to the company’s 401K plan. As part of these operational processes, the company needs to run tabular reports that describe specific characteristics of their employee base – for example, a report listing all employees along with the state in which they work, their salary and pay grade. Each time the company’s HR team needed a report, however, they had to ask the IT team to create one, and a report often took two or three weeks to build.

HR-related and workforce costs represent a sizable portion of an organization’s budgets: Direct HR costs account for nearly 30 percent1 and overall workforce costs often reach 70 percent of operating expenses.2 As such, being able to report on and manage those costs is exceedingly important for organizations of all sizes.

To eliminate the long lead time in accessing information needed for daily HR processes, and to reduce the overhead associated with using IT resources to build individual reports, the client turned to ProKarma for help creating an ad-hoc, self-serving reporting solution its HR and other business divisions could use.

Solution

To address these challenges, ProKarma drew on its extensive experience in business intelligence to build a solution from the ground up. The company had billions of rows of data in its systems, because every pay period created a record for each employee, with entries for every line on the paystub, and so it needed a solution that could accommodate a large volume of data.

Because the client’s data was housed in SAP Enterprise Resource Planning (ERP) software, the ProKarma team built a data warehouse using SAP technology. ProKarma used the SAP Business Objects Business Intelligence platform to model the data in such a way that the HR and other teams were able to ask questions of the data, such as the average age or tenure of the company’s employees.

By simply launching Web-based software, a member of the client’s team could build a report in a matter of minutes, without the need to involve IT – a truly self-service model that saves the company an estimated $150,000 per year in reduced IT expenses alone for each monthly report required.

They were able to easily aggregate data across the company or a region or drill down into how much was paid to its employees on a single day. The team also created a set of customizable report templates so the client could begin using the solution quickly, with minimal effort.

One of the key components of this engagement was the partnership ProKarma established with the client, with a team of four working closely with the retailer for six months. The ProKarma team provided services across the board, from coding at the procedural-code level to training for its business and IT teams. When the engagement ended, ProKarma ensured that not only was the client’s business team self-sufficient when it came to building reports, but its IT team was also self-sufficient, with the ability to further develop the solution without additional assistance from ProKarma.

1 HR Sustainable Cost Reduction. PricewaterhouseCoopers LLP. 2009 https://www.pwc.com/us/en/peoplemanagement/assets/hre_economic_value.pdf

2 Managing an Organization’s Biggest Cost: The Workforce. Human Capital Management Institute. http://www.hcminst.com/files/OrgPlus_Total_Cost_Workforce_.pdf