Andrew Powell

Lieutenant Andrew Powell was a Human male who served in Starfleet as a science officer in the late 24th century. In the 2360s, Powell was assigned to the USS Enterprise-D, under the command of Jean-Luc Picard.

Powell began dating Nurse Alyssa Ogawa in 2370, and within several months the couple were engaged to be married. Soon after the engagement, Ogawa fell pregnant with their first child, Noah Powell who was born in 2371. (TNG episodes: "Lower Decks" & "Genesis"; TTN novel: Taking Wing).

Following the destruction of the Enterprise-D later that year, Ogawa and Powell signed aboard the Sovereign-class USS Enterprise-E. Unfortunately, Powell was unfortunately killed in action during the Dominion War, and was survived by Ogawa and Noah. (TTN novel: Taking Wing

Genesis Wave continuity
In The Genesis Wave continuity, Powell and Ogawa had a girl named Suzi. The two later signed aboard the Enterprise-E in 2372, and the couple remained aboard with their daughter until at least 2377. (TNG novel: The Genesis Wave, Book 3).