Both present perfect and past perfect talk about something that happened before a point in time (reference point).
In the present perfect, our reference point is the present.
In the past perfect, our reference point is in the past.
Click here for the episode text - http://www.espressoenglish.net/difference-between-present-perfect-and-past-perfect-in-english/