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's Role

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.

Automated interface

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.

Next Steps

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.

Why CopperMan

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.

 

Easy BPC

CopperMan consultants can engage at every stage in a BPC project or be involved in most kinds of post-go-live support.

Learn more...

Downloads

CopperMan Consulting Brochure

Find out more about CopperMan Consulting and their services

Learn more...

SAP EcoHub

SAP customers can shop for SAP services at SAP EcoHub

 

Woman

 

 

Let us help you

If you have any questions or want to find out how we can help you please contact us at info@coppermanconsulting.com