Abdalah Fallaha
Data Engineer and Developer
Abdalah entered the business intelligence field in 2015 with enthusiasm about the data world, which was a key to continuous learning and improving his technical skills. In 2018, he started working at Ryanair, one of the biggest airlines in Europe. There, Abdalah had the chance to experience the BI department's evolution, such as migrating to Azure cloud solutions, reporting using Power BI, and designing and implementing data marts.
Portfolio
Experience
Microsoft SQL Server - 7 yearsETL - 7 yearsMicrosoft Power BI - 6 yearsSQL Server Integration Services (SSIS) - 5 yearsDatabase Modeling - 5 yearsAzure Data Factory - 4 yearsAzure Synapse - 4 yearsMicrosoft Azure - 4 yearsLocation
Availability
Preferred Environment
Microsoft Azure, Azure Data Factory, SQL Server BI, Microsoft Power BI
The most amazing...
...thing I've developed is a helpful Power BI app for pilots and chief pilots to monitor KPIs and insights through their iPads.
Work Experience
Senior Business Intelligence Developer
Ryanair
- Designed, developed, and supported several Power BI reports and dashboards to monitor the main KPIs and insights of flight operation, safety, and efficiency.
- Designed and implemented end-to-end BI solutions, identifying business requirements, data modeling, data marts, ETLs, and reporting.
- Migrated from on-premise solutions to Azure solutions.
Business Intelligence Consultant
Bluetab
- Designed and developed Power BI reports and dashboards.
- Developed ETL processes using SQL Server Integration Services.
- Supported and monitored daily executions, finding solutions in case of failure.
Business Intelligence Consultant
Sanofi
- Developed ETL processes using the Informatica PowerCenter tool and created dashboards and reports with QlikView 11.
- Engaged in a data warehouse implementation to improve the performance of QlikView applications.
- Developed ETL processes using SSIS, extracting information, and creating SQL scripts using SQL Server.
- Supported and monitored daily executions and discovered solutions in case of failure.
Business Intelligence Intern
Jazztel Telecom
- Extracted information and modeled different systems in the company.
- Analyzed and reviewed tasks of the extracted data, ensuring the accomplishment of business requirements.
- Developed reports with Oracle SQL upon requests within the company.
Experience
Power BI App for Pilots
I had the opportunity to start and lead the project from scratch. In the first stages, I comprehended the business need, connected to the different data sources, and designed the data mart model for reporting in Azure SQL. I developed the ETL in Azure Data Factory to integrate all data sources into the data mart, and finally, I designed and developed a Power BI app.
The Power BI app was a reporting revolution for the users, it had very positive feedback during my presentations, and the app usage was high, with over a hundred users, for both iPad and desktop versions.
Skills
Languages
SQL, Python
Tools
Microsoft Power BI, Informatica PowerCenter, Azure Logic Apps, SQL Server BI
Paradigms
ETL, Business Intelligence (BI), Azure DevOps
Storage
Databases, SQL Server 2016, Azure SQL Databases, Microsoft SQL Server, SQL Server Integration Services (SSIS), Database Modeling, SQL Server Analysis Services (SSAS)
Other
SQL Server 2015, Data Engineering, Data Visualization, Microsoft Azure, Azure Data Factory, DAX, Azure Synapse
Platforms
Azure, QlikView 11, Azure Functions
Education
Master's Degree in Computer Engineering
The Complutense University of Madrid - Madrid
Certifications
Microsoft Certified: Power BI Data Analyst Associate
Microsoft
Microsoft Certified: Azure Fundamentals
Microsoft