For a large whitegood producer in Europe a system was developed to analyse the indirect spend. From various corporate locations varying from local factories, office locations and country based shared service centers within Europe periodically data is submitted in predefined templates and shipped via the corporate network to a central server.
Submitted data is validated, problems and inconsistencies are reported back to the respective system owners for correction. Valid data is stored in a datawarehouse ready to be harmonised and consolidated. Since Microsoft Excel is used throughout the company and all staff has been trained and feels at ease with this piece of software a decision was taken to leverage this opportunity while at the same time keeping the learning curve low and use Microsoft Excel Pivot Table Service to interrogate the consolidated OLAP cube.
This project confined Pangia to use Microsoft SQL 2000 and the Microsoft Analysis Services because Microsoft is the prefered platform for this client. Within this scope Pangia developed the system archtecture, object model, database model and OLAP cube plus the necessary automated procedures for this platform to operate with the newly developed application server also by Pangia. While OLAP cube processing is web enabled through DTS scripts. System and database administration is fully web enabled as well as the problem reporting and some KPIs. Database and cube interrogation is performed through Microsoft Excel as well as all KPIs.
During this project Pangia worked closely together with MySpend.
During 2006 a large Swedish company sold of part of their business to an existing member of their corporate group. MySpend was engaged to assist in the splitup of the application used for tracking direct cost and price evolution. Since MySpend resources lack sufficient knowledge of IT systems and the knowhow to split these from a more technical point of view Pangia was approached to aid, advise in the splitup and perform certain tasks as data cleansing, harmonisation and loading.
A large dutch bank consulted Pangia and her partner in helping the development of their indirect spend system, a system for tracking and analysing indirect expenditure. The development for this project was mainly done inhouse by the bank itself, except for the "proof of concept" design and development support and initial data handling and loadind which was realised by Pangia.
One of the worlds leading suppliers of refreshments enagaged Pangia for their expertise in Microsoft Analysis Services in the dispute with their preferred software supplier to aid in the development of their Capex system.
During June 2007 the
REACH
directive came into effect in Europe.
To assess the situation Pangia supported the risk assesment team and developed various processes
in order to be able to handle inputs from approx. 15 factories all over Europe and 2500 suppliers worldwide.
Small supplier databases were developed and together with an application emailed to suppliers around the world with the request
to enrich their data with the nessesary elements.