I found a way to do it in author.php file
Just use the following to display the Google+ and Twitter links:
<?php
$curauth = (isset($_GET['author_name'])) ? get_user_by('slug', $author_name) : get_userdata(intval($author));
echo $curauth->googleplus;
echo $curauth->twitter;
?>