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?
Further development of a company database: subprojects for local data warehouse
Project duration: 4 years, 7 months
Brief description
Developing and further developing a tool for grouping together balance confirmations from various R/3 systems and informing various recipients about their current balances by means of an e-mail in Outlook.
Supplement
In addition to the evaluations carried out with MS Access on the basis of the SQL server database, the Analysis Services data warehouse functions are used.
Subject description
Creating a sales prototype with Analysis Services and Pro Clarity as the front end (sales cube). Creating an application for identifying tax amounts; replacing a host application. Developing and further developing a tool for administrating processes and the related objects. Maintaining processes and other objects, as well as assigning contact persons and support staff to modules and servers/systems. Developing an account auditing checking tool for checking supplier invoices. This is based on a shipping company's price lists.
IT project data
- Industries pharmaceutical industry
- Specialist tasks Controlling, financials
- DP tasks Data Warehouse
- System environments Client/Server
- Procedure model Summit-D (PwC)
- Programming languages VBA
- Databases MS Access, MS SQL Server
- Development and test tool MS Query Analyzer, MS SQL Server DTS
- Middleware and frameworks MS SQL Server Analysis Services (SSAS)
Project period01.10.2000 - 30.04.2005
Customers who trust us
