Summary
Overview
Work History
Education
Skills
Websites
Certification
Languages
Social links
Languages
Timeline
Generic

PAWAN MISHRA

Mumbai

Summary

Results-driven MIS Analyst with hands-on expertise in advanced Excel, SQL, VBA, and data visualization. Proven success in automating MIS reports and dashboards to enhance KPI tracking and performance monitoring. Demonstrated leadership in team-based environments, optimizing data pipelines, and supporting strategic email marketing initiatives. Skilled in delivering accurate, high-quality reports to drive data-backed business decisions.

Overview

12
12
years of professional experience
1
1
Certification

Work History

MIS Analyst

Udaan
05.2024 - Current
  • Prepared and maintained critical reports, including Category Growth Sheet and Operations Metrics Sheet.
  • Generated PvA reports hourly, weekly, and monthly to monitor performance against targets.
  • Managed large datasets using advanced Excel formulas and pivot tables for insights and reporting automation.
  • Developed performance dashboards for Market and Area Managers, and monitored key metrics like AOV, Saliency, and Penetration.
  • Produced Cancellation Dashboard to identify trends in cancellations.

MIS Executive and Executive Team Lead

INSPIRITAI PVT LTD
08.2021 - 05.2024
  • Collected, cleaned, and organized raw data from student enrollments, course feedback, and internal operations.
  • Designed performance dashboards and MIS reports in Excel and Google Sheets to monitor KPIs.
  • Automated reports for course progress, lead conversion, and campaign success using Excel VBA macros and Google Sheets.
  • Maintained databases for students, mentors, and projects to ensure data accuracy and accessibility.
  • Tracked email campaign performance and generated insights to enhance marketing strategies.

Team Lead - Email Marketing

Datagain Services
Mumbai
06.2020 - 08.2021
  • Collected data from LinkedIn and other platforms for cold emailing.
  • Supported the manager in developing plans for future projects, initiatives, and objectives.
  • Executed email marketing campaigns using Salesforce and GMASS.
  • Established leads through LinkedIn connections and targeted marketing efforts.
  • Generated performance reports in Google Sheets and Excel to evaluate email marketing effectiveness.
  • Utilized pivot tables and advanced Excel functions for detailed analysis of email campaigns.

Team Lead - Web Research

16 Works
06.2013 - 03.2019
  • Conducted over 100 successful web research projects for B2B data and lead generation.
  • Proficient in LinkedIn Sales Navigator, Hunter.io, GetProspect, Apollo.io, etc.
  • Skilled in building and validating targeted contact lists.
  • Experienced in identifying decision-makers by title, industry, and region.
  • Delivered high-quality, accurate data for marketing and outreach campaigns.

Education

Diploma - Computers

Jetking
Indore
07-2011

12th - Commerce

Bonanza Convent Higher Sec. School Satna
Madhya Pradesh
05-2009

Skills

  • Management information systems
  • Data visualization
  • Advanced Excel and Google Sheets
  • SQL and VBA programming
  • Data analysis and reporting
  • Dashboard creation and performance metrics
  • Database management and ETL processes
  • Email marketing strategies
  • Team leadership and collaboration

Certification

  • Data Analyst
  • Pivot Table Certification For Data Analysis
  • 30-Days Excel Crash Course

Languages

English, Hindi

Social links

https://www.linkedin.com/in/pawan-mishra-617937111/

Languages

Hindi
First Language
English
Proficient (C2)
C2

Timeline

MIS Analyst

Udaan
05.2024 - Current

MIS Executive and Executive Team Lead

INSPIRITAI PVT LTD
08.2021 - 05.2024

Team Lead - Email Marketing

Datagain Services
06.2020 - 08.2021

Team Lead - Web Research

16 Works
06.2013 - 03.2019

Diploma - Computers

Jetking

12th - Commerce

Bonanza Convent Higher Sec. School Satna

Similar Profiles

CREATE PROFILE
PAWAN MISHRA