Regulatory archiving of the Finance application
Client: Intermarché (Les Mousquetaires) — Retail sector.
Resuming and industrialising the regulatory archiving of a very high-volume PeopleSoft FSCM Finance application, under time pressure.
Context
- Steady, significant growth in data volumes.
- Archiving operations stopped with a third-party tool, due to implementation difficulty and the inability to run regular campaigns reflecting IS changes.
- Integrity issues between the archive database and the production database.
- Application performance and availability at risk (IT infrastructure limit — Exadata), with 10 years of production stored.
Levers
Systnaps' tooled solutions and proven methodologies made it possible to:
- Process PeopleSoft FSCM (AP, AR, BI, GL): 48,918,966 invoices.
- Deliver plug & play and accelerate an urgent project during the Covid crisis.
- Train Intermarché's business-IT teams in just 3 days for full autonomy.
- Succeed with a short proof of value, validating the solution on a complex scope and framing the entire project.
Approach
- Start with a proof of value (POV) on a full, complex scope, from modelling to execution.
- Systnaps acting purely as on-demand support, ensuring the autonomy of internal teams.
- Year-by-year archiving and purging from 2011, keeping a constant production volume: the previous 3 years plus the current year.
Results
The most competitive project cost, with ROI delivered. A simple, effective methodology. Even greater, exponential gains are expected at cruising speed.
— Y. L., Head of Finance / Management Control
- Easy adoption by business teams.
- Gains after purge and reorganisation: GLPRD ~ 700 GB, i.e. 10% of total database size reclaimed by archiving and a further 5% by reorganisation.
- Night batch chain: 30-40 minutes saved out of 6 hours, i.e. 10% of total duration.