Subrata Ghosh
Bengaluru
Summary
Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills. Detail- focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Dedicated and hard-working with passion for Big Data.
Overview
12
12
years of professional experience
Work History
Sales Operation & MIS - Modern Trade (PAN INDIA)
Wildcraft India Limited
Bengaluru
2022.10 - Current
- Produced monthly reports using advanced Excel spreadsheet functions.
- Developed and implemented customer account plans for modern trade accounts.
- Created, maintained, and analyzed reports related to sales performance of modern trade accounts.
- Identified opportunities for growth within the modern trade segment.
- Managed relationships with existing customers in the modern trade segment.
- Analyzed data related to customer purchases, trends, and behaviors in the modern trade segment.
- Monitored orders placed by customers in the modern trade segment and ensured timely delivery of goods.
- Collaborated with internal teams, such as marketing, finance, and sales. To develop strategies for increasing sales within the modern trade segment.
- Prepared monthly, quarterly, annual business reviews for senior management highlighting progress made against targets set across Modern Trade Segment.
- Arranging and participated in requirements meetings to understand business needs.
- Used statistical methods to analyze data and generate useful business reports.
- Managed large-scale databases to ensure timely access to critical information for key stakeholders.
- Handling Partner Operational Support like- D-mart, Smart Bazaar, Reliance Smart, SPAR (MAX), Lifestyle, Centro, Metro, and LULU Mall of India
- Prepare daily, weekly, and monthly sales report and share with management.
- Prepare GP report and share with management and Director.
- Prepare weekly and monthly Partner SOH Report, and share with team for PO Indent.
- Prepare and analyze weekly ZONE-wise Sales & Stock report.
- Prepare and analyze Partner Sales data weekly and monthly.
- Prepare offer articles, liquidation plan vs. each share with all ASM, RSM, and Management..
- Prepare & analysis article wise monthly SOH vs Production Plan vs sellout (Primary & Secondary)
- Based on Ideal Quantity, Maintaining Stock, and analysis for ROFO Management of every month.
- Prepare monthly Incentive & Expenses for all respective Promoters, TL, ASM, and RSOM.
- Prepare promoter performance report and share it with HR for salary release.
Sales Coordinator & MIS - Marketing Support
Raksha Pipes Pvt. Ltd
2018.11 - 2022.10
- Preparation of weekly performance report of marketing executive for Management.
- Prepared monthly reports on sales activities, revenue, expenses, and other key metrics.
- Maintained an up-to-date database of prospective clients and their contact information.
- Prepare monthly Sales Report.
- Prepare and analyses district wise sales report.
- Prepare and analyses Expenses report.
- Prepare AGM sales report and analysis.
- Prepare new customer generation data.
- Crossed verification new lead creation & approved (PAN India).
- Responsible for new Dealer/Distributor onboard.
- Material Availability update to customer.
- Product availability check with Factory.
- Co-ordination with logistics for dispatching materials.
- Weekly download of Outstanding, Sales, & Collection report from ERP and sharing with team members.
- Monitoring daily Marketing Employees' attendance at branch level.
- Responsible for Marketing Employee's salary release as per their performance.
- Responsible for issuing credit limit for a dealer/distributor based on their payment cycle/sales.
Sales Coordinator - Marketing & Admin
PEARL POLYMERS
2018.04 - 2018.11
- Responsible for dispatch /production planning for respective customers
- Responsible for preparation of monthly sales report
- Responsible for sending daily report on dispatch with Management
- Responsible for PI Generation, dispatch for respective customers
- Co-ordinated with production team for on time material dispatch to customer.
Sales Coordinator – Marketing & Admin
SPECTRA PIPES
2017.08 - 2018.11
- Responsible for training to new joiners
- Responsible for New Employee onboarding
- Prepare monthly Sales Report
- Responsible for sending daily report on dispatch with Management
- Responsible for maintaining the customer details in client database management software
- Responsible to update the service reports in Dealer Logistic Management System
- Responsible to maintain logistic data in Logistical Software.
Sales Coordinator
SKIPPER LIMITED
2015.04 - 2017.06
- Was responsible for Tender documentation and submission
- Was responsible for maintaining customer database in an SAP based Software
- Was responsible for payment follow up and collection.
Service Sales Co-Ordinator
REDINGTON INDIA LIMITED
2013.01 - 2015.01
- Was responsible for logging customer offsite/onsite calls basis Job card
- Responsible for arranging stocks based on the Job card description
- Co-ordinate and follow up with logistics on part availability
- Co-ordinate with engineer for customer issue fixation on part availability
- Responsible for sharing report with management on the logged calls with reasons.
Education
High School Diploma -
Bandel St. John's High School
Hooghly01.2003
High School Diploma -
Bandel St. John's High School
Hooghly01.2001
Skills
- Data Visualization and Presentations
- Excel Functions
- Data Cleaning
- Cost Analysis
- Team Leadership
- Financial Analysis
- Data Validation
- Data Exports
- Power BI Basic
- Coaching and Mentoring
Accomplishments
- Best Performance award - Sales Co-Ordinator – 2014 (HP).
- Best Performance award Marketing Support – 2022. (Raksha Pipes).
- Basic Hardware & Networking course from IIHT in 2009.
Timeline
Sales Operation & MIS - Modern Trade (PAN INDIA)
Wildcraft India Limited
2022.10 - Current
Sales Coordinator & MIS - Marketing Support
Raksha Pipes Pvt. Ltd
2018.11 - 2022.10
Sales Coordinator - Marketing & Admin
PEARL POLYMERS
2018.04 - 2018.11
Sales Coordinator – Marketing & Admin
SPECTRA PIPES
2017.08 - 2018.11
Sales Coordinator
SKIPPER LIMITED
2015.04 - 2017.06
Service Sales Co-Ordinator
REDINGTON INDIA LIMITED
2013.01 - 2015.01
High School Diploma -
Bandel St. John's High School
High School Diploma -
Bandel St. John's High School
Similar Profiles
Sourabh Kumar TiwariSourabh Kumar Tiwari
Store Manager at Wildcraft India LimitedStore Manager at Wildcraft India Limited
Rakesh DRakesh D
Audit Manager at Wildcraft India Pvt LtdAudit Manager at Wildcraft India Pvt Ltd
Sanjay VirdiSanjay Virdi
Store Manager at Wildcraft India ltdStore Manager at Wildcraft India ltd