Since the mid-1990s Andrew has contributed to many prominent reference titles, including the St. James Encyclopedia of Popular Culture, the International Dictionary of Films and Filmmakers and Our Times: The Illustrated History of the 20th Century and he also helped develop the Kaplan's Career Counselor CD-ROM for InterMedia Interactive Software. Andrew is mentioned in the acknowledgements to The Dickson Baseball Dictionary (3rd edition), The New Bill James Historical Baseball Abstract, A Game of Inches, The World Series in the Deadball Era and The ESPN Baseball Encyclopedia. He has belonged to the Society for American Baseball Research for over 35 years and is a member of the Internet Baseball Writers Association of America.
Andrew is a graduate of Syracuse University with a dual bachelor's in American studies (from the school's College of Arts and Sciences) and magazine journalism (from the S.I. Newhouse School of Public Communications). While in college he wrote for the school humor magazine, worked at campus radio stations WAER and WERW and was an original writer/performer on the Null and Void comedy series which ran on University Union Television (now Citrus TV) from 1987 to 2006. During this time he was also a correspondent for the Syracuse Herald-Journal and a contributor to the Norwich, NYEvening Sun.
Andrew's distant first cousin was 1920s Broadway actress Frances Upton, and he was interviewed for On Any Given Sunday, Robert S. Lyons' biography of Upton's husband Bert Bell (2009, Temple University Press).