Data
Officer shards can be earned by completing the following missions: Beyond Horizons, In the Failures of the Past, Ours By Might, Riddles & Miscommunications, Unmitigated, and What They Cannot Hold. Additionally, shards can be gained by completing Away Teams Assignments and, occasionally, through Rotational Ultra Chests.

Beverly Crusher
Officer shards can be earned by completing the mission A Blessing and a Bane. Additionally, shards can be gained through the Ultra Officer Recruit chests and, occasionally, through Rotational Ultra Chests.

Geordi La Forge
Officer shards can be earned by completing the following missions: Ascendant Part 10, Catalyst Part 2, and Identity Part 5. Additionally, shards can be gained through the Ultra Officer Recruit chests and, occasionally, through Rotational Ultra Chests.

Picard
Officer shards can be earned by completing the following missions: A Blessing and a Bane V, Ascendant Part 20, Catalyst Part 1, Catalyst Part 10, The End of Everything, Unearthed Part 1 and 5. Additional shards can be found in the Offers tab and, occasionally, through Special events.

Wesley Crusher
Officer shards can be earned by completing the mission A Battle for the Ages Part 1. Additionally, shards can be gained through the Ultra Officer Recruit chests and, occasionally, through Rotational Ultra Chests.

William T. Riker
Officer shards can be earned by completing the following missions: A Battle for the Ages Part 5, Changing Gears Part 1, 2, 3, 4, 5, and Nowhere to Run Part 1. Additional shards can be found in the Ultra Officer Recruit chests and, occasionally, through Special events. You can also exchange Transporter Patterns for extra shards.

Deanna Troi
Officer shards can be earned by completing the following missions: Blooper Reel Part 5, Death & Dishonor Part 5, Epina, Fomek, The Center of Our Universe, and You Think You Know Me. Additional shards can be found in the Ultra Officer Recruit chests and, occasionally, through Rotational Ultra Chests.

Worf
Officer shards can be earned by completing the following missions: A Great Escape Part 10, A Great Escape Part 5, Brimstone Part 5, Warriors Lost Part 1, 2, 3, 4, and 5. Additional shards can be found in the Ultra Officer Recruit chests and, occasionally, through Rotational Ultra Chests.

Natasha Yar
Officer shards can be earned by completing the following missions: R&R Part 3, 6, 8, and 10. Additional shards can be found in the Ultra Officer Recruit chests and, occasionally, through Rotational Ultra Chests.