Somya Mishra

Data-driven analytics professional

Kanpur, India 4+ yrs exp 69 · Good

About

Data-driven analytics professional with 4.6+ years of experience in Data Analytics, Business Intelligence, and Reporting Automation. Proficient in SQL, Advanced Excel, Metabase, and dashboard development to deliver actionable business insights. Experienced in KPI reporting, data visualization, process optimization, and enabling data-driven decision-making through scalable analytics solutions.

Skills & Expertise

No skills listed yet

Work Experience

Program Manager

Masters’ Union

Feb 2026 - Present

Analyzed admissions data for 500+ applicants using SQL, Excel, and Lead Matrix CRM, tracking pipeline, KPIs, and conversion metrics. Developed Admissions Analytics dashboards using SQL, Advanced Excel, Google Apps Script, and Lead Matrix CRM across 8+ admission stages. Built automated ETL pipelines and KPI reporting, reducing reporting effort by 75% and TAT from 3 hours to under 45 minutes. Performed funnel, cohort, and conversion analysis, improving funnel visibility by 30% and contributing to 20–25% of enrollments. Analyzed 15+ marketing campaigns using conversion analytics while leading admissions reporting, improving reporting TAT by 35%.

Senior Operations Associate

Interview Kickstart

Feb 2024 - Feb 2026

Analyzed operational data for 10+ technical programs and 1,000+ learners using SQL, Advanced Excel, and Metabase to optimize resource allocation and scheduling. Developed a centralized Business Intelligence platform using SQL, Metabase, Advanced Excel, Google Apps Script, and Zapier, automating analytics across 6+ operational workflows. Built automated ETL pipelines processing 5,000+ records weekly, reducing reporting effort by 80% while enabling real-time KPI monitoring. Automated DSAT reporting, ticket analytics, and workflow notifications, reducing escalations by 30% through root cause analysis. Designed analytics dashboards for the Mentor Community, supporting growth from 75 to 380+ mentors through utilization and engagement analytics. Built payroll and KPI tracking dashboards for 150+ instructors, ensuring 100% data accuracy while streamlining executive reporting. Optimized operational workflows using data analysis, reducing TAT from 25:35 to 20:50, improving operational efficiency by 44%, and leading a 6-member team to improve delivery KPIs by 15%.

Operations Associate

Acciojob

Jul 2022 - Dec 2023

Analyzed performance data for 200+ learners, tracking engagement, completion rates, placement readiness, and program performance to support data-driven business decisions. Built automated dashboards and reporting trackers using Advanced Excel and ETL queries, saving 4+ hours/week by streamlining recurring business and KPI reporting. Analyzed recruitment pipelines and placement metrics for 50+ hiring partners, improving placement conversion by 11% through performance analysis and stakeholder collaboration. Designed performance dashboards for community initiatives, increasing learner engagement by 6.7%.

Operations Intern

Leap Scholar (Leap Finance)

Mar 2022 - Jul 2022

Managed UK study-abroad application data using Advanced Excel, Google Sheets, Zoho, and Metabase, ensuring 100% data accuracy through data validation and reconciliation. Built operational reports and KPI dashboards, improving reporting efficiency and supporting data-driven decision-making.