Information Lifecycle Management for a Global Leader in Specialty Retail
Challenge
- 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
Solution
- 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
Results
- 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