Project description MICROSOFT SQL SERVER PROJECTS

Microsoft development, database development and database administration, web portals and OO development...

Data management - Microsoft Excel, Microsoft Access, VBA

Postbank, Bonn

MS Excel, MS Access, VBA

Postbank, Bonn

PROJECT LINK: Not available
People in the PROJECT: Stefan Troehler
PROJECT Duration: Jan 2014 - Apr 2014
PROJECT Value: SFR. 00'000.00

SQL

Project portfolio
0
HOURS REQUIRED
0
CUP OF COFFEE
0
LINES IN THE CODE
0
EXPERTS IN THE PROJECT

Participation in the project team for a major rollout at 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 major project. Of particular interest were the emigrated computers and the software that was on the individual devices. Not only the migration of the standard software was monitored, but also the migration of special programs, some of which were manually migrated to the new environment. Status files in Microsoft Excel or status files from Microsoft Project, which were imported into the Access database, served as data sources.

  • MS Access and VBA development for monitoring the stadiums for a large infrastructure project.
  • Reading out the data from the various Postbank systems.
  • The current status of the migration work can be determined on the basis of the data analysis.
  • Microsoft Access application developed.
  • Import of various files from the Postbank systems.
  • The data is refined and then evaluated.
  • Daily tranches are created with the jobs to be migrated.
  • The migration of the individual workstations is monitored.
  • Workplaces may only be migrated if they comply with certain rules.
  • Creating and extending the data model (DeZign).
  • Documentation of the data flow and the application.
  • Creation of specifications for new requirements and their implementation.