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
Excel (Power Pivot & Pivot Tables, Formulas, Data Cleansing, Data Migration, V-Lookups, KPI Performance Dashboards)
Experience working on multiple Systems, APPTUS, Oracle, CRM, Qlikview, ERP, WMS, CargoLink, IBM & Google Sheets
High level of understanding in Networking and Development (DLP, Firewalls, Cisco, Juniper, NBA, VPNs, IDS, IPS)
Excellent working knowledge using both Windows systems; SQL Server, Creating Tables, Knowledge of Hyper-V and VMWare
High level of understanding of Microsoft office (Word, Excel, Access, PowerPoint, Publisher)
Excellent communication skill with management and other stakeholders at all levels Ability to Problem-solving and planning
High level of understanding in Programming and Web Development (C#, Python, XML, ASPNET, HTML, XHTML, MYSQL, CSS, Flash, ActionScript, Java)
High Level of understanding of Adobe products (Dreamweaver, Flash, Fireworks, Photoshop and Illustrator)
Can speak various languages, (English, Urdu, Punjabi, Arabic and Spanish)
A leadership approach and always have an eye on the objectives and goals, with an ability to motivate team members and building a confidence with other stake holders An ability to identify problems at first place and problem-solve skill, further on a detail eye on processes and ability to recognize any gaps and forward recommendation to avoid any future problem or how to improve productivity Able to use own initiative and work as part of a team and under pressure to meet deadlines and objectives
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