Sales Admin Officer

FALGUNI PANJA E-mail: ************@*****.***

Contact: +919*********

Resume Headline

Exposure of more then 12+ years’ experience in sales Co-ordination & MIS preparation, Planning, Data analysis, Business Analyst ( ACN data analysis), HR support, Accounting(MIS), Data Management, Report generation, Internal Audit,Data sharing, Operation Support,Report Dashboard & Team Support in FMCG industry.

Professional Experience

Company Name

Britannia Industry

Type Of Job

Sales Admin Officer

Responsibility

Reporting, Sales-MIS, Accounting (Claims & Damage), Nielsen Data.

Work Tenure

5th Aug 2019 – Till Now

Work Profile

Sales MIS

Daily Primary & Secondary Report

Prepared report for Area Head concall (Primary Trend, Secondary Trend & ECO Chanel Wise).

District Cluster Report (Primary & Secondary)

Budget Vs Actual (KRA: primary/SND KPI/Secondary/Shares)

Daily & Biscuit Daily Depot wise Phasing

Dairy Stock Follow up

Nielsen Report (MS, ND WD, STR)

Distributor PDP Update

Dairy Sales Follow up

Dairy Field Incentives Tracker

Dairy MIS

Dairy Trend line.

Biscuit Trend line.

Financials

Bhutan Collection and claims.

Damage Analysis

Finance hygiene

Month end Credit proposals

Company Name

Kellogg India Private Limited

Type Of Job

Region MIS Officer

Responsibility

Reporting, Sales-MIS, Accounting (Claims & Damage), Marketing MIS

Work Tenure

9th JAN 2017 – 31st July-2019

Work Profile

Sales MIS

Dally Primary flash.

Dally Focus brand & new launch SKU Primary, Secondary & Distribution update.

KPI Update – Update KPI (Mandays, Bills cut, LPC, Active store, distribution) Distributor & Sales Man Wise.

Sales man incentive – Target sating & payout calculation.

Distributor incentive (Vijeta) Primary & Secondary update.

SO wise primary and secondary update.

Program outlet (Invested Store) Target Vs Achievement update.

Target stating for Invested stores (Kellogg Premier Club, Udaan, Bandhan)

Stock norm for distributor quarterly.

Sales MIS-Report as per requirement by RSM & RTM.

Claims Accounting

Manual claims:

Manual claims Verify and book PO in oracle.

Create invoice in Oracle.

Send to third party vender for payment.

Online claims:

Verify and check PO value & Forum-Disha Value.

Follow-up with ASM to send online claim approval mail.

Prepare MIS for online claim and send to third party vender for payment.

Damage Claim

Share Audit date with third party auditor.

Follow-up with ASM to share audit stock summary report (Distributor wise).

Verify Soft copy and Hard copy audit report.

Send audit claim to third party vender for payment.

Professional Experience

Company Name

BIO Veda Action Research Company

Type Of Job

Region MIS Officer

Line of Business

FMCG ( Ayurveda Skin Care & Hair Care )

Responsibility

Reporting, Sales-MIS, Logistic MIS,HR MIS & Marketing MIS

Work Tenure

10th Feb 2014 – Till Now

Work Profile

HR MIS

Send daily attendance of branch employees to H.O. Coordinate HR related issue with HO.

Sales MIS

Daily- Primary sales update, Secondary sales update and follow up with sales team for daily progression. Circulate day wise balance to do plan to sales team for achieving target and monitor the sales progress. Brand Staff (BA-Beauty Adviser) wise store offtake update and follow up.

Monthly: Collect Brand Staff (BA) stores sales book & Brand Staff (BA) stores Picture and send to HO for Brand Staff (BA) salary. Compile Brand Staff (BA) salary file and send to HO. Brand Staff (BA) Store cost to sale calculation and provide updated status to sales team.

Logistic MIS

Sales Plan- CFA wise & SKU wise sales forecasting.

Daily report – CFA wise closing stock update & CFA wise In Transit stock follow up.

Monthly: CFA physical stock Audit.

Commercial MIS

Maintain display budget file for Brand staff & Non Brand staff store. Check distributor claims & send to HO. Field force travel expanse check & send to HO

Marketing MIS

Monthly promo budget calculation & cost to sales calculation. Prepare power point presentation & excel report for weekly review meeting.

Previous Company Details:

Company Name

Genius Consultants.

Associated with

COLGATE-PALMOLIVE (INDIA) LTD.

Type Of Job

MIS – Trade Marketing

Line of Business

FMCG

Work Tenure

Aug 2005 – 8th Feb 2014.

Work Profile

REPORTING – MIS

Weekly

Monthly

Regional Report

Branch report

Business Tracking report (STT-Secondary Sales) status to BM, RMCD, AMCD. Drafting Circular and Promo Circular for Business Promotion (Mail Merge-MS Word).Creating circulars in PDF format and uploading in Office Web Space. Formatting various managerial informative reports in MS Excel from CPS( Primary Sales) & STT(Secondary Sales)

Payout Calculation –

STEP, PSR, STL, HN1, VSR: Take suggested parameter of M1 by 21st in M0 from RM and sharing the relevant working file with AM’s, collecting TGT from AM's and compiled. Payout calculation to be done on next month on 6th & 7th and shared with every month to AM's. After confirm payout calculation by AMCD then send to Accounts for processing.

OCC Payout Calculation: Payout Calculation & Sharing with field team. Highlight the exponential growth and wrong RE classification stores.

Visibility Payout Calculation: Visibility allocation working related to these RE's and channel. POP allocation and POP code details to be shared with logistic for timely POP dispatch. After complete the activity Visibility payout calculated in RE wise and share with field team. AMCD confirm Payout calculation and send to IT for uploading in DMS.

Rate Tracker –

Price tracker to be shared with HO of key brand / SKU’s. CP price list upload in office web space.

AC Nielsen – MIS

Create & Update Monthly AC Nielsen dashboard. Preparing Market Share Power Point Presentation for Branch Manager, RMCD, SDM for Meet At HO, activation Meet, Goal-aliment, Branch Meet, AC Nielsen Meet & Stockist Meet.

Promo Budget Calculation

Calculation Activity Promo budget for the current month and send to BFM for IO create getting after approval of SDM.

Academic Qualification:

Examination

Year

Board / University

Institutions / College

Stream

Secondary (Std X)

1993

W.B.B.S.E

Burdwan Ramkrishna Saradapith High School

General

Higher Secondary (Std X+II)

1995

W.B.C.H.S.E

Burdwan Raj School.

Science

Graduation

2000

Burdwan University

Bolpur Collage.

Science

Post Graduate Degree

Masters In Information technology (MSC IT)

University

Sikkim - Manipal University.

Year of Passing

Sept-2004

Personal Particulars:

Permanent Address

56, Banerjee Para Street

O.P- Uttarpara, P.S- Uttarpara Dist-Hooghly, PIN-712258

Telephone

Mobile - +919*********

Permanent Address

76-B D.D.TEWARI ROAD

Kothal hart, Burdwan,

Pin-713102

Parents Name

Mr. Uday Chand Panja

Mrs. Suniti Panja

Date of Birth

4 Nov 1977

Nationality

Indian

Blood group

B+(ve’)

Hobbies: listening music, enjoying with kids.

Place:Kolkata

Date Falguni Panja

Contact this candidate