Case Study - SEGRO
Background to Segro
SEGRO plc (formerly Slough Estates Group) is a property investment and development company focused on the provision of Flexible Business Space in Europe and one of the largest REITs in the world. The Company serves a diversified customer base of around 1,700 customers, operating across a wide range of sectors and representing both small and large businesses, from start ups to global corporations. Segro have invested in SAP BPC primarily to meet their financial reporting requirements including statutory reporting, budget and forecasting.
CopperMan were introduced to Segro through "word of mouth" late on in the project. Segro were an existing SAP BPC client with an already existing application set to service the financial consolidation and reporting needs of the group. With a low level of internal product knowledge, coupled with a less robust system design and a lack of support from their incumbent consultants, CopperMan were quick to introduce a number of very strong consultants into the team. The consultants were qualified accountants with excellent product knowledge who were able to understand the business requirements and work on fixing the many issues Segro had identfied through their last reporting cycle. CopperMan subsequently supported Segro through the whole year end reportng process.
Working on the data flows
With many non-integrated and diverse ledger systems throughout the Group, the ability for the European and UK business teams to quickly and accurately enter the quarterly reporting data needs of the Group into the system was very poor. CopperMan was able to build a standardised set of Excel based upload templates which were designed to import data files from the diverse ledger systems, transform and load these into BPC. This enabled the divisions to accurately submit the year end data sets in the fastest cycle ever completed. The feedback from the year end process was unanimously positive for the CopperMan team.
CopperMan was tasked with automating the GL extract and upload process into SAP BPC. The interface was a natural extension of the current general ledger replacement project which would see a common system and chart of accounts built for all of the European business units. The interface was developed in native Microsoft Integration Services and included full data flow mapping and validation with a simple user front end user screen to control the process initiation.
CopperMan was able to demonstrate how a redesign of the system applications and dimensions would lead to increased stability, flexibility and performance. The redevelopment of the application would further enhance Segro's reporting process as well as improve their ability to maintain and develop the application in house.
As one of the market leading SAP BPC consultancies, with a proven track record in designing and building successful applications, CopperMan was chosen to support Segro with its goal of developing a self sustainable improved, efficient and robust reporting process.