Can a fantastic SAT score "pick up" a mediocre GPA?

It depends where you are applying to. SATs can save you for sure but only to an extent. For the schools you are applying to, your competition is going to have over a 4.0 with the same SAT scores as you. There's always a chance though!!