Mohamed Kotb

Data Analyst at Freelance | Self-Employed

Cairo, Cairo, Egypt

About

I specialize in transforming raw, chaotic datasets into optimized data pipelines, stunning visual stories, and forward-looking business decisions. My approach is purely technical, analytical, and predictive. I don’t just look at what happened in the past; I use statistics and data modeling to help businesses anticipate future trends and take proactive action. Here is my advanced technical stack: * Advanced Data Engineering & Cleaning (Python): Mastering Pandas & NumPy for scalable pipelines. Expert in Memory Optimization (reducing RAM usage by up to 80% using category dtype) and complex data cleaning/text extraction via Regex. * Statistical Analysis & Visualization: Applying core Statistical concepts to validate trends, and leveraging Matplotlib & Seaborn to uncover hidden patterns within data. * SQL & Database Performance: Crafting complex queries, dynamic views, and subqueries to dissect large-scale relational databases (like the Superstore dataset) and track growth metrics. * Business Intelligence (Power BI): Building interactive, production-ready dashboards and custom DAX measures that turn complex data into clear, compelling visual stories for stakeholders. * Automation & AI Orchestration: Deploying AI Agents and automated workflows to eliminate repetitive tasks, saving hundreds of engineering hours. From fixing memory leaks and handling NaN bugs to building end-to-end BI dashboards, I build data solutions that are fast, visually powerful, and strictly aligned with future business growth. 💬 Let’s connect or reach out at: [email protected]

Experience

  • Data Analyst at Freelance | Self-Employed