Ali Dakak

Sole data analyst at an electronics distributor, owning BI from source to report. - Built an automated SAP HANA to Power BI pipeline in Power Query M, replacing a manual Excel process for inventory, sales and open orders. - Rebuilt the data model as a star schema with multiple fact tables and shared dimensions. - Built a customer analytics layer with DAX measures for revenue share, churn, margin and product mix.

Led sales analytics for a ready-mix concrete producer, working directly with Sales and Operations. - Built 20+ recurring and ad hoc Power BI reports on SQL and Python ETL pipelines, cutting report delivery time by 60%. - Launched real-time KPI dashboards with Sales and Operations, contributing to a 15% improvement in customer satisfaction metrics. - Built end-to-end ETL pipelines to clean source data and automate weekly and monthly analytics workflows.

Scraped and compiled accurate product data from online sources, enhancing database integrity and reliability. Automated product lookup processes using Python, significantly improving data retrieval efficiency. Developed Power BI visualizations to provide actionable insights beyond management requests. Conducted audits to ensure data accuracy and implemented best practices in data management. Analysed data trends and generated comprehensive reports to support decision-making.

Automated over 70% of daily and monthly reporting processes, increasing efficiency. Generated fixed and on-demand reports to support financial decision-making. Maintained financial reports and collaborated with the Senior MIS Officer to improve data accuracy. Extracted and analyzed data from core banking applications to meet end-user requirements.

Processed high volumes of deposits, withdrawals, and other banking transactions efficiently. Managed client accounts and supported account openings and closures. Assisted clients with online banking platforms and facilitated account management.

Analyzed and developed a web application enhancement on a Airline’s website that allows users to create new account, shop and reserve flights. Developed a fully working offline demo website for the company with on-flight e-commerce. Introduced a data analysis tool on the new e-commerce system which can track trends and forecast data.