Job Role: Data Analyst

Experience: 2 Years

Address: Islamabad, Pakistan

Skills

SQL 95%
Excel 90%
Data Visualization 90%
Data Cleaning 95%
Power BI 85%

About

About Me

A Data Analyst with experience in project management, and data visualization. I have worked on development projects funded by organizations like the World Bank and JICA, delivering data-driven insights to support strategic decision-making. Proficient in Excel, SQL, Python, and Power BI, I excel at translating complex data into actionable solutions. I am a strong communicator and collaborator, committed to driving impactful results through thorough analysis and effective project management.

  • Profile: Data Science & Analytics
  • Education: Bachelor of Accounting and Finance
  • Language: English, Urdu, Pushto
  • BI Tools: Microsoft Power BI
  • Other Skills: Excel, Python, SQL, Github, JIRA

LinkedIn

Resume

Resume

Experienced in finance, data analysis, and development projects, skilled in Excel, SQL, Python, and data visualization. Proven track record of driving data-driven insights and process optimizations in multilateral agency-funded initiatives.

Experience


2023-Present

Data Quality Analyst

Associates in Development (AiD) Pvt Ltd

AiD is an international consulting organization that provides development and management consulting services in the Engineering, Environment and Social Sectors.

  • Conducted in-depth data analysis and monitoring for World Bank and JICA projects.
  • Delivered actionable, data-driven insights to support strategic decision-making, reducing reporting time frames by 20%.
  • Utilized advanced analytical tools (Excel, Python, and Power BI) to enhance business development and operational efficiency.

2020-2023

Co-Founder and Operation Manager

Pastraw
  • Developed strategic proposals aligning business goals with environmental impact, leading a team of 15 to enhance productivity.
  • Created educational programs to raise awareness about single-use plastic waste.
  • Utilized and collected data, employing business intelligence tools to identify and engage customers effectively.



Education


2017-2021

Bachelor of Accounting and Finance

Institute of Management Sciences, Peshawar
2018

Summer School, Entrepreneurship Business and Research

Zhejiang University, China

Projects

Projects

Below are the sample Data Analytics projects on SQL, Python, Power BI.

Unicorn Companies Data Analysis using SQL

Using SQL queries, I extracted insights on trends and valuations, with a particular focus on the FinTech sector.

Amazon Sales Data Analysis: Insights on Order Quantities Using Python

Performed exploratory data analysis on Amazon sales data using Python to improve the customer experience.

Power BI Health dashboard Project

In the "Health Project" Power BI analysis, I examined hospital data on patient care, including admissions, diagnoses, and billing. I created dashboards to analyze demographics, disease prevalence, and treatment outcomes, providing insights into patient admissions, follow-up efficiency, and financial performance to enhance decision-making and optimize care..

Microsoft Stock Price Data Analysis Using SQL

This project analyzes Microsoft stock data from Kaggle using SQL. Key queries focus on average prices, trading volumes, yearly trends, and price-volume relationships, uncovering patterns in stock performance.

Analysis of Spotify Streaming using Python

This analysis examines a dataset of music tracks, revealing insights into artist collaborations, streaming performance, and musical features. Key findings include trends in release years, the impact of playlist appearances on streaming success, and the diversity of musical characteristics across tracks.

Coffee Sales Analysis Using Excel

This project analyzes coffee sales data in Excel. Duplicates were removed, and lookup functions were used to identify trends, focusing on which coffee products are generating the most sales. The goal is to uncover key sales drivers and inform business decisions.


Store Sale Analysis in Excel

In the "Store Sale Analysis" Excel project, I analyzed sales data to uncover trends in store performance, using pivot tables and charts. Key findings included top-selling products, sales trends, and customer purchasing patterns, providing insights for inventory management and marketing strategies.

Social Media Usage Dashboard BI

Analyzed social media usage to identify trends and engagement patterns, assessing performance across platforms. Key insights included audience demographics, peak activity times, and content effectiveness, informing strategies for improved reach and engagement.

More projects on Github

I love to solve business problems & uncover hidden data stories


GitHub

Contact

Contact Me

Below are the details to reach out to me!

Address

Islamabad, Pakistan

Contact Number

+ 92 315 0967932

Email Address

mian.izaan98@gmail.com



Have a Question? Click Here