Experience

Snoonu

• Qatar
• Technology, Information and Internet
• 300 - 400 Employee

• Jr. BI Analyst - Growth & Partnership

  • Oct 2023 - Present

  Doha, Qatar



Daraz

• Singapore
• Technology, Information and Internet
• 700 & Above Employee

• Performance Analyst - Seller Marketplace

  • Jul 2023 - Oct 2023

  Karāchi, Sindh, Pakistan - Developed SQL scripts using CTEs, Window functions, Joins, and Subqueries to conduct ad-hoc analysis and create dashboards. - Designed and developed an advanced dashboard to monitor the Key Account Manager (KAM) performance where the primary focus of this initiative revolved around critical KPIs: Quality Return Rate (QRR), Quality Issue Rate (QIR), processing time efficiency, Out-of-Stock (OOS) occurrences, successful deliveries, returned items, GMV, NMV which offers granular insights at… Show more - Developed SQL scripts using CTEs, Window functions, Joins, and Subqueries to conduct ad-hoc analysis and create dashboards. - Designed and developed an advanced dashboard to monitor the Key Account Manager (KAM) performance where the primary focus of this initiative revolved around critical KPIs: Quality Return Rate (QRR), Quality Issue Rate (QIR), processing time efficiency, Out-of-Stock (OOS) occurrences, successful deliveries, returned items, GMV, NMV which offers granular insights at various organizational levels, encompassing product, seller, SKU, L1 category, and KAM hierarchies. - Spearheaded the creation of a comprehensive dashboard to track the daily call activities of the fulfillment team which helped to gain precise insights into the volume and connectivity of calls initiated by tagged entities on a day-to-day basis. - Conducted an ad-hoc analysis of Net Promoter Score (NPS) by exploring correlations between NPS and various performance metrics, such as GMV, order quantity, seller ratings, and product ratings across different product categories. Through a meticulous examination, I analyzed a strong correlation between NPS and seller and product ratings, providing an in-depth understanding of customer sentiment. - Regularly analyzed the KPIs for Product Quality NPS, yielding actionable insights that informed strategic decisions and enhanced performance, ultimately leading to improved NPS fill rates. - Analyzed the seller performance in different promotional campaigns, including Flash Sales, Azaadi Campaign, ELP, and Free Shipping. This involved a rigorous examination of NPS levels and meticulous tracking of seller performance across various performing categories. - Assisted in developing customized criteria for each campaign, skillfully adjusting parameters related to seller ratings and product ratings to either include or permanently delist sellers, thereby optimizing the impact of these campaigns and ensuring they aligned with our strategic objectives. Show less



Byte (YC S20)

• Pakistan
• Internet Publishing
• 1 - 100 Employee

• BI Analyst

  • Nov 2022 - Mar 2023

  Lahore, Punjab, Pakistan - Optimized SQL queries using Joins, CASE statements, CTE, Window Functions, Aggregate Functions, and Wildcards to extract data from multiple tables for data analysis using MetaBase. - Conducted RFM analysis to extract and visualize customer retention and churn rates, segmenting customers into different categories according to their R, F, and M scores and developing strategies to increase their Repeat Purchase Ratio (RPR) and overall order per customer (OPC). - Developed effective… Show more - Optimized SQL queries using Joins, CASE statements, CTE, Window Functions, Aggregate Functions, and Wildcards to extract data from multiple tables for data analysis using MetaBase. - Conducted RFM analysis to extract and visualize customer retention and churn rates, segmenting customers into different categories according to their R, F, and M scores and developing strategies to increase their Repeat Purchase Ratio (RPR) and overall order per customer (OPC). - Developed effective business strategies to reduce customer churn rate within 2 months, which contributed to improved customer satisfaction and retention. - Performed weekly and monthly cohort analysis for key metrics including FTUs, Revenue, AOV, and OPC, providing insights into customer behavior and spending habits over time, enabling rapid adjustments to business strategies to stay competitive. - Created trend analysis on the daily and hourly order summary, completed orders, AOV, WAE, In zone and Out zone signups, and location-wise orders trend, enabling stakeholders to identify patterns and make data-driven decisions. - Employed proper data modeling techniques including the use of window functions, CTEs, and optimized queries to reduce a 23-queries dashboard to just 3 queries, improving code reusability and efficiency. - Leveraged DAX and Power Query for data transformation and manipulation, reducing processing time and enabling the faster implementation of business formulas and measures. - Utilized Power BI's data modeling capabilities to effectively resolve complex key relationships between tables, resulting in improved accuracy and efficiency in data analysis. - Played a pivotal role in Byte's migration of critical MetaBase reports to Power BI dashboards, which enabled stakeholders to access more insightful and actionable data for better decision-making. Show less



foodpanda

• Singapore
• Internet Marketplace Platforms
• 700 & Above Employee

• Data Analyst Intern - Delivery and Logistics (1st Pandaship - 2022)

  • Jun 2022 - Aug 2022

  Karāchi, Sindh, Pakistan - Developed and optimized complex SQL queries on Big Query for in-depth business analysis, which assisted in building insightful dashboards for effective decision-making. - Designed and published three significant Tableau Dashboards, including key insights, that helped stakeholders across different verticals to analyze delivery time and different level stacking issues, which improved operational efficiency. - Analyzed various Vendor, Customer, and Rider KPIs through Big Query to decrease… Show more - Developed and optimized complex SQL queries on Big Query for in-depth business analysis, which assisted in building insightful dashboards for effective decision-making. - Designed and published three significant Tableau Dashboards, including key insights, that helped stakeholders across different verticals to analyze delivery time and different level stacking issues, which improved operational efficiency. - Analyzed various Vendor, Customer, and Rider KPIs through Big Query to decrease failure rates and improve customer experience, which contributed to better customer retention and satisfaction. - Implemented an out-of-the-box solution with Pandas Library & Big Query integration in Google Colab to identify ice cream vendors by using keyword matching techniques on the 'product name' dimension, which helped to reduce the incident rate on ice cream vendors, improving operational efficiency. - Presented findings and insights to stakeholders at various levels of the organization, including senior management, which helped to drive informed decision-making and business growth. - Recognized as a finalist for one of the best ideas for Environmental Sustainability Practices in Foodpanda's business model, which showcases a commitment to innovative and sustainable practices. Show less



Institute of Business Administration

• Pakistan
• Education Administration Programs
• 700 & Above Employee

• Undergraduate Teaching Assistant - Object Oriented Programming

  • Feb 2022 - Jun 2022

  Karāchi, Sindh, Pakistan - Assisted 55+ students in Object Oriented Programming – Fall’22. - Supervising students by conducting regular tutorials resulting in enhanced student performance. - Conducting weekly quizzes and creating assignments to analyze regular progress.



Afiniti

• Bermuda
• Software Development
• 700 & Above Employee

• SQA Intern

  • Jul 2020 - Sep 2020

  - Reviewed and developed test strategies, test cases, and scripts for Afiniti's Black box framework, which contributed to the development of high-quality software products. - Conducted customer service tasks to identify and understand relevant hurdles and challenges faced by end-users, which helped to improve the quality and usability of Afiniti's software products. - Recorded software defects using a bug tracking system, which enabled the software developers to address and fix the issues… Show more - Reviewed and developed test strategies, test cases, and scripts for Afiniti's Black box framework, which contributed to the development of high-quality software products. - Conducted customer service tasks to identify and understand relevant hurdles and challenges faced by end-users, which helped to improve the quality and usability of Afiniti's software products. - Recorded software defects using a bug tracking system, which enabled the software developers to address and fix the issues efficiently. Show less



The Citizens Foundation

• Pakistan
• Non-profit Organizations
• 700 & Above Employee

• Curriculum Designer

  • Jun 2020 - Sep 2020

  Karāchi, Sindh, Pakistan - Developed and designed curriculum materials, lesson plans, and instructional resources to facilitate over 100+ students. - Collaborated with subject matter experts, instructional designers, and other stakeholders to ensure alignment with learning objectives and program goals. - Conducted assessments to analyze data to identify gaps in the current curriculum and make recommendations for improvement. - Evaluated existing curriculum and modify as needed to ensure relevance, accuracy… Show more - Developed and designed curriculum materials, lesson plans, and instructional resources to facilitate over 100+ students. - Collaborated with subject matter experts, instructional designers, and other stakeholders to ensure alignment with learning objectives and program goals. - Conducted assessments to analyze data to identify gaps in the current curriculum and make recommendations for improvement. - Evaluated existing curriculum and modify as needed to ensure relevance, accuracy, and effectiveness. - Created assessments and evaluation tools to measure learner progress and program effectiveness. - Work closely with project leads and other stakeholders to ensure the timely and effective delivery of curriculum materials. - Managed multiple projects simultaneously and prioritized tasks to meet deadlines and project goals. Show less



Foundation Fighting Poverty

• Pakistan
• Philanthropic Fundraising Services
• 1 - 100 Employee

• Social Work Intern

  • Jul 2020 - Aug 2020