Expertise in Project Management, Data Transformation, Power BI, and Agile Coaching.
Aktualisiert am 03.07.2024
Profil
Mitarbeiter eines Dienstleisters
Remote-Arbeit
Verfügbar ab: 01.07.2024
Verfügbar zu: 80%
davon vor Ort: 25%
Skill-Profil eines fest angestellten Mitarbeiters des Dienstleisters

Einsatzorte

Einsatzorte

Mönchengladbach (+500km)
Deutschland
möglich

Projekte

Projekte

2 years 7 months
2022-01 - 2024-07

Integrated SAP Data Warehouse on Microsoft SQL Server for Advanced Sales and Controlling Analytics

Lead Developer / Consultant Transact-SQL SQL Requirements Engineering ...
Lead Developer / Consultant
Planning and design phase
  • Requirements Gathering:
    • Work with stakeholders to understand the business requirements for sales and controlling data analysis.
    • Define the scope of the data integration project.

  • Architecture Design:
    • Design the overall Data Warehouse (DWH) architecture on Microsoft SQL Server.
    • Define data models and schemas to accommodate SAP data structures.

Development Phase
  • Data Extraction:
    • Design and implement procedures to extract data from different SAP systems (e.g. SAP ECC, SAP S/4HANA).
    • Ensure that data extraction processes can handle SAP modules SD and CO.

  • Data Transformation:
    • Develop ETL processes to transform SAP data into a format suitable for the DWH.
    • Implement data cleansing, normalisation and enrichment processes.


  • Data Loading:
    • Design and implement procedures to load transformed data into the DWH on Microsoft SQL Server.
    • Optimise data loading processes for performance and reliability.

  • Data Integration
    • Ensure seamless integration of data from multiple SAP systems.
    • Implement data reconciliation and validation checks to ensure data accuracy and consistency.

Test and validation phase
  • Unit testing:
    • Perform unit testing of ETL processes and data transformations to ensure they meet functional requirements.


  • System Integration Testing:
    • Perform system integration testing to ensure that all components of the DWH work together seamlessly.


  • Performance Testing:
    • Perform performance testing to ensure that the DWH can handle the expected load and provide timely analysis.

Deployment and Implementation Phase
  • Production Deployment:
    • Oversee the deployment of the DWH solution into the production environment.
    • Ensure minimal disruption to business operations during deployment.
QlikView Jira Confluence Microsoft SQL Server SAP HANA
Transact-SQL SQL Requirements Engineering Software Deployment Source Code Control

Aus- und Weiterbildung

Aus- und Weiterbildung

1 year 10 months
2022-09 - now

M320: Data Modeling

MongoDB
MongoDB
2 years 4 months
2022-03 - now

Agile Coach

IFAAI - Institute for Agility & Innovation
IFAAI - Institute for Agility & Innovation
3 years 8 months
2020-11 - now

Azure Data Scientist Associate

Microsoft
Microsoft
3 years 10 months
2020-09 - now

Azure Solutions Architect Expert

Microsoft
Microsoft
3 years 11 months
2020-08 - now

Professional Scrum Master II (PSM II)

scrum.org,
scrum.org
3 years 11 months
2020-08 - now

Professional Agile Leadership (PAL I)

scrum.org
scrum.org
4 years
2020-07 - now

Professional Scrum Product Owner I (PSPO I)

scrum.org,
scrum.org
9 years
2015-07 - now

Professional Scrum Master I (PSM-I)

scrum.org,
scrum.org
9 years 3 months
2015-04 - now

Project Management Professional (PMP)

Project Management Institue (PMI)
Project Management Institue (PMI)

Position

Position

Freelancer with strong expertise in Microsoft technologies, specializing in data analytics and engineering. PMP certification and advocate for Agile methodologies, combining structured project management with flexible, collaborative approaches to ensure successful project outcomes.

Kompetenzen

Kompetenzen

Produkte / Standards / Erfahrungen / Methoden

NoSQL (MongoDB Atlas)
Experte
Microsoft SQL Server
Experte
Microsoft Power BI
Experte
Azure DevOps
Fortgeschritten

Programmiersprachen

PHP
JavaScript
Python
SQL (ANSI)
TSQL

Datenbanken

Microsoft SQL
Experte
MongoDB
Experte
Gremlin
Fortgeschritten
MySQL

Datenkommunikation

REST (RESTful API)
Experte
SQL Server Integration Services (SSIS)
Experte
Azure Data Factory
Fortgeschritten
Data Integration Service
Experte

Design / Entwicklung / Konstruktion

Kimball Techniques (Data Warehousing)
Experte
Data Lake / Lake House
Experte
Star, Galaxy and Snowflake Schema
Experte
MVC (Model-View-Controller)
Experte

Einsatzorte

Einsatzorte

Mönchengladbach (+500km)
Deutschland
möglich

Projekte

Projekte

2 years 7 months
2022-01 - 2024-07

Integrated SAP Data Warehouse on Microsoft SQL Server for Advanced Sales and Controlling Analytics

Lead Developer / Consultant Transact-SQL SQL Requirements Engineering ...
Lead Developer / Consultant
Planning and design phase
  • Requirements Gathering:
    • Work with stakeholders to understand the business requirements for sales and controlling data analysis.
    • Define the scope of the data integration project.

  • Architecture Design:
    • Design the overall Data Warehouse (DWH) architecture on Microsoft SQL Server.
    • Define data models and schemas to accommodate SAP data structures.

Development Phase
  • Data Extraction:
    • Design and implement procedures to extract data from different SAP systems (e.g. SAP ECC, SAP S/4HANA).
    • Ensure that data extraction processes can handle SAP modules SD and CO.

  • Data Transformation:
    • Develop ETL processes to transform SAP data into a format suitable for the DWH.
    • Implement data cleansing, normalisation and enrichment processes.


  • Data Loading:
    • Design and implement procedures to load transformed data into the DWH on Microsoft SQL Server.
    • Optimise data loading processes for performance and reliability.

  • Data Integration
    • Ensure seamless integration of data from multiple SAP systems.
    • Implement data reconciliation and validation checks to ensure data accuracy and consistency.

Test and validation phase
  • Unit testing:
    • Perform unit testing of ETL processes and data transformations to ensure they meet functional requirements.


  • System Integration Testing:
    • Perform system integration testing to ensure that all components of the DWH work together seamlessly.


  • Performance Testing:
    • Perform performance testing to ensure that the DWH can handle the expected load and provide timely analysis.

Deployment and Implementation Phase
  • Production Deployment:
    • Oversee the deployment of the DWH solution into the production environment.
    • Ensure minimal disruption to business operations during deployment.
QlikView Jira Confluence Microsoft SQL Server SAP HANA
Transact-SQL SQL Requirements Engineering Software Deployment Source Code Control

Aus- und Weiterbildung

Aus- und Weiterbildung

1 year 10 months
2022-09 - now

M320: Data Modeling

MongoDB
MongoDB
2 years 4 months
2022-03 - now

Agile Coach

IFAAI - Institute for Agility & Innovation
IFAAI - Institute for Agility & Innovation
3 years 8 months
2020-11 - now

Azure Data Scientist Associate

Microsoft
Microsoft
3 years 10 months
2020-09 - now

Azure Solutions Architect Expert

Microsoft
Microsoft
3 years 11 months
2020-08 - now

Professional Scrum Master II (PSM II)

scrum.org,
scrum.org
3 years 11 months
2020-08 - now

Professional Agile Leadership (PAL I)

scrum.org
scrum.org
4 years
2020-07 - now

Professional Scrum Product Owner I (PSPO I)

scrum.org,
scrum.org
9 years
2015-07 - now

Professional Scrum Master I (PSM-I)

scrum.org,
scrum.org
9 years 3 months
2015-04 - now

Project Management Professional (PMP)

Project Management Institue (PMI)
Project Management Institue (PMI)

Position

Position

Freelancer with strong expertise in Microsoft technologies, specializing in data analytics and engineering. PMP certification and advocate for Agile methodologies, combining structured project management with flexible, collaborative approaches to ensure successful project outcomes.

Kompetenzen

Kompetenzen

Produkte / Standards / Erfahrungen / Methoden

NoSQL (MongoDB Atlas)
Experte
Microsoft SQL Server
Experte
Microsoft Power BI
Experte
Azure DevOps
Fortgeschritten

Programmiersprachen

PHP
JavaScript
Python
SQL (ANSI)
TSQL

Datenbanken

Microsoft SQL
Experte
MongoDB
Experte
Gremlin
Fortgeschritten
MySQL

Datenkommunikation

REST (RESTful API)
Experte
SQL Server Integration Services (SSIS)
Experte
Azure Data Factory
Fortgeschritten
Data Integration Service
Experte

Design / Entwicklung / Konstruktion

Kimball Techniques (Data Warehousing)
Experte
Data Lake / Lake House
Experte
Star, Galaxy and Snowflake Schema
Experte
MVC (Model-View-Controller)
Experte

Vertrauen Sie auf Randstad

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.