[{"projectName":"Troubleshooting PostgreSQL issues","team":[{"memberId":"cyclops","name":"Cyclops","role":"Postgres Expert"},{"memberId":"wolverine","name":"Wolverine","role":"Consultant"},{"memberId":"storm","name":"Storm","role":"DBA"},{"memberId":"beast","name":"Beast","role":"Developer"},{"memberId":"tony","name":"Tony","role":"Architect"}],"status":"active"},{"projectName":"Build new apps with MongoDB","team":[{"memberId":"tony","name":"Tony","role":"Developer"}],"status":"planned"}]

db.collection.aggregate([{$unwind:"$team"},{$group:{_id:"$team.memberId",memberName:{$first:"$team.name"},roles:{$addToSet:"$team.role"},projects:{$push:{name:"$projectName",id:"$_id",role:"$team.role"}}}}])