Product Launch: EWM Smart Data Import Tool
Product Launch: EWM Smart Data Import Tool
Integrating specialized technology partners with existing systems and processes can be complex and time-consuming. Transferring data from legacy systems to new platforms is fraught with difficulties. Varied data formats, inconsistent structures and manual intervention often lead to errors, delays and frustration.
Following the launch of the EWM Smart Data Import tool, we’ve seen a 70% reduction in the time and resource requirement to load client data to the EWM system. One client shared, “This is incredible, our team usually has 2 to 3 resources assigned for a few days to create these loads manually each year for annual grants, along with off cycle awards. This is going to be a huge time saver for us.” Following this fantastic feedback, we sat down with Marco Abrunhosa, Director of Analytics and Reporting Product Management, to discuss how it works and what the advantages are.
What is the Smart Data Import Tool and how does it work?
Marco: “The Smart Data Import Tool, developed by EWM, is designed to streamline the process of integrating data on to our platform. It is a revolutionary solution for effortless data integration. Simply set up your transformation rules once, and our system will store and catalog them for repeated use, ensuring a seamless and efficient data implementation process.”
What are the benefits of utilizing the Smart Data Import Tool over traditional data import methods?
Marco: “The Smart Data Import Tool ensures consistency and accuracy by defining, storing, and reusing transformation rules that can be updated and enhanced over time. This leads to substantial efficiency gains, particularly when managing large volumes of data in long-term projects. Its user-friendly interface enables non-technical users to manage data transformations, reducing dependency on specialized staff, while simplifying data integration. Automated validation features detect and flag invalid data early, cutting down on troubleshooting time and significantly reducing the effort required for implementation.“
What has been the impact following the introduction of the tool?
Marco: “Smart Data Import has really revolutionized the way in which we interact with client data at EWM. We have seen numerous cases of over 70% reduction in manual effort required to transform and load data across the lifecycle of a plan, from Annual Award Grant loads to Monthly Carry Transactions. Utilizing the tool extensively has allowed clients to focus primarily on handling the tricky exceptions, not manually transposing data from one format to another.”
