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 4822 IT projects that we have successfully completed with our customers.How can we support you?
Subprojects for structuring a company database
Project duration: 1 year, 7 months
Brief description
Creating play out routines from the company database modules, connecting the company database to the controlling system, replacing the sales and distribution sales ledger, changing the rolling forecast in the company database.
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
Play out routines from the company database modules: CAPEX (capital expenditure), financial statement, sales and supplies for further processing the data, a subsystem and balance sheet, debtors, creditors, financial statement and sales for further processing the data in an additional subsystem. Modifications to the company database by direct extraction from the SAP R/3 central system.
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.11.2002 - 31.05.2004
Customers who trust us
