Seven die as heavy rain wreaks havoc in city