A couple of years ago our department was getting reams of printouts. I thought, “Why do we need all of this paper? If we got rid of it, then we’d save money and resources and I could demonstrate that we did not have to be in a central location to do our jobs and maybe they’ll let me telecommute.” So I presented my idea to the boss, and followed through with the Programming department so that our reports would be written to datasets instead of being printed on paper. If we had a direct contract with the people who leased us the printers, we would have saved about $2,000,000 in printing costs per year. As it was, we probably saved about $20,000 in actual printing costs. The company could negotiate a new contract later to save more money. And this is money that would be saved every year. Now, it’s an accepted practice in business to award 10% of the money saved to the employee whose idea it was. Except in my company. I saved the company at least $20,000 that year (and subsequent years), but I didn’t get squat.
We were getting Business relogs from the Consumer division. Many of these records were being dropped instead of being loaded into the database because of “bad addresses”. Turns out that many of those records had secondary addresses that shifted the city and state. So I modified the program. The program also used a more “intelligent” method of getting the a/r number that prevented many records from being dropped as duplicates. I also wrote a “DO-WHILE” loop to look for ZIP codes and to put them in the appropriate place. As long as I was in there, I converted the “ASCII dots” to spaces which made the data look better, and got rid of the foreign addresses. This is for Trade data. I also wrote a similar program “from scratch” that would process the Collection data. More entities on the database = more revenue for the company. “I done good.”
Many records were dropping because they had foreign addresses. This was a problem because if the foreign records exceeded 5% they were written to a report – but the reports had ALL of the rejects, not just foreign ones. We had to look at the data and determine why records were dropping. With the foreign records, we had to “research” them every month – and there were a lot of them.
I wrote a program that would drop the foreign records and thus save us all a lot of work. People really liked it. But then I got to thinking…
Why not keep the foreign records? They want our business to expand; why not expand north of the border? So I collected about 550,000 records in two months. I took my findings to the Vice President and suggested that since we’re getting the data “for free” from U.S. companies that are already sending us data, why not use them? She thought it was a good idea.
After our all hands meeting in October I approached the president of North American operations and told him about my idea to expand our business to include Canadian companies. He said it was a good idea, and that the VP had mentioned it to him. What she didn’t tell him was that it was my idea. He thought it was hers.
All of that is to point out that I was A) focused on the well-being of the company, and B) that I was actively seeking solutions to problems and also taking steps that would expand our operations.
I was laid off; and they kept someone who didn’t know as much as I do and who won’t even talk to internal customers, let alone external ones.
Go figure.