Project ID: 776 | Branch group: Life Science | Branch: pharmaceutical industry
Development of a company database
Project start/end: 01.05.1999 - 31.08.2002
Structuring and further developing a company database for monthly management reporting of controlling (plants, stocks, turnover, operating statement, cost allocation balance sheet, debtors, creditors, personnel, investment, shared costs, cost types and segmenting, costing, profit center accounting, and revaluation of open items).
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.
Furthermore, the project involves developing various SAP R/3 interfaces to the company database and further processing of data. Other subprojects include: euro changeover of the company database. Mapping rolling forecast in the company database. Tuning the month-end closing processes and the associated IT systems in order to carry out the month-end closing in three days instead of five, with the help of the company database. Modifying the company database to meet the auditing requirements.