A former Police Scotland officer who died by suicide earlier this year has been identified as a violent serial rapist who committed sexual assaults and attempted murders against women over at least 14 years.