Syncsort DMExpressREVIEWER: Joaquin Lopez, CIO for GALOSI.

BACKGROUND: Whether it is from overlooked discounts, missed credits or duplicate payments, overpayments can easily occur and take a bite into a company's profits. GALOSI is one of the most innovative service providers in the recovery auditing services industry, performing comprehensive reviews of each client's accounts payable and purchasing systems in order to detect these lost profits.

PLATFORMS: Windows 2000 Server with two CPUs.

PROBLEM SOLVED: In order to accomplish the necessary processing to find the duplicate payments, we were using Microsoft SQL 2000, but performance became an issue. We were also limited by the type of data that we could use. We need to be able to process different formats. For example, sometimes the information will be in a flat file. With SQL, we have to import the data before we can use it, so it became a two-step process. Due to these issues, we began the search for a solution that minimized the elapsed time of the application while also providing the necessary data transformation capabilities.

PRODUCT FUNCTIONALITY: Not only did Syncsort DMExpress improve the performance of the application, but it also gave us the functionality that we needed. With DMExpress, we can work directly with a flat file to redefine the record layouts and begin using the information. Once the processing is complete, we can take my output and work with that, which saves us a lot of time. It also helps that DMExpress works with meta data. We receive information from a number of different files, but we like to provide our auditors with just one because it's easier for them to examine the data. In order to do this, we'll join the files using the meta data. DMExpress also provides us with enhanced aggregation capabilities including minimum, maximum, count and average. Utilizing the DMExpress ADM component in the application, we are able to divide two numerical fields in a record to produce another field needed for analysis. The Join feature is also used to associate duplicate payments, while Summarization is used to filter by occurrence for certain payments.

STRENGTHS: DMExpress completed the processing of the large files that we deal with in a very short amount of time. Compared to just using Microsoft SQL 2000, DMExpress is approximately three to four times faster. The application incorporates DMExpress into several steps in order to determine whether or not there is a duplicate payment. Once the processing is complete, a team of auditors must visually examine the data to accurately determine that a duplicate payment has been made.

WEAKNESSES: If I want to break my data down into smaller increments, I currently need to create another process. I understand that DMExpress is being upgraded with additional functionality that will provide me with even more flexibility when using its features.

SELECTION CRITERIA: We previously used SyncSort and were well aware of the performance advantages. When we heard about the new functionality incorporated into DMExpress, we knew that this would be the right solution for our application. We were confident that we would achieve the performance that we needed, and we gained additional data transformation capabilities as well.

DELIVERABLES: The files that we receive from our clients vary in size from 50GB to 100GB. With the help of DMExpress, we are able to quickly process the data down to only the information needed, which reduces the file size. For example, a 50GB file can become 10GB after processing. Then, we only examine one vendor at a time for a customer, so the data usually consists of less than 2GB a session. This enables us to find duplicate payments in a shorter amount of time for our clients.

VENDOR SUPPORT: We decided to take advantage of Syncsort's proof of concept (POC) offer in order to test the power and performance of DMExpress in the application. For the POC, Syncsort's technical support team developed a DMExpress solution to find the duplicate payments and assisted throughout the implementation process.

DOCUMENTATION: DMExpress includes an online help feature that guides us through the development of tasks and jobs. It is very easy to use and meets our needs.

Syncsort Incorporated
50 Tice Boulevard
Woodcliff Lake, NJ 07677

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access