About Sonu Prajapati

I'm Sonu Prajapati, also known as Sonu Darv, an Indian Data Analyst with 4+ years of experience in MIS and data analytics at Flipkart, HOD and Sereko. I turn raw data into dashboards, reports and analyses that teams can act on, and I am open to relocating abroad or anywhere for the right role. Please note that "sonudarv" (Sonu Darv) is the username I use across my online profiles.

  • DashboardingI build Power BI and Looker Studio dashboards that track sales, operations and marketing KPIs.
  • MIS reportingI prepare daily to monthly MIS reports in Excel, Google Sheets and SQL, and automate them to save hours every week.
  • Business AnalysisI analyse SKU, pricing, returns and performance data to explain what changed and what to do next.
Data AnalystProfession
4+ YearsProfessional experience
3Roles held
Sereko, HOD, FlipkartPrevious employers

Location - Delhi, India Email - contact@sonudarv.com LinkedIn - linkedin.com/in/sonudarv GitHub - github.com/sonudarv Portfolio - sonudarv.com/projects Reports - sonudarv.com/reports

Sonu Prajapati, Data Analyst in Delhi

Professional Summary

I am the founder of Vriyox, an eCommerce service agency covering web builds, growth strategy, and data-driven decision making for D2C brands. Data analysis is my core skill - it shapes every storefront, campaign, and dashboard we ship.

Before Vriyox I spent my career on the analytics side of large eCommerce operations: building MIS reports and dashboards, tracking marketplace KPIs, reconciling orders and settlements, and turning the numbers into recommendations for operations and management. That data-first habit is what I now bring to every storefront, campaign and report Vriyox delivers.

Professional Experience

Data Analyst · Sereko

Mar 2026 - Sep 2026 · 7 mos

Analysing sales, ad spend, and inventory data across marketplaces and the D2C store, and turning it into dashboards and MIS reports that guide management decisions.

Sr. MIS Executive - Sales · HOD

Feb 2024 - Nov 2025 · 1 yr 10 mos

Built and automated MIS reporting for House of Diagnostics, a multi-centre pathology and radiology chain: test volumes, revenue, report turnaround time and collections, and led junior executives to deliver decision-ready insights to management.

  • Prepare and automate daily, weekly, and monthly MIS reports on test volumes, revenue, and centre performance
  • Build dashboards to track diagnostics KPIs: patient footfall, tests per patient, report turnaround time (TAT), and revenue per centre
  • Analyse test-wise and department-wise volumes across pathology and radiology to flag growth areas and gaps
  • Monitor sample collection, home collection, and report delivery timelines and highlight delays to operations teams
  • Reconcile billing, payments, and collections data, including corporate accounts, to catch mismatches and revenue leakage
  • Use advanced Excel (pivot tables, Power Query, lookups) and SQL to extract and model large datasets
  • Build automated reports with macros and scripts, cutting manual reporting time significantly
  • Run variance and trend analysis against targets and explain the drivers behind every gap
  • Track centre and referral partner performance and flag underperformers with supporting data
  • Validate data accuracy through regular audits and quality checks before reports reach management
  • Present insights and recommendations to management in clear, decision-ready summaries
  • Lead and train junior MIS executives on reporting standards, data checks, and dashboard building

MIS Executive - Operations · Flipkart

Jul 2022 - Jan 2024 · 1 yr 7 mos

Prepared daily and weekly MIS reports and dashboards on orders, returns, and process KPIs, using Excel to keep operations data accurate and actionable.

  • Prepared daily and weekly MIS reports on orders, dispatches, returns, and customer contact volumes
  • Compiled and cleaned data from multiple sources using Excel (pivot tables, VLOOKUP, formulas)
  • Tracked team and process KPIs such as AHT, FCR, CSAT, and quality scores in daily dashboards
  • Analysed trends and shared variance reports on productivity, attendance, and service-level targets
  • Ensured data accuracy through regular audits and timely reporting to operations and management
  • Supported process improvements by flagging repeat issues and top contact reasons from the data
  • Built and updated Excel dashboards with charts and conditional formatting for leadership reviews
  • Analysed order, dispatch, and return data to find delays and bottlenecks in the fulfilment flow
  • Segmented customer contact data by reason, product, and region to guide training and process fixes
  • Forecasted daily contact volumes from historical trends to help plan staffing and shifts
  • Automated repetitive reports with macros and formulas to reduce turnaround time and errors
  • Presented weekly performance insights to managers and tracked follow-up actions to closure
Let's work together

Have a project in mind? I'd love to hear about it. Let's create something exceptional together.