Data Analyst Software Developer

Aliaa Mousa

Data Analyst/ BI Engineer

************@*****.*** +201********* LinkedIn

Professional Experience

BI Engineer/Software Developer, IDACO Jully 2018 - Current

● Created multiple Dashboards to monitor main company KPIs using SQL and Redash.

● Helped the business to make data-driven decisions by digging deep into the data and providing valuable insights.

● Used Python to create an in-depth analysis of complex business problems.

● Developed Backend APIs that control the visualizations for a user-facing app.

● Developed a desktop application for a gym center using SQL and C#. I developed all the CRUD operations.

● Created a desktop app to measure the technician quality using C#

● Created an Android app using JavaScript, and Kotlin. Projects

Student performance Analysis (Tableau, SQL, Data wrangling, Data Analysis)

● Conducted data analysis comparing two Portuguese schools focusing on student performance in Portuguese language courses.

● Extracted and wrangled data on student demographics, absences, study time, school support, and final grades with SQL.

● Created interactive dashboards and visualizations in Tableau to illustrate key findings, including the impact of study time and school support on final grades.

● Presented actionable insights to school administrators, enhancing strategies for academic support and resource allocation.

● The project link can be found here

Exploring Weather Trends (SQL, Redash, Data Wrangling, Data Visualization, Time Series Analysis)

● Conducted a comprehensive analysis of global and local temperature data to identify long-term trends and patterns.

● Extracted and cleaned historical temperature data from various sources using SQL, ensuring data accuracy and consistency.

● Performed time series analysis to compare temperature trends between global averages and a specific city over several decades.

● Created visualizations using Redash to illustrate key trends and anomalies in temperature changes with dashboard filters.

● Presented findings through detailed charts and reports, highlighting significant trends and potential implications for climate research and policy-making. Customer Segmentation and Analysis (SQL, Data Wrangling, Data Analysis, Segmentation)

● Analyzed customer behavior and purchasing patterns for an e-commerce company to identify distinct customer segments.

● Extracted and transformed raw transactional data using SQL, aggregating customer purchase history, demographics, and browsing behavior.

● Implemented advanced SQL queries to calculate key metrics such as customer lifetime value (CLV), average order value (AOV), and purchase frequency.

● Conducted clustering analysis using SQL to segment customers based on their buying habits and preferences.

● Developed actionable insights and recommendations for targeted marketing campaigns, personalized product recommendations, and customer retention strategies based on identified segments.

Education

Bachelor's degree in Computer science, University of Greenwich 2014 – 2018 Skills

UI/UX

Research / storyboards / wireframe tools /

high fidelity/ mockups / Figma/ Adobe XD/

UXD/ Usability Testing/Prototype/Usability

Testing/UX/UI

Tooling and Applications

Android / Swift / HTML / CSS /JS / JQuery /

PHP / XML0

/Java / JavaScript

3D Graphics Design

OpenGL / Unity

Image Processing

Matlab

Database

SQL / Firebase / SQLite / MySQL

Algorithms & Data Structures

C / C++ / Python / C#

Data Manipulation

Pandas / Anaconda

Operating System

Linux / Shell programing

Machine Learning & Deep Learning

Unity ML / Tensorflow - jupyter notebook /

OpenAI0 Gym

Contact this candidate