Resolving data migration key to smooth tech transition

A large scale transformation program successfully transitioned data from a fragmented legacy environment to a new modern system, preserving its valuable history.

CHALLENGE

When data is migrated to new systems, the potential for information held within the source data to be lost or corrupted can be a significant project risk.


A world leading life insurance organisation acquired a bank’s life insurance business, and faced challenging contractual deadlines within which to complete the transaction.


Five aged legacy systems housed 500,000 rows of reference data associated with hundreds of life insurance products. Our client needed to migrate this data to a new policy administration system within the contractual deadlines.


Individual policy rules were embedded within old code in the price tables and, to make matters worse, the data was poorly formatted.


Consolidating and reconciling this large volume of data from the five legacy systems, while continuing to uphold the integrity of all policies required specific skillsets. 


Our client engaged Davidson Technology Consulting, utilising our subject matter expertise and skills at analysing and solving data integrity problems to ensure a seamless data transition from the fragmented legacy environment to the new system.



SOLUTION
Reference data from 250,000 policies


Based on experience gained from delivering large scale financial program transformations, our Finance Specialist developed a structured approach to address the challenge.


The process commenced by reviewing reference data from more than 250,000 policies across the five legacy systems.

 

We then evaluated 120 reference data sheets administering key elements of life insurance policies, and decoded and rewrote the rules embedded within the code of individual policies.


Designing and deploying an audit and control framework meant we could trace all data changes prior to deployment in the new system.


We ensured that actuaries in the Pricing Team and product managers were fully briefed to enable them to have a deep understanding of the changes and drive the sign-off process.


During the user acceptance testing period, we led the support team to rapidly identify and address any real world and user experience issues prior to cutover. We then led the Hypercare team following cutover to provide an elevated level of support and ensure adoption of the new system. To ensure ongoing success, we trained the client’s team and provided them with a standard operating manual.


OUTCOMES

Framework key to achieving high quality data


Cutover to the new policy administration system occurred seamlessly. Furthermore, in the subsequent weeks there was only a single Hypercare incident.


Building a robust change traceability framework ensured amendments to data throughout the reconciliation process could be tracked and audited. This was key to achieving high levels of data quality.


As a result the client could proceed with the final significant release of data, which contributed to the successful transition of customers’ life insurance products.


Share this content

The hidden edge: What volunteering taught me about leadership

by Paula Price • 27 April 2025
Senior executives are constantly navigating complex decisions, inspiring teams, driving results, and carrying the weight of corporate leadership. We are conditioned to lead — to solve, to direct, to deliver. But in this relentless drive to lead, we often forget the power of simply following. Over the years, one of the most transformative experiences in my professional development didn’t come from a boardroom, a leadership program, or a keynote at a summit. It came from volunteering. And more specifically, from being the manager of a number of high-performance rugby teams. At first glance, the role seemed simple: logistics, admin, support. Not exactly the stuff of strategic leadership. But there, on the sidelines, filling water bottles, washing jerseys, preparing paper work, and coordinating team meals, I rediscovered a truth that too many senior professionals lose touch with — the power of service, and the dignity of the roles that go unnoticed. These menial, often thankless tasks, were crucial to the team’s success. And in doing them, I was reminded of how often in our organisations we overlook the people who create the conditions for performance — the unsung operators, coordinators, assistants, and enablers. This experience fundamentally shifted the way I lead. I no longer see these roles as peripheral. I see them as the bedrock of any high-performing culture.  More importantly, stepping out of a leadership identity — even temporarily — gave me the space to remember who I am without the title. Not the CEO, not the CFO, not the strategist or the fixer — just a person in service of something greater than themselves. That humility is grounding. It makes you more empathetic, more observant, and more connected. And paradoxically, it makes you a better leader when you return to your day job.
A man and a woman are giving each other a high five in an office.

Keeping business operations on track with the right administrative talent

by Marketing Davidson • 23 April 2025
Behind every high-performing organisation is a team of administrative professionals who keep everything running smoothly.

Optimising supply chains with industry-leading talent

by Marketing Davidson • 10 April 2025
In today’s fast-paced business environment, procurement and logistics professionals are the backbone of efficient supply chains. As global challenges reshape industries, organisations must adapt by recruiting top-tier talent to ensure resilience, innovation, and sustainability.