John Menzer, the Wal-Mart executive behind the acquisition of UK arm Asda in 1995, is to leave the US retail giant.