Nikunj Vig

Contact

Nikunj Vig

Data Analyst

Data Analyst skilled in Python, SQL, and BI tools with experience in data validation, reporting, and dashboarding. Proven track record improving data accuracy, streamlining workflows, and enabling actionable insights across retail and hospitality operations.
Say Hello
My Work

Follow me:

Linkedin

2

Years of experience

Nikunj

About Me

Data Analyst with hands-on experience in data collection, validation, ERP data management, and analytics reporting. Skilled in building ETL workflows, cleaning and standardizing large datasets, and translating operational needs into data-driven insights. Experienced with Python, SQL, Excel reporting, and BI tools to improve performance metrics, data consistency, and decision-making.
Download CV

My expert
areas

Data Analysis, Data Management, ETL, and Business Intelligence Reporting to improve accuracy, performance, and operational decision-making.

Skills

Python

SQL (Joins, Subqueries, Window Functions, Stored Procedures)

Power BI (DAX, Power Query, KPI Dashboards)

Tableau

Data Cleaning & Validation (EDA, Statistical Validation)

Excel Reporting & Data Modeling

  • 2

    Years of Experience

  • 10

    Dataset Processed

  • 25

    Data Dashboards Built

  • 10

    Projects Completed

Education

Post Graduate Diploma in Business Insights and Analytics
Humber Polytechnic
Toronto, Canada
September 2024 – April 2026 (Expected)
Bachelor of Engineering in Computer Engineering
St. Vincent Pallotti College of Engineering and Technology
India
August 2016 – November 2020

Experience

Walmart Canada

Associate | October 2025 – Present

  • Collected, validated, and restocked 1,500+ products weekly while maintaining 98% inventory accuracy.

  • Performed shelf audits, barcode tracking, and manual checks to reduce aisle-level discrepancies by 20%.

  • Flagged 75+ stock anomalies monthly to improve replenishment accuracy by 30% and support planogram compliance.

  • Partnered with cross-functional teams to improve product placement and reduce restocking errors by 35%.

  • Supported operational improvements contributing to a 12% rise in average customer retention dwell time per aisle.

212Biltmore Private Limited

Business Representative | December 2023 – May 2024

  • Identified 40+ system issues and usability gaps, improving app workflow speed by 25%.

  • Validated cross-system data across 3 hotel platforms, increasing consistency by 30%.

  • Enabled accurate real-time performance metrics used by executive teams and department leads.

  • Translated 15+ user feedback logs into actionable system requirements aligned with business goals.

  • Supported a 20% boost in application delivery and internal adoption through structured insights and reporting.

Excellon Software Pvt. Ltd.

Associate Functional Consultant | October 2022 – May 2023

  • Managed ERP data entry for 100+ dealer and client records weekly to improve integrity by 35%.

  • Reduced input errors impacting invoicing, logistics, and supply chain tracking modules.

  • Preprocessed and assessed raw Excel datasets with 15K+ rows to cut reporting delays by 40%.

  • Standardized unstructured tables into cleaned datasets and reporting-ready outputs.

  • Trained 20+ end-users on ERP workflows, increasing data handling accuracy by 50% and reducing support tickets by 25%.

Projects

Production-Grade End-to-End Azure Data Engineering Pipeline

Personal Project

End-to-End Azure Data Engineering Pipeline

Skills Used

  • Azure Data Factory (ADF), Azure Data Lake Storage Gen2 (ADLS), Azure Databricks, PySpark, Apache Spark, Delta Lake, Unity Catalog, Azure SQL Database, REST APIs, CDC, Auto Loader, Medallion Architecture, Git & GitHub

Key Roles

• Designed and implemented a production-grade end-to-end Azure data platform using ADF, ADLS Gen2, Azure SQL and Databricks, demonstrating a scalable architecture for real-world data workloads.
• Implemented CDC-based incremental ingestion to process only new and updated records instead of full-table reloads, reducing unnecessary data movement and compute consumption
• Built metadata-driven and parameterized ADF pipelines to handle multiple tables through reusable pipeline logic, reducing development effort and improving maintainability as new data sources are added.
• Implemented Auto Loader, checkpointing and Delta Lake within a Bronze–Silver–Gold architecture to support reliable incremental processing, recovery and scalable transformations.
• Integrated automated failure alerts through Azure Logic Apps, reducing the need for manual pipeline monitoring and enabling faster identification of pipeline failures.

Modern SQL Data Warehouse with Medallion Architecture

Personal Project

End-to-End Data Developer

Skills Used

  • SQL, Data Warehousing, ETL Pipelines, Data Modeling, Star Schema, Data Quality Automation

Key Roles

  • Designed a 3-layer SQL warehouse (bronze, silver, gold) using Medallion architecture to process 250K+ rows.

  • Built automated ETL scripts to cleanse and standardize data, resolving 95% of inconsistencies across CSV sources.

  • Integrated ERP and CRM data sources to enable real-time analytics and reduce reporting automation lag by 40%.

  • Created a star schema with 5 dimension tables and 1 fact table to improve analytical performance by 20%.

  • Structured datasets for scalable analytics and reporting across departments.

Copyright © Jae-Hyun Park 2025. All rights reserved.

To Top