Resume

Summary

Ilham Afounnas

Thorough and meticulous Data Analyst passionate about helping businesses succeed. Highly Motivated, teamwork-oriented and experienced in Microsoft SQL Server Business Intelligence (BI), SSIS and SSRS. have excellent skills in Data Warehouse, ETL , Relational and multi-demential database, data integration, Reporting...

  • Agadir, Morocco
  • +212 682122817
  • ilham.afounnas26@gmail.com

Education

Master of Data Mining

2016 - 2018

Wuhan University of Technology, Wuhan , CHina

Master of Software Engineering

2013 - 2016

Universiapolis, Ecole Polytechnique, Agadir, Morocco

Bachelor of System & Network Administration

2011- 2013

BTS , Agadir, Morocco

Professional Experience

Business Intelligence Developer Intern

2015 - 2016

Agadir, Morocco

  • Analyze and Create a Data warehouse for the company DUROC from different databases.
  • Performed Extraction & Migration of Data (ETL) from heterogeneous data sources using SSIS.
  • Experienced in working with Star Schema and Snow Flake Schema to develop OLAP Cubes using MS SQL Server Analysis Services (SSAS).
  • Designed and developed a full-scale BI reporting solution using Power BI, Tableau and SSRS

Software Developer

2014

Agadir, Morocco

  • Al Omrane

Business Intelligence Developer Intern

2015 - 2016

Agadir, Morocco

  • Analyze and Create a Data warehouse for the company DUROC from different databases.
  • Performed Extraction & Migration of Data (ETL) from heterogeneous data sources using SSIS.
  • Experienced in working with Star Schema and Snow Flake Schema to develop OLAP Cubes using MS SQL Server Analysis Services (SSAS).
  • Designed and developed a full-scale BI reporting solution using Power BI, Tableau and SSRS

Information Technology Assistant

2017 - 2018

Wuhan, China

  • Wuhan Pinssible Network Technology Co., Ltd.

Data Analyst

2021 - 2022

Freelance Upwork

Projects

Project 1

2015 - 2016

Agadir, Morocco

Dashboard for World Population 2021

2021

Creation of a dashboard to explore the database of the world population

Movies Industry Data Analysis and Visualizations

2021 - 2022

Creation of a notebook to explore the database from the Movie Industry.

Can we predict who would've survived the Titanic?

2021 - 2022

Creation of a notebook to predict who would've survived.

Skills

SQL

90%

Agadir, Morocco

  • Experience in designing normalized and denormalized database structures.
  • Skilled in data extraction and transformation for analytics.

POWER BI

80%

Expert in building dynamic dashboards and reports to visualize complex datasets.

  • Ability to create calculated measures and KPI indicators.

PYTHON

80%

Strong proficiency in Python for data analysis, scripting, and automation.

  • Experience with libraries like Pandas, NumPy, and Matplotlib.

TABLEAU

70%

Skilled in creating interactive visualizations and reports.

  • Ability to connect Tableau to various data sources for insightful analytics.

DATA MODELING

90%

Experienced in creating conceptual, logical, and physical data models.

  • Skilled in designing scalable data architectures.

EXCEL

70%

Proficient in advanced Excel functionalities for data manipulation and reporting.

  • Skilled in using Pivot Tables, VLOOKUP, and complex formulas.