Looking for a job

Somya Mishra

@somyamishra2

Analytics professional at Masters’ Union who automated admissions KPI reporting, cutting reporting time from 3 hours to under 45 minutes.

India

Message

At Masters’ Union, I analyze admissions data and developed dashboards across 8+ admission stages. I built automated ETL pipelines and KPI reporting that reduced reporting effort by 75% and cut turnaround time from 3 hours to under 45 minutes.

At Interview Kickstart, I developed a centralized Business Intelligence platform that automated analytics across 6+ operational workflows. I also built ETL pipelines processing 5,000+ records weekly, reducing reporting effort by 80% and enabling real-time KPI monitoring.

My work at Interview Kickstart included automating DSAT reporting and ticket analytics, and designing dashboards to track mentor utilization and engagement. Those analytics supported growth of the Mentor Community from 75 to 380+ mentors.

Earlier, at Acciojob, I built automated dashboards and reporting trackers that saved 4+ hours a week. I started in operations at Leap Scholar (Leap Finance), managing study-abroad application data and building operational reports and KPI dashboards.

Experience

Work history, roles, and key accomplishments

Current

Program Manager

Current

Masters' Union

Feb 2026 - Present (8 months)

Analyzed admissions data for 500+ applicants using SQL, Excel, and Lead Matrix CRM, tracking pipeline, KPIs, and conversion metrics. Developed Admissions Analytics dashboards and automated ETL pipelines, reducing reporting effort by 75% and TAT from 3 hours to under 45 minutes.

SQL Excel Google Apps Script Matrix CRM ETL Pipelines KPI Reporting Funnel Analysis Cohort Analysis Conversion analysis

Senior Operations Associate

Interview Kickstart

Feb 2024 - Feb 2026 (2 years)

Analyzed operational data for 10+ technical programs and 1,000+ learners using SQL, Advanced Excel, and Metabase to optimize resource allocation and scheduling. Built a centralized BI platform and automated ETL pipelines, reducing reporting effort by 80% and enabling real-time KPI monitoring.

SQL Excel Metabase Google Apps Script Zapier ETL Pipelines KPI Reporting Dashboard Development Root Cause Analysis Process Optimization

Operations Associate

Acciojob

Jul 2022 - Dec 2023 (1 year 5 months)

Analyzed performance data for 200+ learners, tracking engagement, completion rates, and placement readiness. Built automated dashboards and reporting trackers using Advanced Excel and ETL queries, saving 4+ hours/week and improving placement conversion by 11%.

SQL Excel ETL KPI Reporting Dashboard Development Data Analysis Stakeholder Collaboration

Operations Intern

Leap Scholar (Leap Finance)

Mar 2022 - Jul 2022 (4 months)

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.

Excel Google Sheets Zoho Metabase Data Validation KPI Reporting Dashboard Development