Data Analyst Analysis

Data Analyst

Muhammad Ishaq

925-***-**** *************@*****.***

linkedin.com/in/muhammad-ishaq-306701264

https://github.com/Muhammad-ishaq

https://muhammad-ishaq.github.io/MuhammadIshaq.github.io/

Houston, TX -75081

Technical Skills

•SQL (SQL Server, MySQL)

•Tableau

•Data Cleaning & Preprocessing

•Data visualizations&insights

•Dashboard design

•Excel (V Lookup, X Lookup, Conditional Formatting, Pivot Tables)

•Exploratory Data Analysis (EDA)

Soft Skills

Ability to explain complex data findings to non-technical stakeholders

Strong analytical mindset for interpreting data and identifying patterns

Comfortable contributing to group projects and sharing insights

Able to prioritize tasks and deliver insights within given timelines

Quick to learn new tools, platforms, and business domains

Translates raw numbers into meaningful narratives

Projects (Personal & Learning)

Data Cleaning with MYSQL-- Personal Project (August, 2025)

Cleaned and transformed a raw retail dataset (5000+ rows) using MYSQL

to prepare it for analysis.

Removed duplicates, handled missing values, standardized date formats, and normalized categorical fields.

Used Join's, GROUP BY, CASE, Views, Store Procedures and CTE’s` to restructure and enrich the dataset.

Resulted in a clean, analysis-ready dataset used to generate insights.

Published the project on GitHub for portfolio visibility: https://github.com/Muhammad-ishaq/DataCleaning_layoffs

COVID-19 Data Exploration using MYSQL-- Personal Project (July, 2025)

Analyzed global COVID-19 datasets from internet provided sources.

Cleaned and merged time-series data on cases, deaths, and vaccinations using MYSQL.

Explored trends in infection rates, mortality, and vaccine rollout across countries and regions.

Identified correlations between vaccination rates and case declines, highlighting public health impact.

Published the project on GitHub for portfolio visibility: https://github.com/Muhammad-ishaq/portfolioPROJECT-dataExploration

Employees Demographics- Data Exploration using MYSQL-- Personal Project (June, 2025)

Explored a dataset of 5,000+ employee records to uncover trends in age, gender, department, and salary distribution.

Cleaned and transformed raw data using MYSQL, standardizing formats.

Used row number using window function to find the duplicates in the data.

Removed the duplicates in the datasets.

Used rank and dense rank in the window function to rank the employees based on the salaries.

Published the project on GitHub for portfolio visibility. https://github.com/Muhammad-ishaq/parks_recreations_DataExploration

Data Analysis and Visualization – Personal Project (July, 2025)

Tools: MYSQL, Excel, Tableau

Queried and cleaned a COVID-19 dataset (5000+ rows) using MySQL to prepare for analysis.

Used Excel for initial data exploration, pivot tables, and trend identification.

Built an interactive Tableau dashboard to visualize KPIs such as population infected by region.

Published the project on GitHub and Tableau Public for portfolio visibility. Links are given below.

Book1a Tableau Public

https://github.com/Muhammad-ishaq/Tableau_SQL_PROJ

>> Link to my portfolio website: https://muhammad-ishaq.github.io/MuhammadIshaq.github.io/

Work Experience

RETAIL MANAGER/ANALYST – HAMMAR USA LLC, HOUSTON, TX.

March 2022-current

Analyzed weekly sales and inventory data to identify trends, reduce overstock by 20%, and increase sell-through rate.

Worked as a team and implemented performance dashboards using Excel, resulting in a 12% increase in productivity.

Used data to forecast product demand, reducing stock outs and improving customer satisfaction.

Created weekly reports summarizing KPIs (sales, customer retention, turnover) and presented insights to regional leadership.

Trained new staff on POS systems and data analytics, improving reporting accuracy.

RETAIL MANAGER (ASSISTANT) – VALERO, HOUSTON, TX. January 2020-February 2022

Analyzed daily and weekly sales reports to inform staffing and merchandising decisions, contributing to year to year sales increase.

Tracked inventory levels and used historical sales data to predict product demand, reducing overstock by 15%.

Built Excel dashboards for tracking KPIs such as average transaction value, and employee productivity.

Worked cross-functionally with regional leadership to optimize pricing strategies using local market data.

Trained team members to use in-store reporting tools to monitor and improve department-level performance.

Professional Summary

Retail Manager transitioning into Data Analytics, with 8+ years of experience making data-informed decisions to drive sales, optimize operations, and improve customer satisfaction. Skilled in Excel, SQL, and Tableau with hands-on experience building dashboards and performing customer and inventory analysis.

Education

University of the Potomac Washington DC

MS Computer/Information Systems 2015-2016

University College of Engineering and Technology (IUB), Pakistan

Bachelors of Engineering ( Electrical and Electronics Engineering) 2008 - 2012

Contact this candidate