This is one of 3224 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).
Overview
- Industries pharmaceutical industry
- Specialist tasks BPM: process optimization, BPM: process realization, customer management, data warehouse, pricing, turnover analysis
- DV tasks Data Warehouse
- System environment Business Intelligence
- Procedure model customer standard
- Databases MS SQL Server
- Development/ test tools MS Team Foundation Server TFS, MS Visual Studio,
Project period05.04.2010 - 26.08.2011
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
© Copyright 2024 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
