Hello, I'm

Mr. Zain Ul Abidin

Junior Data Analyst & Business Intelligence Professional

Google Certified AWS Data Analytics
Available for opportunities

Zain Ul Abidin

Data Analyst • Business Intelligence

SQL & Python Power BI AWS Analytics

About Me

Professional Summary

Data-driven analytics professional with hands-on experience in ETL processes, data visualization, and business intelligence. Proficient in SQL, Python, R, Power BI, Tableau, and Excel with proven ability to transform raw data into actionable insights.

Experienced in e-commerce analytics, digital marketing performance tracking, and data-driven decision making. Strong foundation in statistical analysis and cloud technologies (AWS).

10+

Projects Completed

10+

Certifications

8+

Technologies

Technical Skills

Data Analysis

  • SQL
  • Python
  • R Programming
  • Excel (Advanced)

Visualization

  • Microsoft Power BI
  • Tableau
  • Minitab
  • Data Storytelling

Cloud & Tools

  • AWS Technical Essentials
  • ETL (Extract, Transform, Load)
  • Data Pipelines
  • Git & Version Control

Analytics

  • Data Cleaning
  • Data Modeling
  • Statistical Analysis
  • Business Intelligence

Licenses & Certifications

Education

  • Bachelor of Science • Data Analytics

Google Data Analytics Professional Certificate

  • Ask Questions to Make Data-Driven Decisions
  • Foundations: Data, Data, Everywhere
  • Process Data from Dirty to Clean
  • Prepare Data for Exploration

Cloud & Technical Certificates

  • AWS Technical Essentials Certification
  • Minitab Statistical Software Certification
  • Python (Basics) — HackerRank
  • Generative AI — Google

Global Learning Programs

  • SBCC E-Modules Course: Social and Behavior Change Communication — UNFPA
  • Climate Champion e-course — UN CC:Learn

Featured Projects

Uber Analytics Dashboard

Developed a comprehensive Power BI dashboard to visualize key performance indicators including ride volume, revenue trends, driver performance, and customer satisfaction metrics.

Power BI DAX SQL

Sales Analysis Dashboard

Created a dynamic Tableau dashboard tracking market trends, regional performance, and sales forecasts. Implemented data blending from multiple sources for comprehensive insights.

Tableau Data Blending Python

Customer Segmentation Analysis

Performed RFM analysis and clustering to identify customer segments. Built predictive models to forecast customer lifetime value and churn probability.

Python Machine Learning Pandas

Marketing Campaign ROI Tracker

Automated ETL pipeline for marketing data analysis. Created interactive reports showing campaign performance, cost per acquisition, and conversion metrics.

Excel Power Query VBA

Work Experience

Oct 2025 - Present

E-commerce Data Analyst (Intern)

Daraz E-commerce

  • Manage product data pipelines for 500+ SKUs using Excel automation and Python scripts
  • Optimize ROI for Google and Facebook Ads through data-driven recommendations, improving campaign performance by 25%
  • Build interactive Power BI dashboards tracking conversion rates, customer acquisition, and sales trends
  • Conduct A/B testing analysis to improve website conversion rates and user engagement
Duration: TBD

Social Media Marketing Intern

International MUN

  • Managed and optimized brand presence across Instagram, TikTok, and LinkedIn with a strong focus on community engagement and data-driven content creation
  • Developed and scheduled weekly content calendars using Canva and Adobe Express, expanding monthly audience reach
  • Monitored social channels and engaged with followers in real time to maintain brand voice and strengthen loyalty
  • Tracked engagement rate, click-through rate, and follower growth through Meta Business Suite and Google Analytics to guide campaign improvements
  • Applied trend forecasting and moment marketing tactics to improve TikTok/Reels view performance
  • Collaborated with design and copywriting teams to align creative assets with campaign goals and brand guidelines
Duration: TBD

Data Analyst

CodeAlpha

  • Engaged in a structured data analytics program focused on data-driven business intelligence and applied Python-based tools to solve real analytical problems
  • Engineered web scraping pipelines with BeautifulSoup and Python to collect and structure analysis-ready custom datasets from public sources
  • Performed end-to-end exploratory data analysis, including data cleaning, hypothesis testing, and anomaly detection for actionable insights
  • Built visual narratives with Matplotlib and Seaborn to convert complex findings into decision-ready dashboards
  • Conducted sentiment analysis using NLP and lexicon-based techniques on customer and social media text to identify sentiment patterns
  • Published all projects on GitHub with LinkedIn video walkthroughs documenting each delivery

Get In Touch

Let's Connect

I'm always open to discussing new opportunities, collaborations, or just having a chat about data analytics!

Multan, Pakistan
xainyblblack@gmail.com
Available on request