Case Study: Leading Full-Service Logistics Company achieves unified revenue data reporting with Marcum LLP

Marcum Technology's Intelligent Prism Solution Delivers Advanced Data Transformation Services to Meet Client’s Compressed Timeline

Leading Full-Service Logistics Company, a nationwide and international logistics provider headquartered in New York, needed to gather monthly revenue by customer and division for 2017 to 2019. With data spread across roughly 14 ERP systems and multiple file formats, the company turned to Marcum LLP and its Intelligent Prism solution for a fast, easy-to-read consolidated data set under a tight deadline.

Marcum LLP worked with the client to define a common revenue format, then used macros and other data transformation techniques to extract, normalize, and aggregate data from seven divisional data owners and disparate source systems. The solution was delivered on time and on budget, and Marcum LLP helped ensure the final data tied back to the company’s underlying financial statements, completing the project in less than five weeks.