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 : ac9nb6@r.postjobfree.com 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

Contact this candidate