Bayt.com
Shady Nasrat, Sr. Data Analyst

Shady Nasrat

Sr. Data Analyst

Assembly Global

Location
Egypt
Education
Bachelor's degree, Applied Statistics
Experience
6 years, 9 Months

Share My Profile

Block User


Work Experience

Total years of experience :6 years, 9 Months

Sr. Data Analyst at Assembly Global
  • Egypt - Cairo
  • My current job since May 2023
SEO Data Analyst at Assembly Global
  • Egypt - Alexandria
  • January 2022 to April 2023

• Manage and respond to datasets requests.
• Setting up technical SEO dashboards on Looker Studio (GDS).
• Assisting the SEO team with in-depth analysis and weekly performance report.
• Setting up interactive SEO performance reports allowing for data manipulation and segmentation.
• Ensuring that dashboards are up to date, helping the team in regular quality checks by backdating reports and additional data pulls.
• Automating Looker Studio (GDS) reports, SQL queries, and G Sheets.

Data Manager at Caritas Egypt
  • Egypt - Alexandria
  • November 2018 to December 2021

• Designed interactive social, medical, and assistance dashboards.
• Created databases, and automated reports using MS Access and MS Excel for social and medical teams.
• Cleaned, analyzed, and visualized data received from various departments in the project.
• Generated monthly, quarterly, semi-annually, and annually reports internally, and externally.
• Focal point between the EU project and Fawry Plus for Banking Services.

Volunteer Mentor at Coursera
  • Egypt - Alexandria
  • November 2016 to January 2018

Mentor for Speak English Professionally: In Person, Online & On the Phone - Georgia Institute of Technology course.
• Helped learners progress through courses by responding to questions in the discussion forums.
• Helped build a cohesive course community by being welcoming and encouraging as learners work through course materials to help them feel supported and engaged.
• Directed learners to appropriate places to receive help and report serious problems to Coursera.

Education

Bachelor's degree, Applied Statistics
  • at Alexandria University
  • May 2017

C #, Advanced Maths, SPSS (PASW), Linear Algebra, An introduction to Non-parametric Statistics, Accounting, Statistical Methods for Research, An introduction to Risk and Insurance, Econometrics, Minitab, Statistical theory, Regression analysis, Database, Operations research, Finance, Feasibility study, Time series analysis, Design of experiments

Specialties & Skills

Data Visualization
+Endorse 0
SQL
+Endorse 0
Microsoft Excel
+Endorse 0
Data Analysis
+Endorse 0
Statistics
+Endorse 0
R
+Endorse 0
Minitab
+Endorse 0
SPSS
+Endorse 0
MENTORING
+Endorse 0
SQL
+Endorse 0
PYTHON
+Endorse 0
C#
+Endorse 0
Statistics
+Endorse 0
Problem Solving
+Endorse 0
Data Visualization
+Endorse 0
Excel
+Endorse 0

Languages

Arabic
Native Speaker
English
Intermediate

Training and Certifications

Introduction to ChatGPT (Certificate)
Date Attended:
April 2023
Introduction to Power BI (Certificate)
Date Attended:
June 2023
Google Analytics Certification (Certificate)
Date Attended:
August 2022
Valid Until:
August 2023
Intermediate SQL Queries (Certificate)
Date Attended:
April 2018
Spreadsheet Fundamentals (Certificate)
Date Attended:
November 2022
Data Visualization in Spreadsheets (Certificate)
Date Attended:
November 2022
Pivot Tables in Spreadsheets (Certificate)
Date Attended:
November 2022
Intermediate Spreadsheets (Certificate)
Date Attended:
July 2022
Google Analytics 4 GA4 Essential Training (Certificate)
Date Attended:
April 2022
The NonTechnical Skills of Effective Data Scientists (Certificate)
Date Attended:
March 2022
Create a Custom Marketing Analytics Dashboard in Data Studio (Certificate)
Date Attended:
March 2022
Foundations: Data, Data, Everywhere (Certificate)
Date Attended:
January 2022
Intro to Data Studio (Certificate)
Date Attended:
January 2022
Valid Until:
January 2025
SQL (Basic) (Certificate)
Date Attended:
December 2021
Data Science for Everyone (Certificate)
Date Attended:
September 2021
Data Fluency Exploring and Describing Data (Certificate)
Date Attended:
April 2021
Building Resilience (Certificate)
Date Attended:
March 2021
Learning Data Analytics (Certificate)
Date Attended:
March 2021
Database Fundamentals (Certificate)
Date Attended:
December 2020
Data Challenger Track (Certificate)
Date Attended:
November 2020
Power BI Essential Training (Certificate)
Date Attended:
October 2020
Data manipulation with dplyr (Certificate)
Date Attended:
May 2020
Introduction to the Tidyverse (Certificate)
Date Attended:
May 2020
Intermediate R (Certificate)
Date Attended:
May 2020
Data analysis in Excel (Certificate)
Date Attended:
May 2020
Essential Design Principles for Tableau (Certificate)
Date Attended:
February 2020
SQL Fundamentals (Certificate)
Date Attended:
December 2019
Data Analysis Track (1MAC) (Certificate)
Date Attended:
November 2019
Fundamentals of Visualization with Tableau (Certificate)
Date Attended:
October 2019
Business Statistics and Analysis Specialization (5 Courses) (Certificate)
Date Attended:
March 2019
Coursera Mentor - 12 Months (Certificate)
Date Attended:
December 2017
Intro to R (Certificate)
Date Attended:
April 2018
Spreadsheet basics (Certificate)
Date Attended:
April 2018
Data Analysis with Spreadsheets (Certificate)
Date Attended:
May 2018
Intro to Python for Data Science Course (Certificate)
Date Attended:
May 2018
Introduction to Git for Data Science (Certificate)
Date Attended:
July 2018
Write Professional Emails in English (Certificate)
Date Attended:
February 2016
Write Professional Emails in English (Certificate)
Date Attended:
January 2016
Write Professional Emails in English (Certificate)
Date Attended:
February 2016
Write Professional Emails in English (Certificate)
Date Attended:
February 2016
Write Professional Emails in English (Certificate)
Date Attended:
February 2016
R Programming (Certificate)
Date Attended:
October 2018
Practical Time Series Analysis (Certificate)
Date Attended:
September 2018
The Data Scientist’s Toolbox (Certificate)
Date Attended:
July 2018
Data Science Math Skills (Certificate)
Date Attended:
January 2018
Learning How to Learn: Powerful mental tools to help you master tough subjects (Certificate)
Date Attended:
July 2017
Tricky English Grammar (Certificate)
Date Attended:
September 2016
Speak English Professionally: In Person, Online & On the Phone (Certificate)
Date Attended:
August 2016
Programming for Everybody (Getting Started with Python) (Certificate)
Date Attended:
August 2016
Grammar and Punctuation (Certificate)
Date Attended:
August 2016
Basic Statistics (Certificate)
Date Attended:
August 2016
Build Your Professional ePortfolio in English (Certificate)
Date Attended:
April 2016
Write Professional Emails in English (Certificate)
Date Attended:
February 2016
Time Management Certification (Certificate)
Date Attended:
July 2018
Data Analyst Track (Certificate)
Date Attended:
April 2018
The Fundamentals of Digital Marketing (Certificate)
Date Attended:
April 2018
Learning R (Certificate)
Date Attended:
October 2016
Managing Your Time (Certificate)
Date Attended:
June 2017
Mastering Common Interview Questions (Certificate)
Date Attended:
October 2017
Coursera Mentor Community and Training Course (Certificate)
Date Attended:
November 2016

Hobbies

  • Running
  • Reading