Two (somewhat separate) questions I have are:
Is it a good approach to put performance optimization as a separate skill-set backed up by line items (instead of just 2 words in "skills")?
Do the items i put as examples below sound like useful/braggable data to distinguish oneself to a hiring technical manager (whether I put them on a resume or just mention them on interview), or are they just another reason for said manager to yawn? (I'm talking average company, not Google/FogCreek where stuff like this is probably done by flying monkeys or interns on daily basis).
E.g., in my current job, I have what I consider fairly worthy accomplishments that are nevertheless not directly part of my job function nor of main resume-able projects (in part because most were not even remotely related to my own projects/software - I was acting as a hired gun for other teams):
Redesigned a query which was in the enterprise's top 10 worst resource users on the dataserver to decrease IOs by 97-99% (Detail: it was a search for tree's leafs and I implemented very neat BFS solution without even needing to tune the indexes)
Redesigned another query that was, again, on the enterprise's top 10 worst (and also accounted for 90% IO and DB CPU usage of a very heavily used application) to improve performance 95%
Redesigned a company-wide report generation API to reduce memory consumption 99% (easy to fix - the bloody moron of a module was building 500MB+ XML strings in memory!)
Re-wrote a large reconciliation software to go from 2GB memory usage (and crashing) on 200k rows of DB data to 80Mb constant memory usage on unlimited amount of rows.
Improved throughput of a very complicated custom trade loader 99% by redesigning it to accept and optimize batches of trades. This was done in 2 days dev->staging, after the client was originally quoted 7-week estimate to fix the bottleneck almost causing them to terminate a major contract.
One worry I have is that these aren't really very special (e.g. enough to distinguish from other candidates), and as such will be just white noise on a resume.
Another worry is that they will seem as a slam on the software I was fixing (which in reality wasn't all that bad, just somewhat dated and thus not designed for incredible growth of data the firm had 3 years later. And I'd rather avoid giving the impression of putting down other people's software.
Thanks for any feedback, especially if you write it wearing your "hirer" hat.