Profilbild von Lukas Reese Professional Data Analyst | PowerBI | Excel | SQL | Python | alteryx aus Springe

Lukas Reese

verfügbar

Letztes Update: 27.10.2023

Professional Data Analyst | PowerBI | Excel | SQL | Python | alteryx

Abschluss: M.A. International Business Management
Stunden-/Tagessatz: anzeigen
Sprachkenntnisse: deutsch (Muttersprache) | englisch (verhandlungssicher)

Schlagwörter

Data Analysis Python Power Bi SQL Alteryx Automatisierung Business Intelligence Kommunikation Datenbereinigung Datenvisualisierung + 5 weitere Schlagwörter anzeigen

Dateianlagen

CV-Lukas-Reese-Data-Analyst_271023.pdf

Skills

I am a professional Data Analyst helping you to bring your data alive. I translate raw data into actionable insights using Business Intelligence Tools such as Excel, PowerBI, Python, SQL and alteryx.

My skills:
✅ Data Cleaning, Data Analysis, Data Preparation, Data Visualization, Statistical Tests
✅ Data Modeling, Data Model improvement & DAX
✅ Automation of repetitive tasks
✅ Tools: Excel, Power BI, Python, Alteryx, SQL Here's how I helped my previous employer:
✅ Analyzed 30+ million rows of data, investigated trends leading to 200.000€ savings.
✅ Increased visibility and transparency of logistics carrier performance and freight costs
✅ Helping management to make actionable decisions.
✅ Answering to several ad-hoc request by understanding the business context and the nature of request helping my coworkers to focus on what they do best and save valuable time.

My background:
✅ Certified Professional Data Analyst
✅ Master's degree in International Management
✅ 3+ years working experience in logistics field including Project Management & Data Analytics

Why me?
✅ A positive client experience is my number one concern
✅ Ability to translate your requirements into meaningful insights
✅ Passionate Data Professional always looking to deliver the highest quality results
✅ 24/7 ultra-reliable communication: You will always be aware of the project status ✅ Because I genuinely care about helping you succeed in your business
✅ Delivering fast and accurate results by always thinking about the business context
✅ I will customize dashboards based on you individual design needs (color, font, logo)
✅ International & intercultural experience, knowing how to work in different environments.

Projekthistorie

02/2023 - bis jetzt
PowerBI Developer (freelance)
Afag (Industrie und Maschinenbau, 500-1000 Mitarbeiter)

- Spearheaded data analysis and optimization efforts, enhancing the data set and data model for improved supply chain insights at Afag Group.

- Conducted comprehensive data cleaning and restructuring of fact and dimension tables, resulting in enhanced performance and data accuracy.

- Successfully implemented custom-designed reports catering to specific supply chain requirements, providing actionable insights to stakeholders.

- Utilized advanced DAX formulas to create dynamic reports on crucial supply chain metrics such as inventory turnover, lead time, customer satisfaction, and portfolio analysis.

- Employed Power BI's cutting-edge features, including bookmarks and drill-through functionality, to deliver an engaging and intuitive user experience.

- Ensured seamless user experience by regularly updating and refining the Power BI app, incorporating user feedback and addressing evolving business needs.

11/2022 - 10/2023
Digital Analyst (freelance)
Telefonica (Telekommunikation, >10.000 Mitarbeiter)

- Gathered and verified KPIs from multiple areas and departments to provide a 360-degree view, enabling efficient fraud detection for Telefonica.

- Utilized Power BI and DAX functions to implement scoring logic, effectively identifying and preventing fraudulent behavior.

- Employed robust data cleaning techniques to ensure accuracy and reliability, facilitating precise analysis and decision-making.

- Translated complex data into clear, insightful Power BI visualizations, aiding stakeholders in data-driven decision-making.

- Collaborated with cross-functional teams to understand business requirements and create effective data models for analysis.

10/2020 - 06/2022
Logistics & Planning Specialist
Pandora (Konsumgüter und Handel, >10.000 Mitarbeiter)

* Developed and maintained an existing Power BI solution to optimize carrier freight
costs using alteryx, SQL and PowerBI leading to increased costs transparency and
savings >150.000 EUR
* Created data visualiations using PowerBi to monitor carrier delivery performance
and increase customer satisfaction while reducing bottle-necks.
* Streamlined logistical freight cost budget for EMEA. Communicated with various
stakeholders to increase transparency and analyzed monthly performance of three
supply chain flows.
* Automized repetitive tasks by utilizing alteryx and Power Query to improve
efficiency

10/2019 - 09/2020
Junior Consultant Logistics & SCM
umlaut Consulting GmbH

* PMO role in digitalization project at Airbus in the agile SAFe Framework
* Monitored reports & prepared user analyses
* Communicated impediments and progress of new developments to stakeholders
* Modeled and analysed new process for ERP System implementation using MS Vison

Zertifikate

Professional Data Analyst
2022

Reisebereitschaft

Nur Remote verfügbar
Remote contracts only. Flexible with working time and hours.

Sonstige Angaben

I am a passionate and certified Data Analyst having a masters degree in International Business Management. I love to go into the details and exploring data sets with the goal of improving decision making process and reducing costs. Data can tell an unbiased story that not many people can tell. It gives black on white insights on company processes, performances, weaknesses and strengths. I know how to gather data requirements from stakeholders, query the data, clean and transform the data and communicate it back to stakeholders. Three years of working in Hamburg, Germany, as a logistics consultant and as a logistics analyst in the Jewellery industry gave me valuable experience. On the technical part as well as on the people part. Since July 2022 I started my freelance journey as a data analyst helping my clients in data and PowerBI related project. However, it was always my dream of working remotely as a data analyst while being location independent. By leveraging multiple tools such as PowerBI, alteryx, SQL, Python and Excel in my previous job, I was able to explore patterns, find hidden costs and optimize logistics freight costs. My aim is to give you an "aha-effect" about your data which will help you grow and optimize your business.
Profilbild von Lukas Reese Professional Data Analyst | PowerBI | Excel | SQL | Python | alteryx aus Springe Professional Data Analyst | PowerBI | Excel | SQL | Python | alteryx
Registrieren