@aghazalynot sure what your queries are since you didn't share, but here's how I'm doing it. Query the AssignmentTimePhasedDataSet, Projects, and Resources table. Assignments contains "actual work" (which come from time submitted via timesheets [we have "protected actuals" enabled"]). Link to information about the person from the resources table (like name, team, etc) by joining on Resource ID. Add in information about the assignment (like project name) by joining on the ProjectID.
As a partial example, here's the odata query I use against the assignments: