Haroon SB

Developed an analytics platform integrating GA4, Google Ads, Meta Ads, and Search Console into unified analytics datasets. Built Python/SQL data pipelines, KPI dashboards, and automated performance analysis. Implemented an AI recommendation/anomaly explanation engine using OpenAI APIs to interpret performance anomalies and suggest optimisation actions. Tech used includes Python, SQL, GCP, MongoDB, OpenAI API, Next.js, and AWS.

Conducted SEO keyword research and competitor analysis to identify content opportunities and improve search visibility. Implemented website tracking with Google Tag Manager and GA4 to measure user behaviour and conversions. Configured tracking tags and custom events in GTM to ensure accurate data collection across website interactions. Built Looker Studio dashboards integrating GA4 and Google Search Console to track traffic, keyword performance, and engagement metrics. Delivered data-driven insights to the marketing team, contributing to a ~40% increase in website traffic and organic impressions.

Analysed multi-location retail sales, customer, inventory, wastage, and operational data to identify performance trends, margin opportunities, and areas requiring management attention. Built Power BI and Looker Studio dashboards covering revenue, customer behaviour, inventory performance, and operational KPIs to compare performance across locations and reporting periods. Designed Python/SQL ETL workflows to clean, validate, deduplicate, and consolidate raw business data into analysis-ready datasets. Automated recurring weekly reporting workflows, reducing data preparation time by ~40% and improving reporting consistency. Investigated sales and operational variances and translated findings into clear recommendations for non-technical stakeholders.