VS

Building Data-Driven Business Systems
for Operations, Supply Chain & AI Automation

I build data-driven systems for operations, supply chain, e-commerce and AI automation. From managing farm production and inventory planning to scaling online businesses, I transform complex workflows into measurable business growth.

Specializing in Business Analytics, Supply Chain Optimization & AI-Powered Automation.

Operations • Analytics • Automation
A professional headshot of Vijay Shukla
A professional headshot of Vijay Shukla

Business Operations, Analytics & Technology

About Me I am a Business Analyst and Operations Professional with hands-on experience in data-driven business management, technology operations, inventory control, and process optimization. Currently, I work closely with Sachde Food & Beverages, managing operational data and business performance across multiple brands including Love N Latte, Nymi Coffee, and JustMySalad. My role involves transforming raw business data into actionable insights that support strategic decision-making and operational efficiency. I oversee sales analytics, inventory management, purchase order (PO) management, business reporting, and performance tracking across multiple outlets. In addition to analytics, I provide technology and operational support for outlet teams, helping streamline workflows and improve day-to-day business operations. My responsibilities also include managing and optimizing the websites and digital platforms of Love N Latte, Nymi Coffee, and JustMySalad, ensuring smooth customer experiences and efficient backend operations. I work extensively with business data, dashboards, reporting systems, and operational processes to identify opportunities for growth and efficiency. I am particularly interested in solving complex business and technology challenges through analytics, automation, and AI-powered solutions. My goal is to build scalable systems that combine Business, Data, Operations, and Technology to drive measurable business growth and improve decision-making.

Business Impact & Operational Excellence

Driving business growth through analytics, operations management, technology solutions, and data-driven decision making.

5+

Brand Managed

20+

Outlets And Operations Supported

Inventory

POs • Stock Control • Procurement

Analytics

Sales • Operations • Business Intelligence

No commitment. Let's discuss your project and see how I can help.

My Approach

Business-Focused Solutions

I don't just build reports; I solve business challenges. My focus is on delivering insights that lead to measurable improvements in your operations.

Actionable Dashboards

You get polished, easy-to-understand dashboards that stakeholders can use immediately to make informed decisions. My work is built for clarity and impact.

Reliable & Responsive Partner

Expect clear communication, timely delivery, and a professional partnership. I keep you updated at every stage and am always available to discuss progress.

Proven Track Record

With over 15 projects successfully delivered, I have a history of helping businesses harness their data to improve efficiency and drive growth.

Insights, Clearly Communicated

I specialize in translating complex data findings into plain English, ensuring everyone from the C-suite to the ops team understands the story.

Future-Proof Analytics

The solutions I build are designed to grow with your business. I create flexible, scalable models that can adapt to your changing data and operational needs.

How I Work

Simple, transparent process. You'll get clarity at every step and regular updates throughout the project.

1-2 Days

1. Discovery & Requirement Gathering

First, I understand your business objectives and define the key questions we need to answer. We'll identify KPIs and locate the necessary data sources to build a solid foundation.

Project Dependent

2. Data Extraction & Preparation

I extract data from various sources, then clean, transform, and model it. This ensures the data is accurate, consistent, and ready for analysis.

Project Dependent

3. Dashboard Development & Analysis

This is where the insights come to life. I build interactive dashboards and perform deep-dive analysis to uncover trends, patterns, and actionable insights hidden in your data.

1-2 Days

4. Insight Delivery & Review

I present the findings in a clear and compelling narrative. We'll review the dashboards together, ensuring the insights are understandable and directly address your business goals.

Ongoing

5. Deployment & Support

Once the dashboards are finalized, I deploy them for your team's use. I provide ongoing support to ensure the solution remains valuable and adapts to your future needs.

Core Capabilities

Dashboards & Reporting

BI & Visualization

Building insightful MIS, KPI trackers, and executive summaries that provide a clear, at-a-glance view of business performance.

Inventory & Ops Analytics

Core Analytics

Deep-diving into stock variance, wastage, and returns data to control shrinkage, improve stock accuracy, and optimize inventory flow.

Quick Commerce KPI Analysis

Specialization

Specialized analysis of Fill Rate, Cancellation Rate, and SLA performance to identify bottlenecks and drive operational excellence.

Advanced Excel & Data Modeling

Technical Skills

Leveraging Power Query, Pivot Tables, and advanced formulas to clean, transform, and model complex datasets with efficiency and accuracy.

SQL for Data Extraction

Technical Skills

Writing efficient SQL queries with joins and aggregations to extract and manipulate critical data from relational databases.

E-commerce Operations

Domain Knowledge

Managing product listings, catalog data, and tracking key metrics like OOS and order execution for major online channels.

Featured Projects

Real-world data analytics projects showcasing technical expertise and problem-solving.

Stock Availability & OOS Tracker

Stock Availability & OOS Tracker

Developed an Excel dashboard using Power Query to provide real-time visibility into out-of-stock items, helping reduce OOS instances by 15% and prioritize stock replenishment.

ExcelPower QueryKPIDashboard
Order Funnel & Cancellation Analysis

Order Funnel & Cancellation Analysis

Analyzed order data to map the customer funnel and segmented cancellations by root cause. Identified 'stock mismatch' as a key issue, leading to a 20% reduction in cancellations for targeted stores.

ExcelAnalysisKPIReporting
SLA Monitoring (Dispatch + Delivery)

SLA Monitoring (Dispatch + Delivery)

Created a daily SLA monitoring report to track order placement, dispatch, and delivery timings. Improved average delivery time by 10 minutes and increased SLA compliance to 98%.

SLAKPIReportingExcel
Pricing/Discount Impact Watch

Pricing/Discount Impact Watch

Built a model to compare sales, GMV, and margin percentage during promotional periods. This enabled data-driven decisions on discount strategy, improving gross margin by 5%.

ExcelAnalyticsMargin ProtectionReporting

Insights & Articles

Exploring topics in data analytics, operations, and business intelligence.

Building a Scalable Data Warehouse for Analytics
Data Architecture
JAN 15, 2024
8 MIN READ

Building a Scalable Data Warehouse for Analytics

Learn how to design and deploy a modern data warehouse using cloud technologies for scalable, production-ready analytics applications.

Read Full Article
Advanced Dashboarding with Power BI and DAX
Analytics
JAN 10, 2024
12 MIN READ

Advanced Dashboarding with Power BI and DAX

A comprehensive guide to building dynamic and insightful dashboards using Power BI, focusing on advanced DAX formulas and data modeling techniques.

Read Full Article
Automating KPI Reporting with Python and SQL
Operations
JAN 5, 2024
6 MIN READ

Automating KPI Reporting with Python and SQL

Set up automated data extraction, transformation, and reporting pipelines using Python scripts and SQL queries for seamless operations monitoring.

Read Full Article

Resume Highlights

Expert in Advanced Excel, Power Query, and Pivot Tables for complex data modeling.

Proven ability to design and build insightful MIS dashboards for operational KPIs.

Strong understanding of Quick Commerce metrics like Fill Rate, OOS%, and SLA.

Adept at root cause analysis for complex operational issues like stock variance and order cancellations.

Skilled in translating raw operational data into actionable business insights.

Passionate about efficiency; automates manual reporting tasks using Power Query and structured data templates.

Excellent stakeholder management skills; partners with operations teams to implement data-driven improvements.

Work Experience

Current Role

Inventory & Operations Analyst

Restaurant Company (Multi-Outlet Ops)

  • Managed daily inventory tracking for multiple outlets, ensuring stock accuracy.
  • Built daily and weekly MIS dashboards for Stock Value, Variance %, and Consumption trends.
  • Identified wastage patterns, leading to corrective actions and reduced dead stock.
  • Reduced manual reporting time by creating structured templates for reconciliation.

Previous Work / Additional Responsibility

E-commerce & Quick Commerce Operations

Listing + Execution Support

  • Managed product listing, catalog updates, and operational data for online sales channels.
  • Tracked and reported on performance issues like OOS, cancellations, and stock mismatch.
  • Supported faster decision-making with structured data on product availability and demand.

Resume Highlights

Expert in Advanced Excel, Power Query, and Pivot Tables for complex data modeling.

Proven ability to design and build insightful MIS dashboards for operational KPIs.

Strong understanding of Quick Commerce metrics like Fill Rate, OOS%, and SLA.

Adept at root cause analysis for complex operational issues like stock variance and order cancellations.

Skilled in translating raw operational data into actionable business insights.

Passionate about efficiency; automates manual reporting tasks using Power Query and structured data templates.

Excellent stakeholder management skills; partners with operations teams to implement data-driven improvements.

Fast learner, currently expanding skills in Power BI (DAX) and SQL.

Download Full Resume

Ready to Start Your Project?

Let's discuss your project. I'll help you build a solution that works for your business and grows with your needs. Initial consultation is free. No obligation.

Other ways to connect

You can also reach out directly via email or WhatsApp.

Email Me WhatsApp