Information Lifecycle Management for a Global Leader in Specialty Retail

32% Data Reduction with archive and purge solution without system disruption for EBS Financials ERP Data


  • Complex data retention requirements, required adherence to regulatory reporting for some countries in APAC
  • Company had not documented any data retention, archival or compression plan till date
  • Lack of inter-department coordination for taking decision on solution design
  • Complex on-demand query access and reporting requirements on historical data


  • Designed and implemented an On-going Information Life Cycle strategy for EBS Financials (GL, AR, AP, CE, FA), Purchasing, HR and Compensation
  • Automated purging of transient Oracle EBS data
  • Partitioning of large tables and indexes


  • Reduced size of the database by more than 32% thereby increasing storage space and increasing performance
  • Consulting workshop with insights on global data retention and regulatory requirements in retail, for IT, Legal and Business teams to learn best practices for decision making on their growing data
  • Designed & executed an effective Information Life Cycle Management strategy for ongoing management, archive and purge of historical transactions
  • Data access and reporting strategy now supports business and global regulatory requirements by following the global best practices
  • Saving time on maintenance tasks by implementing automated purging of transient Oracle EBS data
Company Overview

Headquartered in San Francisco, CA since its inception in 1969, the largest retail chain in US and 3rd largest in International Locations.



Applications & Technologies