Ayan Tabassum

Ayan Tabassum

About

Detail

Lead Analytics & Growth Strategist | SQL & BI Expert | Non-Profit Co-Founder
Islamabad, Pakistan

Timeline


work
Job
school
Education
folder
Project

Résumé


Jobs verified_user 0% verified
  • D
    Lead Analytics & Growth Strategist
    DealCart
    Jul 2024 - Current (2 years)
    • Led 10+ cross-functional analytics projects and 200+ ad-hoc requests, using PostgreSQL in Metabase and Python to extract data, generate actionable insights, and drive data-informed decisions across departments. • Increased app feature adoption rates by 30% through data analysis and optimization recommendations, leading to significant user engagement growth. • Utilized MoEngage and Google Analytics 4 to monitor user behavior, identify trends, create custom segments, and execute growth campaigns, employing A/B testing to boost active users by 8% and influence customer behavior. • Developed and automated 30+ real-time dashboards in Google Sheets using Google App Script (JavaScript), streamlining performance reporting and data visualization.
  • S
    Business Intelligence Analyst
    Sage Freight
    Sep 2023 - Jul 2024 (11 months)
    • Executed multiple analytics-oriented projects, achieving an overall 3% reduction in business costs. • Developed over 30 dynamic dashboards using Power BI, Tableau, and SQL, reducing manual reporting labor by 70% and enhancing data accessibility across all departments. • Analyzed and optimized queries’ performance, reducing query execution time by 30% and improving overall system efficiency.
  • JUGNU
    Operations & Strategy Analyst
    JUGNU
    Jul 2022 - Sep 2023 (1 year 3 months)
    • Created over 20 custom reports and visualizations using Tableau and SQL. • Leveraged Fulfillment and Logistics analytics to deliver actionable insights, driving a 17% reduction in Delivery Lead Time, a 15% decrease in Shrinkage, and an average 10+% improvement in Service Level KPIs. • Orchestrated, designed, tracked, and managed pilot projects targeting cost reduction in Logistics-centered operations.
  • Lahore University of Management Sciences
    Teaching Assistant
    Lahore University of Management Sciences
    Sep 2021 - Dec 2021 (4 months)
    • Assisted the instructor in tutoring a group of 90 students for the course CS100: Computational Problem Solving.
  • S
    Co-Founder & Growth Specialist
    SATOON
    Sep 2021 - Jul 2022 (11 months)
    • Designed and executed strategies aligning organizational goals with the company mission; evaluated plans, identified strategic weaknesses, and provided enhancement recommendations. • Surpassed quarterly donation targets by 26% through strategic initiatives, enabling acquisition of IT, educational resources, food, clothing, and support for over 80 orphans
  • NETSOL Technologies Inc
    Data Analyst Intern
    NETSOL Technologies Inc
    Jul 2021 - Aug 2021 (2 months)
    • Analyzed extensive datasets, extracting valuable insights to inform decision-making and process optimization with senior members. • Engaged with mentors to refine analytical methodologies, refining skills in feature selection, model evaluation, and performance optimization.
  • ICI Pakistan Limited
    Data Analytics Intern
    ICI Pakistan Limited
    Jun 2021 - Jul 2021 (2 months)
    • Spearheaded the creation of an advanced predictive model focused on customers’ debt collection behavior, achieving an accuracy rate of 96% through careful feature engineering and model selection. • Translated analytics into actionable debt collection insights, enhancing financial efficiency through cross-functional teamwork.
  • G
    Analytics Intern
    GharPar Technologies Private Limited
    Dec 2020 - Jan 2021 (2 months)
    • Analyzed automated and manually acquired data sets to analyze consumer behavior and create learnings to gain consumer insight and create customer segments.
Education verified_user 0% verified
  • Lahore University of Management Sciences
    Bachelor of Science - BS, Computer Science
    Lahore University of Management Sciences
    Jan 2018 - Jan 2022 (4 years 1 month)
  • AITCHISON COLLEGE
    High School Diploma
    AITCHISON COLLEGE
    Jan 2006 - Jan 2018 (12 years 1 month)
Projects (professional or personal) verified_user 0% verified
  • C
    CandyScape Analytics Platform
    Jan 2021 - May 2021 (5 months)
    • Developed an end-to-end platform with integrated user and admin portals, enabling real-time tracking of inventory and customer orders through data pipelines. • Built automated reporting systems to deliver insights on sales trends, customer behavior, and inventory forecasting, supporting data-driven decision-making. • Ensured the platform’s scalability and reliability, balancing front-end user experience with back-end analytics processing for seamless operations