SQL Server Reporting Services Experts

• Led enterprise reporting modernization by migrating legacy SSRS reporting solutions to Power BI, supporting 500+ business users while ensuring full GDPR/DSGVO compliance.
• Designed and optimized Power BI and Microsoft Fabric semantic models using star schema, dimensional modeling, advanced DAX, and performance optimization techniques, reducing query latency by 25%.
• Delivered 20+ executive and operational dashboards featuring KPI scorecards, drill-through, bookmarks, and row-level security, improving reporting efficiency by 20%.
• Enabled self-service analytics through governed Power BI datasets, dataflows, and gateway architecture, increasing business-led reporting adoption by 35%.
• Configured an incremental refresh policy and query folding for a 50+ million row sales dataset, reducing daily report refresh times by 85%.
• Deployed automated ETL/ELT pipelines using Azure Data Factory, Microsoft Fabric, and Snowflake, reducing reporting delivery timelines by 40% through workflow automation.
• Spearheaded Microsoft Fabric analytics modernization initiatives including lakehouse architecture, OneLake integration, and centralized data platform development, reducing data latency from 2 hours to 20 minutes.
• Translated business requirements from 15+ stakeholders into scalable Power BI semantic models and dashboards, improving reporting consistency and reducing ad-hoc reporting requests by 25%.
• Applied Microsoft Copilot and generative AI tools to accelerate SQL development, DAX authoring, technical documentation, and testing activities, reducing development effort by approximately 15 hours per week.

• Structured analysis and evaluation of business processes

• Gathering, documenting, and prioritizing requirements

• Creating business-friendly and technically executable process models

• Use of Camunda tools

• Deriving requirements and interfaces from BPMN diagrams

• Coordination with stakeholders and business units

• Translating business requirements into technical solution designs

• Implementing efficient and tailored applications

• Systematic collection, analysis, and documentation of requirements

• Prioritizing and validating requirements in close collaboration with stakeholders

• Alignment between business and development to ensure shared objectives

• Creating use cases, user stories, and acceptance criteria

• Continuous requirements and change management throughout the project lifecycle

• Define project goals and create project plans

• Delegate tasks and monitor project progress

• Monitor budgets and inform stakeholders

• Mendix: Architecture, development, and maintenance of custom applications (Microflows, Domain Model, Security, XPath)

• Modeling Mendix workflows for process optimization

• Develop scalable apps with Mendix including REST/SOAP integration with SAP, SQL, Azure & SharePoint

• UI design for Mendix using Atlas UI, Fluent UI, HTML, CSS, JavaScript

• Develop web & mobile apps with Mendix using agile methods (Scrum, Kanban)

• Implement business logic with Mendix Microflows and Nanoflows

• Performance optimization and architecture improvements for Mendix applications

• Conduct Mendix training

• Create technical documentation and best practices for Mendix

• Coaching and mentoring for low-code development with Mendix

Creation of workflows for generating the data basis for the article import of a web shop: combining data from several sources, analyzing the requirements, designing the process with Jupyter Notebooks and Knime. Also creating code for automation in Python using Polars and Pandas.

Processing the source data, filtering and merging the source files and creating the needed intermediate products, creating the upload files, plausibility checks, quality checks.

Technologies used: PyCharm, Python, Jupyter Notebooks, SQL, Knime. Pandas, Polars

• Led end-to-end delivery of complex international customer-facing IT and system transformation projects across mobility, retail, life sciences, and product development domains.

• Managed project opportunities and delivery initiatives from concept development, planning, execution, migration, validation, deployment, and final customer acceptance.

• Acted as the primary point of contact for project stakeholders, ensuring alignment between customers, business units, suppliers, and delivery teams.

• Ensured timely project execution through proactive monitoring of milestones, deliverables, dependencies, risks, and resource requirements.

• Led and coordinated global cross-functional teams of 20+ members across multiple time zones. Served as the central coordination point for project activities, ensuring accountability, milestones, progress tracking, and timely resolution of issues across multiple stakeholders. Managed status reporting with all the stakeholders, providing clear and timely updates to ensure alignment on project goals.

• Provided functional leadership, mentoring, coaching, and issue resolution support to project team members. Worked closely with senior leadership and executive stakeholders to define project charter and project scope, priorities, milestones, manage dependencies, success criteria and achieve project goals.

• Collaborated closely with senior leadership, business stakeholders, suppliers, operations teams, and external partners to define project objectives and ensure successful execution.

• Managed stakeholder communication through executive dashboards, KPIs, governance reviews, steering committee meetings, and project status reporting.

• Anticipated business needs and provided effective technical solutions in a timely manner to improve business satisfaction.

• Led and supported sub-project management structures, ensuring consistent execution, reporting, and escalation across complex initiatives.

• Managed supplier relationships and service providers to ensure compliance with contractual obligations, service levels, timelines, and quality expectations.

• Supported vendor selection processes, RFP evaluations, delivery governance, cost monitoring, and performance reviews.

• Controlled project budgets, forecasts, resource allocations, and financial tracking to ensure delivery within approved constraints.

• Scheduled workshops explaining the business requirement, prioritizing project goals and managing change.

• Oversaw cloud migrations (Azure/ AWS), database migrations/upgrades, system upgrades, infrastructure & application modernization, data management, legacy decommissioning initiatives, AI solutioning, transition plan of 2000+ applications etc.

• Coordinated execution, deployment, integration, commissioning, data migration and handover activities to ensure production readiness.

• Led a cross-functional team proactively managing dependencies and resolving project issues to closure, while maintaining delivery timelines.

• Proactively managed project risks, dependencies, issues, change requests, and escalations to ensure predictable project outcomes.

• Ensured compliance with GxP, ITIL, corporate governance standards, validation requirements, and audit controls.

• Led internal and external audit support activities, validation documentation, CAPA coordination, and regulatory compliance initiatives.

• Drove process standardization, automation, and governance improvements across project delivery functions.

• Led application rationalization initiatives resulting in the retirement of more than 50 legacy applications, improving operational efficiency and reducing maintenance costs.

• Currently driving Generative AI initiatives to automate project documentation, reporting, knowledge management, and delivery processes.

• Facilitated lessons learned workshops and implemented continuous improvement actions to enhance project execution effectiveness.

• Development of ETL pipelines with Talend (7/ Enterprise)
• Development/adaptation of database schema/database functions (PostgreSQL)
• Development of GIT CI pipelines

Technologies: Talend Enterprise, Git, PostgreSQL, Dbeaver, SQL, PL-SQL, Liquibase

• Led design, development, and deployment of data solutions supporting a major pharma acquisition for Takeda Pharmaceutical Company, delivering transparency reporting systems across Azure,Databricks (Python and Shell Scripting) platforms.
• Owned,Designed and developed scalable ELT pipelines to process Customer and Product data using Azure, complex SQL, Databricks, and shell scripting, enabling efficient data integration and processing across multiple sources including job orchestration and workflow automation.
• Implemented performance optimization techniques (query tuning, parallelism, workload optimization), improving system efficiency and processing time.
• Applied strong analytical and problem-solving skills to assess technical solutions and support business requirements for compliance and transparency reporting.
• Designed scalable data foundations suitable for downstream analytics and AI workloads.
• Led data quality initiatives by assessing multiple source data, defining quality metrics, and establishing processes for monitoring and continuous improvement.

Task

• Further development of a new ERP system with Blazor
• Creation of e-invoices with the XRechnung and ZUGFeRD format
• UI/UX design Client-server system
• Windows 11 Technology
• Microsoft .NET 9, Git, Azure DevOps, ASP.NET, MSSQL, Blazor Programming languages
• C#, MVVM Development tools
• Microsoft Visual Studio .NET 2022 Database
• MSSQL Industry
• Other

DWH for customer and financial data

• Extension of the DWH with new data sources
• Report development
• Data quality management

Methodology: Scrum

Tools: Atlassian Confluence & Jira

Databases: Microsoft SQL Server

Programming languages: SQL, T-SQL

ETL: Microsoft SQL Server Integration Services (SSIS)

Frontend platform: PowerBI, Microsoft Reporting Services

• Implemented the BI solution and replaced the old BI landscape
• Led the “Sales Bonus Plan” subproject: expanded the existing solution and migrated to Azure (Databricks)
• Led the “Cognos Migration” subproject: expanded existing data warehouses based on MS technologies (source systems: Oracle), analyzed business requirements and designed the technical solution
• Expanded the relational DWH database
• Developed ETL processes using SSIS
• Developed the multidimensional database (OLAP Cubes/SSAS)

• Support and further development of a complex process for creating XML documents for electronic invoices / E-Invoicing (XRechnung, ZUGFeRD)
• Automation of operational processes, process development and optimization
• Development of frontend applications with MS Power Apps
• Porting SQL Server 2016 to SQL Server 2022
• SQL Server database administration

• Consulting and creation of various web applications based on SharePoint and the React framework for different clients
• Development and testing of accessible apps for SharePoint
• Creation of various test cases for test automation
• Development of various solutions based on Azure
• Creation of various web services based on .NET
• Development of various SharePoint Framework solutions
• Development of various UI solutions based on SharePoint
• Consulting and creation of various Power Apps applications and Power Automate for the steel industry and an IT consulting company
• Support, consulting, and development with offshore teams for SharePoint 2013, 2016, and microservices for a logistics company
• Consulting, concept design, and development of microservices and web applications based on Microsoft technology and the React framework for a logistics company
• Consulting, concept design, and development of various SharePoint Framework solutions on SharePoint 2016 for logistics
• Consulting for the migration from SharePoint 2010 to 2016 for an IT consulting company

• Digitalization in the public sector
• Worked on 4 different projects to date
• Development of a tool for managing municipal data
• Development of a tool for certifications
• Further development of two tools for managing funding
• Creation of functional modules based on .NET
• Creation of SQL queries for reports and documents
• Creation of scripts for data transfers to the FISBOX® database
• Creation of specialist applications using the standard tools of FISBOX
• Development of data models and screen structures
• Implementation with FISBOX
• Development of evaluations with FISBOX
• Development of evaluations with SQL Server Reporting Services
• Participation in requirements gathering and analysis of customer requirements, as well as in the creation of technical concepts
• Creation and further development of technical documentation
• Creation of test cases, execution of developer tests and participation in quality assurance measures
• Technologies: FISBOX, C#, .NET, Visual Studio, MSSQL, SSMS, SSRS, Power BI, TFS, Git, Angular, Blazor

• Replacement of a Java application and the Oracle DB for loading the internal WerWasWo system using SSIS.
• Development of SSIS packages to load text files into the database (SQL Server)
• Development of a database project for deployment on various servers
• Creation of queries to monitor the loading runs
• Development of a PowerShell script to automate the deployment of the SSDT projects.
• Oracle, SQL Developer, Microsoft SQL Server 2022 on-premises, SQL Server Management Studio v21, Visual Studio 2022, SSIS, SSDT, PowerShell.

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