Montfort - being a moderator at the SDMB only works well at Mensa meetings. I kinda liked Enderw23’s suggestion except that of course it was spoiled by Frankd6.
I have another idea though (obviously not as good as the OP): voice talent cast director for the Simpsons. No one knows who that is, and you can dangle in front of them the promise that they can make a voice appearance as Bart Simpsons’s new girlfriend.
Drug dealer.
Around here, we describe a certain kind of bar as “the kind of place where the best pickup line is ‘when I was in law school…’”
Of course, the bar down the street the best pickup line is “when I was in prison…” so it probably depends a lot on the bar.
A friend of mine studied in Zaragoza for a year, and always tried to pull the “I’m a Dutch F-16 pilot” schtick. Worked like a charm, until he tried it on one particularly handsome Spanish lady, whose boyfriend turned out to be an F-16 pilot. He also turned out to be standing next to her, and was immediately all over him with all sorts of technical questions that aren’t exactly covered in FlightSimulator 2.0 
Double bummer.
Nick Mason, crap as he may be, is well known enough. That wouldn’t work. Talk about a guy who met the right people at the right time though. Isn’t this known as the Ringo Starr Syndrome? No talent, right friends.
I’m guessing that Formula One driver might actually turn some of the wimmins on. Right, ladies?
Yeah, right. If you told women in bars that you were the drummer for Pink Floyd, they’d probably offer to stand you to a Geritol.
Here, let me sing you a little song…
*To please both my parents
I’ve had to give over
And dance with the doctors and merchants and lawyers
Their manners are fine
But their feet are unsure
So I’d much rather dance with my Log Driver!
For he goes twirling, twirling down white water
That’s how the Log Driver learns to step lightly
In twirling, twirling down the river
The Log Driver’s Waltz pleases girls completely.*
I once had a man in a bar try to pick me and two of my friends up by saying that he was a school teacher on Dawson’s Creek. He could have been since Dawson’s Creek is filmed in my town. But, I don’t know why a 55 year old man would think that would enable him to pick up three 23 year old women even if it were true.
I have never been easy to pick up in a bar, but Moderator of SDMB would be very likely to catch my attention. 
Claiming to be the drummer for Pink Floyd isn’t really going to work. However, you could always claim to be one of the several musicians that tour with them. From the liner notes for Pulse which was from their last tour in '95, these people are:
Sam Brown - Backing Vocals
Jon Carin - Keyboards, Vocals
Claudia Fontaine - Backing Vocals
Durga McBroom - Backing Vocals
Dick Parry - Saxophones
Guy Pratt - Bass, Vocals
Tim Renwick - Guitars, Vocals
Gary Wallis - Percussion
As for Nick Mason’s alleged lack of talent, what about his excellent leading vocal in “One of these Days”?
Well if you were a professional lesbian…
But I’ll go with weight lifter.
(I have never picked up any one in a bar. I was picked up and dropped once though)
Yeeeeeees, Nick Mason is 54 years old and probably wouldn’t be picking up college girls.
And yeeeeeees, many people know the name Nick Mason.
and yeeeeeeeeeeeeees, many people will realize that you’re not Nick Mason.
However, most people won’t. Hey, I’m all for this fighting ignorance thing, but I’m kinda thinking that when I step into a bar, all bets are off. More to the point, perpetuating ignorance is good.
I figure that if the girl I tell it to doesn’t realize that there’s no possible way a person who was born over a decade after the band started touring could possibly be in the band…well, I can’t really be blamed for my fib, can I?
I take it you never heard of the Rolling Stones, huh?
P.J. O’Rourke once wrote that the ideal career for picking up women was war journalist (which was his job at the time). It combines the machoness of war with the intellectualism of journalism. You get credited with being a hero for exposing yourself to danger without the possible negative connotations for killing people. Your travel experiences gives you a combination of the exotic with the familiar and a “ships that pass in the night” allure (along with an excuse for not calling regularly). And it’s easy to fake: all you need is a subscription to Newsweek and a few generic anecdotes you can revise to fit some recent war.
I had a friend who would answer “superhero” when people asked what he did for a living. It worked for him (and sounded better than “computer programmer”). He was annoying that way.
I used to tell people I was running for saint. Gave out “get out of hell free” cards and everything. That didn’t work.
No idea what real profession would work…
I am.
Did you used to be an amature? Who much do you make a year? Are the benifits good? When you are on vacation are you hetero?
A war journalist would win me over in a second, no question. I’d also be swooning if he said “You know, I’ve won an Oscar.” Even though I hate the Oscars and I can’t think of the last time I agreed with them, and even if the guy said he won it for sound effecrs editing, I’d be so impressed.
Two words: freelance gynecologist.
An Oscar? I would ask for at least a Tony. The Oscars are so… common.
“Hey! A major media award! Awwwwwwwwwww…it’s a Grammy!”
The trouble with this OP is that you need a job title that implies:
and is still romantic and exciting…
The only think that I can think of that qualifies is a veterinarian. I can come up with some 3 out of 5, but the money thing is a real problem.
Perhaps this is why I’m such a flop at picking up guys at parties.
How about “professional pick-up artist”? 