Upgrade Post project
Profileimage by Anonymous profile, Senior Consultant Microsoft Business Intelligence
Kirchzarten
available

Last update: 01.02.2024

Azure Data Engineer

Graduation: Diplom in Computer Science (FH)
Hourly-/Daily rates: show
Languages: German (Native or Bilingual) | English (Full Professional) | Swedish (Elementary)

Keywords

Skills

Alexander Klein is a senior Business Intelligence consultant with more than 20 years of experience. He focuses on Business Intelligence and Data Warehouse projects with Microsoft technologies like SQL Server, Power BI, Azure ML or Cortana Intelligence. Since 2008, he has been a self-employed consultant in large and medium-sized projects in all sectors across Europe. He has been visiting SQL Saturdays all over Europe since 2013.Since 2017 Alexander speaks at national and international conferences / user groups about Data Warehouse, BI, Azure and AI

Project history

10/2003 – current
Online Shop / Online Portal / E-Commerce
  • Retail
  • Initial development / continuous development of Online shops / Portal solution for Retailers
    Design and Implementation of a Data Warehouse for the Analysis and Reporting of incoming orders
  • Role: Project leader, Architect, Developer
  • Technologies: MS SQL Server 2000/ 2005 / 2008  / 2012 / 2016 (SSDS, SSAS, SSRS, SSIS, MDS), Azure ML, Azure Analysis Services, Azure Data Factory, Power BI, Cortana Cognitive Services, FileMaker, EasyLog (DHL).
 
02/2017 – 06/2017
Development of a Azure SQL DWH
  • Energy
  • Development of a new BI Landscape in Azure to replace the excising DWH and Reporting.
  • Role: Developer/Trainer
  • Technologies: Azure SQL DWH, Azure SQL DB, Azure Analysis Service,  Azure Data Factory, Logic App, Azure Stream Analytics, Azure Functions, Azure Automation, Power BI

03/2015 – 12/2015
Further development of an Analysis and Reporting Tools
  • Pharma wholesaler
  • Development of an existing analysis and reporting application for the purpose of optimizing inventory
  • Role: Developer/Trainer
  • Technologies: MS SQL Server 2012/2014 (SSIS, SSRS, SSAS, MDS), IIS

10/2014 – 12/2015
Replacement of a host system with a MS SQL Server System
  • Producer Glass / Eye optics
  • Replacement of an existing Host system including existing reporting with a SQL Server System. Existing reporting with the SSRS cannot be changed. Interfaces for Data supply from other system eg. CRM
  • Role: Developer
  • Technologies: MS SQL Server 2008R2 (SSIS, SSRS, SSAS)

02/2014 – 09/2014
Development of a DWH Prototype
  • Producer Glass / Eye Optics
  • Development of the existing prototype until final version. Implementation of new requirements and interfaces with different systems of the company.
  • Role: Architect, Developer, Business Analyst
  • Technologies: MS SQL Server 2008 R2 (SSIS, SSRS, SSDB), ClickView, Siemens Host

09/2013 – 01/2014
 
Development of a DWH
  • Foundation
  • Development of a DWH for their Project Controlling Department. Take over of an existing Cube into the new System. Migration of the existing DWH from SQL 2008 to SQL 2012. Adaption of existing SSRS Reports according to specifications by the department.
  • Role: Consultant, Architect, Developer
  • Technologies: Microsoft SQL Server 2008 / 2012 (SSIS, SSRS,SSAS), TARGIT

02/2012 – 08/2013
 
Extension of a DWH
  • Pharma Wholesaler
  • Extension of an existing Data warehouse according to client specifications. Redesign of an ETL Process. Customer specific reports. Implementation of new reports (SSRS), Product matching with the help of Master Data Service (MDS) of the SQL Servers 2012.
  • Role: Architect, Developer
  • Technologies: Microsoft SQL Server 2008 R2 / 2012 (SSIS, SSRS,SSAS, DQS, MDS), SharePoint 2010, PowerPivot, TFS

09/2010 – 02/2012
 
Development of a DWH
  • Healthcare
  • Redesign of a Data warehouse based on MS SQL Server 2008 R2. Design of a ETL Process with SSIS to retrieve data from DYNAMICS NAV / XML Files / Telephone system / ImageNow.
    Support and creation of reports according to specifications of the departments. Implementations of Interfaces by using SSIS.
  • Role: Project leader, Architect, Developer, Business Analyst
  • Technologies: MS SQL Server 2008 R2 (SSIS, SSDS), DYNAMICS NAV, Excel, NetSearch, Oracle, SalesForce
 

09/2009 – 04/2010
Development of a DWH
  • Producer
  • Extension of an existing DWH and migration from MS SQL 2000 to MS SQL 2005. Development of Cubes according to guidelines by the departments. Training of the key user. Design of a ETL concept for external data structures.
  • Role: Architect, Developer
  • Technologies: MS SQL Server 2005 (SSDS,SSIS,SSAS) DYNAMICS AX, Axapta 3
 

09/2008 – 12/2009
Online shop / Online portal
  • Retail
  • Development and design of an Online shop / Portal solution for retail. Analytics and reporting of incoming orders
  • Role: Project leader, Architect, Developer
  • Technologies: MS SQL Server 2005 / 2008 (SSDS, SSAS, SSRS), ASP.Net 3.5, Telerik, FileMaker, TFS

04/2009 – 05/2009
Development of a DWH Prototype
  • Bank
  • Development of a DWH Prototype until final Version. Design of reports with SSRS and Excel 2007
  • Role: Architect, Developer
  • Technologies: MS SQL Server 2008 (SSDB, SSIS, SSRS, SSAS)

01/2009 – 01/2009
Proof of concept DHW
  • LCD Manufacturer
  • Opportunities of the SQL Server 2005 with analysis and reporting with the focus of order fulfillment
  • Technologies: MS SQL Server 2005 (SSAS, SSRS, SSIS, SSDB), Excel 2003, IMB DB2

10/2008 – 11/2008
Database und Frontend Migration
  • Pharma
  • Migration of two existing applications from SQL 2000 to SQL 2005 (Backend) and MS Access 2000 to MS Access 2003 (Forntend)
  • Role: Architect, Developer
  • Technologies: MS SQL Server 2000 / 2005, MS Access 2000 / 2003, MBS Navision

03/2004 – 08/2008 
Workshops, Proof of Concept, technical Support (2. Level) in the area of BI MS SQL Server 2000 / 2005 / 2008
03/2008 – 04/2008 
Data Warehouse migration
  • Service provider
  • Migration of an existing Data Warehouse von SQL 2000 to SQL 2005
  • Technologies: MS SQL Server 2000/2005, MS IIS

10/2007 – 11/2007 
Design and development of a web analytics application
  • Insurance
  • Design and development of a web application for analytics and reporting. The application should be integrated into the existing web interface.
  • Technologies: MS SQL Server 2005, TARGIT PDK, MS IIS

08/2007 – 09/2007 
Intranet portal for analytics and reporting
  • Service provider
  • Design and development of an intranet portal for analysis and reporting based on the TARGIT Net Clients
  • Technologies: MS SQL Server, TARGIT PDK, MS IIS

04/2007 – 05/2007
Data Warehouse migration
  • Solar industry
  • Migration of the exiting DWH from SQL 2000 to SQL 2005 including the development of the existing analysis and reports.
  • Technologies: MS SQL Server 2000/2005, MS IIS, MBS Navision

01/2007 – 03/2007 
Conception and implementation of a DWH
  • Service provider
  • Design and development of a data warehouse based on CRM data.
  • Technologies: MS SQL Server 2000, Super Offices CRM, TARGIT, MS IIS

07/2006 – 09/2006 
industry BI solution for energy producers
  • Service Provider
  • Development of an industry standard BI solution for energy producers based MBS Navision as source system and TARGIT as frontend
  • Technologies: MS SQL Server 2000, MBS Navision, TARGIT, MS IIS

04/2005 – 10/2005 
Conception und and implementation of a DWH
  • Packaging manufacturer
  • Design and implementation of a DWH for 15 shops worldwide
  • Technologies: MS SQL Server 2000, MBS Axapta, TARGIT, Excel, MS IIS
 

12/2004 – 02/2005 
Implementation of TARGIT
  • Food producer
  • Implementation of the TARGIT Software to replace the existing excel reporting. Training of the users and administrators.
  • Technologies: MS SQL Server 2000, TARGIT

04/2004 – 08/2004 
Product development
  • Technical conception and development of a DWH for plan and Is data
  • Technologies: MBS Navision, MS SQL-Server 2000, MS OLAP, Business Analytics, Macssoft

06/2004 – 06/2004
Business Analytics
  • Production
  • Product implementation and education of the user
  • Technologies: Microsoft Business Analytics, MS SQL-Server 2000, MS OLAP

10/2003 – 01/2004
Online Shop
  • Shoe retailer
  • Design and implementation of a web shop with the interface to the ERP System
  • Technologies: MS SQL-Server 2000, ASP, IIS, Filemaker

09/2003 – 10/2003
Internet portal
  • Movie theater
  • Design and Implementation of the Webpage
  • Programming of newsletters, weekly program and archive
  • Technologies: MySQL, PHP

04/2003 – 08/2003
Conception of a DWH
•       Direct marketing
•       Combination of exiting software solutions
•       Technologies:  MS SQL-Server 2000, MS Access, MS Excel, Crystal Reports, .Net und Visual Basic
10/2002 – 07/2003
Customer database
  • Direct marketing
  • Development and support of an existing data base
  • Creation of surveys for call center agents
  • Exports / Reports according to customer specifications
  • Training of user
  • Technologies:  MS SQL-Server, MS Access, Crystal Reports, MS Excel

07/2002 – 08/2002
Internet portal
  • Wine cooperative
  • Design und Implementation
  • Realization of a shopping cart, newsletter and calendar of events
  • Technologies: MySQL, PHP

10/2001  – 04/2002
Data Mining
  • Pharma
  • Conception, testing and prototyping
  • Testing of products from different manufacturer
  • Selection of suitable data mining methods
  • Technologies: MS SQL-Server, ORACLE, OLAP, Cognos, MIS, Business Objects

06/2001 – 08/2001
Article database with Web integration
  • Import / Export
  • Development of an item database with order functionality Implementation of a web shop, supplier area and creation of a demo database for presentations
  • Technologies: MS Access und ASP

01/2001 – 05/2001
Fleet management
  • Pharma
  • Conception and development of a prototype
  • Administration of the fleet from bicycle, car, truck and electric vehicles. Monthly reports regarding TÜV, mileage, fuel costs and availability
  • Technologies: Apache, Tomcat, JSP

09/2000 – 11/2000
Development of a web shop
  • IT service provider
  • Development and maintenance of a web shop
  • Technologies: Apache, Tomcat, JSP

09/1998 – 02/1999
Field service worker database
  • Press
  • Conception and development of a database for the field service workers for improved product range in the branches.
  • Technologies: MS Access

 

Local Availability

Open to travel worldwide
Looking for projects based in Denmark, Sweden, Norway, Finnland or Iceland.
Profileimage by Anonymous profile, Senior Consultant Microsoft Business Intelligence Azure Data Engineer
Register