Automatisation expert, Data visualization specialist, Excel Guru, Power BI addicted & Out of the box thinker
- Verfügbarkeit einsehen
- 0 Referenzen
- auf Anfrage
- 10247 Friedrichshain-Kreuzberg
- Umkreis (bis 200 km)
- it | en | es
- 25.05.2024
Kurzvorstellung
Qualifikationen
Projekt‐ & Berufserfahrung
7/2022 – offen
Tätigkeitsbeschreibung
Power BI Report-Designer (Frontend) 07/22 – now Energy Sector
● Source Data: Excel Files and SSAS cube
● Advanced Power BI Dashboard (Scatter Plot, Parameter based for source connection, complex DAX calculation.)
● Develop various Dashboard pages for internal Controlling
● Develop various KPIs based on definition of Controlling
● Tools: Power BI Services, Power BI Desktop, SQL Server
● My Role
○ Design Visualization in Power BI
○ Discuss the needs with the specialist departments and derive user stories from them
○ Optimize existing data model
○ Implement complex calculations in DAX (percentiles, scatter plots, etc.)
Power Bi
10/2017 – 4/2023
Tätigkeitsbeschreibung
Improvement of the existing Excel-Dashboards process. Development of new features and tools as part of the Excel Dashboard Framework (like Workpaper, Snap Shot, Translation, Speed Test Tool and Pre-Populating Utility).
● Improved stability and reduced maintenance efforts for the EDBFW. Increased maturity of automation in build production of the dashboards and in the Testing tool.
● Assessment and fixing of issues with the Excel Dashboards or the framework. Create smart solutions to flexible dashboard functions. More focused on General Ledger Analysis and
Financial Services, I helped in other projects. Lately, I also work as a Scrum Master (together with a colleague). ● Analysis of the possibility to add (or move to) Power BI and the possibility to move to Excel online.
● Always available to help colleagues (for example with problems concernin VBA) and to explain new features / possibilities (for example regarding Power BI).
Power Bi, Agile Methodologie, Scrum, VBA (Visual Basic for Applications), Microsoft Excel
9/2015 – 9/2017
Tätigkeitsbeschreibung
● Analysis of the challenges related to the acquisition of new processes, from the technical to the organizational point of view, finding solutions adapted to the available resources and in time with the deadline.
● Acquisition of European reporting activities, including on-site presence (Germany, Switzerland, Denmark). Data generation and processing using SAP Analysis Office and various business warehouse systems for cost and consolidated income (including SAP R / 3). Improvement of the creation process of the reports, from the data retrieve to the delivery of the report, including high level of automatization using VBA (excel, access, PPT, outlook, pdf…). Introduction and standardization of European reports with components from different BW systems
Power Bi, Microsoft Excel, SAP HANA, VBA (Visual Basic for Applications)
Ausbildung
Universitá Ca Foscari Venezia
Venedig
Über mich
Achieving Results: I develop fast prototypes to get early feedback before I start the final implementation. I always show a high level of commitment, working very independently and making his own decisions.
Fostering Innovation: I’m characterized by my always high motivation to create new innovations and to solve problems efficiently.
Other characteristics with which others describe me: Inspiring & Motivating Others, Value-Based Collaboration, Value-Based Collaboration, Data Driven, Technology Enthusiast
Weitere Kenntnisse
● >10 years of experience: Excel, Visual Basic
● 5-10 years of experience: PowerBI, Power Query, DAX, MS Access
● 2-5 years of experience: SQL Server Management Studio (SSMS); MS Reporting Services (SSRS); Data Warehouse; Transact-SQL; Visual Studio, Azure Analysis Services (AAS), Git, Visual Studio Code, AzureDevOps
Project Management
● Agile Programming (Defining Requirements/ User Stories, implement solution, present results to stakeholders), SCRUM, KANBAN, Classical Project Management (V-Model)
Persönliche Daten
- Italienisch (Muttersprache)
- Englisch (Fließend)
- Spanisch (Fließend)
- Deutsch (Gut)
- Europäische Union
Kontaktdaten
Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.
Jetzt Mitglied werden