Microsoft Azure 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

• Established a cyber resilience framework for AI-accelerated threats in the Frontier AI Threat Endurance (FATE) program: capability assessments, maturity assessments and gap analyses covering cyber security, operational resilience, incident response, recovery and governance, followed by target concepts and improvement measures
• Supported action owners from specification through implementation: implementation roadmaps, decision papers, management presentations and governance reporting, as well as audit- and supervision-ready documentation; managed stakeholders from IT, Information Security, Risk Management, Operational Resilience, Business Continuity and the business units

• 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

• Training AI models, evaluating images and text UI/UX, turning the provided data into insights through OpenAI Feather as part of the machine learning workflow

Technologies: OpenAI Feather

Tools: Fabric, AWS, dbt, Power BI, SQL, DWH, R, Python

• Supported customers in implementing an architecture design for extracting and preparing data
• Planned the design and implementation of the BI and DWH platform
• Ensured the scalability and performance of the data platform

• 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

• AI-Enabled Analytics & Reporting: Lead a 2-person BI team, applying predictive analytics and automation to translate complex business requirements into forward-looking insights, recommendations, and financial reports.
• Advanced Data Visualization: Design and maintain 25+ high-impact Power BI/Tableau dashboards tracking company-wide KPIs and trends, structured to support predictive and automated reporting.
• Web Analytics & Insights: Own GA4 tracking and analysis, driving a 15% increase in conversion insight through deeper customer journey analysis.
• Data Pipeline Optimization: Partner with data engineers to redesign and automate data pipeline workflows, cutting manual reporting time by 20% while safeguarding data accuracy and system uptime.

• Expansion and support of the product portfolio for video analytics and Computer Vision
• Requirements gathering and requirements engineering
• Consulting, project management, and coordination of pilots and the international rollout
• Tools: IP-based camera and video systems, Citrix Administration, OneNote, Microsoft Teams, Node-Red, Office 365, Age Verification, Qognify Umbrella, Thingsboard, Xovis 3D Sensors, AXIS Cameras, GK POS software, Atlassian JIRA

• 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

• Transition of Microsoft Azure operations to BTC AG
• Responsibility: Budget of 60k €
• Personnel: Managed 5 people
• Tools: Office 365, JIRA, Confluence

• Evaluation and further development of Engineering Excellence initiatives as part of the “Digital First” program
• Validation of efficiency, productivity, and cost-saving potential in the Software Development Lifecycle (SDLC)
• Organization-wide analysis of the use of Generative AI in the Software Development Lifecycle (SDLC)
• Evaluation of optimization measures in the areas of product management, delivery, developer experience, metrics, and quality assurance
• Alignment of the “Next Level Architecture (NLA)” target vision with regard to organizational design, governance model, and scalability
• Identification of structural bottlenecks in the delivery organization and development of alternative optimization approaches
• Preparation of decision-making and management documents for department management and the Executive Board to evaluate efficiency potential and transformation measures

Skillset: Engineering Excellence, Operating Model Design, Generative AI, AI in SDLC, SAFe, DevOps, Software Delivery Metrics, Value Streams, Team Topologies, Domain Driven Design, Azure DevOps, Jira, Confluence, Management Reporting, Business Case Assessment

• 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