MS SQL Server Performance and tuning

I have a stored procedure that I need t have tuned...  It takes about 3 seconds to return the Rows...  According to the "BOSS" at my compaany... that's too slow...  There are other SPs that make up the page that this is attached to.  All in All the whole page takes about 11 seconds.  This SP is the most complex.

The proc is below....

      SELECT p.pid, p.project_name, p.project_Manager, p.project_Manager_email, p.project_start_date, p.project_end_date,                   
            COUNT(DISTINCT r.id) as TTLstaff,
            DATEDIFF(day,getDate(), p.project_end_date) AS DaysRemain,
            COUNT(DISTINCT d.deliverable_id) as lateDelivs,
            COUNT(DISTINCT t.task_id) as TTLTsk,                               
            COUNT(DISTINCT s.issue_id) as TTLIss,
            COUNT(DISTINCT rx.risk_id) as TTLRsk           
      FROM projects p, project_intermediate pi                      
            LEFT OUTER JOIN resources r ON (pi.pid = r.pid AND r.assigned = 1)                               
            LEFT OUTER JOIN deliverables d ON (pi.pid = d.pid AND
                  (( getDate() > d.due_date
                        and d.date_submitted IS NULL )
                              OR
                                    ( d.date_submitted > d.due_date
                                          and d.date_submitted IS NOT NULL )))          
            LEFT OUTER JOIN tasks t ON (pi.pid = t.pid) AND t.spid IS NULL                              
            LEFT OUTER JOIN issues s ON (pi.pid = s.pid) AND s.spid IS NULL                               
            LEFT OUTER JOIN risks rx ON (pi.pid = rx.pid) AND rx.spid IS NULL           
      WHERE pi.user_id = 'XXX' AND pi.pid = p.pid
      AND p.inactive = 0 AND pi.spid IS NULL  
      GROUP BY p.pid, p.project_name, p.project_Manager, p.project_end_date, p.project_Manager_email, p.project_start_date, p.project_end_date  
      ORDER BY p.pid ASC;