Would you tolerate, try to fix, or just leave?...
Hello all. This may be a bit of a rant, but I would like to hear some other opinions. I started out as contractor on my current job. When I started they needed a database years ago, but were just getting around to it since the work had become overwhelming. I work for a large school district. With NCLB their reporting needs exploded overnight. A woman in the assessment department had been aggregating the tests prior to my arrival. She has no degree in IT...Only a 3 day Access course. She started out with the district as a teachers aide 20 years ago. She had created an unmaintainable approach where she had a differnet DB for each and every assessment that came into the office. There were literally hundreds of .mdbs on the network, and everytime a new test came in, she started a new DB and aggregated the report by hand... printed out the report and faxed it to 150 schools. They needed way more reporting than she was able to handle and the number of tests just kept growing.
As a consultant I suggested and got a SQL server inhouse. I created them a central DB, that to date has identified 11 differnet test types that come into the dept. Each test type aggregates differently and produces approximately 6 reports each. We now deliver the reports to the schools online using Cold Fusion, and I aggregate the tests by popping off modules and stored procedures to prepopulate reporting tables (very complex reports... too much number crunching to do on the fly online) Somewhere in the middle of all of this I took a regular job in the department. I saw a great project to build, and so far I had nailed all of their requirements despite very short deadlines. The system is still a work in progress but we have come a long way. However, a new student information system comes online in the fall, and I am faced with migrating our assessment system to work with the new DB. It's a project, but nothing that I haven't tackled before.
Anyway, about 6 months ago, the director decided that she wasn't around the office enough, and put the woman who used to do the aggregation in charge of the office in her absense. This woman had been in the department the longest and knows the business well. Unfortunately, somehow, this decision put her in charge of my IT project which she is totally unqualified to do in my opinion.
She has stuck to her guns however, and made my life miserable in the meantime. She has clamped the vise grip down on me so hard that I can no longer do my work, and hitting the dealine for the migration is impossible at this point. Basically everything remains the same except for the new systems unique ID's which we will use instead of our own internall ID's that we've been using for 1 year, plus a few other enhancements. When I should be flying to hit the Fall deadline, all I have done is document to her what I will do, how I'm going to do it, when I'm going to do it... even though she doesn't understand what I'm doing at all. I must document even routine functions. The reporting tables will each have approx. three new unique ID fields from the new system, and we will drop their old replacements. It is not enough to tell her that I will work on this migration, I must now document my append queries to accomplish the task and tell her exactly what I'm doing. I've created appropriate "Roles" for the new assessment DB, but describing each roles function is not enough. I must spell out the exact permissions to each and every table for the roles to her,... just to have her turn around and ask me if she has full access. I have documented routine database functions in 2,3 sometimes 4 different ways, since she never seems to understands it no matter how I put it together. The woman can't join three tables together to get out what she wants if her life depended on it, but she insists on having input into the table design. (Can you say flat file design?) I think she wants way too much detail concerning my work, considering that she had never heard of SQL Server or a normalized DB design before I walked through the door. I find myself scheduled into meetings to re-collect requirements over and over again that I have already collected. I was told just yesterday that I am not allowed to talk to anyone in the department or ask any questions. If I need ANYTHING it is to go through her. She barely comprehends my work, yet wants full control over it. I have to document for her every added field and every added table in this migration project. She questions my motives for creating data driven structures to drive the front-end. She has access to SQL server and can pull up the schema at anytime, but since she doesn't understand the schema, I need to write every change I make down in a Word document to be handed in to her, even though she will never personally use any of the tables. When she gives me requirements, and I say that I have a good solution that will work. Does she let me go back and implement it? No. I must document my approach in 3-4 different ways and once she (sort-of) understands what I'm doing, she may let me move forward. (But she usually only lets me move forward because the dealine for the project is looming.) Then I must scramble to implement in a week what I have documented for 3 weeks. She shows her ignorance of my work when she asks questions like... "Where is the pull table?" (uuummmm in SQL Server you stupid &*($)#) She is so used to having tables spread all over the network, she still has trouble comprehending that everything is central on one box now... And this woman is managing me!!
Needless to say, my work has ground to a halt, but the deadlines have not gone away. I have been reminding everyone that if I don't move faster, we will never meet the deadline for implementation of the new system, but I continue to waste hours documenting my own activity and work day for her. Sometimes I've been given only 3 days to pull something off when I've told her it would take two weeks... She thinks one week is plenty of time to complete a new aggregation routine, despite what I say. I'm going crazy!
I have gone to the top boss and tried to confront her about this stuff. After all I have a degree in the field and 11 years experience behind me. In my prior job I was assistant project manager for a team of 13 and a number of projects. I have done a good job for them and brought them out of the DB dark ages,...AND THIS IS THE THANKS I GET.
Has anyone had a similar experience with a boss like this? I love the project but I'm ready to quit over one person. The job is close to my house and there are many other good points (benefits), but I find this treatment intolerable. I find it degrading, beneath my abilities, an insult, and possible death to my career if I can't change things. I might understand this treatment if I had repeated failures, but up until she took over, I had nailed every report and requirement given to me in a timely manner.
What to do... What to do? thoughts? Suggestions? Stories? More rants... discussions... anything... after all I'm not allowed to talk to anyone here and I'm craving some interaction while I document more stuff for Mondays endless requirement meetings that never... blah blah
(sorry so long)