This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4905 IT projects that we have successfully completed with our customers.How can we support you?
Replacing a reporting solution for wholesaler and end customer data with a global data warehouse
Project duration: 1 year, 5 months
Brief description
Replacing a Japanese reporting solution based on UNIX and an Oracle DB with a globally defined data warehouse. Sales figures, wholesaler transactions and pricing are also included, as well as country-specific customer and product data.
Supplement
In Japan, the local FACT (Fundamental Account Tracking) system is replaced with PRISMA. Specific Japanese features are considered here, such as the national wholesaler data networks JD-NET (Japan Drug Network), NHI (Nihon Health Industry) and the Ultmark customer file system.
Subject description
Japan has a mature pharmaceuticals market. Products in some business areas are distributed and sold via wholesalers, others are sold directly to customers. A special pricing and monitoring system is necessary here. A large quantity of information is provided by standardized national networks for Japan: JD-NET (Japan Drug Network, orders and sales), NHI (Nihon Health Industry, sales), Ultmark (customer data).
IT project data
- Industries pharmaceutical industry
- Specialist tasks BPM: process optimization, BPM: process realization, customer management, data warehouse, pricing, turnover analysis
- DP tasks Data Warehouse
- System environments Business Intelligence
- Procedure model customer standard
- Databases MS SQL Server
- Development and test tool MS Team Foundation Server TFS, MS Visual Studio
- Middleware and frameworks MS SQL Server Analysis Services (SSAS), MS SQL Server Integration Services (SSIS)
Project period05.04.2010 - 26.08.2011
Customers who trust us
