Projects by Sonu Prajapati, Data Analyst

Problem: D2C brands had to hire a different team for their website, ads, data and store work. It cost more, took longer, and nothing worked together.

Solution: Started Vriyox, one team for everything an online brand needs: Data Analytics, Web Development, Performance Marketing, eCommerce Services and eCommerce Business Consultation. Every decision is backed by real numbers.

Problem: Marketplace performance was checked by hand from several reports, so slipping KPIs were noticed late.

Solution: Defined the key metrics, automated the data pull and calculations, and built a daily view with targets and trends, so teams see problems the same day.

Problem: Recurring reports were rebuilt manually every cycle, which took hours and left room for copy-paste mistakes.

Solution: Standardised the report formats and automated the data prep and refresh with macros, formulas and SQL, cutting manual effort and turnaround time.

Problem: It was unclear which products drove revenue, which were tying up stock, and where pricing was eating into margin.

Solution: Combined sales, stock and pricing data, ranked SKUs by contribution and margin, and flagged fast movers, slow stock and margin gaps with clear recommendations.

Problem: Orders and settlement payments did not always match, and missing or short payments went unnoticed.

Solution: Matched orders against payments and settlements, flagged mismatches by reason, and reported the gaps so they could be followed up and recovered.

Problem: Ad spend was reported channel by channel, so it was hard to see which campaigns actually returned revenue.

Solution: Brought ad platform and GA4 data together, tracked spend, ROAS and conversions per campaign, and recommended where to shift budget.