Name: Ubaid Zia

Job Role: Data Analyst

Experience: 1.5 Years

Address: Islamabad, Pakistan

Skills

SQL 75%
Power BI 80%
Data Visualization 70%
Advance Excel 85%

About

About Me

Data Analyst with hands-on experience in data cleaning, data extraction, reporting automation, and interactive dashboard development using Excel, Power BI, and SQL. Skilled in data analysis, performance tracking, trend identification, and data visualization to support data-driven decision-making. Experienced in creating automated reports and providing actionable insights to improve operational efficiency and business outcomes.

  • Profile: Data Analytics
  • Education: Bachelor of Engineering
  • Language: English, Urdu
  • BI Tools: Microsoft Power BI
  • Interest: Traveling, Travel Photography

0 +   Projects completed

LinkedIn

Resume

Resume

Data Analyst with hands-on experience in data cleaning, data extraction, reporting automation, and interactive dashboard development using Excel, Power BI, and SQL. Skilled in data analysis, performance tracking, trend identification, and data visualization to support data-driven decision-making. Experienced in creating automated reports and providing actionable insights to improve operational efficiency and business outcomes.

Experience


June 2024 – Present

Data Analyst

The Viewlytics
  • Streamlined monthly viewership reporting processes across 10+ news channels by developing automated Power BI dashboards, reducing manual reporting time by 30% and enabling real-time data visualization for key stakeholders.
  • Developed and maintained interactive Power BI dashboards for Facebook, Instagram, and YouTube, tracking daily watch time, audience growth, and engagement metrics to support performance analysis and trend identification.
  • Optimized SQL queries to enhance database performance and improved dashboard load times by 50%, ensuring faster access to critical business insights for decision-makers.
  • Collaborated with cross-functional teams, including content, marketing, and data teams, to present data-driven insights and communicate actionable recommendations using clear visualizations and data storytelling techniques.

Sept 2023 – May 2024

Reporting and Analytics Engineer

Ecopack Limited – PET Bottles Manufacturing
  • Collected, cleaned, and organized daily machine performance data using Microsoft Excel, ensuring data accuracy, completeness, and real-time performance tracking across production lines.
  • Designed and implemented custom Excel templates and automated spreadsheets for performance reporting, reducing manual data entry time by 40% and improving reporting accuracy.
  • Developed and consolidated weekly performance summaries by merging daily shift data into comprehensive Excel reports, enhancing data visibility and enabling informed decision-making for senior management.
  • Conducted ad-hoc data analysis using Excel formulas, PivotTables, and charts to identify operational trends, detect recurring equipment failures, and support preventive maintenance planning through data-driven insights.



Education


2008-2012

Bachelor of Engineering

Comsats University Abottabad Campus
2005-2007

Higher Secondary School

Army Public School & College Attock

Projects

Projects

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

Analysis Ecommerce Sales Data Dashboard in Power BI

Created interactive dashboard to track and analyze online sales data.

HR Analytics Dashboard in Power BI

Analyzes employee attrition within an organization and to identify patterns, trends, and potential factors contributing to employee turnover.

Revenue Optimization Dashboard for Hospitality Industry

Executed comprehensive data transformation using Power Query to clean, reshape, and enrich raw hospitality data.


Danny's Dinner SQL Case Study

Analyzed Danny's Diner data using SQL to uncover insights on customer behavior, sales trends, and menu preferences.

Certifications

Certifications

Certification 1

Introduction to MS Excel

Certification 2

Introduction to SQL

Certification 3

Power BI for Beginners

Certification 4

Data Analytics Essentials Cisco

Certification 5

Data Analytics Essentials

Certification 6

Python Demonstrations for Practice Course

Certification 4

Python for Beginners

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

0332 5063036

Email Address

ubaid_zia14@yahoo.com

Download Resume

Resume link