Mohd Affan Zaheer

Business Development Executive

Lucknow, Uttar Pradesh, India3 yrs 7 mos experience
Most Likely To SwitchHighly Stable

Key Highlights

  • Expert in transforming complex data into actionable insights.
  • Proficient in developing interactive dashboards using Power BI.
  • Strong background in data storytelling and stakeholder reporting.
Stackforce AI infers this person is a Data Analyst specializing in E-commerce analytics and business intelligence.

Contact

Skills

Core Skills

Data AnalysisBusiness AnalyticsPricing StrategyData Management

Other Skills

Business CommunicationsCommunicationExcelGoogle SheetsMarket ResearchMicrosoft OfficeMicrosoft PowerPointPivot TablesPower BIPricing AnalysisProgrammingPublic SpeakingR (Programming Language)Reporting & AnalysisSQL

About

I’m a detail-oriented Data and Business Analyst with proven expertise in Power BI, SQL, Excel, and Python to turn complex datasets into clear, actionable insights. I specialize in developing interactive dashboards, cleaning and transforming data, and building visual reports that support strategic decision-making. With hands-on experience in KPI tracking, process optimization, and stakeholder reporting, I bridge the gap between technical data and business goals. My strengths lie in data storytelling, automation, and delivering value-driven solutions that empower cross-functional teams. I'm currently seeking full-time opportunities where I can leverage my Power BI skills and analytical mindset to drive business performance and contribute to impactful data initiatives. Let’s connect and explore how I can support your team! Below are my contact details: Email: affanzaheer5@gmail.com

Experience

Swiggy

2 roles

Business Analyst - Power BI and Excel

Promoted

Apr 2023Present · 2 yrs 11 mos · Lucknow, Uttar Pradesh, India · Remote

  • Utilized Power BI and Excel to conduct in-depth market research, analyzing trends, competitor pricing, and customer behavior to support strategic pricing decisions.
  • Interpreted large datasets to uncover market opportunities and risks, delivering actionable insights that directly influenced pricing strategies.
  • Continuously monitored market conditions and updated dashboards to ensure pricing remained competitive and aligned with real-time trends.
  • Performed detailed pricing analysis using Excel, SQL, and forecasting tools to evaluate the effectiveness of current pricing models.
  • Collaborated with cross-functional teams to gather and analyze pricing-related data, ensuring a comprehensive approach to decision-making.
  • Delivered clear, data-driven pricing recommendations to senior leadership through interactive Power BI reports and Excel-based presentations.
  • Maintained and validated pricing models regularly, enhancing accuracy and operational efficiency.
  • Integrated market intelligence into pricing frameworks to strengthen the predictive capabilities of models.
  • Partnered with finance and IT to align pricing systems with organizational standards and ensure data integrity.
  • Trained team members in leveraging Excel-based pricing tools and interpreting Power BI dashboards for everyday decision-making.
  • Developed and automated monthly and annual performance reports in Power BI, SQL, and Excel, highlighting key campaign metrics.
  • Conducted pivot-based analysis in Excel to track growth patterns, identify anomalies, and uncover actionable trends.
  • Analyzed profit and loss data post-campaign and proposed strategies to mitigate risks and improve ROI.
  • Delivered timely, insight-rich reporting to leadership, enabling proactive and data-informed business actions.
Power BIExcelSQLData AnalysisPricing AnalysisBusiness Analytics

MIS Data Analyst

Jul 2022Mar 2023 · 8 mos · Lucknow, Uttar Pradesh, India · Remote

  • Managed the catalog and taxonomy for Swiggy’s Instamart across 28 cities, ensuring consistency and accuracy across all storefronts.
  • Created and maintained top-level (L1) and subcategories (L2) to optimize product organization and navigation.
  • Defined and implemented rules for subcategory (L2) management, enhancing catalog structure and discoverability.
  • Oversaw product visibility strategies to improve user experience and conversion.
  • Performed SKU tagging using both automated tools and manual Excel-based workflows to ensure accurate classification.
  • Maintained and updated category data based on regular inputs from category managers using structured Excel templates.
  • Took full ownership of taxonomy, including day-to-day storefront changes and hierarchy adjustments.
  • Managed image and banner tagging, ensuring alignment with seasonal campaigns and promotional strategies.
  • Controlled subcategory ranking and reordering using data insights from Excel and Power BI dashboards.
  • Handled bulk SKU activation/deactivation through internal systems and Excel-based trackers.
  • Analyzed category performance and generated detailed reports in Power BI and Excel for actionable business decisions.
  • Updated product pricing in alignment with promotional strategies and market trends.
  • Enriched product content (long/short descriptions, quantity, product name/type, cart limits) to drive engagement and clarity.
  • Conducted regular product quality audits and ensured data accuracy across the catalog.
  • Participated in daily syncs with category managers to align on priorities, troubleshoot issues, and implement improvements in real time.
  • Led SKU backfilling efforts to maintain an up-to-date and comprehensive online catalog.
ExcelPower BIData AnalysisMarket ResearchData ManagementBusiness Analytics

Ardem data services

Data Specialist

Jul 2020Oct 2020 · 3 mos · Lucknow, Uttar Pradesh, India

Etl

Web Designer

Jun 2019Jun 2019 · 0 mo · Lucknow, Uttar Pradesh, India

Education

Simplilearn Alumni

Data Analytics — Data Processing

Aug 2021Jul 2022

BHALCHANDRA Group of Institutions

PGDM

Jan 2019Jan 2021

University of Lucknow

BCA — Computer Programming

Jan 2016Jan 2019

Stackforce found 100+ more professionals with Data Analysis & Business Analytics

Explore similar profiles based on matching skills and experience