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 identify performance anomalies and suggest optimisation actions. Technologies include 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 using Google Tag Manager (GTM) and GA4 to measure user behaviour and conversions. Configured tracking tags and custom events in GTM to ensure accurate data capture 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 that contributed 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 enable consistent comparisons across locations and reporting periods. Designed Python and SQL ETL workflows to clean, validate, de-duplicate, and consolidate raw business data into analysis-ready datasets. Automated recurring weekly reporting workflows, reducing data preparation time by ~40% while improving reporting consistency. Investigated sales and operational variances and communicated actionable recommendations to non-technical stakeholders.