Centralised product mapper web portal to provide and manage a unified view of products sold across the branch network and portfolio companies | Panamoure Consulting

Centralised product mapper web portal

across companies and branch network

transformation of builders merchant group

transformation of builders merchant group

Centralised product mapper web portal

across companies and branch network

The business operates through six divisions, with the core builders’ merchant branches supported by a network of speciality plumbing and heating, roofing and electrical branches, a dedicated timber processing and distribution business, and a strong online presence. The group today has more than 140 branches operating across the south of England.

What Were the Challenges?

Multiple ERPs across different portfolio companies
Multiple points of contact, stakeholders and process owners
Infrastructure setup constraints including configurations managed by multiple vendors
Existing manual mapping activity did not cover full population of products
Short project deadline

So, What Did We Do?

Our agile REBOT methodology was used to structure the project into three development sprints for execution.
Regular interactive sessions were held with all stakeholders to capture comprehensive business requirements that were signed off prior to development starting.
We designed a solution that addressed both tactical and strategic objectives, providing the flexibility to cater for future requirements that might arise from further business acquisitions.
A Cloud-based “Product Mapper Portal” was built using latest technology stack:
- Front-end: Angular, Google’s powerful JavaScript/Typescript based framework
- Middleware: Node JS, a lightweight JS framework for server with the power of npm libraries to expedite development
- Database: Azure SQL Database
- ERP Data Sync: Azure Data Factory pipelines and activities were used to refresh portal data from different ERP Source systems at defined frequencies
- Security: Azure Key Vault and Azure API Gateway policies (including API limit, DDoS prevention, Firewall etc.) to provide security to the portal data over REST APIs
Daily Scrum calls, focused on achieving timely goals, enabling client feedback for regular releases.
A dedicated team provided testing as a service (TaaS) ensuring high-quality testing was performed not just on the web portal but also on data migration (a single migration of millions of records).
Effective support during User Acceptance Testing (UAT) ensured timely delivery and drove rapid signoff from the business.
Regular, focused meetings with stakeholders ensured all project dependencies were managed correctly and project progress was communicated effectively

Results

The Product Mapper Portal now sources Product data across the different ERP Sources (3+) and unifies them as a Master Product (using appropriate product codings/groupings) to allow for 100% accurate supplier rebate calculations and discounting. This has allowed for re-tendering and improved pricing negotiations across multiple suppliers and is estimated to reduce supply costs by 6%.

Do you need to digitally optimise your business?

We are experts in what we do. Committed professionals who are at the leading edge of our specialised field.

Other examples of our work

Dedicated captive team providing BAU support to business users

Delivery of managed services including Microsoft Dynamics 365 F&O

Our client is a 65-year-old family-owned business group in the construction sector, with 4,000 employees with a strong track record of delivering major infrastructure programmes in the UK, Ireland, and Canada.

Centralised product mapper web portal across companies network

transformation of builders merchant group

The business operates through six divisions, with the core builders’ merchant branches supported by a network of speciality plumbing and heating, roofing and electrical branches, a dedicated timber processing and distribution business, and a strong online presence. The group today has more than 140 branches operating across the south of England.

Ground breaking scalable smart app (Microsoft Azure)

athlete passport / mobile application

Panamoure was approached to build the proposed Athlete Passport Application (“App”) to monitor and manage an athlete’s wellbeing, strength, conditioning and nutrition. The application is the first phase in an expected roadmap which will create various solutions including audience specific apps and the overall athlete management by respective international governing bodies.