In this video I demonstrate how to automatically populate fields in an InfoPath form with values from the SharePoint user profile store for the current logged in user.
It is important to note that this method will only work for SharePoint 2010 sites that are hosted under a web application configured for classic mode authentication. If you are using claims based authentication this method will return an error message. In the future I plan to create a video to demonstrate how to accomplish this task for a claims based SharePoint web application.
The video is about 16 minutes long.