Mohammed Fawzy, Data and Analytics Consultant

Mohammed Fawzy

Data and Analytics Consultant

SARA GROUP

Location
United Arab Emirates - Dubai
Education
Diploma, Microsoft® Certified Solutions Associate: Office 365
Experience
18 years, 11 months

Share My Profile

Block User


Work Experience

Total years of experience :18 years, 11 months

Data and Analytics Consultant at SARA GROUP
  • United Arab Emirates - Dubai
  • My current job since January 2020

Accomplished Data and Analytics Leader with a successful history in implementing and sustaining DataOps methodologies at the SARA Group. Proven expertise in ensuring high-quality, reliable, and timely data delivery, coupled with effective collaboration with stakeholders for insightful decision-making. Actively seeking a challenging role to apply leadership skills in managing data analytics teams, crafting data-driven solutions, and assessing emerging technologies to elevate organizational data capabilities. Leading a cross-functional team in the development and implementation of data-driven solutions.
• Experienced in leading teams to analyze data, identify trends, and develop insights to inform decision making.
• Collaborated with business stakeholders on projects to improve data quality and streamline data workflows.
• Facilitated meetings and discussions to ensure all stakeholders were aligned on project objectives.
• Provided regular progress updates and encouraged feedback to ensure projects met the needs of all stakeholders.
• Provided training and support to help stakeholders understand and use data effectively.
• Successfully delivered data-driven solutions that benefited both technical and non-technical stakeholders.
• Adept at leveraging data to create predictive models and forecasting future trends.
• Experienced in developing Retail sales analysis, Inventory analysis, RFM Customer, CLV analysis and forecasting using Time-series techniques.
• Proficient in SQL, Oracle, Data Lake, and other database technologies to create and maintain data warehouses.
• Created dashboards and reports in Power BI to visualize and communicate insights to stakeholders.
• Designed and maintained data pipelines using SQL, ADF, SSIS, Python to extract, transform, and load data from various sources.
• Skilled in data modeling (Kimball and Inmon), ETL, and data mining techniques to extract, transform, and load data from multiple sources.
• Ensuring compliance with data privacy regulations and laws
• Managing the data Disaster recovery, Availability, backup, and recovery process
• Overseeing data quality control and data cleansing efforts
• Developing and implementing data management strategies and policies

Senior Data Warehouse and Bi Developer at Alysara Group
  • Kuwait - Al Kuwait
  • June 2016 to January 2020

• Led data warehouse projects from concept to completion.
• Skilled in Big data modeling, ETL, data mining, and data analysis.
• Expert in SQL, Oracle, and other database technologies.
• Created dashboards and reports in Power BI and Cognos, to visualize and communicate insights to stakeholders across the organization.
• Adept at creating data warehouses that are secure, reliable, and scalable.
• Experienced in developing data warehouse strategies and roadmaps.
• Highly organized and detail-oriented with excellent problem-solving skills.
• Ability to work independently and collaboratively in a fast-paced environment.
• Adept at working with stakeholders to identify data requirements and develop data-driven solutions.
• Designing and maintaining data storage and access systems
• Managing the data Disaster recovery, Availability backup and recovery process
• Developing and implementing data management strategies and policies
• Ensuring compliance with data privacy regulations and laws

Senior Database administrator and BI developer at KPTC
  • Kuwait - Al Kuwait
  • July 2013 to June 2016

As a Senior Database Administrator and Business Intelligence (BI) developer, I have extensive experience in managing and optimizing large-scale, complex database systems. My expertise includes troubleshooting, performance tuning, and security management. I have hands-on experience with various RDBMS such as Oracle, MySQL, and SQL Server. I also have experience in using BI tools like SSRS, and Power BI to create and maintain data warehouses, data marts and reporting/analytics tools. My strong skills in SQL, ETL processes and data modeling, made me proficient in delivering efficient BI solutions. I have experience working in team environments and communicating with stakeholders, which enabled me to understand business needs and deliver solutions accordingly.

Database & System Administrator at Futurekids
  • Kuwait - Al Kuwait
  • September 2011 to July 2013

As a Senior Database Administrator and Business Intelligence (BI) developer, I have extensive experience in managing and optimizing large-scale, complex database systems. My expertise includes troubleshooting, performance tuning, and security management. I have hands-on experience with various RDBMS such as Oracle, MySQL, and SQL Server. I also have experience in using BI tools like SSRS, and Power BI to create and maintain data warehouses, data marts and reporting/analytics tools. My strong skills in SQL, ETL processes and data modeling, made me proficient in delivering efficient BI solutions. I have experience working in team environments and communicating with stakeholders, which enabled me to understand business needs and deliver solutions accordingly.

IT Specialist at Quattro Trading
  • Egypt - Cairo
  • November 2007 to August 2011

System Administrator For ( MS Windows server 03 AD.Dns, Ms Xp, Vista windows client, Ms ISA 04, File server )
Support 8 location Desktop, POS & ERP and network
Built SharePoint site provide dynamic ERP reports, KPIs, Events, New, Management dashboard, New Projects plain.
Database Administrator For SQL 2005 DB
Develop analysis report By SQL 2005 Report services
Develop HR emplyee Information Application
Implement Finger print solution in all company branch and manage software
Backup Strategies for all company Data and application
Editing company Intranet
1st responsible for Retail Management Application Netpos (Implementation, Support, Training )
Training the employees on ERP system Netsis;
Installed network appliances;
Wrote technical documentations;
Implemented new stores

System Administrator at SAS Egyp
  • Egypt - Cairo
  • May 2006 to November 2007

As an IT Specialist, I have experience in providing technical support to users, troubleshoot and resolve hardware and software issues, installation and maintenance of computer systems and networks. I am proficient in various operating systems and have experience in managing and maintaining servers, storage devices and network equipment. My expertise in IT security and data protection has enabled me to identify and mitigate potential threats and vulnerabilities. I have a track record of delivering projects on time and providing efficient support to users. My strong analytical and problem-solving skills make me an asset to any organization.

Technical support at Universal Systems
  • Egypt - Cairo
  • May 2005 to April 2006

Technical Support For ERP application Business Key client side
Support for Office Pcs, and servers.
Tester For Application

Education

Diploma, Microsoft® Certified Solutions Associate: Office 365
  • at Microsoft
  • December 2024
Diploma, Microsoft Specialist: Implementing Microsoft Azure Infrastructure Solutions
  • at Microsoft
  • December 2024
Diploma, Microsoft® Certified Solutions Associate 2012
  • at Microsoft
  • August 2024

Microsoft® Certified Solutions Associate 2012 Certification Number : E375-5951

Diploma, MS SQL 2005 DBA
  • at VirgiTech
  • July 2024
Diploma, MCSE
  • at YAT
  • June 2024
Bachelor's degree, Science
  • at Mounifya University
  • May 2024
Diploma, Administering Microsoft SQL Server 2012,2014 Databases
  • at Microsoft
  • March 2024
Diploma, Querying Microsoft SQL Server 2012,2014
  • at Microsft
  • February 2024
Diploma, Data Analyst Associate
  • at Microsoft
  • August 2021
Bachelor's degree, Bachelor of Science
  • at Menofia university
  • May 2005

Specialties & Skills

Data Management
Master Data Management
Data Warehousing
Data Analysis
Microsoft SSRS
machine learning
R (PROGRAMMING LANGUAGE)
AMAZON WEB SERVICES
DATA MANAGEMENT
EXTRACT TRANSFORM LOAD (ETL)
DATA MINING
MANAGEMENT
DATA MODELING
DISASTER RECOVERY
POWER BI
SAS (SOFTWARE)
SQL analysis Services
Backup Exec
Crystal Report
R development
Data Modeling
Power BI
Data analyst
Database Administrator and Availability
Data warehouse
Master Data Management
databases
team management
problem solving
digital marketing
teamwork

Languages

English
Intermediate

Training and Certifications

Microsoft® Certified Data Analyst (Certificate)
Date Attended:
July 2020
Microsoft® Certified Solutions Associate: Windows Server 2012 (Certificate)
Date Attended:
August 2013
MS: Implementing Microsoft Azure Infrastructure Solutions (Certificate)
Date Attended:
December 2014
Microsoft® Certified Solutions Associate: Office 365 (Certificate)
Date Attended:
December 2014
Microsoft® Certified Solutions Associate: SQL Server 2012 (Certificate)
Date Attended:
March 2015