ABHISHEK GUHA ROY
Sales Coordinator, MIS, Logistics Coordinator
Noapara, Barasat, Kol
Summary
Sales Support/ Logistic Support & MIS Professional Seeking challenging assignments in Sales & Logistic Coordination/ Support & MIS domain across the Industries preferably FMCD, Foods & Beverages/ Confectionery/ Dairy, Home Appliances, Pharmaceuticals, Manufacturing, Iron & Steel, Small/ Heavy Machinery, Automobile/ Auto-ancillary, Medical & Healthcare, Building Materials. A diligent & goal-oriented professional with 18+ years of experience leading corporate marketing and internal communications & Sales Support in State and zonal level for renowned companies across diverse industries like Engineering Steel Files & Cutting Tools, Electrical Appliances/ Consumer Durables& Chemical/ Livestock health. Expert in the MIS Reporting, Database Management& SAP Sd (Sales & distribution) Module, Logistic Support
Overview
19
19
years of professional experience
6
6
years of post-secondary education
2
2
Languages
Work History
Regional Sales/ Logistic Coordinator
NITCO LTD, Bengal
Kolkata
07.2019 - Current
- Coordinating with functions including Sales & Marketing, Finance, Warehouse/Billing, Logistics etc.& with
- Customers/ CFA’s to ensure smooth & timely flow of Sales processes and providing quality & comprehensive MIS on regular basis/ as & when required
- Selected Accomplishments – Following up with Sales team for collections & Orders – To maintain smooth sales and avoid billing restriction due to Overdue O/s amount of Customers
- Allocating Materials in stock against the System (SAP) order in coordination with the Supply Chain
- Team at Morbi – Gujrat Preparing Loading Plans of materials for Customers and communicating the same to Logistics
- Team by mail
- Coordinating with Transporters to place Containers (Rail, ship)/ Trucks as per loading plans sent within specified timeline
- Looking after any Transporter Related/ loading related issues (Breakage/ Shortage of materials), and following up the key pending issues with Commercial Dept
- Maintaining Daily Tracker- Regional Performance: Sales/ Collection/ Contribution/ Category, SE
- Performance: Sales/ Category/ Dealer wise billing Preparing and analyzing various reports- As required by Sr
- Regional Manager time to time
- Maintaining Project Trackers, and tracking Project Dispatches
- Preparing Monthly MIS RMM/ ZMM Data preparation Preparing/ Sending Quotation (Retail/ Enterprise), Price List, Circulars
Regional Sales Coordinator
EMAMI LTD – HCD DIVISION, Health Care Products
Kolkata
11.2018 - 07.2019
- Coordinating with functions including Sales & Marketing, Finance, Warehouse/Billing, Logistics etc.& with
- Customers/ CFA’s to ensure smooth & timely flow of Sales processes and providing quality & comprehensive MIS on regular basis/ as & when required
- Selected Accomplishments – Co-ordination in-betweens Sales Team of HCD OTC & HCD Ethical Divisions (total Size – 2 RSMs,ASMs, 47 ASOs/JOs), Stockiest and 8 Sales Depots for any type of requirement
- Following up with Sales team for collections and updates on Driving Activities
- Monitoring Whole sale/ Retail network Maintaining Daily Tracker- Regional Performance: Sales – Primary-Secondary/ Credit Control/ SO
- Performance: Sales/ Brand/ Stockiest wise Primary/Secondary/Eco/ Bill Cut Tracking Preparing and analyzing various reports- As required by RSM & HO time to time
- Preparing Monthly MIS RMM Data preparation Distributing Price List, Circulars- - As & When required Coordination with Commercial Dept – For Distributor’s Pay-out, Field Force Incentives, monthly/
- Quarterly & Half Yearly Basis, Distributor’s A/c Settlement, New Distributor Opening Organizing Interviews, HR Coordination- As & When required for ASOs/ Off-Roll Fes for their
- Appointment/ F & F after Resignation Keeping Data Back-up to RSM/ ASM/ SEs- As & When required HO coordination- Forecast and other formats- As & When required Maintaining Driving Activity Calendar Time to time following up the key pending issues with Commercial Dept.
Regional Sales Coordinator
NITCO LTD, Innovsource India Pvt. Ltd, Bengal
Kolkata
09.2016 - 11.2018
- Tiles/ Building Materials (Under third Party Payroll –, Coordinating with functions including Sales & Marketing, Finance, Warehouse/Billing, Logistics etc.& with
- Customers/ CFA’s to ensure smooth & timely flow of Sales processes and providing quality & comprehensive MIS on regular basis/ as & when required
- Selected Accomplishments – Co-ordination in-betweens Sales Team, Dealer and Depot for any type of requirement
- Following up with Sales team for collections
- Monitoring Wholesale network - Retail field Maintaining Daily Tracker- Regional Performance: Sales/ Collection/ Contribution/ Category, SE
- Performance: Sales/ Category/ Dealer wise billing Preparing and analyzing various reports- As required by RM time to time
- Maintaining Project Trackers Preparing Monthly MIS RMM/ ZMM Data preparation
- ABHISHEK GUHA ROY Page 3 Phone: 09831600846 SRM organization- Venue/ Date/ Presentations/ MOM/ Following-ups Tracking Daily SMS/ Mail from all field person on day plan and also actual at the end of the day
- Tracking DCR on daily basis and tracking weekly, Tracking Tour Programme of all region Field staff Preparing/ Sending Quotation (Retail/ Enterprise), Price List, Circulars- - As & When required
Officer
JK FILES (INDIA) LTD
Kolkata
09.2010 - 08.2016
- A Raymond Ltd subsidiary, Manufacturer of Engineering Steel Files &
- Cutting Tools, IT (Warehouse Invoicing and Dispatch/, Coordinating with various functions including Sales & Marketing, Finance, Warehouse, Quality Control
- Logistics etc.& with Customers/ CFA’s to ensure smooth & timely flow of Sales processes and providing quality & comprehensive MIS on regular basis/ as & when required
- Selected Accomplishments– Warehouse & supply chain
- Invoicing as per orders in the system (SAP) and Following up with Logistics Team for timely dispatch of materials
- Selected Accomplishments– Sales Support Keeping track of achievement of primary sales targets Tracking credit limit for a customer Ensuring that claims as per (Normal Scheme/ Special Scheme) are submitted and settled on regular basis and processing the same Correspondence with various functions (viz
- Sales & Marketing, Production, Quality Control
- Warehouse/ Billing, Logistics, Finance) of 5 Plants at Ratnagiri, Chiplun, Vapi, Kolkata & Pithampur and Head Office at Thane, to ensure timely & satisfactory supply of materials to customers & effective settlement of customer/ company accounts Effective correspondence on Orders, C-Forms, Road Permits Following up with Customers for overdue payments (Direct/ Thru’ Sales Team) Indenting for CFA’s item requirements as per norms/ additional requirements Necessary follow-up with Transporters Timely, accurate quotations, pro-forma invoices & price lists to customers, processing inquiries through email, phone and fax and participating in execution of overall Sales & Marketing
- Strategies
- Selected Accomplishments– MIS Reporting Providing active effective administrative & analytical MIS support to company sales & Marketing team (Handling 8 Sales Personnel, 4 Sales Depots) – with various database maintenance, sales/ payment details and clear Sales data analysis including –
- Sales/ Collection Target-vs-Achievement Status - Weekly/ Monthly/ Quarterly/ Yearly
- Sales Comparison Report/ Chart - Category wise/ Item wise/ Customer wise/ FY wise
- Daily Pending order-vs-Stock Report
- Debtor’s Outstanding statement and date wise aging
- Customer wise payment status and
- Sales agreements, in-time proposals, Warehouse Stock, C Form Status with any other requirements from Management regarding pre-sale material and after-sale deliveries
- Constructing Power Point Presentations for Management meetings
Computer Operator
POLARON MARKETING LIMITED
Kolkata
12.2007 - 08.2010
- Deftly coordinated Administrative activities Managing Accounts Receivable process while seamlessly tracking the credits in bankbook with the help of daily Bank statement obtained from Bank website and tallying with the database of collection from debtors daily Tracking Cheques-under-Clearance Record Sending Credit & Debit Advices to respective branches via E-mail
- And been accountable for Performing the entire computer related jobs in the office and streamlining the office management system Making computer presentations Preparing reports for various assignments Proper filing and maintenance of all the reports Handling overall responsibilities pertaining to routine correspondences of the company and looking after overall Data management of the files of projects & business while ensuring Maintaining daily & monthly records pertaining to Payments from debtors against dues outstanding for six Divisions including Marketing, Sheffield, Water Lifting Pump, Fan
- Trading & SS Divisions Maintaining branch-wise dishonored Cheque records and coordinating with concerned branches for the same Prepared and maintained monthly MIS reports pertaining to sales
Back-Office Assistant (Billing/ MIS/ Sales Coordination Assistant)
DAVEY AGENCY, OF RFCL Ltd
Kolkata
12.2004 - 11.2007
- Chemical Reagents and Health Products for Livestock, Been Accountable for entire gamut of Administrative work specifically related to official documents and material Maintaining track records & updating information in computer for the daily transactions using SAP Managing invoicing, generating stock transfer note and goods receipt etc
- Through SAP Sales Coordination Activities (Kolkata & Rest West Bengal Region) like sending Price quotation, Pro forma Invoice, Following up for Payments, C Forms, Road Permit from Debtors/ Customers, providing necessary Business data/ MIS to Sales Personnel, Correspondence with Sales/ Marketing
- People and Customers
- ACADEMY OF ACCOUNTS
Office Assistant (Accounts & Administration Assistant/
MIS
04.2004 - 11.2004
- Handled & maintained day-to-day accounting operations after necessary adjustments manually as well as electronically while liaising with all relevant departments and collecting required information Maintained other MIS and administrative activities Maintained front office activities
- ABHISHEK GUHA ROY Page 5 Phone: 09831600846
- Technology
- Software: SAP Sd (Sales & Distribution Module), MS Office - Word, Excel (Sumif, Countif
- Vlookup, Hlookup, Pivot Table, Formulas, Conditional Formatting, Data Validation)
- PowerPoint
Education
Bachelor of Arts - General
UNIVERSITY OF CALCUTTA
Kolkata, India 07.2004 - 08.2006
Higher Secondary - Pure Science
WEST BENGAL COUNCIL OF HIGHER SECONDARY EDUCATION
West Bengal, India 05.1993 - 06.1995
Madhyamik - General Studies
WEST BENGAL BOARD OF SECONDARY EDUCATION
04.1991 - 04.1993
Skills
Sales Supportundefined
Timeline
Regional Sales/ Logistic Coordinator
NITCO LTD, Bengal
07.2019 - Current
Regional Sales Coordinator
EMAMI LTD – HCD DIVISION, Health Care Products
11.2018 - 07.2019
Regional Sales Coordinator
NITCO LTD, Innovsource India Pvt. Ltd, Bengal
09.2016 - 11.2018
Officer
JK FILES (INDIA) LTD
09.2010 - 08.2016
Computer Operator
POLARON MARKETING LIMITED
12.2007 - 08.2010
Back-Office Assistant (Billing/ MIS/ Sales Coordination Assistant)
DAVEY AGENCY, OF RFCL Ltd
12.2004 - 11.2007
Bachelor of Arts - General
UNIVERSITY OF CALCUTTA
07.2004 - 08.2006
Office Assistant (Accounts & Administration Assistant/
MIS
04.2004 - 11.2004
Higher Secondary - Pure Science
WEST BENGAL COUNCIL OF HIGHER SECONDARY EDUCATION
05.1993 - 06.1995
Madhyamik - General Studies
WEST BENGAL BOARD OF SECONDARY EDUCATION
04.1991 - 04.1993
Similar Profiles
Emily YoungEmily Young
Sr. Business Implementation Specialist at NitcoSr. Business Implementation Specialist at Nitco
David HansteinDavid Hanstein
Contractor's Assistant at dad and Nitco group Canada inkContractor's Assistant at dad and Nitco group Canada ink
Deisi MolinaDeisi Molina
Driver, Warehouse Orders at Nissan NitcoDriver, Warehouse Orders at Nissan Nitco
NILADRI ROYNILADRI ROY
Deputy Project Manager at Knight Frank India Pvt LtdDeputy Project Manager at Knight Frank India Pvt Ltd
SWARNITA DASSWARNITA DAS
Supply Onboarding Executive at Mervice Infotech Pvt LtdSupply Onboarding Executive at Mervice Infotech Pvt Ltd