Big Data & Analytics Consultant

4/2023 – 7/2023

Project goal:
• Integrate business logic in the data warehouse to develop KPIs required for tracking
• Automate P&L reporting to streamline the monthly financial reporting process

Project outcome
• Automated P&L Dashboard that provides full visibility on performance on multiple granularity

• Skills: Analytics, Optimization, Business Intelligence, Data Visualization
• Tools: SQL Server, Coding in Python, Power BI

Big Data, Business Intelligence (BI), Business Intelligence and Reporting Tools (BIRT), Datawarehouse / DWH, Microsoft Power BI, Datenbankadministration, mySQL, Projektmanagement (IT), Python

9/2022 – 12/2022

Project goal:
• Track competitor prices across multiple markets
• Automate the price collection process
• Introduce a competitors pricing dashboard

Project Outcome:
• Developed an automated competitors’ price gathering tool for ~70 brands
• Developed a Tableau dashboard that helps visualize price evolution for multiple products across markets

• Skills: Web scraping, Data Engineering, Data Visualization
• Tools: SQL Server, Coding in Python, Tableau

Automatisierungstechnik (allg.), Big Data, Business Intelligence (BI), Data Mining, Data Science, Datawarehouse / DWH, Pega Robotic Process Automation (RPA)

10/2021 – 9/2022

Project goal:

• Develop a data platform that would help in business steering
• Align with different stakeholders to build multiple use cases
• Develop a roadmap to identify key priorities that would enable the company’s growth

Project outcome:
• Developed a blueprint of the technical requirements needed to achieve the business goals
• Developed a singe source of truth and verified data sources used to calculate business KPIs and dashboards

• Skills: Project Management, Analytics, Data Visualization, Data Processing
• Tools: SQL Server, Jira, Tableau, Confluence

Big Data, Business Intelligence (BI), Datawarehouse / DWH, Datenanalyse, mySQL, Projektleitung / Teamleitung (IT), Python, Produktdatenmanagement (PDM)