Where’s Mack?

Hi folks, it has been a while since I posted. I’m not dead or in solitary confinement.

I’ve just been busy studying Python, and it has taken a bit of my time.

I’ll post something soon….

Anybody else working on Python?


Filed under Audit

3 responses to “Where’s Mack?

  1. YT

    Congratulations! Finally you made it! I remember somewhere in your posts you mentioned that the reason you had not continued your IT security(technical) career because of the lack of programming skill. Are you learning Python for fun or work now?
    I have “studied” Python for a while. Took Google IT Automation with Python training and finished it in May. I now make sure that I spend at least half an hour everyday coding so that I can turn Python programming to a habit.


  2. John

    Congrats, I have liked the move to python very much. It is definitely programming though. Juypter notebooks can make it a lot easier to baby step your way, but it is still programming. Are you using full run scripts, or do you use more of the juypter notebook exploration approach. Which IDE are you using? I have been using Jetbeans, PyCharm Community version on top of an anaconda install. I use anaconda for notebooks but pycharm for the runtime. In typical form, for me, I ran off to build as much, as fast, as I could, which means 8 years later there are fundamentals that I discover I should have been doing from the start. But it is definitely not the same as something with an interface. Anyway good luck with your progress it is a great tool.


  3. I have been in this game for quite a long time now, and can’t help but feel a sense of deja vu regarding your programming foray. It reminds me of the very same conversations that have happened a number of times over the years in the audit community. It used to be with respect to Basic programming, then SQL, and these days it’s Python. The problem is that, historically, when auditors start programming they occasionally make errors, and these are very challenging to identify.

    Don’t get me wrong; I’m a coder myself, and realize the value that it can bring to a task. It’s just that a little bit of knowledge can be a dangerous thing in the wrong hands. The issues with spreadsheet errors have been well documented in the past, but identifying programming errors is a much more challenging exercise, and just as likely. This is the very reason that the audit analytics tools such as IDEA, ACL, or my tool Analyzer, were created. To minimize the amount of coding an auditor had to do.

    Now you are a very technical guy, and I’m sure that you will build in appropriate controls to ensure that your results are valid, but not everyone will be. From an audit management perspective, it is very hard to assess the skills of the auditor/programmer that has submitted a result, and even the most skilled programmers make errors (I have voluminous personal experience in that area). And what about the auditor who takes over responsibility for the program in the future? Your career plans are well documented in this forum, but almost everybody moves on at some point, and maintainability is a valid concern.

    Programming audit procedures is often the most expedient way to solve a problem, but it is a double-edged sword. I encourage you to continue your journey, but please be aware of the consequences embodied in that choice.



Leave a Comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.