Back to Developers
Subhojeet Ghosh

Subhojeet Ghosh

Business Analyst

Kolkata, W.B.
85
Profile Score

About

Business Analyst with over 2+ years of experience in developing dashboards, performance reports, and actionable business insights. Proficient in Advanced Excel, SQL, and Power BI, with a strong foundation in business and data analytics. Skilled in retail and e-commerce analytics, with hands-on experience in analyzing complex datasets, extracting data from multiple sources, and delivering insights that support strategic decision-making and enhance operational efficiency.

Skills & Expertise (18)

MS Excel Advanced
8.3/10
2
Years Exp
Power BI Intermediate
7.5/10
2
Years Exp
SQL Intermediate
7.1/10
2
Years Exp
Data Modeling Intermediate
6.2/10
2
Years Exp
Tableau Beginner
5.6/10
1
Years Exp
Macros Power Pivot Index-match XLOOKUP Cross-Functional Collaboration Innovator Team Work Analytical Requirement gathering Predictive Modeling Data Visualization Postgresql MySql

Work Experience

Senior Analyst (E-Commerce / Retail Merchandising - U.S.)

EcoSoul Home Inc.

May 2023 - May 2025

Automated inventory and in-stock rate dashboards in Excel (XLOOKUP, Index-Match, Power Pivot, Macros), reducing stockouts by 10% and maintaining >95% stock availability. Performed volumetric analysis, achieving 15% cost reduction and improving overall supply chain efficiency. Forecasted demand using Ahold IRI data by analyzing sell-through rates, store-level sales, and regional trends, strengthening demand planning. Created MIS reports on secondary sales to evaluate retail performance, identify sales trends, and support strategic decision-making. Analyzed advertising sales and expenditure to optimize ACOS and TACOS, identifying peak sales periods and revenue drivers. Designed and automated interactive dashboards in Power BI and Excel to integrate multi-source datasets for precise reporting and growth strategies. Managed new product launches by overseeing SKU nomenclature, barcode generation (GS1 portal), and DBMS dataset maintenance. Enhanced product visibility on Amazon by optimizing imagery, A+ content, and artwork while conducting competitive market research for product expansion. Delivered daily performance reports with pivot tables and charts, introduced new reporting strategies, and delegated tasks effectively to cross-functional design teams.

Business Analyst (KART IT)

Whole9yards USA

Jul 2025 - Sep 2025

Tracking and optimizing stock levels of top-selling products and key vendors to maintain availability and prevent stockouts. Evaluating and improving Buy Box eligibility by implementing corrective actions, boosting competitiveness and driving sales growth. Coordinating with vendors and internal teams to plan promotions, manage lead times, and ensure timely adjustments. Facilitating operations by engaging with vendors on order-related queries, updates, and fulfillment requirements. Resolving CST-escalated cases promptly to minimize business impact and maintain operational efficiency. Streamlining operational processes by collaborating with cross-functional teams to address challenges and ensure smooth business operations.

Education

B.Tech. - Bankura Unnayani Institute of Engineering

- 2016 · Afghanistan

12th (Science) - Delhi Public School, Siliguri

- 2011 · Afghanistan

Certifications

Business Analytics Certification Course

Relevel by Unacademy · 2022

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 85/100

Profile Overview

Member sinceMar 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation

Skills (18)

MS Excel Power BI SQL Data Modeling Tableau Macros Power Pivot Index-match XLOOKUP Cross-Functional Collaboration +8 more