(written from a Production point of view)
According to background material created for Star Trek Generations, Major General Georges E. Picard was an officer within the United Earth Space Probe Agency in 2161. He was an aide to Ambassador Thomas Vanderbilt at the founding of the Federation after the Romulan War, and he noted the irony of the ceremony taking place in the same place as the founding of the United Nations in 1945 after World War II. He was quoted as saying, "What is occurring here today is a sign that some good can come of such a scourge."
This information was stated within a newspaper article entitled "It's Federation Day!", written by Larry Nemecek. General Georges Picard was obviously intended as an ancestor of future Starfleet Captain Jean-Luc Picard, as a clipping of the article was contained within the Picard family album during the filming of Generations. Nonetheless, the clipping, and thus all information on George Picard, was never visible on-screen and is therefore non-canon. Even so, one wonders in what capacity he could have served since Captain Picard states that he was the first member of the Picard family to leave the solar system in Star Trek Nemesis.