Abdelaziz Mallekh

Analyzed and cleaned multi-country sales data (UK, India, Dubai, Indonesia) using Power BI and Power Query. Developed KPIs with DAX (profit margin, revenue growth, production cost). Built interactive dashboards on product sales (websites, mobile apps), customer data, and financial performance. Created year-over-year comparison reports and sales forecasts. Automated reporting for executive insights and ensured data reliability.

Implemented a new cloud-based ETL solution (Talend Management Console) to support large-scale international operations and retail data processing for NOZ, VEO's key client improving report generation speed by 80% and centralizing customer and sales data. Collaborated with data architects to build scalable data models aligned with surplus stock workflows and retail performance metrics, enhancing data quality and consistency. Automated reporting pipelines using Cognos scheduling and Python scripts, saving 15+ hours weekly and reducing data processing time by 70%. Developed Power BI dashboards using DAX, M Query, and Power Query to monitor sales, inventory turnover, and retail KPIs across NOZ stores achieving 95% user adoption. Contributed to performance optimization, data governance, and cross-border retail analytics in a high-volume, data-driven environment.

Streamlined ETL processes with Talend Data Integration, improving data loading by 25% and automating claims and policy performance reports, saving 5+ hours weekly. Standardized data pipelines using Talend and SQL to ensure accuracy in premium calculations, claims tracking, and policy renewal analytics for finance and marketing teams. Collaborated with business users to define KPIs for auto insurance operations, including claims frequency, loss ratio, policy growth, and profitability metrics. Built interactive Power BI dashboards using Power Query and advanced DAX to visualize trends in claims management, underwriting performance, and contract lifecycle. Delivered executive-level insights through Excel and Power BI reports, supporting forecasting, risk analysis, and strategic planning for the auto insurance portfolio. Provided analytical support on claims volume, policy retention, and revenue evolution, helping business units align on key performance indicators and data-driven decisions.