AHMED's CV
AHMED ELMAHGARY
BA/BI (Business Analysis/Business Intelligence) Consultant
Profile summary
Skilled Business Analysis and Business Intelligence Consultant with 4 years of experience in project management information systems, process standardization, and data visualization. Proven background in delivering standard operating procedures, Power BI dashboards, and digital transformation frameworks across the GCC region. Certified Project Management Professional and Lean Six Sigma Black Belt holding an MSc and BSc from Khalifa University. Dedicated to aligning business strategy with technology implementation to support organizational excellence.
Career highlights
Power BI Dashboard Delivery: Built a Power BI template with a live Excel file generating dashboard reports, charts, visuals, and Gantt timelines for public works projects, complemented by a user manual.
Statistical Data Analysis: Performed statistical data analysis on over 5000 rows across economics, sustainability, transport, infrastructure, and logistics to assess KPI trends and objectives for the Riyadh Plan Strategy 2030.
Document Management Records: Managed records of project deliverables, status progress reports, and meeting minutes while supporting subject matter experts across more than 2800 documents.
Key skills
Professional experience
Directed organizational excellence consulting initiatives, managing functional alignment and process standardization across corporate real estate and public sector portfolios. Oversaw the delivery of operational frameworks, business requirements, and system integration strategies for major development entities in the region.
- Built a Power BI template with a live Excel file generating dashboard reports, charts, visuals, and Gantt timelines for public works projects, complemented by a user manual.
- Performed statistical data analysis on over 5000 rows across economics, sustainability, transport, infrastructure, and logistics to assess KPI trends and objectives for the Riyadh Plan Strategy 2030.
- Managed records of project deliverables, status progress reports, and meeting minutes while supporting subject matter experts across more than 2800 documents.
- Developed the Business Requirements Document used for process digitization and software automation through functional and non-functional requirements.
- Supported the delivery of SOPs, business policies, and procedures across design, development, delivery, project controls, external relations, HSE, commercial, and contract functions.
Guided client engagement operations by processing inbound sales inquiries, developing financial projections, and establishing structured sales targets across regional accounts.
- Coordinated directly with the operation department to execute the supply and installation of hardware devices, videowalls, and structured cabling.
- Managed communication channels for ELV systems projects to maintain alignment between client requirements and operational delivery.
Managed digital transformation frameworks involving form design, template creation, and business process workflows. Engaged with IT stakeholders to identify gaps and propose data strategy solutions for Primavera Unifier implementations, while coordinating system integrations and document migrations with technical teams.
- Designed a Power BI data model and report for a specialty food and beverage company, developing DAX measures for sales, cost of sales, and gross profit margin.
- Built a scalable data model featuring incremental loading from a SQL Server data warehouse, historical tracking, and executive-level reporting.
- Conducted market analysis for a national retailer by developing linear regression models to predict customer incomes and sales.
Education
Chemical Engineering
- CGPA: 3.59, MSc: Chemical Engineering– 2019
Chemical Engineering
- CGPA: 3.95, BSc: Chemical Engineering - 2017