Windows account with profile - role information from sql with asp.net
===

I am looking for best practice for our asp.net web users that connect to our web sites.  This is intranet (within our organization) only.  We currently use Identity.Name to get their domain account and look up additional information about them in custom code in each application based on Identity.Name.  This is working however I would like to better connect via custom ProfileProvider and RolesProvider.
We are using c#, .net 4, webforms and mvc.

Ideally, we could put configuration within the machine.config so that user information would be available for our developers automatically.  Is using custom profile / roles provider going to work?  thx