Learn Data Skills
Mohamed Ashraf

Mohamed Ashraf

Certified

Data Engineer

Computer Sciences | Saudi Arabia

Technologies

My Portfolio Highlights

My New Course

Introduction to SQL

My New Workbook

Project: Analyzing Unicorn Companies

My New Workbook

Competition - Everyone Can Learn Python Scholarship

My New Course

Introduction to SQL

Data visionary, envisioning a future transformed by the power of information.

My Work

Take a look at my latest work.

course

Introduction to SQL

DataLab

Project: Analyzing Unicorn Companies

DataLab

Competition - Everyone Can Learn Python Scholarship

course

Introduction to SQL

My Certifications

These are the industry credentials that I’ve earned.

SQL Associate

SQL Associate

Data Engineer Associate

Data Engineer Associate

Introduction to SQL

Introduction to SQL

Other Certificates

MicroStrategy ANALYST

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to SQL
Introduction to Power BI
Understanding Prompt Engineering
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

Jadara Solutions | Sep 2022 - Present

Data Management Consultant

• HRDF (Outsource): Created SSIS package to load data from Excel Files to SQL Server. • Designed, Developed, and Deployed reports in MS SQL Server environment using SSRS. • Generated Sub-Reports, Conditional, Drilldown reports, Drill through reports, and parameterized reports using SSRS. • Created reports to retrieve data using stored procedures that accept parameters. • Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard. • Involved in creating views, stored procedures, and custom SQL queries to import data from SQL server to PowerBI. • Reviewed SQL queries and edited inner, left, and right joins in Power BI by connecting live/dynamic and static datasets. • Analyzing Reporting requirements and translating them into data sourcing and modeling requirements including Dimensional & Normalized data models, Facts, Dimensions, Star Schemas, Snowflake Schemas, Operational Data Stores, etc. • Creation of database objects like tables, views, materialized views, procedures, and packages using MSSQL.
Show More

Al Rajhi Bank | Jun 2021 - Jun 2022

Business Intelligence Developer

• Power BI: Generated 12 new BI dashboards with PowerBI. Imported data from SQL Server DB to Power BI to generate reports, Created Dax, Queries to generate computed columns in Power BI, and Generated computed tables in Power BI by using Dax, Creating Database objects - tables, views, functions, and developing procedures for implementing application functionality at the database side for performance improvement, Involved in creating new stored procedures and optimizing existing queries and stored procedures. • Data Lineage: Traced Data Lineage of data elements from ASP reports to transfer it to Power BI and improve it, Identification of a Level 1 data source at attribute creation and subsequent levels, Identification of a Level 1 data source based on attribute updates during the data life cycle. Trace the data from Visuals, then DataMart, then Staging - To - DataMart, then Staging, then Landing - To - Staging, then Landing, then Source ETL, then Source.

Master Works | May 2017 - May 2021

Business Intelligence Developer

• STC (Outsource): Create MicroStrategy reports and dashboards, Created the application objects (filters metrics, and prompts). Developed the Reports as per the Design Documents, Performed the report data manipulations using various options like (page by, sorting, totals, thresholds, etc..). Created View filters, Report Limits on the report data, for ERP and CRM and OLAP and more projects. • Qassim Project, Designed MicroStrategy reports and dashboards utilizing cross tabs, maps, scatter, pie, bar, and density charts and ETL implementation using SQL Server Integration Services SSIS, Reporting Services. • Royal Commission in Jubail (Outsource): Create MicroStrategy reports and dashboards, Created the application objects (filters metrics, and prompts), Developed the Reports as per the Design Documents, Performed the report data manipulations using various options like (page by, sorting, totals, thresholds, etc.,). Created View filters, Report Limits on the report data. • GAZT (Outsource): Refreshment of Tableau server dashboards, Insure that all data sources are refreshed on daily bases at planned times, Managed and monitored the storage utilization, Monitored, manage, and control the servers (application). Manage the upgrading tableau servers tasks, Deal with operation team notifications about the servers size and memory consumption. • University of Prince Sattam Project: Fetching data from Twitter to enable streaming data analysis on Big Data datasets up to 250 GB, reducing the manual processing time by 80%. Created data-driven dashboards to enable contextual and interactive data analysis.

My Education

Take a look at my formal education

Bachelor in Computer ScienceModern Academy Maadi | 2015

About Me

Mohamed Ashraf

Who Am I? Business Intelligence Developer with over 5 years of professional and technical experience.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free