Business Intelligence 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

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

• Setting architectural standards for Informatica Power Center development teams
• Maintenance-performance-health for DWH (Exadata) environments
• Qlik Sense / BO reports architectural standards
• Implementing best practices in ETL tasks
• Documentation ETL standards on Confluence
• Dynamic Data Masking rules for GDPR/KVKK regulations by using Informatica DDM tool
• DWH Data model Power Designer
• Upgrade Qlik Sense versions
• Merge all Informatica server's repository databases on one Oracle DB

• 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.

Independent Consultant

• Advisory focus: E-Commerce, Digitalization, Automation, Pricing, Assortment & Merchandising, Platform Strategy
• Industries: Retail & Consumer Goods
• Subject Matter Expert for leading management consultancies
• Ongoing executi...

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

• Delivered MVP-focused full-stack architecture for a health-sector client: Vite/React frontend, backend services on Google Cloud Run, and Supabase for database plus IAM/authentication.
• Supported product requirements engineering and prioritized cost-aware workload placement, implementing browser-side/edge computation where feasible before moving logic to backend services.

• 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

• Title: Enhancing Syntactic Awareness in Transformer Language Models for Hindi Dependency Parsing
• Investigated syntactic knowledge captured by transformer language models (RoBERTa, XLM-RoBERTa) for Hindi dependency parsing, a morphologically rich and low-resource language.
• Developed structure-aware model variants (Struct_Roberta_hi, Struct_XLMR) by integrating a CNN-based parser network between transformer layers, inspired by the StructFormer architecture.
• Conducted extensive error analysis including label-wise, distance-based, direction-based, sentence length-based, and LVC/Non-LVC evaluations.
• Evaluated models on downstream NLP tasks (NER, POS tagging) using the IndicXTREME benchmark.

• 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.

• Conducted advanced machine learning methods on large-scale inequality datasets for forecasting, clustering and feature importance to assess impacts on growth
• Integrated multi-source inequality datasets into a unified panel; applied reproducible preprocessing pipelines including variable harmonization, outlier treatment, normalization, and multiple-imputation methods
• Published four papers in international peer-reviewed journals

• 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

• Overall responsibility for strategic and operational procurement, Procurement Management (11 FTE).
• Further development of the procurement and procurement organization, including task and role model.
• Management of cross-functional special projects (e.g. value engineering, design-to-cost).
• Development and implementation of a holistic sourcing and procurement strategy with a focus on resilience, ESG, de-risking, decoupling and cost performance.
• Execution of a comprehensive procurement transformation with a new supply chain strategy alignment.
• Reorganization of the procurement team to improve efficiency through clear role allocation and relief from non-core and non-functional tasks.
• Professionalization of contract management processes and supplier development programs.
• Process optimization along the S2C and P2P chain, including standardization and automation in line with MDR (EU Regulation 2017/745), GxP compliance & quality management systems ISO 9001 and ISO 13485.
• KPI development and optimization of the KPI system for performance and efficiency measurement in critical paths and missing parts.
• Coaching the team in strategic procurement work, project management and procurement due diligence.
• Implementation of AI-supported tools for sourcing, spend analysis and inventory management to optimize inventory.
• Achieved inventory reduction of ~31% through professional inventory management.
• Management of two cost reduction (cost avoidance) programs with quantified results: ~50% reduction in manufacturing costs for one core component and ~64% reduction in material costs for the successor platform through redesign and category sourcing.
• Savings in the low double-digit million range versus the baseline.
• Material groups: contract manufacturing, PCBA, EMS, blower, silicone injection molding, power supplies, batteries, displays, hoses, masks, valves, foams, cables, sensors, wireless modules (2G–5G), telemedicine components, laboratory services.