The investigator who led the Homeland Security Department’s internal review of a prostitution scandal involving Secret Service agents on assignment in Colombia in 2012 has himself resigned over an incident involving a prostitute in Florida, The New York Times reported.