Welcome

 THOMAS DODD AND ASSOCIATES is a consultancy that is focused on clear business analysis and bespoke IT solutions.


Our Director is Joel Dodd, who has a diverse range of professional experience and abilities.  He brings a fresh perspective to tasks, and his pragmatic versatility makes him a valued resource.  While he is more a Swiss Army knife than a magic bullet, his superpower is the ability to see through the fog and identify the true issue of a situation.

Our Values are:

  • NO jargon
  • what is right for the client 
  • Stand by all of our work
  • elegant solutions for hairy problems
  • trust and respect are earned


Profession Experience:

  • Industrial quality management system design and implementation 
  •  Educational leader:
        • Head of Faculty (Maths), 2005-2013
        • NZAMT Award winner for integrated website development to support a distance-education statistics course  
        • CORE e-Fellow for research program regarding cellphones as pedagogical tools
        •  Development and delivery of SBA cadetship program, 2023
  • Senior Business Analyst with Ministry of Social Development, 2014-2024 
  • Chair of charitable trust 2012-2024 
  • Built a viable hospitality business 2000-1


IT Skills:

Joel began programming computers in 1979, learning BASIC, and then at university he learned PASCAL with introductory FORTRAN and COBOL.  In recent years, he has:

    • developed Excel applications using VB6;
    • coded SQL queries for data extraction;
    • Developed SQL-based web dashboards;
    • Developed independent Python applications that combine data collation, analysis and graphic dashboard reporting.
    • designed, coded and written HTML web pages with CSS formatting;
    • designed and hard-coded Android apps (personal project)

Using Python to Write a Dataframe to a Google Spreadsheet

 I had all sort of issues with this one.  Multiple searches, and trying many variations of the Google API access code modules to find one th...