Mayar Abdou

• Developed dimensional and semantic models for SSAS cubes and dashboards, defining relationships between facts and dimensions and enabling integrated reporting.
• Built ETL/data pipelines using SQL, SSIS, Python, and Power Automate to extract, transform, and load data from multiple sources for analytics.
• Created interactive dashboards and reports in Power BI, implementing measures, KPIs, and DAX calculations to deliver actionable insights.
• Developed web scraping solutions using Python (Selenium) for data acquisition and enrichment.
• Collaborated with Data Science and cross-functional teams to gather requirements, align data, and support data-driven decision-making.
• Researched emerging technologies and created proof-of-concept solutions to enhance analytics workflows.

Main Projects:

• Recruitment Analytics Cube: Automated daily extraction of recruitment targets from SharePoint via Power Automate and CRM actuals using SQL pipelines, delivering real-time visibility into hiring KPIs and performance metrics.
• Digital & Social Media Analytics Platform : Built a Python scraper for Google, Meta, Snapchat, and TikTok Ads Manager, designed a SQL dimensional model, and deployed an SSAS cube with integrated dimensions and facts. Automated daily extraction, eliminating 80% of manual work, to track campaign costs, leads, and performance.
• Power BI Dashboards: Developed interactive dashboards to monitor user engagement, lead conversion, advertising impact, and installation trends across devices and platforms, providing actionable insights for marketing and product teams.
• MDX–SQL AI Automation : Created automated MDX extraction workflows from Analysis Services to SQL using Python, producing clean, analysis-ready datasets for AI workflows while minimizing manual intervention.

• Designed advanced Power BI dashboards from raw Excel/CSV data using Power Query, DAX, and analytical models to deliver actionable insights.
• Developed a custom Arabic JSON map for Saudi Arabia, enhancing localization and data visualization accuracy.
• Implemented interactive features including bookmarks, drill-throughs, and navigation to improve user experience and engagement.
• Managed end-to-end BI development, from data acquisition and transformation to reporting, ensuring high-quality, stakeholder-ready solutions.