Hamza Khan

Hamza Khan

Data analyst
UAE
English, Urdu
Full-time On-site

About Me

Data analyst with 2 years of experience building data pipelines, Power BI dashboards, Streamlit applications, and LLM-powered prototypes. Skilled in Python, SQL, and Databricks, with a statistics background and a focus o…

Experience

Demand Planner

Petromin Corporation (AMAP) · Dubai, United Arab Emirates
Feb 2026 - Jul 2026 · 4 months

<p>Responsible for pricing, demand planning, and data analytics for the Auto Parts division's B2B and stock-based genuine OEM parts business, serving export and local customers.</p><p> Built a Streamlit pricing application in Python that ingested vendor quotations, normalised part numbers for accurate matching, fell back to last inventory price when quotes were missing, and applied tiered margin and handling logic, cutting quote turnaround time and reducing manual pricing errors.</p><p> Prototyped a Generative AI agent (Gemini LLM) to auto-generate standardised descriptions for Toyota, Daihatsu, and Honda OEM part numbers, automating bulk catalogue data enrichment.</p><p> Designed and maintained a centralised database integrating customer enquiries and vendor quotations, surfacing demand patterns and tracking customer- and vendor-side price movements over time.</p><p> Produced inventory analyses segmenting stock into fast- and slow-moving items to guide demand planning and replenishment.</p><p> Partnered with sales, procurement, and operations teams to coordinate fulfilment of confirmed orders across export and local deliveries.</p>

Data Analyst

DP World · Dubai, United Arab Emirates
Aug 2024 - Feb 2026 · 1 year 6 months

<p>Worked across the Applied Science and Commodities teams of a global ports and logistics company, building models, dashboards, and automated reporting for commercial and operations stakeholders.</p><p> Designed profitability models across ~300 feeder routes, integrating shipping schedule and market freight rate data via external APIs, shortlisting the top 25 options and supporting the launch of 2 new routes.</p><p> Collaborated on an AI-powered model that responds to freight quote requests in real time, removing multi-day back-and-forth with clients.</p><p> Automated weekly ERP performance reporting in Databricks using SQL and PySpark, consolidating shipment, revenue, and utilisation data into a single pipeline and replacing a manual process of around 8 hours per week.</p><p> Built and maintained Power BI dashboards across 10,000+ marketing leads from 2 campaigns, integrating CRM data sources and tracking KPIs for lead quality, source performance, and geographic distribution, used by the campaigns' marketing manager.</p><p> Automated data extraction and validation processes (HS code extraction, invoice resolution) and analysed congestion data from 20+ global ports.</p>

Data Analyst Intern

DP World · Dubai, United Arab Emirates
Jun 2023 - Aug 2023 · 2 months

<p>Summer internship supporting commercial analytics, focused on consumer data analysis, price modelling, and catalogue management.</p><p> Performed statistical analysis on consumer data to identify geographic trends.</p>

Skills

Python SQL PySpark ETL pipelines API integrations LLM agents Claude Gemini LangGraph Generative AI prototyping forecasting statistical analysis hypothesis testing A/B testing Tableau Power BI Streamlit Advanced Excel Alteryx Databricks Azure Synapse Git Docker Microsoft Power Platform PowerApps Power Automate Copilot Studio
Report this Profile?