Portfolio - Nitin Kunigal

Nitin Kunigal

Supply Chain Operations (3PL) Professional

Resume

1

Excel Project

2

PowerBI Projects

1

SQL Project

About Me

Hi, I’m Nitin Kunigal. Thanks for visiting my portfolio.

My experience is rooted in 3PL supply chain operations, where I worked closely with inbound and outbound warehouse processes. Being on the ground gave me a clear understanding of how execution gaps, especially around inventory accuracy and reporting, can impact overall performance.

In my role, I improved visibility into these gaps by streamlining reporting workflows using Excel and Power Query, helping reduce manual effort and bring more structure to operational tracking.

This experience shaped how I approach problem-solving. I use data not just for reporting, but to understand execution, identify risks early, and design processes that work in real-world environments.

The projects showcased here reflect this approach, focusing on inventory performance, process improvement, and data-informed decision-making.

If you’re exploring ways to improve operational execution through data, let's connect!

Key Skills

Advanced Excel

Power BI

JIRA

SQL

SQL Server

Data Modeling

ETL

Power Query

Data Visualization

Data Cleaning

Root Cause Analysis

KPI Reporting

Data Analysis

Stakeholder Collaboration

Data Warehousing

Agile (Scrum, Kanban)

Inventory Control

Warehouse Operations

Process Optimization

Supply Chain Operations

Cycle Counting

Inventory Reconciliation

Warehouse Management Systems

Process Modeling

Requirements Gathering

My Projects

Inventory Operations Enhancement for MapleDash - A Business Analysis Initiative

Domain/Function: E-Grocery (Retail)

Full-Stack BI: Databricks Lakehouse to Power BI Reporting

Domain/Function: Retail

Sales Lead Management System - A Business Analysis Case Study for V-Cosmetics

Domain/Function: Retail / Sales

Sales & Revenue Growth Analysis for ValueFrenzy

Domain/Function: Retail and E-Commerce

Business 360 Analysis for AtliQ

Domain/Function: Consumer Electronics (Retail and E-Commerce)

My Experience

Inventory Operations Associate | ProPack Logistics | Toronto (Canada)

Oct 2020 – Feb 2024

Worked in a high-volume 3PL warehouse environment supporting multiple B2B clients, with a focus on inventory accuracy, execution discipline, and operational visibility. Operating close to day-to-day warehouse activities provided hands-on exposure to how data, process gaps, and system updates directly impact order execution.

✔️ Tracked and analyzed inbound and outbound KPIs using Excel, delivering structured daily and weekly reports to highlight material flow trends, bottlenecks, and execution delays.
✔️ Performed cycle counts and investigated system vs physical variances across 8,000+ SKUs, coordinating corrections with warehouse leads to maintain accuracy above 95% and reduce downstream disruptions.
✔️ Automated recurring KPI reports using Power Query by consolidating WMS exports with operational logs, improving reporting consistency and saving 4–5 hours per week.
✔️ Managed daily system transactions within WMS, ensuring accurate updates and adherence to defined process flows to support consistent order execution.

Collaborated closely with warehouse leads and account managers to surface risks, resolve discrepancies, and support smoother handoffs across receiving, storage, and dispatch activities.

Awards & Certificate

Get Job Ready: Power BI Data Analytics for All Levels 3.0

The Complete SQL Bootcamp (30 Hours)

Process Improvement

Mastering Key Performance Indicators (KPIs)

Root Causes Analysis

Agile Project Management - Authorized by Google

Requirements Gathering In Business Analysis - Authorized by Microsoft

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/nitinkunigal

Call Me

+91 9380407202

GitHub

https://github.com/nitinskunigal

PowerBI Project

Inventory Operations Enhancement for MapleDash - A Business Analysis Initiative

Domain/Function: E-Grocery (Retail)

I led an end-to-end Business Analysis initiative for MapleDash, a simulated multi-warehouse e-grocery retailer, to resolve critical inventory execution gaps.

View Project
Engagement

View Project
on GitHUB

Other Tools

draw.io

Jira

This diagram depicts the future state process map of the Inbound (Receiving) process.

This diagram answers a key executive-level question: “What systems and actors (users) interact with the IMS, and what information flows between them?” Human users interact with the system only where judgment is required, such as exception handling.

Project Details

While core systems such as the IMS, WMS, and OMS are in place, inventory operations relied heavily on manual coordination, delayed updates, and supervisor-driven controls.

A data-driven assessment revealed that operational challenges stem not from missing systems, but from execution gaps between physical warehouse activities and system-recorded inventory states. These gaps manifest as inventory inaccuracies, ATP overselling, uneven stock distribution, frequent replenishment exceptions, and preventable picking disruptions.

This Business Analysis project defines a targeted IMS enhancement approach focused on system-directed execution, automated inventory updates, and exception-based human intervention across five core processes.

The solution deliberately avoids full system replacement or enterprise-grade integrations, aligning with MapleDash’s operational maturity and growth trajectory.

Project video

Live Interactive Dashboard

SQL Project

Full-Stack BI: Databricks Lakehouse to Power BI Reporting

Domain/Function: Retail

This project shows how I solved key business problems for a simulated mid-sized retail company by building a full-stack BI solution using a Databricks Lakehouse architecture and Power BI.

View Project
Engagement

View Project
on GitHUB

Other Tools

Databricks

Power BI

This diagram illustrates data lakehouse is built in Databricks using Medallion Architecture, depicting how data flows across layers progressively.

This diagram depicts the structure of the source data model and how source tables are related to each other. This is a very important process in building a dimensional data model in the Gold layer.

Project Details

The organization relied on multiple source systems for data. Due to this, leadership lacked a trusted, consistent view of KPIs across business functions. Different teams interpreted metrics differently, which slowed decision-making and increased the risk of acting on incomplete or conflicting information.

The solution follows a Lakehouse + BI architecture using Databricks and Power BI, structured around three layers/ phases:

1. Bronze Layer: Raw ingestion of source data
2. Silver Layer: Data quality fixes and standardization
3. Gold Layer: Business transformations, dimensional modeling, and reporting views.

Data Pipeline orchestration is setup and Power BI connects directly to the Gold layer, ensuring reports are always driven by governed, business-aligned data. This phased approach ensured that technical implementation remained directly tied to business outcomes, while also allowing each layer to build logically on the previous one.

Project video

Sales Lead Management System - A Business Analysis Case Study for V-Cosmetics

Domain/Function: Retail / Sales

The case Study is about addressing the challenges faced by V-Cosmetics' sales teams and proposing a strategic solution (Lead Management System/ LMS) accordingly. The proposed solution aims to streamline lead management, automate activity tracking, and enhance visibility across sales operations.

View Project
Engagement

View Project
on GitHUB

Other Tools

Draw.io

Word

Pencil (Wireframing)

Canva

In this case study, the Use Case Diagram portrays the interactions of sales reps, sales managers, and the CRM with the Lead Management system.

In this case study, the Process Flow Diagram depicts the activities involved in the sales process involving Sales Reps, Sales Managers, LMS, and CRM.

Project Details

V-Cosmetics is a new entrant in the beauty care industry and is striving to establish its market presence. To achieve this, the company focuses on both inbound and outbound lead generation. Sales reps engage in outbound prospecting while also managing incoming leads from various channels. However, sales managers face challenges in assigning, tracking, and monitoring leads, and sales representatives struggle with efficiently logging activities, managing follow-ups, and ensuring timely conversions.

Without a structured system, tracking leads, monitoring sales progress, and ensuring accountability become difficult, leading to inefficiencies such as missed follow-ups, poor visibility into sales activities, and ineffective decision-making.

To address these challenges, I proposed a strategic solution that aims to streamline lead management, automate activity tracking, and enhance visibility across sales operations, ensuring a more structured and data-driven approach to sales growth.

Project video

Excel Project

Sales & Revenue Growth Analysis for ValueFrenzy

Domain/Function: Retail and E-Commerce

The analysis aims to diagnose critical business challenges, particularly declining revenue and profitability in the USA, while exploring key performance metrics—Total Revenue, Gross Profit, Quantity Sold, Total Transactions, and Average Transaction Value (ATV).

View Project
Engagement

View Project
on GitHUB

Other Tools

Power Query

DAX

PowerPivot

Draw.io

Word

PowerPoint

The Dashboard explores key performance metrics—Total Revenue, Gross Profit, Quantity Sold, Total Transactions, and Average Transaction Value (ATV).

Despite a TRANSACTION INCREASE in late 2021, ATV remained steady, driven by FREQUENT low-tier purchases.

Project Details

This project analyzes ValueFrenzy, a fictional supermarket chain in the USA, Mexico, and Canada, facing stagnant revenue growth and profitability concerns across regions and product categories. The COO and CFO sought insights into slowing revenue and potential regional inefficiencies or product performance issues.

As the Business Analyst, I examined three years (2021-2023) of sales data, identifying trends affecting revenue, profit, and transaction values. Using Excel (Power Query, Power Pivot, DAX) and BA techniques (SWOT, Gap Analysis, Stakeholder Interviews, Competitor Benchmarking), I conducted in-depth analysis and created business reports. I developed an interactive Excel dashboard that revealed a 25% drop in Average Transaction Value (ATV) and regional sales disparities.

Based on my findings, I recommended pricing optimizations, regional sales strategies, and inventory improvements, enabling data-driven decision-making at ValueFrenzy.

Project video

PowerBI Project

Business 360 Analysis for AtliQ

Domain/Function: Consumer Electronics (Retail and E-Commerce)

Global Business Insights 360 is an advanced data analytics initiative designed to transform AtliQ Hardware’s decision-making processes. The project leverages Power BI to provide real-time insights, improve forecasting accuracy, and drive operational efficiency across key business functions.

View Project
Engagement

View Project
on GitHUB

Other Tools

Mural

Word

PowerPoint

Canva

MySQL

Excel

The dashboard depicts PC Market Share Trend of AtliQ and its competitors along with YoY trends of other metrics.

Stakeholder Mapping/ Matrix helps you understand the influence that stakeholders have on the project and the impact that the project has on them.

Project Details

AtliQ Hardware: Enterprise-Wide Data Analytics Transformation

AtliQ Hardware’s rapid expansion into LATAM led to significant losses due to intuition-based decisions, fragmented data, and Excel’s limitations in scaling operations. Key challenges included:
- Lack of data-driven decisions, with expansion strategies based on surveys rather than analytics.
- Data silos across ERP & CRM, causing reporting inconsistencies.
- Competitive disadvantage as rivals like Dell leveraged advanced analytics.

Solution: Data-Driven Business Strategy

AtliQ’s CEO prioritized analytics across Sales, Marketing, Finance, and Supply Chain, creating a unified, scalable reporting framework. This transformation enabled enterprise-wide visibility, regional insights across Europe, North America, and LATAM, and real-time decision-making—enhancing market competitiveness and operational efficiency.