@alchemyst:
What I would to know is, through pfsense can I setup rules per user or per group as definined in active directory?
Also can pfsense report internet usage, data sent/received, sites visited, etc per user in active directory rather than IP based?
No to both. You're looking for more of a proxy server than a firewall. The Squid package can do some of that, offhand I'm not sure how much.