How to find a user's profile by his email or id?

Go to Users page and enter the user's email address in the search line. You will see all existing profiles with the specified email address in all your projects. To view the profile, click Show profile on the desired user's card.

If you exactly know the ID of the user you are looking for, then just enter it in the search line and you will immediately find yourself on the user profile page.