Automation Expert

5/2022 – 3/2024

Generic tasks:
• Build a strategy for Power BI implementation
• Creation of a process map
• Agile project management
• Development of a requirements catalogue & iterative requirements management
• Stakeholder analysis
• Data Lineage
• Write a design guide for reports
• Creation of a catalogue of key figures
• Training team members in Power BI
• Process optimization with RPA & Power Query
• Learning RPA Blue Prism
• Learning Azure Databricks

Power BI related tasks:
• SQL Server design: View creation & querying in datamart
• Power BI corporate design templates
• Power BI cloud: Data pipeline, Datamart & Metrics in combination with MS Power Automate flows
• Creation of a very large data model
• Creating multiple Power BI reports for different audiences
• Optimization of usability: synchronized filters, drill-downs through multi-layered hierarchies, bookmarks, wide spectrum in presentation and viewing methods
• DAX & Power Query programming
• Mapping of complex business logic in the data and visualizations
• Data Quality Management via Power BI incl. Metrics & automatic Power Automate notifications
• Building a usage metrics report
• Use Parameters
• Performance Optimization: use of SQL native database query, SQL Server optimization, Power Query optimization
• Setup gateway on a server
• Bug fixing

Azure Databricks, Microsoft Power BI, SQL

4/2022 – 4/2023

• Contributing to the UiPath Community of Practice
• RPA introduction to IT support department
• Multi project management in form of using indus-trialized ETL templates and PBI reports
• Kaizen of project templates & project planning
• Design a system of service item data
• Transform static project management into agile
• Coordinating huge data correction activities across Europe

Microsoft Power Automate, Microsoft Power BI, Microsoft SQL-Server (MS SQL), UiPath

10/2020 – 3/2022

- Automation of item setup process via RPA and PBI
- Develop a complex PBI report to ensure a high data quality in several systems
- Maintaining Sharepoint, PBI workspace & Azure user groups
- Process documentation via MS Visio and a handbook

Microsoft Power Automate, Microsoft Power BI, Microsoft SQL-Server (MS SQL), UiPath

7/2020 – 8/2022

Der Kunde wollte Micro-Targeting in seinem Wahlkampf einsetzen. Ich entwickelte einen Power BI-Bericht, der auf historischen Wahldaten und Strukturdaten basierte. Die Synthese aus beidem ermöglichte es dem Kunden, einen Schwerpunkt in seinen Kampagnen zu setzen, maßgeschneidertes Marketingmaterial in den richtigen Bezirken einzusetzen und Veranstaltungen zu planen, um die richtige Zielgruppe anzusprechen.

Microsoft Power BI