Marcum Technology’s Intelligent Prism Solution Delivers Advanced Data Transformation Services to Meet Client’s Compressed Timeline
We engaged Marcum Technology to bring together data from multiple separate platforms into one usable data source. Marcum tackled the project and delivered outstanding results in less than five weeks and on budget. The complexity of normalizing data from so many different sources, each in its own structure, cannot be underestimated. To deliver results that ties to our underlying financials that quickly was fantastic.
— Chief Financial Officer
ABOUT THE CLIENT
With headquarters in New York and locations across the United States, the company provides delivery services to all major cities in the United States and internationally. They are a full-service logistics company providing warehousing for “final mile deliveries,” domestically and overseas.
HOW WE HELPED
The source data varied from simple Excel spreadsheets generated from current technology systems to complex, multi-file fixed-width formats generated from older mainframe systems. Marcum worked with our client to determine a common format for the revenue data. Next, Marcum collaborated with the seven different data owners in the various divisions to extract data from their systems. Because time was of the essence, Marcum’s only request of the client was to deliver the data fields in whatever format they could. Using macros and other data transformation techniques, Marcum successfully aggregated the data into a common data format, per the client’s specifications. Throughout the engagement, Marcum professionals worked hand-in-hand with the client to perform quality assurance on the data set to ensure it matched with the underlying financial statements.