Overview
Work History
Education
Skills
Certifications
Projects
Accomplishments
Timeline
Generic

Subham Nandi

Associate
B-17/122, Kalyani, Nadia

Overview

6
6
years of professional experience

Work History

AMAZON

Associate Retail
02.2022 - Current
  • Performed end-to-end product mapping by matching ASINs with competitor SKUs using identifiers such as EAN, UPC, model number, brand, and product attributes to ensure 100% accurate product comparison and analyzing retail data.
  • Leveraged SQL to query large datasets for inventory health checks, identifying inconsistent records and reducing data discrepancies by 65%.
  • Developed interactive dashboard in Power BI using DAX formulas to provide insights to pricing strategies , price increase opportunities , price recommendation , discount and promotion planning optimizing reporting workflows by 40%.
  • Prepared productivity reports for the entire team using Micosoft Excel (PivotTable).


PowerBI | SQL | MS Excel | Mapping tool |


ICICI BANK LTD

Deputy Manager
03.2021 - 07.2021
  • Provided service line with effective financial management and conduct KYC to prevent illegal activities such as fraud and anti money laundering and also identifying suspicious transactions.
  • Maximized sales performance through delivery of an exceptional customer experience

CRM | VRM | KYC | MS Excel

Dabur India Ltd

Intern
04.2020 - 07.2020
  • Visited over 200 outlets travelling through 6 beats in and around Kalyani, increased distribution coverage
  • Converted 67% of the non existing chemist outlets into active business as a result increasing ROI of the company

Excel | MS PowerPoint


Education

PGPBM+MBA - Sales And Marketing

Bengal Institute Of Business Studies
09.2021

B.Sc Honours - Economics

Scottish Church College
04.2018

Skills

  • Analysis & Visualization tools: Power BI , AWS QuickSight , Microsoft Excel
  • Programming Languages: SQL , Python

Certifications


  • Statistics for Data Science and Business Analysis - Certified by udemy
  • SQL Essential Training - Certified by Amazon
  • Visualizing with QuickSight - AWS training and certification


Projects

Credit Card Financial Dashboard | Power BI, SQL

  • Developed an interactive dashboard using transaction and customer data from a SQL database and provided insights based on dashboard findings.

Ecommerce Sales Dashboard | Power BI

  • ·Analyzed data and created a dashboard using various charts and slicers to deliver accurate Sales Forecasting.

Music Store Analysis | SQL

  • ·SQL project to analyze online music store data

Accomplishments

  • Achieved the Stellar Award in CMT Rewards and Recognition based on productivity,consistency and optimization- Amazon

Timeline

AMAZON

Associate Retail
02.2022 - Current

ICICI BANK LTD

Deputy Manager
03.2021 - 07.2021

Dabur India Ltd

Intern
04.2020 - 07.2020

B.Sc Honours - Economics

Scottish Church College

PGPBM+MBA - Sales And Marketing

Bengal Institute Of Business Studies
Subham NandiAssociate