Business solutions for you portfolio

About

Company: IBM Schweiz, Basel

Technology: T-SQL, SSIS, SQL

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Sep 2013 – Dez 2015

Cost: no details


This project is about loading the customer data from IBM Europe into the corresponding databases. This is done by means of stored functions, which are implemented in T-SQL. Parallel to the implementation by means of stored procedures, various ETL routes are also developed by means of SSIS. The application already exists and new customer requirements are being integrated.

  • Requirement engineering.
  • Creation of the concepts.
  • Responsible for extracting and loading all European customer data.
  • Data is extracted from various data sources using SSIS and loaded
  • and loaded onto the DWH without transformation.
  • Using stored procedures (T-SQL), the data is prepared for reporting after loading
  • Data preparation is continuously adapted to the new needs of reporting.
  • reporting needs.
  • The same applies to the underlying database schemas.
  • Creation of reports using Cognos.
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.