freiberufler Automatisation expert, Data visualization specialist, Excel Guru, Power BI addicted & Out of the box thinker auf freelance.de

Automatisation expert, Data visualization specialist, Excel Guru, Power BI addicted & Out of the box thinker

offline
  • auf Anfrage
  • 10247 Friedrichshain-Kreuzberg
  • Umkreis (bis 200 km)
  • it  |  en  |  es
  • 25.05.2024

Kurzvorstellung

Automatisation expert, Data visualization specialist, Excel Guru, Power BI addicted & Out of the box thinker

Qualifikationen

  • Agile Methodologie5 J.
  • Latex
  • Microsoft Excel7 J.
  • Microsoft Powerpoint
  • Power Bi9 J.
  • SAP HANA2 J.
  • Scrum5 J.
  • VBA (Visual Basic for Applications)7 J.

Projekt‐ & Berufserfahrung

Power BI Developer (Festanstellung)
HexaBase GmbH, Berlin
7/2022 – offen (2 Jahre, 5 Monate)
IT & Entwicklung
Tätigkeitszeitraum

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

Eingesetzte Qualifikationen

Power Bi

Power BI, Excel & Visual Basic Developer (ETL & Frontend)
KPMG, Berlin
10/2017 – 4/2023 (5 Jahre, 7 Monate)
Finanzdienstleister
Tätigkeitszeitraum

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

Eingesetzte Qualifikationen

Power Bi, Agile Methodologie, Scrum, VBA (Visual Basic for Applications), Microsoft Excel

Reporting Specialist (Festanstellung)
BASF, Berlin
9/2015 – 9/2017 (2 Jahre, 1 Monat)
Chemieindustrie
Tätigkeitszeitraum

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

Eingesetzte Qualifikationen

Power Bi, Microsoft Excel, SAP HANA, VBA (Visual Basic for Applications)

Ausbildung

Bachelor/Master in Economics and Business
Statistics and Analysis of complex systems
Universitá Ca Foscari Venezia
2004
Venedig

Über mich

Iam a very collaborative person, solution oriented, focused on improvement and development, with pro-active attitude. Due to my expert knowledge of Microsoft Excel (guru level), Power BI, Microsoft Access and VBA I work with a high level of automation.
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

Programming, Database and Cloud
● >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

Sprache
  • Italienisch (Muttersprache)
  • Englisch (Fließend)
  • Spanisch (Fließend)
  • Deutsch (Gut)
Reisebereitschaft
Umkreis (bis 200 km)
Arbeitserlaubnis
  • Europäische Union
Profilaufrufe
299
Alter
48
Berufserfahrung
16 Jahre und 7 Monate (seit 04/2008)

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden