Sonu Prajapati

Building Vriyox into a full eCommerce service agency covering web builds, growth strategy, and data-driven decisions for D2C brands.

• Lead Vriyox end to end: vision, strategy, service offering, and day-to-day business operations
• Build sales, traffic, and revenue dashboards for D2C clients so decisions rest on live data, not guesswork
• Set up GA4, Google Tag Manager, and conversion tracking to measure every step of the customer journey
• Track ecommerce KPIs across clients: conversion rate, AOV, CAC, ROAS, LTV, and repeat purchase rate
• Run funnel and drop-off analysis to find where visitors leave and fix checkout and landing page leaks
• Analyse ad spend and campaign performance, then reallocate budget toward the highest-return channels
• Segment customers with cohort and RFM analysis to power retention, email, and re-marketing campaigns
• Analyse SKU, category, and pricing data to flag fast movers, slow stock, and margin leaks for clients
• Run A/B tests on pages, offers, and creatives and read the results with clear, data-backed recommendations
• Automate reporting with Excel, Google Sheets, Looker Studio, and AI workflows to cut manual effort and cost
• Deliver weekly and monthly performance reports with insights and next-step actions for each client
• Manage client relationships, proposals, delivery timelines, and quality of every project

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.

• Build and maintain sales, orders, and revenue dashboards across marketplaces and the D2C store
• Track key ecommerce metrics: conversion rate, AOV, CAC, ROAS, return rate, and repeat purchase rate
• Analyse SKU, category, and pricing performance to flag fast movers, slow stock, and margin leaks
• Report on ad spend and campaign performance, with clear recommendations for budget allocation
• Run customer cohort and retention analysis to support LTV and re-marketing decisions
• Forecast demand and inventory needs from sales trends to reduce stock-outs and overstocking
• Clean, validate, and merge data from marketplaces, ad platforms, and the store into one reliable dataset
• Analyse return and cancellation data to identify root causes by product, pincode, and courier
• Prepare profit and loss views by channel and SKU, including fees, discounts, and ad cost
• Automate recurring reports with Excel, Google Sheets, and SQL to save hours every week
• Deliver weekly and monthly MIS reports and insights to management for faster decisions
• Partner with marketing, operations, and catalogue teams to turn data findings into action

Built and automated MIS reporting on sales, orders, and fulfilment, reconciled payments data, and led junior executives to deliver decision-ready insights to management.

• Prepare and automate daily, weekly, and monthly MIS reports on sales, orders, and fulfilment performance
• Build dashboards to track marketplace KPIs: GMV, conversion, order defect rate, and return rate
• Analyse SKU-wise sales, stock, and pricing data to flag fast movers, slow stock, and margin gaps
• Monitor delivery, cancellation, and return trends and highlight root causes to operations teams
• Reconcile orders, payments, and settlements data 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 seller and vendor performance metrics 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

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