Any adverse effect if we delete individual profile items that may or may not contain data ?

I want to clean up ancient, no longer relevant items prior to migrating to V5.

Do you mean custom profile fields? If so, no. It would just remove the data if you remove the profile field.