John Lewis Partnership executive Richard Mayfield will join Asda as its new chief financial officer this summer, the company has revealed.