Retail veteran will take over supermarket that has lost market share and struggled to overcome IT problems