Microsoft SharePoint Experts in Essen

• Designed and developed a production-ready data platform based on Microsoft Fabric for an e-commerce company
• Built a scalable Medallion Architecture (Bronze, Silver, Gold) with Lakehouse and Delta Lake as the foundation for analytics and AI applications
• Developed a metadata-driven ETL platform with PySpark and a generic Incremental Loading Framework (SQL Server → Bronze → Silver → Gold)
• Developed reusable components for Microsoft Fabric Notebooks to standardize data integration, transformation, and validation
• Implemented automated data pipelines including monitoring, logging, error handling, and Delta MERGE strategies for stable production operations
• Built a business layer architecture for reporting, data warehousing, and reusable data products
• Integrated heterogeneous data sources via SQL Server, REST APIs, Amazon SP API, and Google Analytics 4
• Worked closely with business departments to analyze business requirements and translate them into scalable data architectures

Technologies: Microsoft Fabric, PySpark, Python, SQL Server, Delta Lake, Lakehouse, OneLake, Data Factory, Data Warehouse, REST APIs, Amazon SP-API, Google Analytics 4

• QA Lead for end-to-end quality assurance of the Sparkasse & Sparkasse Business banking apps (iOS/Android); design and implementation of the Test Strategy including functional testing, regression testing, and UAT for eID, Push Notifications, and white-label components
• Creation and maintenance of test concepts and test plans in TestRail; structured Defect Management and error analysis; stakeholder management and risk management for the early identification of critical quality risks
• Accessibility Testing according to WCAG 2.1 (iOS/Android); coordination of AI-supported test automation and optimization of test processes to shorten release cycles
• Release Management: planning, management, and coordination of all test activities; status reporting to management and stakeholders; quality assessment of releases and release recommendations in an Agile/Scrum environment
• Challenge: Highly complex build and release process across several Sparkasse institutions; close coordination with the DevOps team to stabilize the CI/CD pipeline and ensure reproducible test builds before every release.

Tools: Jira, Confluence, TestRail, Android Studio, Xcode, Firebase, Jenkins, GA4

• Success: Successful launch of the eID authentication process - quality assurance ensured for 50+ Sparkasse institutions

• Created data pipelines and visualization tools to support sustainable energy decision-making
• Developed insights that could optimize renewable energy deployment and grid integration strategies

• Management of IT with 10 employees, including budget and personnel responsibility.
• Harmonization of the Navision systems in Germany, Switzerland and Austria.
• Connection of the ERP systems in Switzerland, Austria and Italy to the central Microsoft Power BI systems in Germany.
• Rollout of a new firewall at 10 locations in D, CH and A.
• Evaluation of a new DMS.
• Migration to Windows 10 / 11.
• Transformation of 9 countries into ONE Europe.
• Start of NIS2 implementation in 5 European countries.

• Development of Power BI reports, measures, and KPIs for sales, purchasing, materials management, warehousing, and production
• Analysis of the proALPHA database (Progress OpenEdge) and high-performance SQL queries for extraction and transformation
• Data models, ETL processes, and pipelines including automated refresh via Power BI Service and Data Gateway
• Gathering requirements and implementation in close coordination with the specialist departments

Selected projects:

• Sales report: revenue, incoming orders, and order status
• Purchasing report with automated purchase suggestions (Power Automate)
• Monitoring of missing parts for production and materials management
• Production bills of materials on Microsoft Fabric including deployment pipeline (Dev → Prod)
• Forecast comparison report
• Central Power BI apps that bundle all reports by department

Technologies: Power BI, DAX, Power Query (M), SQL, proALPHA, Progress OpenEdge, Microsoft Fabric, Power Automate, Python

• Requirements analysis
• Provisioning of SharePoint sites and permissions
• Provisioning of SharePoint libraries and lists as data repositories
• Development of the UI with Power Apps
• Development of automations with Power Automate to transfer data from Power Apps using Dataverse connectors
• Creation, customization and management of Power Platform security roles
• Creation and management of Power Platform Pipelines
• Development of a UX design with Power Apps

NIS2 Implementation Project and ISMS Development Based on IT-Grundschutz

Municipal utilities, public-law institution

• Analysis of the current compliance status regarding the requirements of the NIS Directive (NIS-2, EU 2022/2555).
• Identification of critical infrastructures and processes within the organization.
• Development of an action plan to meet NIS requirements.
• Conducting a risk analysis in accordance with BSI Standard 200-3 as the basis for the security concept.
• Preparation of an individual security concept including technical and organizational measures according to BSI IT-Grundschutz.
• Preparatory support for an optional certification according to BSI IT-Grundschutz.
• Adaptation of existing security policies and development of new ones for access controls, incident management and data protection.
• Consideration of municipality-specific requirements and integration of the measures into the existing IT infrastructure.
• Documentation of the results and preparation of audit-ready evidence for audits.

Tools, languages and frameworks used: MS Office, Verinice, IT-Grundschutz (200-x), NIS-2 (EU 2022/2555), ISMS, AI-Act (EU 2024/1989)

• CHG Meridian AG is a financial company focused on leasing in the areas of IT technology, logistics and medical technology and is regulated by BaFin. One part of the company is Return to Remarketing, where devices delivered to the technology center (notebooks, smartphones, tablets, etc.) are prepared for resale. The project I supported was responsible for enabling damage assessment of returned lease devices, documenting them visually in the form of pictures, enabling invoicing for the customer, and making the pictures available via the in-house customer platform. This was achieved through a combination of in-house development within the internal development department and the use of SaaS products. The second project was the transition of SaaS tendering software, purchased by the business unit, into the operations of the CHG IT department. Evaluation of security questions in relation to BaFin requirements, development of an authorization concept, implementation of single sign-on, documentation of the application in the CHG systems (CMDB, iKnow, etc.) and handover into operations.

Used technologies and methods: NIS2, DORA, agile software development, Scrum, Kanban, ServiceNow, SaaS, MS Teams, MS SharePoint, Active Directory, Entra ID, CMDB, incident management, change management, request management, service level agreement

• The goal of Afworki GmbH IT-Consulting is to make small and medium-sized companies more competitive by overcoming challenges in digitalization, automation, and data management.

• Tailored technology, strategy, and specialist consulting designed to meet the individual needs of each company.

• Analyzing the company's current situation and developing the best possible solution together with the client.

• Using both agile and classical IT project management methods to deliver projects on time and within budget.

• Focusing on automating and orchestrating all data flows in a data warehouse to create a unified and standardized data foundation.

• Considering the dependencies between IT and business to achieve sustainable positive effects.

• Employing modern strategies and tools specifically tailored to the company's needs.

• Supporting digitalization, the introduction of agile working methods, and the creation of up-to-date reports and analyses.

• Objective: streamlining management and enabling well-founded, data-driven decision-making.

• Led the subproject for implementing Vulnerability Response as part of DORA
• Documented the current processes in compliance, risk & security
• Created the functional design for introducing application, infrastructure, and cloud vulnerabilities
• Agile management of the integration service provider, the technical department, and the company's cross-functional teams
• Integrated the V scanners Tenable, Qualys and Defender, as well as NVD and CISA/KEV
• Integrated GitLab Ultimate for importing and processing SBOMs
• Developed automation rules to match scan results with CIs in the CMDB, assign vulnerabilities and remediation tasks, handle approvals (false positives, exceptions) and closures
• Calculated multiple risk scores and priorities
• Defined dashboards and reports (Workspaces, Performance Analytics)
• Aligned the new processes, especially to improve the CMDB data quality (according to CSDM)

• SAP Basis operations for complex SAP system landscapes (ABAP and Java stacks)
• Administration, monitoring, and optimization of SAP systems with regard to availability, performance, and stability
• Planning and execution of data center moves as well as migrations of SAP systems and databases
• Handling of incidents, changes, and problems according to ITIL processes, including root cause analyses
• Creation of technical concepts, operations documentation, and implementation plans

Technologies: SAP NetWeaver, ITIL processes, technical migrations

• Led the 12-week training program to become an AI and automation specialist
• Created training materials & video courses on "AI Fundamentals", "Working with ChatGPT", "Prompt Engineering", "AI Agents with N8N", "Automations with Make.com" & AI-generated marketing content (images, videos, blog posts & social media posts)
• Conducted workshops on the above topics
• Tools: Loom, N8N, Make.com, ChatGPT, Midjourney, Gamma.app, Canva, Kling AI, Magnific AI
• Result: Participants learn the technical and business know-how to successfully build a business as AI and automation specialists

• Operational and financial support for the start-up build of a medical care center brand in Germany with 11–25 planned locations
• Designing a scalable site rollout model including a standardized ramp-up (go-live, capacity, FTE plan, revenue/cost projections)
• Developing an operating model and making TCO/make-or-buy decisions
• Building site business cases (revenue mix, cost structure, break-even, sensitivities) to prioritize the expansion pipeline
• Setting up liquidity and financing planning, including deriving funding requirements
• Establishing a reporting structure for transparency on performance and scaling progress
• Implementing budgeting and forecasting (rolling forecast, scenario analyses) for operational control of the medical care center build
• Standardizing employment contract templates and supporting the hiring setup

• Led workstream for analysis and optimisation of the solution development and release process within the newly established organizational structure
• Analyzed and adopted existing processes after transition of technical responsibility to E.ON Digital Services
• Supported the agile development approach within engineering teams
• Established a unified workflow for business requirements and clear communication interfaces, documented using Atlassian Jira on both the business and engineering sides
• Created dashboards with Rich Filters for Jira Dashboards to provide an overview of feature releases and their connection to technical releases
• Designed new burnup charts and statistics per release to improve transparency of overall technical progress at the product level