Ubaid Zia

Ubaid zia

bookmark on deepenrich
location of Ubaid ZiaIslāmābād, Pakistan
Phone number of Ubaid Zia+91 xxxx xxxxx
Followers of Ubaid Zia1000 followers
  • Timeline

    Sept 2023 - May 2024

    Reporting and Analytics Engineer

    Ecopack Limited – PET Bottles Manufacturing
    Current Company
    Jun 2024 - now

    Data Analyst

    TheViewLytics
  • About me

    Data Analyst | Excel | Power BI | SQL

  • Education

    • Dice camp

      2024 - 2024
      Data analysis using advance excel and sql (2024) data analyst a
    • Dicecamp

      2024 - 2024
      Microsoft power bi (2024) data analyst a
    • Nebosh

      2016 - 2016
      Level 3 safety course occupational safety and health a

      I am NEBOSH Certified

    • Comsats abbottabad

      2008 - 2012
      Bachelor's degree electrical and electronics engineering c
    • Army pyblic school & college attock cantt

      2005 - 2007
      Fcs (computer science) science b
    • Army pyblic school & college attock cantt

      2003 - 2005
      Matric science a
  • Experience

    • Ecopack limited – pet bottles manufacturing

      Sept 2023 - May 2024
      Reporting and analytics engineer

      • 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. Show less

    • Theviewlytics

      Jun 2024 - now
      Data analyst

      • 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.• Automated data extraction, data cleaning, and data aggregation workflows using SQL, saving 5+ hours per week and reducing data processing errors through process optimization.• 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.• Continuously enhanced technical skills in Power BI, SQL, and Excel through hands-on project work and self-directed learning, focusing on reporting automation, advanced data analysis, and data visualization techniques. Show less

  • Licenses & Certifications