Ayaan Haleem

Ayaan Haleem

Internship

Followers of Ayaan Haleem2000 followers
location of Ayaan HaleemGermany

Connect with Ayaan Haleem to Send Message

Connect

Connect with Ayaan Haleem to Send Message

Connect
  • Timeline

  • About me

    Consultant Data Analyst @ e& UAE | Driving Business Insights| Reduced Reporting Time by 30% | Building Scalable Dashboards | SQL • Power BI • Excel • Python

  • Education

    • Punjab College of Information Technology

      2009 - 2011
      College ICS A

      Activities and Societies: Debates Speaches Dramas ICS

    • New Siddeeq Public School

      2007 - 2009
      High School Metric B

      Activities and Societies: Speach's Dramas Metric

    • COMSATS Institute of Information and Technology

      2012 - 2016
      Bachelor’s Degree Computer Science B

      Activities and Societies: Chess , Seminars , Events BS(Computer Science)

  • Experience

    • Zong CMPak Ltd

      Apr 2016 - May 2016
      Internship

      I was responsible for following task1-Preparation of Weekly Industrial updates,.2-Preparation of Weekly Mega project updates by coordinating with North,South and Central regions.3-Preparation of Postpaid ESS-Revenue Reports4-Product and Region wise revenue monitoring5-Development of new dashboards in QlikView.6-Adhoc data requirement and analysis.7-Daily tasks assigned by the team.

    • GrayStork

      Jan 2017 - Oct 2017
      Developer
    • Telenor

      Oct 2017 - Dec 2022

      While being in Telenor's Analytics and Performance Management unit, primary focus was to gauge the performance of the respective regional teams in achieving the goals/Targets by conducting the Daily/Weekly/Monthly situation rooms. Also was responsible for finding the opportunities for business improvements and recommend based on analysis.• Examining the growth of business KPI’s FCA/Churn/Rejoiner’s, Revenue, Recharge etc• Covid19 impact analysis on business KPI’s e.g. Pre Covid19 vs Post Covid19• Product impact analysis in order to have a clear & concrete picture of campaign.• Finding the market share of OMO with our data set.• Identifying the gaps and finding opportunities for business.• Exploring other business KPI’s with strong understanding of data mining using SQL/Self Service tools , Data warehousing and visualization in Qlik or Excel.• Delivering presentation of analysis with findings and recommendations at multiple platforms. Show less Responsible for generating insights for Business • Analyzing the data and creating interactive dashboards for the end user. • Developing automated reports using the tools like Business Object & Qlik sense. • Data scrutiny using the SQL to generate the insights as per business need. • Also was responsible for generating actionable insights and finding opportunities for business.• Daily/Weekly/Monthly Nationwide Performance Reports Management to higher management by conducting the Battle Rooms/Situation rooms. Show less Being a Data Analyst I am responsible for the following tasks.• Responsible for gathering the business requirements from external stakeholders.• Timely deliver the Adhoc Reports with 100% efficiency.• Addressing the business questions raised by various business units by sound and thorough analysis and recommendations • Developing BTEQ/TPT for automation of BI Scheduled Jobs using Shell Scripting.• Developing Reports using the tools like Business Object.• Data scrutiny using the SQL to generate the insights as per business need. Show less

      • Assistant Manager Data Analytics

        Dec 2020 - Dec 2022
      • Sr Executive Data Analytics

        Sept 2019 - Dec 2020
      • Executive Data Analytics

        Oct 2017 - Sept 2019
    • Etisalat UAE

      Dec 2022 - now
      Consultant Data Analyst

      • Delivered weekly data-driven insights to C-level executives, supporting strategic decision-making.• Collaborated with teams to define analytical needs and translate data into actionable recommendations.• Led product postmortems, driving continuous improvements in development and performance.• Analyzed CVM campaigns to measure customer engagement and ROI.• Conducted EDA to identify trends, anomalies, and growth opportunities.• Built interactive dashboards (Power BI, Excel) to track KPIs and business performance in real time. Show less

  • Licenses & Certifications

  • Honors & Awards

    • Awarded to Ayaan Haleem
      Employee of the Quarter Telenor Pakistan Jan 2021 Employee of the Quarter 2021
    • Awarded to Ayaan Haleem
      Go Getters Telenor Pakistan Dec 2020 Performer of the Month Dec'2020.
    • Awarded to Ayaan Haleem
      High Flyer Award Telenor Pakistan Jul 2020 Honored with Performer of the Month Award (High Flyer)
  • Volunteer Experience

    • Member

      Issued by Environmental Conservation Himalayan Outreach on Feb 2005
      Environmental Conservation Himalayan OutreachAssociated with Ayaan Haleem