Click here to download PDF

Technology

 

Data processing in the LIM back-office consists of a set of linked process stages which capture, archive, analyze, validate and deliver data from over 175 world wide information sources.  Inherent in this process is an elaborate range of automated and manual data checks which help insure the information is delivered both timely and accurate.  Additionally, each and every MIM database is monitored remotely in real-time for processing and system problems.

 

Processing

 

Twenty years of persistent technological problem solving and development have molded the proprietary LIM data management process into what it is today.  LIM extracts information from numerous sources, in numerous formats, and then parses and normalizes that data into a central ORACLE 10g data store.  Every original file is archived and every data value is logged and qualified producing a real historical audit of data and corrections.  Each stage of the process is monitored in real-time by a highly trained staff of data analysts who respond to problems using an automated CRM system. 

 

Cleaning

 

Alarms are triggered when expected data files are late and any new data files are automatically scanned for broad inconsistencies and content malformation.  Each time new data is exported to a client MIM database it is dynamically scanned by a set of characteristic-based data cleaning filters for irregularities.  Currently, LIM employs over 600 data cleaning filters.  When suspect data values are located, a CRM ticket is generated automatically and assigned to a LIM data analyst for immediate review.  Internally, the LIM Data Operations staff utilizes a Six Sigma approach for effective process analysis and improvement.

 

Monitoring

 

LIM is a service oriented company who keeps constant watch over every MIM database.  Each time a client MIM processes new data, that MIM sends a message to our headquarters in Austin, Texas.  The messages are classified into several buckets where they are parsed and read for errors.  Error messages automatically generate a CRM ticket notifying on duty staff to potential data or hardware problems.  This proactive approach alerts the MIM I.T. support professionals so that they can begin to diagnose problems before clients report them.

 

Measuring

 

The LIM Data Operations Team utilizes a Six Sigma approach for defining, analyzing, and managing data source and process problems.  Each phase of data processing and filtering equates to an opportunity to accurately deliver data in a timely manner.  Each time a measurement point in the data process generates an exception our integrated proprietary CRM system generates a ticket.  Each ticket is investigated for action requirements by a data analyst and all actions, ticket statistics and notes are logged and archived.  On a weekly basis we generate a granular statistical report of our archived and current tickets which is thoroughly reviewed to diagnose opportunities for better process management.  The reports generate a Six Sigma level for the process as a whole each week.  Currently with more than 180 data vendors, including all quality filters, vendor based problems, down time, and LIM generated issues, we have an average open to close time of less than 2 hours for individual tickets.

 

Summary

 

With an innovative approach to processing, cleaning, and error monitoring, LIM provides a full service back-office data solution.  In addition to core services, LIM offers highly customizable features for informed clients.  Our data management tools can provide endless variations of data intelligence, from correction notifications to advanced data filtering and calculations, to clients on demand.  The LIM data cleaning layer has the ability to send suspect data notifications to both clients and vendors the moment inconsistencies are located.

 

 


www.lim.com