Man who reviewed loss-making council housing company becomes its MD