Each of these solutions involved the following tasks in their creation:

  • Understand user needs and requirements.
  • Evaluate vitality of current systems.
  • Perform initial (and continuing) data analysis.
  • Evaluate third party systems.
  • Create the database logical design.
  • Create the database physical design.
  • Execute processing using SQL.
  • Compose and implement reports.
  • Design and execute user interfaces.
  • Integrate other internal data sources.
  • Integrate third party systems.
  • Document solutions, including audit trails.
  • Test and validate.
  • Install the system.
  • Train users and incorporate feedback.
  • Maintain, modify and improve.
  • Extend.

As tax director for two publicly traded corporations and in public practice, I have “walked the walk” by creating many mission critical systems, including the following, in two decades of Tax/IT crossover:

  • Tax operations databases.
  • Double entry tax basis reporting system.
  • Workflow management system.
  • Public partnership transfer agent system.
  • State tax apportionment.
  • Partnership income allocations and K-1 preparation.
  • Market discount/OID calculations.
  • Automated schedule M item calculation.
  • Tax deferred exchanges.
  • Corporate change of ownership matters.

Each of these exhibited the precision, control, flexibility and efficiency potentially inherent with database technology.

Tax/It Experience 

​David M. Flory
Database Technology for the Tax Function