Services Case Studies About Us News and Trends   Home
        
      Presentment
      Your Attaché
      Data Integration
      Programming
      For Printshops

      Back to Services
   GATHER, CONVERT AND FORMAT DATA.
   


Data versus Information
Data on its own has no meaning, only when interpreted by some kind of data processing system does it take on meaning and become information. To look at it another way, information is data that has been organized and presented in a systematic fashion to clarify the underlying meaning.

 

Extraction - In order to present information to someone, you need to extract the raw data for that information from one or more storage systems. Many firms rely on older mainframes that have limited output functionality. These systems tend to be very reliable and initially required a large investment of both time and money. For these two reasons, many firms wish to continue using them. This creates some intricate challenges that need to be overcome in order to get the data in a form that can be used for presentation to a client. These systems have been patched multiple times in the last 10-25 years and now consist of what is commonly referred to as spaghetti code. Experienced software professionals to augment and fix the software are harder and harder to find. While mainframes are good at performing functions that are coded into them, in comparison to today's systems they are difficult to update and their output is extremely inflexible. Via customized extraction software and its knowledge of main frame operating systems, Statement Solutions can collect your data and get it into a format that can be converted for current use.

 

Conversion - Once the data has been extracted it needs to go through a conversion process. There are often three parts to the process. Merging, data integrity validation and output formatting. Merging is when you combine two or more data sources to create the data you want available everywhere. Data integrity validation is making sure that the combined and merged data is correct and complete. Formatting is getting the extracted data to be usable by other applications for printing, presentment and management. Statement Solutions works with many different backends including:

 

•  ADP

•  Beta

•  CRI

•  SIS

•  DST – Mutual fund backend

•  PFPC – Mutual fund backend

•  SunGard/Phase 3

•  SEI – Trust Co. System

•  Credit Union System

 

Output - Using custom proprietary software for each client we are able to sort, process, calculate and validate the client's data. Once the data has been converted and validated for accuracy it is stored in a robust relational database. Unlike on a mainframe, all the data within the database can be queried and acted upon. This flexibility lets you look at the data in meaningful ways for your clients as well as for your business. After the data is stored, it can be formatted for various types of output.

 

Choose your format and Statement Solutions will put your data into it. Most clients implement:

•  PDF

•  Word

•  Excel

•  Jpeg

•  Tiff

•  Html

•  Xml

 

Others are available and used on a case by case basis.

  © Statement Solutions, LLC 1995-2024 All Rights Reserved Site design by Studio Two.