Cambridge University professor Jason Arday has resigned with immediate effect amid investigations into his academic credentials and background.