Ahmed Gharib

Data Analyst & BI Specialist | AI-Powered Analytics

+20 102 018 9281 | ahmedgharibbadran@outlook.com | LinkedIn | Ismailia, Egypt

Professional Summary

Results-driven Data Analyst with 2+ years of experience in data reporting, Excel automation, and business intelligence within large-scale projects. Proven record of reducing reporting time by 30% and improving data retrieval efficiency by 40%. Proficient in Power BI, Advanced Excel, SQL, and DAX. Built and deployed AGB Analytics — a live AI-powered web analytics platform — demonstrating ability to translate data expertise into real-world product solutions.

Work Experience

Data Reporting Analyst & BI Analyst 02/2020 – Present

Orascom Construction — Egypt

Automated workforce reports using Advanced Excel (Pivot Tables, VLOOKUP, Macros), reducing reporting time by 30%
Built Power BI dashboards for project performance monitoring, KPI tracking, and executive reporting
Improved data retrieval efficiency by 40% through structured digital archiving and tracking systems
Collaborated with HR, engineering, and project teams to ensure 99% data accuracy across multiple sites

Data Analyst & Analytics Product Builder 2023 – Present

AGB Analytics — Independent · agbinsights.com

Built and deployed a live AI-powered web analytics platform that auto-detects data domains and generates KPIs, charts, and pivot tables from any uploaded dataset
Integrated AI assistant for natural-language data insights and automated pattern detection
Delivered Power BI projects: HR Attrition Analysis, Global Superstore Sales Strategy, and Project Milestone Tracker — each with custom DAX measures and stakeholder-ready dashboards

Technical Skills

BI & Visualization: Power BI, DAX, DAX Studio

Spreadsheets: Advanced Excel, Pivot Tables, Macros, VLOOKUP

Database: SQL, MySQL, SQL Server

Data Processing: Power Query (M), ETL Pipelines

Data Modeling: Star Schema, Snowflake Schema

AI & Analytics: AI Insight Generation, AGB Analytics Platform

Other: Report Automation, Digital Archiving, SharePoint

Education

Bachelor's Degree — Information Systems

Arish University, Egypt · 2020 – 2024

Languages