John Demsey began advising for the retailer about a year ago as the company sought to revamp its beauty business.