This is one of 4531 IT projects that we have successfully completed with our customers.How can we support you?
Evaluations for the incoming post center
Project duration: 10 months
Brief description
In this project, management is informed about receipts from various clients into the incoming post center and into the associated databases. To achieve this, MS Access SQL queries are started and output in MS Excel tables. This takes place fully automatically at various times of day.
Supplement
The management information system consists of an MS Access database that provides a connection to the DB2 and SQL queries. The queries are started in a macro, and the corresponding Excel spreadsheets are created and filled with the results. The queries are created in MS Access with SQL. The VBA programming also took place in MS Access. The program is started via the Windows Scheduler at certain times of day.
Subject description
The incoming post center records inbound mail, e-mails and faxes from a wide variety of insurance areas (clients), such as life insurance, health insurance, health funds and damage to property. Management needs key figures to monitor the progress of stepwise automation of the incoming post center.
Overview
- Industries insurance
- Specialist tasks insurance, insurance controlling, management information system (MIS)
- DV tasks customised software new development
- System environment Client/Server
- Procedure model iterative procedure
- Databases DB2
- Development/ test tools MS Access
- Operating systems Windows 2003
Project period18.09.2007 - 29.07.2008
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
