Zonal MIS & Coordination
Name : Piyali Banerjee Father’s Name : Sudhakar Banerjee
Date of Birth : 08/07/1971 Address : 50 A, Barabagan Lane Mobile No : 990-***-**** Serampore, Hooghly
E-mail ID : ******.*******@*****.*** Pin - 712 203
Working Experiences :
Name of the Company : NITCO Ltd.
Designation : Sr. Executive–Sales Coordination
(East & South – Retail & Key Account)
Duration : From Sep2016 to May2019
Responsibilities : COORDINATION, MIS REPORT GENERATION, MIS ANALYSIS, MIS MANAGEMENT
AOP preparation
Business Trend analysis, Contribution Analysis & Growth Analysis.
Region-wise monthly dynamic target calculation, Focus Product Working
Daily Score Card, Weekly Tracking, Monthly Actual & Annual Compliance Report –Sales & Collection
Formulation of monthly/quarter/annual business review analysis formats pertaining to Zone/Region/Territory/District/Town wise sales & collection report for the Management review
Data support (Advanced, Critical) for AVP’s presentation/analysis, Agenda & MOM preparation - follow-up & status update
All Region / Zone’s monthly review date fixation, Agenda, MOM, Presentation Collection, supervision
Creating and maintaining database as per Management requirement
Tracking on Own Factory Sales with secondary liquidation.
Stock as well as FTL / Vehicle Placement reports to AVP
Clearance of Old POs in the system
NDA performance
Supervision of PJP, DCR, MVMC reports maintenance, deviation analysis
Scheme Communication, Execution, Tracking
Co-ordination with Corporate Office to Region Offices, Field in term of Reports & data sharing, Operation & various any other requirement
HR Coordination, support
Sales forecasting co-ordination with Region/ Zone for timely availability of stocks
Production Schedule Coordination & Communication for any focus requirement
Name of the Company : NITCO Ltd.
Designation : Zonal Coordinator – Sales (East)
Duration : From Jun2012 to Aug2016
Responsibilities : Coordination & Communication – with Head Office, Regional Offices, Regional Manager-Field Force.
Information handling – Branch Offices-Depot, Dealers.
Tracking & follow-ups - Reports of Regional Manager-Field Force - Volumn-wise, Category-wise, Dealer-wise, SE-wise Primary TGT vs ACH, DCR, Forecast, PJP, Stock – MWH, Depot, SE-wise Secondary.
MIS Reporting (preparation, compilation & analysis) of Eastern Zone & Data Control- Primary - Value/Quantity, Secondary - Call Norms/Productivity, Sale, Contribution, New Dealer Performance, Top 10 Dealer Performance, Poor Performing Dealer, Slow & non-moving Stock, Out standing, Issues, Action Plan, Competitor Activity. Formulation of different required formats. Minutes of Meeting preparation & last month MOM review.
Project support & maintenance of Data - Preparation of Quotations, Tracking & Record maintenance of rate /other data.
Result Orientation - Daily tracking mechanism and follow ups on reports & data has really helped on improvement, Analysis of sale data is an inputs towards Zonal achievement, Tracking of SE-wise secondary data, Formulated & implemented DCR format & guidelines all across Zone, Maintenance of historical data of Zone.
HR support - Assistance in recruitment process, Induction for new employees, Attendance & leave record maintenance as per leave policy.
General Administrative support – Travel & hotel arrangement, general office administration, AMC.
Name of the Company : TLT Engineering India Pvt. Ltd.
Designation : Sales Coordinator
Duration : From Sep2009 to May2012
Responsibilities : Coordination & Communication – with Head Office, Branch Offices (all India, Overseas Principals, Forwarder & Transporter.
Information handling – Branch Offices, Overseas Principals, All Regional Employees.
Tracking & follow-ups - With Branch Offices for offer status.
MIS (preparation, compilation) of all India & Data Control - For Proposals, Sales, Import, price comparison comprising of client enquiry – quotations from overseas principals – offer to client – final order placement to principals.
Documentation – With forwarder for clearance, transporter for despatch of material along with processing of despatch documents.
HR support - Assistance in recruitment process, Attendance & leave record maintenance as per leave policy.
Secretarial support – Travel & hotel arrangement, general office administration, AMC, personal file handling.
Name of the Company : Nilkamal Limited
Furniture Division
Designation : Regional Coordinator
Duration : From Mar2007 to Feb2009
Responsibilities : Coordination & Communication - with Head Office, Branch Manager-Field Force & Depot.
Information handling - Stockists, Depot, All Regional Employees.
Tracking & follow-ups - Reports of Branch Manager-Field Force & Depot for timely submission.
MIS Reporting (preparation, compilation & analysis) of Eastern Zone & Data Control- Primary - Value/Quantity, Secondary - Call Norms/Productivity, Focus/Value Added Product, New Launched Product, KRA Tracking, Realisation, Forecasting, Competitor Activity, Report on ATL / BTL / TTL activity, Assistance in Production Scheduling - Mould movement, Security Deposit - Outstanding, Branch Head’s Action Plan for the month, Minutes of Monthly Meeting implementation, Assistance in Distributor Appointment, Review of poor performing distributor.
Depot Auditing - Physical-System Stock verification, Administration.
HR support - Assistance in recruitment process, Induction for new employees, Attendance & leave record maintenance as per leave policy.
Name of the Company : The Himalaya Drug Company
Consumer Products Division
Designation : Executive - Sales Coordination
Duration : From Apr2000 to Mar2007
Responsibilities : Total coordination internally with Head Office & field people and externally with C&FAs and stockists.
MIS - Various reporting (compilation & analysis) of entire Eastern Region to HO.
Different report track & follow-ups with field force.
Indent compilation & dispatch tracking.
Claim Management (approval / sanction, timely submission, checking-calculation/supporting, track of claims & credit notes).
Induction for new employees.
Documentation & filing of related records.
Data & document control.
Different information handling - stockists, C&FA, all regional employees.
General office administration to run a RSO, assistance in recruitment process, attendance & leave record maintenance as per leave policy, checking of field expenses as per travel policy, stationery distribution, document dispatch - receiving.
Name of the Company : BGS Exports Pvt Ltd
Designation : Project Assistance
Duration : Dec98 to Apr2000
Responsibilities : General secretarial & computer assistance. Coordination & record maintenance for new project.
Name of the Company : Otis Elevator Company (India) Limited
Quality Systems Department
Designation : ISO Coordinator (Temporary Assignment)
Duration : Feb96 to Mar97
Responsibilities : Assistance in ISO9002 Certification of the region. Document & data control for ISO project through computerized system. Coordination of ISO9002 documentation work, Maintaining records.
Name of the Company : The Tata Iron & Steel Company Limited
Personnel Department
Designation : Trainee (On job training)
Duration : Feb95 to Jan96
Responsibilities : Development of software on officers’ promotion & transfer details, employees’ qualification & recruitment process. Exposure on computerized departmental data processing work. Maintaining personnel data records. Assistance in recruitment process. Regular correspondence & filing.
Academic Qualification :
Madhyamik : Under West Bengal Board of Secondary Education in the year 1988 (62.1%)
Higher Secondary : Under West Bengal Council of Higher Secondary Education in the year 1990 (52.3%).
Bachelor Of Science : Under Calcutta University in Botany, Zoology & Physiology in the year 1992 (62.5%).
Professional Qualification :
Computer courses from Industrial Training Institute (Under W. B. Govt), Computer Society of India - Calcutta Chapter, Computer Science & Engg. Department - Jadavpur University.
Operating Systems - DOS, Unix, Windows under Network environment (LAN)
Languages - Basic, C, COBOL
Database - DbaseIII+, Foxbase, Foxpro
Ms-Office (Excel, Word, Power Point)
SAP Operation