Salman Khan
Newcastle-under-Lyme,Staffordshire
Summary
Accomplished data professional with expertise in data handling, transformation, and visualisation. Posesses advanced skills in SQL. Experienced in using business intelligence tools which include; Power BI, Tableau, and SSRS to drive data-driven decision-making.
Overview
7
7
years of professional experience
4
4
years of post-secondary education
1
1
Certification
Work history
Business Insight Analyst
MSC Industrial Supply Co. UK
Wednesbury, UK
04.2023 - 11.2025
- Delivered ad-hoc reporting support across multiple departments, including Accounting, Finance, Sales and Marketing.
- Evaluated marketing campaigns and conducted customer analysis to inform targeted marketing strategies which lead to 20% increase in engagement.
- Analysed transactional data and pricing strategies and identified inconsistencies and uncontrolled probe and manual discounts contributing to 15% margin improvement.
- Queried data using SQL in SSMS, presenting insights through Power BI, Grow BI, SSRS, MS Excel.
- Supported in migration of data and reporting during transition from SSRS to Grow BI and then to Microsoft Fabric.
Data Analyst
Bruce Power
Tiverton
11.2021 - 11.2022
- Queried and mined large data sets using SSMS, Oracle SQL Developer and PL/SQL.
- Developed and Maintained ETL packages in SSIS and Azure Data Factory to prepare data for reporting.
- Created and managed dashboards and reports for work order management, monitoring operations and assessing performance using Power BI and P BI Report Builder.
- Prepared Milestone Adherence Dashboard by coordinating and gathering data from various teams for it to be presented in Outage Performance meetings.
Data Visualization Teaching Assistant
University of Toronto
Toronto
02.2021 - 04.2022
- Taught students Git, Excel, VBA, Python, SQL, ETL and data warehousing, MongoDB, HTML, CSS, JavaScript, Tableau, R, Big Data, and Machine Learning.
- Assisted in teaching Bootcamp classes and guided students in office hours.
Analyst Intern
Weatherford Drilling International
Islamabad
06.2018 - 08.2018
- Performed Inventory Analysis on MS Excel and determined rig items leading to excess costs of $450,000.
- Created well Kill sheet to demonstrate well control limitations and performed other drilling calculations using MS Excel.
- Prepared technical reports and presented on various elements, processes and challenges of business.
Education
Bachelors of Engineering - Mechanical
Ontario Tech University
Oshawa, Canada 09.2015 - 04.2019
Data Analytics Specialist Program -
Sysintelligence Institute of Technology
Toronto, Canada 04.2020 - 10.2020
Skills
- Data Handling, Data Transformation, ETL and Data Mapping, Data Cleaning, Data Modeling, Data Visualization, Data Warehousing, Machine Learning
- Business Intelligence Tools such as: MS Excel, Power BI, P BI Report Builder, SSIS, SSRS, Grow BI, Tableau, Cognos Analytics, Google Analytics, R Studio, MS PowerPoint, Azure Data Factory, AWS, Git
- Languages: SQL, Python, R, DAX, VBA, JavaScript, Matlab, C, C#
- RDBMS: SSMS, MySQL, Oracle SQL Developer, PostgreSQL, IBM db2, Azure SQL, MS Access
- Frameworks: HTML, CSS, Bootstrap, PHP, XML, JSON, JQuery, AMPscript
Certification
- 761: Querying Data with Transact-SQL (2020-12)
- PCEP – Certified Entry-Level Python Programmer (2020-11)
- DA-100: Analyzing Data with Microsoft Power BI (2020-10)
- Microsoft Certified: Data Analyst Associate (2020-10)
Timeline
Business Insight Analyst
MSC Industrial Supply Co. UK
04.2023 - 11.2025
Data Analyst
Bruce Power
11.2021 - 11.2022
Data Visualization Teaching Assistant
University of Toronto
02.2021 - 04.2022
Data Analytics Specialist Program -
Sysintelligence Institute of Technology
04.2020 - 10.2020
Analyst Intern
Weatherford Drilling International
06.2018 - 08.2018
Bachelors of Engineering - Mechanical
Ontario Tech University
09.2015 - 04.2019