Open to opportunities

prakhar srivastav

@prakharsrivastav1

Message

Data Analyst focused on MIS reporting and dashboards, automating workflows to deliver KPI-driven insights.

India

Message

What I'm looking for

I’m looking for a role where I can build dashboards and automate MIS/reporting workflows, turning SQL, Python, and BI tools into reliable KPI-driven insights. I want to partner with business and product teams to improve performance through data-driven decisions and continuous process improvement.

I’m a Data Analyst skilled in MIS reporting, business reporting, dashboard development, KPI monitoring, and business analytics. I focus on turning messy operational data into actionable insights that support sales, marketing, and product decisions.

In my recent role, I built a lead funnel tracking system to monitor conversions, call performance, lead stages, and agent productivity. I also reduced daily reporting effort by 80–90% by automating CRM, Razorpay, and ERP reconciliation through APIs and Google Sheets.

I’ve strengthened data quality by automating the cleaning of 1.77 lakh+ CRM records using Python, improving consistency for downstream reporting. I’ve also optimized analytical query pipelines in BigQuery/Redash (reducing query runtime by 20%) and supported product strategy by analyzing usage and user journey data, boosting feature adoption by 12%.

Experience

Work history, roles, and key accomplishments

Data Analyst

21K School

Sep 2025 - Jun 2026 (9 months)

Built a lead funnel tracking system and dashboards to monitor conversions, operational KPIs, and funnel bottlenecks for Sales and Marketing. Automated CRM/Razorpay/ERP reconciliation and created Python-based data cleaning workflows to improve reporting accuracy and data quality.

Business Reporting Dashboard Development KPI Reporting SQL Advanced Excel Python Google Sheets APIs Data Cleaning Data Validation Google Ads Meta Ads

Product Analyst Intern

Lokal — Behtar Technology

Jan 2025 - Mar 2025 (2 months)

Optimized analytical query pipelines using SQL to improve BigQuery/Redash performance and enable faster product analytics. Built insight generation workflows and automated dashboards/reports using Advanced Excel and Power Query to support product strategy decisions.

SQL BigQuery Redash Metabase Product Analytics User Behavior Analysis Dashboarding Advanced Excel Power Query

Data Research Analyst Intern

Small Big Growth

Nov 2024 - Dec 2024 (1 month)

Automated Excel reporting and created data cleaning/validation workflows to improve reporting efficiency and data accuracy. Conducted company and market research using public sources and enrichment tools, and prepared insights for strategic prospecting.