Data
Officer shards can be obtained from completing the following missions: Beyond Horizons, In the Failures of the Past, Ours By Might, Riddles & Miscommunications, Unmitigated, and What They Cannot Hold. Also, shards can be gained by completing Away Teams Assignments and, occasionally, through the Event Store.

Beverly Crusher
Officer shards can be obtained from completing mission A Blessing and a Bane. Also, shards can be gained through the Ultra Officer Recruit Chest and, occasionally, through Rotational Ultra Chests.

Geordi La Forge
Officer shards can be obtained from completing the following missions: Ascendant Part 10, Catalyst Part 2, and Identity Part 5. Also, shards can be gained through the Ultra Officer Recruit Chest and, occasionally, through Rotational Ultra Chests and the Event Store.

Picard
Officer shards can be obtained from 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 Unearthed Part 5. Occasionally, through Special Events and the Event Store.

Wesley Crusher
Officer shards can be obtained from completing mission A Battle for the Ages Part 1. Also, shards can be gained through the Ultra Officer Recruit Chest and, occasionally, through Rotational Ultra Chests and the Event Store.

William T. Riker
Officer shards can be obtained from completing the following missions: A Battle for the Ages Part 5, Changing Gears Part 1, 2, 3, 4, 5, Archive: The Riker Maneuver, and Nowhere to Run Part 1. Also, shards can be gained through the Ultra Officer Recruit Chest and, occasionally, through Special Events and the Event Store. You can also exchange Transporter Patterns for additional shards.

Deanna Troi
Officer shards can be obtained from 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. Also, shards can be gained through the Ultra Officer Recruit Chest and, occasionally, through Rotational Ultra Chests and the Event Store.

Worf
Officer shards can be obtained from completing the following missions: A Great Escape Part 10, A Great Escape Part 5, Brimstone Part 5, Archive: The Battle of Oltomon, Warriors Lost Part 1, 2, 3, 4, and 5. Also, shards can be gained through the Ultra Officer Recruit Chest and, occasionally, through Rotational Ultra Chests and the Event Store.

Natasha Yar
Officer shards can be obtained from completing the following missions: R&R Part 3, 6, 8, and 10. Also, shards can be gained through the Ultra Officer Recruit Chest and, occasionally, through Rotational Ultra Chests and the Event Store.