Magellan Health, a healthcare management company focused on the fastest growing, most complex areas of health, including special populations, complete pharmacy benefits and other specialty areas of healthcare, was working to keep pace with the increased number of data formats that clients sent for loading. The cost, time and skilled resources required to develop custom mapping to load each customer’s data has been on the rise, making their current process prohibitive and untenable. Magellan Health needed a solution that would minimize development effort and accelerate implementation time for new data feeds, regardless of the format.
Magellan Health developed a web application that allows analysts to define layouts for each set of customer data based on test data received from that customer. Whenever a new file (with a different format/layout) needs to be loaded, a business analyst defines the meta data using the web application and the existing Informatica PowerCenter workflow loads it. No additional development effort is required. Magellan eliminated the customized developmental effort which, in turn, cuts down on time to implement new feeds. Since the business analyst specifies the mapping directly in the metadata, this also eliminates misinterpretation of business rules, which could occur during customized development which reduces testing time.