DWH(Data Vault) Architecture/Modelling/Development not available until 08/31/2019

DWH(Data Vault) Architecture/Modelling/Development

not available until 08/31/2019
Profileimage by Anonymous profile, DWH(Data Vault) Architektur/Modellierung/Entwicklung
  • 21614 Buxtehude Freelancer in
  • Graduation: Dipl.-Wirtschaftsinformatiker (FH)
  • Hourly-/Daily rates: 110 €/hour
  • Languages: German (Native or Bilingual) | English (Full Professional)
  • Last update: 30.05.2019
KEYWORDS
PROFILE PICTURE
Profileimage by Anonymous profile, DWH(Data Vault) Architektur/Modellierung/Entwicklung
ATTACHMENTS
Profil (Stand 25.01.2019)
The download of this file requires a paid membership.
SKILLS
Certifications
03 2017 
Certified Engineering Principal (MCEP) - Version 9.4.1  (MicroStrategy)
09 2016  Data Management and Analytics (SQL Server 2014/2016) (Microsoft)
04 2015  SAP Certified Application Associate – Modeling and Data Management with SAP BW 7.3 & SAP BI 4.0 SAP
12 2014 Certified Data Vault 2.0 Practitioner 
09 2014 OMG Certified Expert in BPM – Fundamental Certification (OMG)
10 2013 Certified Application Associate – SAP Hana 1.0 (SAP)
07 2013 Microsoft Certified IT Professional Business Intelligence Developer 2008 (Microsoft)
05 2013 Microsoft Certified IT Professional Database Developer 2008 (Microsoft)
10 2012 Certified Application Associate Business Foundation & Integration with SAP ERP 6.0 EHP5 (SAP)
08 2012 Certified Application Associate Business Intelligence with SAP NetWeaver 7.0 (SAP)
 
REFERENCES
01 2018 – .. DWH - Modelling / Development
  • Oracle 12, WhereScape
Entwicklung eines neuen Data-Vault DWH:
  • Erstellung/Automatisierung von ETL-Prozessketten
  • Modellierung und Entwicklung eines Data-Vault-DWHs
Banking
06 2017 – 12 2017Modellierung und Entwicklung
Technologie:
  • Microsoft BI
Weiterentwicklung eines vorhandenen DWH und Entwurf, Design und Entwicklung eines neuen Data-Vault DWH (HR-Daten) auf der Basis SQL Server 2012 (SSIS):
  • Erstellung von ETL-Prozessketten
  • Modellierung und Entwicklung eines Data-Vault-DWHs (HR)
  • Weiterentwicklung und Performanceoptimierung von vorhandenen DWH-Strukturen.
Retail
05 2017 – 06 2017 Design und Umsetzung
Technologie:
  • Microsoft BI
Entwicklung einer metadatengesteuerten Erstellung und Befüllung einer DWHW-Load- und Core-Schicht (ETL, Tabellen, Views, StoredProcedures) von Oracle nach SQL Server 2014:
  • Erstellung eines Programmes zur Generierung von DTSX-Paketen, DB-Strukturen und StoredProcedures
  • Einführung und Performanceoptimierung
Versicherung
09 2016 – 05 2017 Modellierung und Umsetzung
Technologie:
  • Microsoft BI
Pflege und Weiterentwicklung eines DWH auf Basis SQL Server 2012:
  • DWH-Modellierung (Data Vault),
    Erstellung und Pflege von ETL-Prozessketten.
  • Performance-Optimierung
  • Betrieb
  • Optimierung (Architektur)
Finance
06 2016 – 09 2016 Design und Umsetzung
Technologie:
  • Microsoft BI
Umsetzung Reporting-Themen auf SQL Server 2014:
  • Erstellung von ETL-Prozessketten.
  • Erstellung von AdHoc-Abfragen
  • Anforderungsanalyse, Modellierung und Implementierung eines Data-Marts als Basis für ein KPI-Dashboard zur Auswertung von Callcenter-Calls (Data Vault, SSRS)
Projektsprache
  • Englisch
Software
04 2016 Umsetzung
Technologie:
  • Microsoft BI
  • SSAS + Cube-Entwicklung
Migration von SQL Server 2005 auf SQL Server 2014:
  • Migration von SSIS-Paketen und Erstellung von ETL-Prozessketten.
  • Installation, Migration und Anpassung von SSRS-Reports
  • Integration von Alt-Systemen
Retail
12 2015 – 05 2016 Design und Umsetzung
Technologie:
  • Microsoft BI
Entwurf, Design und Entwicklung der Beladung eines Data-Vault DWH mit SSIS.
  • Automatisierung der Erstellung von Load-Paketen für CSV, SAP (Theobald), Oracle-Datenquellen
  • Mentoring
  • SQL-Server Optimierung
  • Administration SQL Server
  • Einbindung von UNIT-Tests
  • Entwicklung einer Infrastruktur für „Continuous Integration“ mit TFS 2015 / BI-Data-Tools
Production
09 2015 – 12 2015 Architecture / Design DWH
Modeling and Development of a Data Vault prototype for a FODD-EDWH on Basis Microsoft SQL Server / Micrososft Dynamics AX 7.
Consulting
02 2015 – 08 2015 DWH Developer, Designer and Consultant
Migrating a DWH-landscape from SQL Server 2008 to SQL Server 2014:
  • Requirements analysis, designing and developing a central process-control with decentralised execution-engine(backend)
  • Requirements analysis and designing a central process-monitor (Backend)
  • Creation of function specifications
  • Managing workshops and providing training-session for future users
  • Migration and development of SSIS-packages and ETL-processes
Retail
04 2015 – 06 2015 Developer
Migration of MS-SQL-Databases with MS-Access-
Frontend to Azure:
  • Finalize the customers landscape decision
  • Operating the Migration
  • Supporting the frontend-team
Production
06 2013 – 02 2015 DWH Modelling
Defining and modeling a System of KPIs
  • Supporting the customer in defining the KPIs
  • Modelling the KPIs including interfaces
  • Requirement- and function analysis
  • Organizing and holding  workshops with customer
Public sector
10 2011 – 02 2015 Design, development and sub-project lead (OLAP)
Planning and implementing the migration from Microsoft SQL Server 2000 including SSIS (DTS), SSAS and SSRS to Microsoft SQL Server 2008.
  • Designing and implementing test-scenarios to compare AS2000- and AS2008-Cubes
  • Implementing a SSRS-Portal to support communication between project-team and customer
  • Coordination of approval-procedures with the customer
  • Development of ETL-process chains in SSIS
  • Draft and train best-practices for current and future development in SSIS and SSAS
  • Coordinating the tasks of regular processing and deploying AS2008 cubes with the operating staff
  • Implementing and operating an automatic migration from AS2000 to AS2008 cubes with .Net
  • Administering test-servers
  • Optimizing performance of SQL and MDX queries
Public sector
10 2009 – 10 2011 Design and Development
Designing and developing KPIs in AS2008 (relational with T-SQL, multidimension with MDX)
Public sector
07 2010 – 12 2010 Design and Development
  • Designing a Backup strategy for Microsoft SQL Server 2005/2008
  • Implenting an ETL process from Progress to Microsoft SQL Server 2005
  • Operating migration to SQL Server 2008
Production
09 2008 – 10 2009 Development
Maintance and further development on existing data marts (relational and OLAP) hosted on Microsoft SQL Server and Analysis Services 2000
  • Implementing process chains (DTS)
  • Implementing TSQL-procedures (SQL Server 2000)
  • Designing and developing KPIs with MDX
  • Maintance on AS2000 Cubes
  • Developing Interfaces with TSQL
  • Implementing and operating test scenarios
  • Optimizing TSQL code (performance, coding)
Public Sector
04 2008 – 09 2008 Project lead, development
Implementation a data mart for analyses on call center data
  • Planing and coordinating staff
  • Communication with customer
  • Organizing workshops with the customer to acquire a requirements document
  • Change management
  • Development in sub project "ETL"
  • Development in sub project "relational DB-Design"
IT/Consulting
TIME AND SPATIAL FLEXIBILITY
Vor-Ort Einsätze sind möglich (Mo-Do 40Std)
ab 31.08.2019
GET IN TOUCH

I accept the Conditions

I accept the terms of the privacy policy

Note: sending your contact request is free of charge