SHIHAB MOHAMED
senior data analyst
Abu Dhabi
Summary
Results-driven data analyst with over 6 years of experience leveraging advanced analytical tools and techniques to extract meaningful insights from complex datasets. Proficient in Python, SQL, Data Warehouse (DWH), Excel, ETL processes, Power BI, and AWS, enabling effective data storage and processing. Expertise in designing interactive dashboards that facilitate strategic decision-making and enhance organizational performance. Committed to delivering high-quality analysis that drives business growth and operational efficiency.
Overview
9
9
years of professional experience
1
1
Certification
2
2
Languages
Work History
Senior Data Analyst
G Fiber Information Technology
2020.01 - Current
- Led the development of a reporting solution suite containing 16 Power BI reports for 15 corporate customers of RW, using Microsoft's latest in-memory database technology.
- Developed complex SQL queries using 14 procedures, including Common Table Expression (CTE), to support Power BI and SSRS reports.
- Embedded more than 20 Power BI reports on a Salesforce portal page, and successfully managed access to data for over 4K users using 'Roles.'
- Provided continued maintenance and development of bug fixes for existing and new Power BI reports twice a month for two years.
- Streamlined data integration methods for more accurate reporting and analysis.
- Implemented robust security measures to protect sensitive company information from unauthorized access or disclosure.
Junior BI Analyst
Al baraka bank of Sudan
2017.03 - 2019.08
- Designed custom SQL queries to extract, analyze, and generate automated reports, reducing reporting time by 30%.
- Assisted in data validation, contributing to a 10% improvement in data accuracy.
- Supported in the development of business intelligence solutions, enhancing market understanding by 15%.
- Developed robust SQL scripts to extract relevant information from large datasets quickly and accurately, expediting ad hoc report requests.
- Delivered customized training sessions to end-users on BI tool usage, enhancing adoption rates across the organization.
- Evaluated vendor offerings for BI solutions, conducting thorough assessments of product functionality, scalability, and cost-effectiveness to make informed recommendations for purchase decisions.
- Facilitated a better understanding of critical business drivers by designing user-friendly visualizations that communicated complex data insights effectively.
Education
Bachelor of Science - Business Computing
Sudan International University
Sudan 2001.04 -
Skills
Proficient in technical skills
Power BI: Data modeling, DAX, Power Query, data visualization, dashboards, reports
Data Analysis: SQL, Excel, Python, R, statistical analysis, data mining
Databases: Microsoft SQL Server, MySQL, PostgreSQL
Proficient in AWS (R3, Redshift, Glue) and Azure
Experienced in advanced data analysis with Excel
Data extraction expertise
Data integrity assurance
Data analysis expertise
Advanced analytics
Data quality assurance
ETL processes
Certification
Google Data analytics
Timeline
Google Data analytics
2023-01
Senior Data Analyst
G Fiber Information Technology
2020.01 - Current
Junior BI Analyst
Al baraka bank of Sudan
2017.03 - 2019.08
Bachelor of Science - Business Computing
Sudan International University
2001.04 -