Qualification: Graduate
Experience: Minimum 2-4 years of experience in relevant field
Key Responsibilities
1. BASIC WORK
A. Tertiary Sales Changes Analysis
· Changes in Sales (MTD Vs LMTD)
· Changes in Sales (Day To Day Week Changes)
· Focus Models Branch Wise Sales Analysis
B. Stock Report
· Stock Report Segregate & share to branch one by one
C. Primary Sales Report
· RDS, Branch, Model, Price Slab Wise Primary Target Achievement Prepare and Share With Management
· Primary Sales Report Branch Wise Segregate And Share To Branch One By One
· Model wise & top 4 MD wise Primary Data prepare
D. Secondary Sales Report
· RDS, Branch, Dealer, Model, Slab Wise Secondary Target Achievement Prepare and Share With Management
· Secondary Sales Report Branch Wise Segregate and Share To Branch One By One
E. Inventory Trend Chart Prepare
· RDS Stock, Market Stock, Stock WOD %, Stock WOD Count, Sales & Turnover Days Trend Chart Prepare
F. Sale Return
· Sale Return Process From Dealer To RDS Warehouse To Avail the Unavailable Model To Customer
G. Drumbeat Activity
· New Employee Details Updation, Employee Attrition, Promoter Dealer Shuffle, Dealer Creation, Dealer close
H. Alignment Master
· Maintain Manpower & Dealer Alignment Master (It boost smooth sales, reports accuracy)
I. Shopboy Incentive Claim Data
· Shopboy Incentive Claim Data Collect From Branch and Compile and Share To Team
J. Monthly Market Competition Report
· Market Competition Report Collect From Branch and Prepare Dealer, Brand & Model Wise Report
K. Dealer & Manpower Data
· Collect Updated Employee & Dealer Data From Branch And Update Accordingly On V Work Within 5th of Every Month
2. PROJECT WORK
A. Retailer Data Format
· Retailer wise & model wise MTD/LMTD sales data prepare (Delhi HO report)
B. VBA Data Format
· VBA wise & model wise MTD/LMTD sales data prepare (Delhi HO report)
C. VCM Calculation
· Prepare VCM calculation report every month & share to retail department
D. Monthly Dashboard- Growth Analysis
· Store, Channel, TL & Series wise Sales analysis report prepare (Delhi HO report)
E. TL& JTL Productivity
· TL&JTL Productivity report share to Retails team
F. VBA Suffling Data
· Store shuffled VBA's store wise sales analysis (Delhi HO report)
3. OTHER
A. Focus Models Sales Report
· Focus Models Target Vs Achievement Report Prepare
B. Active Model Price List
· Active Model Price List Mapped & Share To Retails Team Every Month
C. Stock Details Share
· Stock Details Share as per requirement
Required Skills:
· Strong knowledge of Microsoft Excel (Advanced Excel preferred)
· Proficiency in Pivot Tables, VLOOKUP/XLOOKUP, IF functions, dashboards, and data analysis
· Strong analytical and numerical skills
· Excellent attention to detail
· Good communication and coordination skills
· Ability to manage multiple reports within strict timelines
· Knowledge of sales reporting and inventory management will be an added advantage
Pay: Up to ₹22,000.00 per month
Work Location: In person
