Cracking the code to successful conversions: establish issue management

Let’s get this out of the way: EVERY PROJECT HAS ISSUES at one time or another. Sometimes a technical issue may need to be communicated to the project manager, escalated to gain resolution or just communicated within the project team. I seem to always hit issues during testing, and these issues never fail to keep me up at night. My issues usually revolve around:

  1. Source system data layouts or file definitions.
  2. Data quality that was overlooked in the source systems, and now must be resolved during conversion.
  3. Data volume – What? You mean 10 million records on an initial load is BAD?
  4. Data design for the target system is not optimal for query performance.
  5. Programs for the data extraction, transformation and load were not changed when the input data layout was changed, or just had a few translation issues.

I bet you figured it out by now – my life is surrounded by DATA. So, any planning and mitigation that we can do upfront to address these issues is totally worth it!

Usually early on, the project manager will create a communication plan for the project. This can be used for the following:

  1. Describes how to communicate with stakeholders and the project team (team meeting, management meetings, status reports, etc.).
  2. Describes how to escalate and resolve issues.

The second item listed above can also be described in an issue escalation plan. For BI projects, I usually just add a section to the communication plan. However, for large conversion projects, I recommend creating a separate document broken down by type of issue, such as when and when not to escalate. It should also include information about mitigation since it's usually required for a successful implementation.

What data errors have you experienced? Could better communication have helped resolve them? Share your thoughts below.

 

 

tags: data conversion, issue management

2 Comments

  1. jaap karman
    Posted July 15, 2014 at 1:52 am | Permalink

    What to think of the requirement:
    "The data, bi-report, must be approved first before it is allowed to be viewed/accessed by the operational business."

    What you are hearing is an acceptance environment for reports on operational production data.
    That is easily got confused with code management using words of "wich version", "wich release". Sometimes it is mitigated by a copy action without any documentation or statement.

    Getting trapped by the confusion caused by those words can be even worse.
    The code management is often done with mandatory guidelines. Ever tried to explain that the acceptance of production reports is not the same as acceptance of code (or machine or fixes)?

    • Joyce Norris-Montanari Joyce
      Posted July 15, 2014 at 1:45 pm | Permalink

      Good Point!

      Thank you.

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <p> <pre lang="" line="" escaped=""> <q cite=""> <strike> <strong>