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
Assistant Manager of motor OD Claims at IFFCO TOKIO GENERAL INSURANCE CO LTDAssistant Manager of motor OD Claims at IFFCO TOKIO GENERAL INSURANCE CO LTD