Mahi Gupta

About Mahi Gupta

I am an MCA postgraduate with a strong foundation in data analysis, statistics, and business problem solving.I specialize in transforming raw, unstructured data into clean, structured, and analysis-ready datasets. My recent work includes performing data wrangling on large e-commerce datasets (99K+ records), conducting data quality assessments, feature engineering, and building revenue and delivery performance metrics using Python and Pandas.My core skills include:• Python (Pandas, NumPy)• SQL• Excel (Advanced)• Power BI• Data Cleaning & Transformation• Data VisualizationI am actively seeking opportunities in Data Analytics, Business Analytics, and Reporting roles where I can apply analytical thinking to solve real business problems.Portfolio: analyticsbymahi.inGitHub: https://github.com/MAHIGUPTA45

Experience

1. Data Analyst

   Apexplanet Software Pvt Ltd

   Feb 2026 — Present

   Data Analytics Intern• Performed data immersion and profiling on a 99K+ record e-commerce dataset• Conducted data quality assessment (missing values, duplicates, inconsistencies)• Standardized datetime fields for time-based analysis• Engineered new features including purchase year/month, delivery duration, and delay metrics• Merged multiple datasets to create a unified master dataset• Built revenue metrics (price + freight value)• Delivered an analysis-ready dataset with proper documentationTools Used: Python, Pandas, SQL, Excel, Jupyter Notebook

Education

• PSIT Kanpur (Pranveer Singh Institute of Technology)

  Master of Computer Applications - MCA, Computer Science

• Amity University Lucknow Campus

  Bachelor of Science - BS, Mathematics