Summary
Overview
Work History
Education
Skills
Areas Of Expertise
Accomplishments
Timeline
CustomerServiceRepresentative

Hamza Ali

Data Analytics
Birmingham,United Kingdom

Summary

  • An Ambitious Individual who has been working as a Data Analyst for over 5 years in many different companies. My role has varied from a data analyst to a project and solutions analyst or a supply chain analyst depending on each company requirements and how they sort and accumulate data. I have been using many different systems throughout my career such as SAP, SQL, VBA, Oracle, IBM, Power BI, MS Office, Excel & Google Sheets, which i am all experienced in to a high standard.
  • V lookups, pivot tables and identifying data to migrate from one to another or forecasting and predicting trends for companies based off historical data is what i have learned and gained using my own initiatives and company guidelines. An ability to identify problems at first place and problem-solve skill, further on a detail eye on processes and ability to recognise any gaps and forward recommendation to avoid any future problem or how to improve productivity.

Overview

6
6
years of professional experience
3
3
years of post-secondary education
1
1
Language

Work History

Transport Planner/Analyst

Unipart Logistics
Tamworth, West Midlands
10.2022 - 01.2023
  • Used SAP and Excel/Google Sheet to create monthly and quarterly benchmark analytics, illustrating costs for Different Departments & Higher management team.
  • Handling reports and performance KPIs which benefited the company to make forecasts and predictions on revenue generated, profits & loss and depot performances to meet targets.
  • Planning deliveries and stocks with stakeholders, liaising with other transport members from the JLR Transport team. Being part of the control tower to forecast loads with other departments, representing the transport team in the control tower. Making sure the control tower could de-escalate issues and matters before they reach the next step.

Supply Chain Analyst

DSV AIR/SEA & ROAD UK
Tamworth, West Midlands
03.2022 - 08.2022
  • Evaluated and implemented new technology solutions to improve supply chain operations by using Qlikview Analytics, SSRS, SAP, IBM & CargoLink.
  • Utilized data analytics to identify and resolve supply chain issues and improve overall performance from international markets and making it more streamline.
  • Creating Reports by using Excel Formulas, Pivot Tables & VBAs. And collating data from multiple softwares to create data and reports on supply chain KPIs to verify compliance with established standards.
  • Accurately processing and checking data queries by following procedures correctly and meeting agreed deadlines. Identifying solutions to resolve data queries.


Pensions Project & Solutions Analyst

Aon Financial Services UK
Birmingham, West Midlands
09.2021 - 02.2022
  • Recommended process improvements to continually identify, analyse and fix constraints and challenges when assigned a task.
  • Validated results and performed quality assurance to assess that the accuracy of data is within guidelines by using different softwares, Excel, Power BI and SQL databases.
  • Used strong analytical and problem-solving skills to develop effective solutions for challenging situations by using SQL Databases to pull large strings of data into Excel and creating KPI Reports to establish decision making.
  • Gained strong leadership skills by managing projects from start to finish.

Master Data Analyst

Saint-Gobain Ltd
Coventry, West Midlands
07.2021 - 09.2021
  • Analysed large amounts of data to identify trends and find patterns, signals to create reports with Excel & Power BI for higher managements and Stakeholders.
  • Leveraged text, charts and graphs to communicate findings in understandable format to present data to internal and external stakeholders.
  • To design and Migrate data into the existing products offered by Saint-Gobain to make it more effective and efficient. Debug the system and ensures that it is error-free.
  • Assign Macros into Excel via VBA to make it more effective and professional for large amount of data.

Contract Support Analyst

Arcus FM
Redditch, West Midlands
09.2020 - 06.2021
  • To use MI data, dashboards, trackers and the CAFM system to review, manage and control the flow of work orders for a group of contractors within a category managed by a Contract Manager (Performance) or a Technical Contract Manager.
  • To support the Contract Manager (Performance) or the Technical Contract Manager in all aspect of the work order life cycle, ensuring that the contractors are making progress with their assigned work-orders & completing before deadlines.
  • Ownership of the Touchpoint portal to include audit of current documents, also adding/uploading of contracts. Develop a working document for example DFM SLA’s, contractor handbook. Manage contractor escalation contact details and ensuring they are always up to date.

Data Reporting Analyst

IR Global
Solihull, West Midlands
08.2018 - 07.2020
  • Developed processes to automate a lot of reporting processes, resulting in 50% time decrease in manual cleansing of the data. Gathering, analysing data to enhance profit for the business and to expand the business.
  • Resolved variances in performance reports through root cause analysis and review of internal performance reports. Served as Analytics expert on company performance metrics analysis, design, development.
  • Create Ad Hoc Reports for customers and Directors, weekly or monthly to enhance decision making, find anomalies in the data, and validate the data by using Excel Formulas & MYSQL.

Pricing & Operations Analyst

Npower RWE
Solihull, West Midlands
08.2017 - 06.2018
  • Work with CRS, Apttus, Salesforce, REMIT, Oracle and SQL to create reports and templates for customers to pass through the CRS system and be accepted by ACER. Create KPI’s for Energy Companies & Directors on a weekly & monthly basis to enhance decision making,.
  • Forecasting Energy Consumption data by analysing and migrating historical data through Oracle and CRS/CRM to find anomalies and validate the data for future reports.Developed strong analytical and financial skills, which helped to anticipate market and company needs.
  • Use internal software’s such as Apttus to update customer data and cross check with Remit to see if each client is in scope and still active or check for any changes that have been made.

Graduate Business Analyst

Gefco UK
Coventry, West Midlands
08.2016 - 07.2017
  • Website Data Scraping, extracting large amounts of data from oversea depots and internal data into a readable format. Data mining, extensive amount of numerical data from manifests to reach conclusions and any arrears or anomalies.
  • Assign Macros into Excel via VBA to make it more effective and professional for large amount of data. Work with stakeholders to improve the business productivity.
  • Performed regular audits and assessments of logistics processes to identify weaknesses, improve supply chain operations and minimize waste.

Education

Bachelor of Science - Computer Science

Birmingham City University
Birmingham
09.2013 - 07.2016

Skills

    Excellent Reporting Skill, using both SAP, CRM, REMIT, SSRS, VBA, Power BI, SQL Queries & Databases

undefined

Areas Of Expertise

│Data Entry │ Data analyst │Database Systems │Web development │Business Analyst │Programming │Generating Reports│

Accomplishments

    GCSE Subjects/ GCSE’S Actual Grades

    English (Language) B)

    Math’s (B)

    R.E (Short Course) (C)

    Media (C)

    ICT Diploma (B)

    Science = (B, B)

    OCR ICT Unit 3 (Distinction) (A)

    Resistant Materials (C)


    A-Level Subjects/ A-Level Actual Grades

    Sociology (C)

    ICT (C)

    Business Studies (C)


Timeline

Transport Planner/Analyst

Unipart Logistics
10.2022 - 01.2023

Supply Chain Analyst

DSV AIR/SEA & ROAD UK
03.2022 - 08.2022

Pensions Project & Solutions Analyst

Aon Financial Services UK
09.2021 - 02.2022

Master Data Analyst

Saint-Gobain Ltd
07.2021 - 09.2021

Contract Support Analyst

Arcus FM
09.2020 - 06.2021

Data Reporting Analyst

IR Global
08.2018 - 07.2020

Pricing & Operations Analyst

Npower RWE
08.2017 - 06.2018

Graduate Business Analyst

Gefco UK
08.2016 - 07.2017

Bachelor of Science - Computer Science

Birmingham City University
09.2013 - 07.2016
Hamza AliData Analytics