Mohamed Ashraf Email & Phone Number

Riyadh, Saudi Arabia

Riyadh, Saudi Arabia

- Implemented and managed Metadata Management, Mapping Manager, and Business Glossary Manager using Erwin Data Intelligence for effective data governance.- Developed and executed Data Quality processes to ensure accuracy, completeness, and consistency of data across various sources.- Created comprehensive data mapping documentation to facilitate data lineage and traceability between source and target systems.- Collaborated with cross-functional teams to define and manage business glossaries, ensuring consistency and standardization of terminologies across the organization.- Conducted data profiling and validation activities to identify data quality issues and implemented solutions to resolve them.- Led the design and implementation of data integration workflows and ETL processes to consolidate data from multiple sources into centralized repositories.- Provided technical expertise in optimizing data models and database structures to enhance data retrieval performance and storage efficiency.- Actively engaged in stakeholder management, including requirement gathering, data analysis, and providing insights to support decision-making processes.

Riyadh, Saudi Arabia

• 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 the 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 and normalized data models, Facts, Dimensions, Star Schema, Snowflake Schema, Operational Data Stores, etc.• Creation of database objects like tables, views, materialized views, procedures, and packages using MSSQL.

Riyadh, Saudi Arabia

• 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, created 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.

Riyadh, Saudi Arabia

· Refreshment of Tableau server dashboards.· Ensure that all data sources are refreshed on a daily basis in planned times.· Manage and monitor storage utilization.· Monitor, manage and control the servers (application).· Manage the upgrading tableau servers tasks.· Deal with operation team notifications about the servers size and memory consuming.

Al-Riyadh Governorate, Saudi Arabia

• 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.• 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.

Riyadh, Saudi Arabia

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.