Transforming Data into Actionable Insights

Data Analyst | SQL Expert | Visualization Specialist

About Me

Husnain Zahoor

Data tells a Story and I help businesses Read it. As a Data Analyst, I turn raw numbers into actionable insights that guide smarter decisions and drive tangible growth.

With expertise in Advanced Excel, PostgreSQL, Data visualization, and statistical analysis, I bridge the gap between technical data processing and business strategy. My professional experience in project planning and performance tracking has strengthened my ability to deliver data-driven solutions in real-world scenarios.

Based in Riyadh Saudi Arabia, I’m on a mission to help organizations unlock the full potential of their data and turn insights into impact.

Core Expertise

PostgreSQL

Advanced SQL querying, data cleaning, transformation, and complex business intelligence reporting to extract actionable insights from large datasets.

Advanced Excel

Expert in Pivot Tables, XLOOKUP and complex data analysis. Creating automated reports and dashboards for efficient data processing.

Data Visualization

Creating compelling visual stories with Tableau. Designing interactive dashboards that communicate complex data insights effectively.

Featured Projects

Each project demonstrates my ability to solve real business problems using data analytics. Click on any project to explore detailed case studies including methodology, findings, and business impact.

Retail Analytics

Walmart Store Sales Performance Analysis

Business Challenge: Identify key drivers of store performance variance and quantify holiday season impact on weekly sales patterns across 65,000+ transactions.

52% Sales from Holidays
0.75 Efficiency Correlation
65K+ Rows Analyzed
5 Key Recommendations
  • Uncovered that holiday periods drive majority of annual revenue
  • Identified store efficiency as primary performance driver
  • External economic factors showed minimal correlation with sales
  • Delivered actionable strategies for underperforming stores
Advanced Excel Pivot Tables Statistical Analysis XLOOKUP Data Visualization Correlation Analysis
View Project Details
Search Engine Analytics & Forecasting

Case Study:Cliqz Search Engine Analysis

Business Objective: Analyze user search behavior patterns and forecast query volume to optimize server capacity planning and operational efficiency for search engine infrastructure.

70K+ Search Queries
2.7K Hourly Forecast
3K/hr Capacity Recommended
15% Cost Reduction
  • Built time-series forecasting model predicting hourly search volumes
  • Designed interactive Tableau dashboards for operational planning
  • Identified peak usage patterns across countries and time zones
  • Provided data-driven server capacity recommendations
Tableau Time-Series Forecasting Advanced Excel Data Visualization User Behavior Analysis Dashboard Design
Case Study:Explore Analysis & Dashboards

Looking for more? These case studies demonstrate my full analytical workflow from problem definition to actionable recommendations.

Request Full Portfolio

Professional Experience

Jr. Planning Engineer

Shandong Tiejun Electric Power Engineering Co, Ltd

Feb 2025 - Present | Riyadh, KSA

  • Participated in weekly client meetings alongside senior managers to review progress reports, discuss updates, and gather client feedback for project adjustments.
  • Collected, cleaned, and validated project data from multiple departments, improving progress tracking accuracy and enabling faster operational decision-making.
  • Built S-curves, Pivot Tables, and performance dashboards in Advanced Excel, reducing report preparation time by 30–40% across daily, weekly, and monthly reporting cycles.
  • Developed 1-week and 3-week look-ahead plans to support task prioritization, increasing on-time task completion by up to 20%.
  • Monitored weekly progress targets (2–3% growth), identified variances 2–3 days earlier, and triggered timely corrective actions across departments.
  • Delivered data-driven insights that helped teams recover from progress gaps and improved schedule alignment by 10–15%
  • Analyzed planned vs. actual productivity to predict delays and support proactive decisions, including manpower adjustments and resource reallocation.
  • Delivered data-driven insights that helped teams recover from progress gaps and improved schedule alignment by 10–15%
  • Identified systematic gaps between planned and actual progress, contributing to improved workflow planning and reduced last-minute bottlenecks.
  • Produced concise, stakeholder-ready reports highlighting completed work, upcoming risks, and optimization opportunities, improving execution accuracy and cross-team communication.
  • Strengthened analytical, reporting, and visualization skills by applying practical data techniques directly aligned with Data Analyst responsibilities.

Education

Bachelor of Computer Engineering

KFUEIT – University of Engineering and Technology, RYK | 2019–2023

Developed expertise in analytical thinking, problem-solving methodologies, and engineering systems, preparing for data-driven roles in technology and business.

Let's Connect

Professional Email

husnainzahoor313@gmail.com

Available for data analysis opportunities

Direct Contact

+966 58 050 1693

Available for calls & WhatsApp

Current Location

Riyadh, Saudi Arabia

Open to opportunities in KSA & remote