Omar Ahmed

Business Intelligence AnalystFull Time

• Job Details:• Optimized ETL workflows using SSIS and T-SQL, reducing data loading time by 40% and ensuring seamless daily data loading into the data warehouse. • Created 15+ interactive dashboards in Power BI and Excel using the right KPIs to track brands performance, store targets and achievements. • Enhanced the product transfer operation by 30% by integrating data from multiple transfer systems and developing complex Excel reports to manage transfers across 25 different sales channels and warehouses, reducing process time by 60%. • Analyzed customer purchase behavior using RFM analysis, Pareto Analysis, and clustering, leading to data-driven marketing strategies and improved customer segmentation. • Built an automated inventory monitoring system in Power BI and Excel, enabling real-time stock analysis and reducing stockouts by 30% through optimized replenishment cycles.