Business solutions for you portfolio

About

Company: Postbank, Bonn

Technology: MS Excel, MS Access, VBA

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Jan 2014 – Apr 2014

Cost: no details


Collaboration in the project team of a large rollout of the Postbank. The aim was to monitor the Windows migration of the entire Postbank. For this purpose, several applications were implemented using Microsoft SQL Server and Microsoft Excel and Microsoft Access. Status files were imported, status data were evaluated and a consolidated status could be published daily. This made it possible to monitor the large-scale project. The migrated computers and the software on the individual devices were of particular interest. Not only the migration of the standard software was monitored, but also the migration of special programmes, some of which were migrated manually to the new environment. Status files in Microsoft Excel or status files from Microsoft Project were used as data sources, which were imported into the Access database.

  • MS Access and VBA development to monitor the stages for a large infrastructure project.
  • Reading out the data from the various Postbank systems.
  • Based on the data analysis, the current status of the migration work can be can be determined.
  • Microsoft Access application developed.
  • Import of various files from the Postbank's systems.
  • The data is refined and subsequently analysed.
  • Daily tranches are formed with the workplaces to be migrated.
  • The migration of the individual workstations is monitored.
  • Workstations may only be migrated if they comply with certain rules.
  • Creation and expansion of the data model (DeZign).
  • Documenting the data flow and the application.
  • Creating specifications for new requirements and their implementation.
Back to the portfolio
Order a similar project
Order a project

+41 (0)44 586 53 45
+41 (0)76 737 00 84
+41 (0)77 915 25 52

 

info@bs4y.ch

Order a project
Tell us what kind of project you want to do.
Name
E-mail
Want to order
Upload your brief
For message
Submit project request

User Agreement

With this questionnaire (application) I officially express my consent to the processing (collection, systematization, accumulation, storage, clarification, (updates, changes), use, distribution (including transmission), depersonalization, blocking and destruction), including automated, my personal data specified in this Questionnaire (application), in accordance with the requirements of the law "On personal data".

The personal data specified by the client are provided for the purpose of communication with the client, as well as for informing about other products and services. Consent is provided from the moment of filling of this application for the entire life of the client.

This consent can be revoked by the client upon submission of an application in simple writing in accordance with legal requirements.