Menu

Hi! I'm Sarmad,
Data Analyst
based in Edmonton, Canada

Hi! I'm Sarmad,
Data Analyst
based in Edmonton, Canada

Hi! I'm Sarmad,
Data Analyst
based in Edmonton, Canada

Provide end-to-end solutions for data challenges, turning information into insights

Provide end-to-end solutions for data challenges, turning information into insights

Provide end-to-end solutions for data challenges, turning information into insights

Explore My Projects

Explore My Projects

Explore My Projects

Explore My Projects

My Amazon Spending

Analyzes personal Amazon purchases from 2020 showing insights into spending pattersn

Advanced Data Processing

Data Acquisition

Tableau Workflow

View Project

My Amazon Spending

Analyzes personal Amazon purchases from 2020 showing insights into spending pattersn

Advanced Data Processing

Data Acquisition

Tableau Workflow

View Project

My Amazon Spending

Analyzes personal Amazon purchases from 2020 showing insights into spending pattersn

Advanced Data Processing

Data Acquisition

Tableau Workflow

View Project

My Amazon Spending

Analyzes personal Amazon purchases from 2020 showing insights into spending pattersn

Advanced Data Processing

Data Acquisition

Tableau Workflow

View Project

PostgreSQL Database

Created a dataset by webscraping Gymshark product page and imported it into a PostgreSQL database for analysis

Webscraping with Python

PostgreSQL

Synthetic Data Generation

View Project

PostgreSQL Database

Created a dataset by webscraping Gymshark product page and imported it into a PostgreSQL database for analysis

Webscraping with Python

PostgreSQL

Synthetic Data Generation

View Project

PostgreSQL Database

Created a dataset by webscraping Gymshark product page and imported it into a PostgreSQL database for analysis

Webscraping with Python

PostgreSQL

Synthetic Data Generation

View Project

PostgreSQL Database

Created a dataset by webscraping Gymshark product page and imported it into a PostgreSQL database for analysis

Webscraping with Python

PostgreSQL

Synthetic Data Generation

View Project

Credit Card Fraud Model

Detect fraudulent credit card transactions using the XGBoost algorithm and fine-tune the model parameters

Advanced Data Preprocessing

Machine Learning

Feature Engineering

View Project

Credit Card Fraud Model

Detect fraudulent credit card transactions using the XGBoost algorithm and fine-tune the model parameters

Advanced Data Preprocessing

Machine Learning

Feature Engineering

View Project

Credit Card Fraud Model

Detect fraudulent credit card transactions using the XGBoost algorithm and fine-tune the model parameters

Advanced Data Preprocessing

Machine Learning

Feature Engineering

View Project

Credit Card Fraud Model

Detect fraudulent credit card transactions using the XGBoost algorithm and fine-tune the model parameters

Advanced Data Preprocessing

Machine Learning

Feature Engineering

View Project

YuGiOh PowerBI Dashboard

Leveraging Python scripting for API integration, data cleaning techniques to create a Power BI dashboard

API Integration

Design Principles

Power BI

View Project

YuGiOh PowerBI Dashboard

Leveraging Python scripting for API integration, data cleaning techniques to create a Power BI dashboard

API Integration

Design Principles

Power BI

View Project

YuGiOh PowerBI Dashboard

Leveraging Python scripting for API integration, data cleaning techniques to create a Power BI dashboard

API Integration

Design Principles

Power BI

View Project

YuGiOh PowerBI Dashboard

Leveraging Python scripting for API integration, data cleaning techniques to create a Power BI dashboard

API Integration

Design Principles

Power BI

View Project

Work Experience

Conducted survey analysis using Python, transforming responses into actionable recommendations that improved venue operations through 15% parking cost reduction and expanded amenity offerings

20 %

faster querying load times by optimizing DAX expressions

Business Data Analyst

Explore Edmonton

Championed and implemented an enterprise-wide Databricks data lake solution that streamlined ETL processes and enhanced cross-organizational data accessibility for 200+ users.

Work Experience

Work Experience

Work Experience

20 %

faster querying load times by optimizing DAX expressions

Explore Edmonton

Explore Edmonton

Business Data Analyst

Business Data Analyst

Conducted survey analysis using Python, transforming responses into actionable recommendations that improved venue operations through 15% parking cost reduction and expanded amenity offerings

Conducted survey analysis using Python, transforming responses into actionable recommendations that improved venue operations through 15% parking cost reduction and expanded amenity offerings

Conducted survey analysis using Python, transforming responses into actionable recommendations that improved venue operations through 15% parking cost reduction and expanded amenity offerings

Championed and implemented an enterprise-wide Databricks data lake solution that streamlined ETL processes and enhanced cross-organizational data accessibility for 200+ users.

Championed and implemented an enterprise-wide Databricks data lake solution that streamlined ETL processes and enhanced cross-organizational data accessibility for 200+ users.

Championed and implemented an enterprise-wide Databricks data lake solution that streamlined ETL processes and enhanced cross-organizational data accessibility for 200+ users.

Developed PowerBI dashboards analyzing $28M provincial budget allocation, enabling senior leadership to optimize fund distribution to different Indigenous nations in Alberta.

Developed PowerBI dashboards analyzing $28M provincial budget allocation, enabling senior leadership to optimize fund distribution to different Indigenous nations in Alberta.

2x

faster reporting analysis by automating data entry

Government of Canada

Data Analyst

Trained employees on PowerBI that streamlined data monitoring processes, resulting in improved reporting efficiency across departments.

Trained employees on PowerBI that streamlined data monitoring processes, resulting in improved reporting efficiency across departments.

The Process

Approach to Data Analysis

Approach to Data Analysis

1

1

1

1

Problem Definition

Understand the requirements for the business and define what success looks like

Have a clear problem statement

Have a clear problem statement

Communicate with stakeholders to understand needs

Communicate with stakeholders to understand needs

Define specific KPIs

Define specific KPIs

Data Collection

Gathering all necessary data from relevant sources while ensuring proper access and permissions.

Creating a data inventory that shows potential data sources

Document data relationships and schemas

Document data relationships and schemas

Document data relationships and schemas

Assess data quality

Assess data quality

Assess data quality

2

2

2

2

3

3

3

3

Data Cleaning

To ensure the data is reliable and suitable for analysis, this step is crucial. Detect errors, inconsistencies, and inaccuracies

To ensure the data is reliable and suitable for analysis. Detect inconsistencies, and inaccuracies

Identify missing values, outliers, and inconsistencies

Identify missing values, outliers, and errors

Develop and implement standardized cleaning procedures

Develop and implement standardized cleaning procedures

Document cleaning steps

Document cleaning steps

Exploratory Data Analysis

Discover patterns, spot anomalies, and form hypotheses

Generate summary statistics and basic visualizations

Identify potential relationships between variables

Create initial hypothesis based on observed patterns

4

4

4

4

5

5

5

5

Detailed Analysis and Insights

Test hypotheses and validate findings and offer actionable insights by translating analytical results into business value

Apply appropriate statistical tests and models

Apply appropriate statistical tests and models

Create executive summary highlighting key findings

Create executive summary highlighting key findings

Design clear visualizations to communicate results effectively

Design clear visualizations to communicate results effectively