Miguel Angel | Data Analyst @ Lufthansa Technik | Power BI, Python, SQL, Tableau, Azure

Miguel Angel

Data Analyst @ Lufthansa Technik | Power BI, Python, SQL, Tableau, Azure

Based in Miami, FL

About

I'm Miguel Ángel Arroyo, a data analyst from Sevilla, Spain, with a background in NCAA Division 1 swimming. My passion for technology led me to pursue a Master’s in Big Data Analytics in Miami. At Lufthansa Technik, I specialize in business intelligence, developing scalable BI solutions, real-time dashboards, and API integrations to optimize performance. I focus on automating workflows to enhance efficiency and data-driven decision-making. With a results-driven mindset and a passion for learning, I strive to bridge the gap between data and business impact.

Skills

Projects

Power BI Business Sales Dashboard Development and Optimization

Developed a Power BI dashboard for restaurant businesses on third-party delivery platforms. Leveraged advanced technical skills in Power BI, utilizing DAX measures and Power Query functionalities. Integrated essential Key Performance Indicators (KPIs)

King County, Washington House Sales Dashboard

Created a comprehensive Tableau dashboard for King County, Washington, focusing on house sales data. Emphasized data storytelling and visualization techniques for effective insights.

Predictive Modeling and EDA of Electric Vehicle Dataset

This project involves a comprehensive exploration of electric vehicle (EV) data to reveal adoption trends-insights, charging patterns, and consumer preferences. By using predictive analytics, it aims to forecast future EV adoption and address key challenges in the electric vehicle landscape.

Spotify Advanced Power BI Dashboard

Developed an advanced Power BI dashboard for Spotify, enhancing visualization with HTML and DAX. Gained proficiency in Power BI for detailed data insights and analytics.

EDA and Linear Regression Model to predict hospital bills from health data

The project performs detailed Exploratory Data Analysis (EDA) in R on medical insurance data to explore variations in medical charges. A subsequent linear regression model predicts hospital bills based on various factors, revealing significant associations that provide crucial insights.

Sales Analystics and Operations Project

Built a Power BI dashboard to analyze sales performance, including revenue trends, product sales, and employee contributions, using DAX and Power Query for advanced data modeling. Designed dynamic visualizations with conditional formatting and created a time-based analysis system

Google Fiber Customer Service Analysis

Designed a Business Intelligence dashboard for Google Fiber’s customer service team to analyze repeat call trends and improve customer satisfaction. This project simulated a real-world BI scenario, requiring structured thinking, stakeholder collaboration, and dashboard development.

Experience

September 2023 - May 2024

Business Intelligence Analyst at Sisifo Analytics

Played a pivotal role in driving a transformative project aimed at empowering restaurants utilizing third-party platforms like Uber Eats, DoorDash, and Grubhub. Responsible for end-to-end management, I orchestrated the aggregation and cleansing of diverse datasets, establishing a standardized data infrastructure for consistency. Leveraging my expertise in Power BI and Data Analysis Expressions (DAX) measures, I developed a dynamic dashboard featuring essential Key Performance Indicators (KPIs) crucial for strategic decision-making. By emphasizing data-driven principles, the project aimed to optimize operations, reduce third-party reliance, and foster direct sales growth for the restaurant businesses.

June 2024 - Present

Data Analyst at Lufthansa Technik

• Collaborated with the customer service team to understand their data needs and requirements. • Developed and automated business reports and KPIs using Power BI, Python, and Excel. • Streamlined reporting and business processes, reducing manual data entry time. • Built real-time dashboards to improve performance tracking and operational efficiency. • Extracted and analyzed data from SAP, SQL, and other sources to provide insights for decision-making.

Education

2022-2024

MASTER OF SCIENCE IN BIG DATA ANALYTICS

St. Thomas University College of Sciences and Technology Data Science, EDA, Machine Learning, Business Intelligence GPA: 3.70/4.00 Miami, Florida

2020-2022

BACHELOR OF SCIENCE IN INTERNATIONAL BUSINESS AND ECONOMICS

California Baptist University 2 x Provost’s List Business Analytics, Supply Chain, Marketing, Finance GPA: 3.69/4.00 Riverside, California