Nikunj Vig
Data Analyst
Follow me:
2
Years of experience
Nikunj
About Me
My expert
areas
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
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
Customer Churn Analysis and Prediction Model
Personal Project
Data Preprocessing and Visualization
Skills Used
- Data Preprocessing, Data Visualization, Predictive Modeling, Customer Analytics, Matplotlib, Seaborn
Key Roles
-
Processed 7,043 telecom records to identify churn drivers and improve targeted retention strategies.
-
Discovered that customers with less than 12 months tenure had 45% higher churn, supporting more focused campaigns.
-
Built advanced visualizations to uncover behavioral trends, contributing to a 22% increase in customer lifetime value.
-
Developed a churn segmentation model that reduced attrition by 15% through predictive tagging.
-
Enabled strategic outreach to over 2,000 high-risk customers, improving retention operations at scale.
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.
