The man responsible for rolling out open banking has resigned after an independent investigation into allegations of bullying and intimidation.