|
Application
Usage Management Leads to $1.4M in Operating Costs Savings and Increased
IT Efficiencies
Corporate Express, a
international office products distributor, recently acquired by
Staples, built a 40 TB data
warehouse to serve as its strategic platform for
analysis of order and inventory data. While they were migrating
legacy data and concurrently doubling the size of the user
community, they called on Teleran to help reduce the costs
associated with supporting and maintaining this system over time.
Corporate Express Challenge
A service level agreement required the data warehouse to be
up and running by 7:00 a.m., Monday through Friday. However,
nightly data loads of more than 400 database tables had "hit
a performance wall". The load typically wasn’t finished
until after 8:30 a.m., 1½
hours
after the required start time. The business impact of this
delay was significant. Each morning, customer service reps must
handle millions of dollars of return products. They needed access
to this system to arrange for these return goods to be shipped
directly to another customer before those orders had to be filled
from a company warehouse and generate additional shipping expense.
Teleran Solution
Corporate
Express used iSight to evaluate whether the data that was loaded
every night was actually being used by the business. As a result
of this evaluation of users’ information usage patterns, IT
identified that over 30% of the data was unused or dormant. They
also identified that certain users were slowing the load time
processes by accessing the system during the load time window. By
deleting or archiving the unused data and by applying some iGuard
usage management policies to prevent user access during the data
load, Corporate Express was able to cut the nightly load-time by
25%.
As
a result the data warehouse was now online daily before 7:00 am,
enabling service reps to ship return goods directly to new
customers and avoid the extra shipping and handling expense. By providing this critical
information 1½ hours earlier, the company was able to reduce
shipping expenses by over $800,000 in the first 12 months. In
addition the reduced amount of data loaded and stored in the data
warehouse allowed Corporate Express to recover almost 1/3 of their
disk storage and avoid an expensive server upgrade. This saved the
company an additional $650,000, enabling Corporate Express to save
a total of $1,450,000 throgh their use of Teleran’s solution.
See
how DBAs reduce load times & support costs with iGuard and
iSight
See
how an IT VP used iSight to reduce costs
Back
to top
*All
company names and logos are trademarks or registered trademarks of their
respective companies . |
