Grant O'Brien, the CEO of Woolworths Australia, is to end his 28-year career with the retailer after announcing his decision to retire.