jafar Khaled Elzubaidi

Business AnalystFull Time

• Job Details:• Designed and built a comprehensive data warehouse, integrating data from multiple sources, including SAP EMW, Salesbuzz, and Excel, using SQL Server Integration Services (SSIS) for hourly data extraction, transformation, and loading (ETL). • Developed high-performance SQL Server Analysis Services (SSAS) cubes from the data warehouse, enabling real-time business intelligence and actionable insights for leadership. • Created and implemented automated Power BI dashboards, ensuring data refresh every hour from SSAS to deliver real-time metrics for business decision-making and operational improvements. • Improved data accuracy by 20% through the application of advanced data validation techniques, enhancing the reliability and integrity of all reports and analyses. • Collaborated closely with the Commercial Department to streamline inventory management, reducing discrepancies by 10% and ensuring timely product deliveries. • Managed daily support escalations as a 3rd line of support, resolving complex technical issues efficiently and maintaining smooth business operations.