Name: Muhammad Hamid Khan

Job Role: Data Analyst

Experience: More then 2 Years

Address: Mianwali, Pakistan

Skills

SQL 70%
PYTHON 25%
Power BI, Tableau (Data Visualization) 90%
Statistical Analysis 85%
QGIS 40%

About

About Me

With over 2 years of comprehensive experience in the field of data science & analytics, accompanied by a degree in Data Science. Proficient in data analysis, statistical analysis, hypothesis testing, customer behaviour analysis, spatial analysis, promt engineering, report writing & machine learning. Demonstrated success in leading impactful projects and providing effective training workshops on Data for Good Governance.

  • Profile: Data Science & Analytics
  • Domain: Data Science for Public Policy, Public Policy Analysis ,Business, Development Sector & Governance, Digital Governance,
  • Education: Data Science Bootcamp
  • Language: English, Urdu, Saraiki, German(Basic)
  • BI Tools: Microsoft Power BI, Tableau, SQL Server,Pyhton (Jupiter Notebook), QGIS, & Generative AI
  • Other Skills: Excel, Git, Google Analytics, Report Writing, Presentation, Teaching & SEO
  • Dream: Data Scientist for Public Policy, Social Science, Good Governance

0 +   Projects completed

LinkedIn

Resume

Resume

Seasoned Data Scientist with 2+ years of experience driving business strategies and public policy analysis through data-driven insights. Proven expertise in data science, statistical analysis, machine learning algorithms and project management.

Experience


2023- Present

Data Scientist

Freelance .
  • Developed interactive dashboards in Power BI and Tableau, integrating complex data for insights on operations, customer behavior, and trends, enhancing strategic decisions.
  • Mastered SQL for data manipulation, reporting, and optimized database performance. Led schema design and automation of data processing tasks through advanced SQL techniques.
  • Used Python for data analytics, employing Pandas, NumPy, and Scikit-learn for data cleaning, analysis, and machine learning, automating analytical processes and adding predictive capabilities.
  • Conducted geospatial data analysis with QGIS to identify market trends, optimize logistics, and improve marketing, supporting market expansion and operational efficiency improvements.
  • Improved NLP model performance with prompt engineering for better data extraction and sentiment analysis, enhancing customer service chatbots and marketing communication personalization.
  • Integrated Tableau with SQL and Python to automate data analytics pipelines, streamlining workflows, reducing manual work, and delivering timely, actionable insights to stakeholders.
  • Authored comprehensive analytical reports combining AI insights and data visualizations to communicate findings, trends, and recommendations, enhancing executive decision-making and strategic initiatives.
  • Pioneered the use of generative AI models to automate the creation of data narratives, transforming raw data into engaging, easily digestible reports for diverse audiences.
  • Enhanced report accuracy and depth by integrating AI-driven predictive analysis, offering forward-looking insights and scenario planning to guide future business strategies and operations.



Education


2020-2024

Bachelor of Governance and Public Policy

National University of Modern Languages, Islamabad

Grade: 3.65 CGPA.

2023-2024

Data Science Bootcamp

Atomcamp

Grade: Top Rankers.

2022-2024

1: A Crash Course in Data Science

2: Introduction to Business Analytics

3: Prompt Engineering For Chat GPT

4: Data Processing and Manipulation

5: Chat GPT for Advance Data Analysis

6: Google SEO Fundamental

Coursera

Grade: Top Ranked.

Projects

Projects

Below are the sample Data Analytics projects on Excel, Power BI, Tableau, SQL, QGIS, Pyhton, Prompt Engineering, & Reports.

Power BI: Amazon Prime Sales Dashboard

Formulated dashbaord for amazon sales data, DAX measures, to present insights and hidden patterns.

Power BI: Flying Whale Dashboad

Build a dashboards to visulize appointment and cancellation treands, time series analysis, and visulize crucial insights .

Power BI: Coffee Sales Dashboard

Designed a power bi dashboard for coffee point to analyze sales trends, hidden patterns, and slaes over days, months, and year .

SQL: City Trains Data Analysis (EDA, KPI's)

The project is an SQL-based analysis of city train systems, focusing on air quality, bus routes, commuter patterns, road segments, traffic flow, and weather to derive key performance indicators

SQL: Walmart sales EDA

This SQL script is designed for analyzing Walmart sales data, featuring commands for database use, data selection, and feature engineering, including time of day categorization and dataset modification.

SQL: Bank Data EDA

SQL database project for managing bank transactions, accounts, customers, and financial records with queries for analysis and reporting.

0 Certifications/Appriciations
0 Projects
0 Mentored Students

More projects on Github

I love to solve business problems, public policy analysis & uncover hidden patterns and convert raw data into insightful stories


GitHub

Contact

Contact Me

Below are the details to reach out to me!

Address

Islamabad, Pakistan

Download Resume

resumelink



Have a Question? Click Here