Hamza Khalid

BI and Analytics Professional

About Me

I am an Analyst (Strategy & Analytics) at EG Group UK, leading analytics for 3000+ fuel stations across Europe driving a boost in efficiency, detecting frauds, leakages and inventory management to save financial and environment losses. Over the past 3 years I have specialised in Power BI, Tableau, Python, SQL and Excel. Worked with The Government (Billion-Dollar Infrastructure Projects), The World Bank, Tier-1 Banks, Utilities, Tourism and Oil/Gas (Logistics & Inventory Optimization) sectors etc; experienced in stakeholder management, documentations, requirements gathering and building analytical storylines.


"Hamza stands out as an exceptional professional, combining technical expertise, strategic thinking, and business acumen to deliver impactful results. He excels at building strong client relationships and communicating insights with clarity and confidence. His ability to navigate challenges, lead projects effectively, and consistently deliver results makes him a valuable asset to any team. I highly recommend Hamza for his dedication, leadership, and consistent drive to exceed expectations."

Ayman Rehan
(Senior Manager Analytics @ EY MENA)

"I’ve had the pleasure of working closely with Hamza, and I can confidently say he is an invaluable asset to our team. His analytical skills, attention to detail, and ability to transform complex data into actionable insights are truly impressive. One of Hamza's standout strengths is his expertise in Power BI. He has an incredible knack for building dynamic dashboards and visualizations that not only look great but also drive decision-making. Whether it's wrangling large datasets, optimizing reports for efficiency, or uncovering trends that others might miss, Hamza consistently delivers high-quality work with precision and clarity."

Afraz Hussain
(Head of Fuel Pricing @ EG Group)

Experience

Placeholder image

EG Group UK

Analyst (Strategy & Analytics) - Dec 2024 - Present

Helping 3000+ petrol stations across Europe with analytics, focusing on large-scale fuel inventory management, early leaks, anomaly detection, and loss prevention.
Built Power BI dashboards to enhance anomaly detection and response times by 25%, while advancing BI strategies to improve reporting accuracy and mitigate financial losses.
Serving as the 𝗦𝗠𝗘 𝗳𝗼𝗿 𝗿𝗲𝗽𝗼𝗿𝘁𝗶𝗻𝗴, 𝗱𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱𝗶𝗻𝗴, 𝗮𝗻𝗱 𝗮𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗼𝗻, collaborating with teams to deliver data-driven insights that drive business improvements.

Power BI DAX SSRS Python MS Excel Power Apps Power Automate SQL Server
Placeholder image

EY MENA

Assistant Manager (Senior Executive II, Data Science & Analytics) - Nov 2022 - Nov 2024

Led 40+ end-to-end BI projects at EY, optimizing ETL pipelines for datasets with 3M+ records and cutting processing time by 40%.
Delivered predictive analytics models that improved forecast accuracy by 30% and enhanced operational efficiency for World Bank projects.
Presented BI solutions to 100+ stakeholders including Government Officials, VPs, Directors, Managers and other Team Heads as well, helping them drive strategic decisions for the business.

"Developed dashboards showcased at national and international forums, including COP’28, highlighting impactful data-driven insights on global platforms. Achieved two promotions within two years, advancing from Analyst to Senior Data Consultant II."

Python Power BI DAX Tableau SQL Azure Machine Learning Geospatial Data Analysis Process Automation & Scripting Data Warehousing Data Integration Cross-functional teams collaboration Stakeholder Management Requirement Gathering Data Quality Management Strategic Planning
Placeholder image

BLUTECH Consulting Pakistan

BI Analyst - Aug 2022 - Nov 2022

Helping Tier-1 banking clients with optimising ETLs, SQL queries and developing financial dahsboards; enhancing risk monitoring and reporting efficiency by 20%.

SQL Server SSRS SSIS ETL SSAS MDX Power BI Financial/Transactional Dashboards

Certifications

Placeholder image

EY’s Artificial Intelligence academy

A.I. Engineering

Placeholder image

EY’s Analytics academy

Data Integration

Placeholder image

Udemy

ChatGPT, Midjourney, DALL-E 3 & APIs - The Complete Guide

Placeholder image

Udemy

Microsoft Excel: Advanced Excel Formulas & Functions

Placeholder image

Datacamp

Intermediate SQL Server

Placeholder image

Frontier Technology Institute

Data Science (6 Month Certification)

Projects

IoT Devices Malicious Attack Detection (Research Purpose)

Built and optimized ML models to detect malicious activity in IoT data, achieving high accuracy through advanced analysis and visualization techniques.

  • Designed and compared 7+ ML models to detect malicious IoT activity with high accuracy.
  • Conducted exploratory data analysis and generated classification reports for model evaluation.
  • Created interactive visualizations to highlight data patterns and model insights.
Python Machine Learning Supervised Learning Unsupervised Learning Classification Reports Model Comaprisons Data Visualisations Exploratory Data Analysis

Inventory Management System

Created a custom desktop application for inventory, finance, and vendor management using Python, Tkinter, and Firebase.

  • Enabled stock tracking, payment processing, and balance sheet generation.
  • Integrated SQL queries with Pandas DataFrames for data analysis.
  • Utilized Firebase for real-time database management and Tkinter for GUI design.
Python Data Analytics Financial Risk Metrics Firebase Treeview Tkinter

YouTube Search Optimization: Title-Content Accuracy Evaluation

Developed a technique to compare YouTube video titles with speech content, improving search relevance and reducing misleading titles.

  • Analyzed title consistency with video content to ensure higher relevance.
  • Implemented AI-driven methods using Python, Assembly AI, and IBM Watson Studio.
  • Enhanced viewer satisfaction by refining search results with accurate title assessments.
Python Machine Learning Assembly AI MoviePY IBM Watson Studio

Predictive Analytics for YouTube Video Pricing with Fbprophet

Created a script to collect and analyze YouTube video price data, leveraging time series analysis for accurate future price predictions.

  • Collected day-wise data using YouTube Data APIs and Selenium.
  • Applied data cleaning techniques for accurate analysis and forecasting.
  • Utilized Fbprophet for precise time series forecasting of video pricing trends.
Python YouTube Data APIs Selenium FB Prophet

Recommendations

"He was a virtuous addition in our team. He always chase to learn new things and discuss new propositions with team, which personaly help me alot."

Satish Kumar
(Manager Analytics @ Soneri Bank Pakistan)

"Having closely monitored the progress of Hamza over the last six months, I found him to be a diligent professional who has not only been able to perform under pressure, but also deliver quality work. He will be an asset to any organisation."

Masood Zaidi
(Senior Consultant @ EY UK)

"He was a virtuous addition in our team. He always chase to learn new things and discuss new propositions with team, which personaly help me alot."

Abdul Rauf
(Senior BI Consultant @ Smart Solutions UAE)

"Hamza has been one of our start interns. I have been consistently impressed with Hamza’s attitude and productivity during the time that he has worked in the office. He was primarily involved in projects related to Data Analytics, Web Scraping / Web Crawling, Automation, Product Building, Freelancing and API Integration."

Konain Qurban
(Associate Director @ Scouts Canada)

"I have worked with Hamza on data science and analytical projects and can say he is a great team member to work with. His technical capabilities do really stand out."

Anas Abid
(Founder @ Disilytics Pakistan)