Work Advice Needed: Not SQL Related

  • My current work is an interesting place.  It is a mid-tier family run business.  There is about 1000 employees for the company spread over several states in the west/southwest of the US.  Over the course of several years and several company mergers/purchases the software processes have become muddled.  I was originally brought in to help do data integration but increasingly I find that I am doing a tech evangelist's job.  In my 20 years of working in IT, this is the first company that I have worked for where none of the employees actually trust the software.  Most business processes are built on the premise that the software is wrong and what someone wrote down is right.  So the company has finally reached a point where it cannot grow any bigger without radically changing the way it does business but, no one wants to trust software to help (ERP's, BPA, etc) without micro-managing that software (hence removing any benefit from using such).

    I like the company and the people I work with.  Do any of you wiser individuals have any advice for someone in this situation.  I want to be part of the solution and not part of the problem.

    Thanks!

  • Are the data flows documented? So someone could do a test to make sure data starting from A ends up in Q w/o being changed?

  • logitestus - Wednesday, February 7, 2018 8:46 AM

    My current work is an interesting place.  It is a mid-tier family run business.  There is about 1000 employees for the company spread over several states in the west/southwest of the US.  Over the course of several years and several company mergers/purchases the software processes have become muddled.  I was originally brought in to help do data integration but increasingly I find that I am doing a tech evangelist's job.  In my 20 years of working in IT, this is the first company that I have worked for where none of the employees actually trust the software.  Most business processes are built on the premise that the software is wrong and what someone wrote down is right.  So the company has finally reached a point where it cannot grow any bigger without radically changing the way it does business but, no one wants to trust software to help (ERP's, BPA, etc) without micro-managing that software (hence removing any benefit from using such).

    I like the company and the people I work with.  Do any of you wiser individuals have any advice for someone in this situation.  I want to be part of the solution and not part of the problem.

    Thanks!

    Does this mistrust of software go right to the top (ie, senior management)? If yes, I fear that you may be flogging a dead horse. Without high-level buy-in, this stuff is difficult to change.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • Trust is a hard thing to get back once it's lost.  If I were given the freedom to try, I'd start with a handful of smaller "wins".  If that doesn't start to grow confidence, you're likely stuck...

  • ManicStar - Wednesday, February 7, 2018 8:54 AM

    Are the data flows documented? So someone could do a test to make sure data starting from A ends up in Q w/o being changed?

    Some are but most aren't.  This is due to the "magic" of the ERP system.  Lots of custom coding that wasn't documented by the system's vendor.

  • Phil Parkin - Wednesday, February 7, 2018 8:58 AM

    logitestus - Wednesday, February 7, 2018 8:46 AM

    My current work is an interesting place.  It is a mid-tier family run business.  There is about 1000 employees for the company spread over several states in the west/southwest of the US.  Over the course of several years and several company mergers/purchases the software processes have become muddled.  I was originally brought in to help do data integration but increasingly I find that I am doing a tech evangelist's job.  In my 20 years of working in IT, this is the first company that I have worked for where none of the employees actually trust the software.  Most business processes are built on the premise that the software is wrong and what someone wrote down is right.  So the company has finally reached a point where it cannot grow any bigger without radically changing the way it does business but, no one wants to trust software to help (ERP's, BPA, etc) without micro-managing that software (hence removing any benefit from using such).

    I like the company and the people I work with.  Do any of you wiser individuals have any advice for someone in this situation.  I want to be part of the solution and not part of the problem.

    Thanks!

    Does this mistrust of software go right to the top (ie, senior management)? If yes, I fear that you may be flogging a dead horse. Without high-level buy-in, this stuff is difficult to change.

    The mistrust does reach the top in the sense that they do not trust the current systems.  They are open to new systems but due to the mistrust they tolerate zero mistakes.  I am not afraid to attempt a change but most other people are.  Most employees of this company have worked here (IT included) for over 5+ years.  I believe we can do it but due to the brow-beaten mentality most have, I am having a hard time convincing people that we can be successful.  Hence my reaching out.  Maybe, I am missing something.

  • The question you need to ask is "would my efforts to remove the doubts be successful, and would there be enough of a benefit to justify the effort"
    It may make sense to start with some detective work to uncover where this distrust began.   I'm betting that there were many hiccups at the beginning of "automation" that caused this to start, and it snowballed from there.
    Also, as a family run business, you may be fighting the "old folks" who simply do not understand technology, and subsequently, mistrust it.  There may be the left over attitude in place that technology is a necessary evil, not a useful tool.   

    I agree with Bert-701015, go for the small wins, but also want to add that you need to get some "champions" working for and with you.  

    To relate a story, at a previous position the managers of each office had a spreadsheet template that they needed to simply enter the numbers for each day and email it to accounting.  The spreadsheet automatically summed the rows via formula. In one office, the manager would enter the numbers, and then add them all up on an adding machine.  She never understood that this the spreadsheet was actually her adding machine.  That was only one example of her inability to embrace technology, and she was eventually let go.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • Thank you for your responses.  You have given me food for thought.

  • logitestus - Wednesday, February 7, 2018 10:39 AM

    Thank you for your responses.  You have given me food for thought.

    Good Luck!  if it were me, i'd probably start polishing the resume too, so i felt i had an 'out' if it starts to drive you nuts.

  • One thing to do is go find the local SQL Server User Group and go to the meetings. Open positions are often announced at the beginning of each meeting. If nothing else, you can go meet new people who can  help you land your next job.

  • Find a champion.

    You want a high level person with integrity who will work with you and support your efforts. If it's family run, someone in the family. You don't need trust and the software doesn't need trust if your champion has trust. Then, build trust in you, the process and the software through the champion.

    Without that, I'd look for work because it sounds like an ugly task.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Grant Fritchey - Thursday, February 8, 2018 4:38 AM

    Find a champion.

    You want a high level person with integrity who will work with you and support your efforts. If it's family run, someone in the family. You don't need trust and the software doesn't need trust if your champion has trust. Then, build trust in you, the process and the software through the champion.

    Without that, I'd look for work because it sounds like an ugly task.

    Thank you for the advice Grant.  It's now part of my "grand" plan.

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply