Summary
Overview
Work History
Education
Skills
Certification
Timeline
Websites
Interests
Disclaimer
Subroto Roy

Subroto Roy

Retail Planner
NEW DELHI
I believe you have to be willing to be misunderstood if you're going to innovate.
Jeff Bezos

Summary

Driven professional aiming to contribute to organizational growth and advance my career by leveraging existing skills while gaining new expertise. I seek a challenging role offering personal and professional development opportunities to add significant value to the company. Committed to learning and adapting to new challenges, my experience includes overseeing various aspects of company operations, managing and analyzing data for informed decision-making, planning and forecasting sales aligned with budgets and marketing strategies, and ensuring on-time product delivery.

Overview

6
6
years of professional experience
5
5
years of post-secondary education
6
6
Certificates
3
3
Languages

Work History

Assistant Manager

Reliance Retail
Noida
02.2022 - Current

Inventory Management:

  • Sales monitoring for stock management.
  • Creating sales forecasts to maintain forward week cover and stock health.
  • Store-wise sales and replenishment analysis, particularly for Trends stores.

Sales and Product Analysis:

  • Reviewed sales and gross profit report to assess company efficiency
  • Sales Dashboard creation.
  • Sell-thru analysis.
  • Comparing Budget Target Vs Budget Achievement.
  • Evaluating Business Contribution.
  • Analyzing discounting strategies.
  • Tracking growth over weeks and months
  • Analyzing mix of sales across zones, bricks, brands, and more.
  • In-depth product analysis based on zone, color, MRP, style, USP, brick, and brand.

Data Analysis and Reporting

  • Managing and analyzing data for informed decision-making.
  • Planning and forecasting sales and marketing strategies.
  • Ensuring timely product delivery within budget constraints.
  • Creating reports using SAP and Tableau based on management requirements.
  • Analyzing data at various levels, including category, brand, MRP, brick, and store.
  • Collaborating with internal and external category management.

Product Listing and Business Conversion:

  • Listing products on AJIO Business (B2B to B2C).
  • Conversion Analysis of Product Listing Page (PLP), Product Details Page (PDP), and Add to Cart (ATC) to actual orders on AJIO.

Purchase Management:

  • Creation of Buyplan and Balancing according to RA.
  • Creating Purchase Requisitions and Purchase Orders.
  • Validating Purchase Requisitions with vendors based on cost, Ex-Factory, color, and delivery dates.

Retail Executive

Resideo ADI Global
Noida
10.2020 - 01.2022
  • Managed and maintained purchase orders and invoices.
  • Communicated with suppliers to negotiate best pricing on apparel and accessories.
  • Monitored and analyzed sales records, trends, or economic conditions to anticipate consumer buying patterns.
  • Prepared and analyzed reports to track inventory and purchasing trends.
  • Reviewed each store location's buying trends to ascertain correct assortment of apparel for maximum sales and profits.
  • Analyzed sales and inventory data to determine purchasing needs and reorder points.
  • Studied and monitored market trends to identify potential suppliers.
  • Negotiated contracts with vendors for cost-effective purchasing terms.
  • Provided clerks with information to print on price tags such as price, mark-ups or mark-downs or style number.
  • Collaborated with sales team to identify and fulfill customer needs.

Audit Executive

ASC Consultancy
Noida
09.2019 - 09.2020
  • Physical Stock Verification as per System Generated Reports.
  • Identified control gaps in processes, procedures and systems through in-depth research and assessment and suggested methods for improvement.
  • Analyzed data and findings to prepare reports detailing financial information.
  • Performed observations and evaluated supporting documents to supplement audit findings.
  • Collected and reported monthly expense variances and explanations.
  • Prepared reports for templates and maintained compliance database.
  • Analyzed all audit results and resolved all compliance issues.

Fresher

Shridhar and Associates
New Delh
11.2017 - 04.2019
  • Self-motivated, with strong sense of personal responsibility
  • Demonstrated strong organizational and time management skills while managing multiple projects
  • Developed strong communication and organizational skills through working on group projects
  • Assisted with day-to-day operations, working efficiently and productively with all team members
  • Demonstrated respect, friendliness and willingness to help wherever needed
  • Applied effective time management techniques to meet tight deadlines
  • Organized and detail-oriented with strong work ethic
  • Passionate about learning and committed to continual improvement
  • Learned and adapted quickly to new technology and software applications
  • Identified issues, analyzed information and provided solutions to problems
  • Gained strong leadership skills by managing projects from start to finish
  • Proven ability to develop and implement creative solutions to complex problems
  • Exercised leadership capabilities by successfully motivating and inspiring others

Education

Post-Graduation Diploma in Business Management - Business Management

NARSEE MONJEE INSTITUTE OF MANAGEMENT STUDIES (NMIMS), Mumbai
04.2021 - 05.2023

Bachelor of Commerce - Accounting And Finance

DELHI UNIVERSITY, Delhi
07.2016 - 07.2019

Skills

Performance Reviewing

undefined

Certification

Foundations: Data, Data, Everywhere- Coursera

Timeline

Visual Analytics with Tableau

12-2023

Essential Design Principles for Tableau

08-2023

Data Visualization and Dashboards with Excel and Cognos

06-2023

Fundamentals of Visualization with Tableau

06-2023

Introduction to Data Analytics- Coursera

05-2023

Foundations: Data, Data, Everywhere- Coursera

03-2023
Assistant Manager - Reliance Retail
02.2022 - Current
NARSEE MONJEE INSTITUTE OF MANAGEMENT STUDIES (NMIMS) - Post-Graduation Diploma in Business Management, Business Management
04.2021 - 05.2023
Retail Executive - Resideo ADI Global
10.2020 - 01.2022
Audit Executive - ASC Consultancy
09.2019 - 09.2020
Fresher - Shridhar and Associates
11.2017 - 04.2019
DELHI UNIVERSITY - Bachelor of Commerce, Accounting And Finance
07.2016 - 07.2019

Interests

Travelling

Listening Music

Badmintion

Gaming

Watching Movies and Series

Disclaimer

I hereby declare that all the information given above is true and correct to the best of my knowledge. All the information shared in the resume is correct, and I take full responsibility for its correctness. I solemnly declare that the information in this resume is true to the best of my knowledge and belief
Subroto RoyRetail Planner