Mehak Pandey

About

Analytical and detail-oriented BCA student with hands-on experience in root cause analysis, process review, and data-driven problem solving across business, marketing, and finance contexts. Experienced in SQL, Python, Excel, Power BI, and Tableau, with strong cross-functional collaboration and documentation skills.

Experience

• Automation Developer
  SINGEM EZee
  Mar 2026 – May 2026
• Data Analyst Intern
  Softlabs Group
  Jun 2025 – Sep 2025
• Data Analyst Intern
  Kliqspace Marketing
  Apr 2025 – May 2025
• Business Analyst
  Merisha Films
  Nov 2024 – Dec 2024
• Project Manager & Research Intern
  Auor
  Nov 2024 – Mar 2025

Education

• Bachelor of Computer Applications (BCA)
  K.P.B. Hinduja College
  Computer Applications · 2023 – 2026

Skills

• SQL
• Python
• Power BI
• Tableau
• Pandas
• DAX
• Jira
• Root Cause Analysis
• Data validation
• Trend analysis
• Excel
• KPI Tracking
• Benchmarking
• Gap Analysis
• Process Review
• Impact Assessment
• Corrective Action
• Ms Office
• Preventive Action

Projects

• ShopIndia – E-Commerce Performance Analysis
  SQL, Python, Tableau

  Analysed recurring discount and margin issues across channels through cohort and RFM analysis and recommended a data-backed corrective reallocation.

• RetailMart – Process Gap Analysis & BI
  SQL, Python, ETL, Tableau

  Identified process and data gaps across CRM, POS, and ERP systems and implemented corrective ETL and data quality controls to eliminate recurring inconsistencies.

• IndiaFirst Bank – Customer Analytics & RCA Framework
  SQL, Python, Power BI, Excel

  Conducted root cause analysis on customer transaction and churn data across multiple banking tables and delivered an executive dashboard with preventive recommendations.

Courses & certifications

• Tata GenAI Powered Data Analytics · Tata · 2025
• Google 5-Day AI Agents Intensive · Google · 2025
• Oracle Data Platform 2025 Foundations Associate · Oracle · 2025
• Oracle Cloud Infrastructure 2025 Generative AI Professional · Oracle · 2025
• Prompt Engineering for GenAI