Ranjit Rane

Scope of outlets for Dashboards & Presentations:-

Total Retailers > 1.60 Lac

Franchise Stores - 600

Key Result Areas:

1. Creation of Daily Sales Dashboard (FTD/MTD) as per below metrics,

• WOD/Order Items/Value.
• State/Area/JMDL/JMDO wise.
• Category wise

2. GT Retailers/Franchise Onboarding Journey,

• Presenting Daily dashboard highlighting the status of each onboarding process - Department wise(Finance/Marketing /Operations)
• Manpower Performance Tracker - Highlights the target vs achievement data of the Manpower deployed across Geography

3. Sales /Onboarding Incentives,

• Daily Publish, Sales and Onboarding Incentive Dashboards to Field teams.

4) Adhoc Reports:

• Prepare and Publish ADHOC Reports with Key insights for the Head Office Leadership team to analyze the Regional Team Performance which helps them to take corrective decisions and prepare action Plans accordingly.

`5) Retailer - Manpower Mapping :

• Ensure accurate retailer to Manpower mapping based on monthly targets.

6) Sales Assist / Beat Mapping / Attendance Field Resource App:

• Creating and ensuring correct manpower hierarchy and retailer mapping is uploaded in internal company app, which helps the regional teams across geography to assign Beat(Store visit Schedule) to their subordinates, Punch attendance and analayse retailers and subordinate wise real time performance.

• Preparing and Publishing below Reports to all the HOD'S of Tata Croma . This reports are related to 200 plus Tata Croma Stores and Ecom channels

1. Sales Report/Sales Dashboard( Daily/Weekly/Monthly)

2. Markdown Report.(Daily & Monthly)

3. Bundle SKU/Attach SKU Offer Analysis(Weekly)

4. KYBM Report (Key Brand Merchandise Report)(Monthly)

5. Markdown Analysis (PPT) (Monthly)

6. Buying Update (PPT)

• Preparing Business Reports (Monthly/Weekly) of 1100 Jio Centres, 6000 Jio Points, 1800 Jio Stores,08 Regional Call Centres & 2 Verification Centers
• Providing Security Manpower Cost Analysis to Management by creating various combinations of Security Personnel across Pan India Jio Centre's/City Offices/Regional Call Center's& Verification Center's as & whenever required
• Preparing & Providing Security Manpower Budget to Finance for raising Work Orders.
• Providing support to GM Operations in ensuring smooth functioning of Business Operations across PAN India Centre's.
• Resolving Issues related to Data & other queries raised by Regional/State/Area Heads.
• Doing on-going RCA (Root Cause Analysis) on various business issues & providing the analysis report to Regional/State/Area Heads.
• Training of Area Managers across Pan India on Data Management in SCRUM Software .
• Managing Data of 2000+ Security Personnel across Pan India in SCRUM Software.

1. MIS Sales Report :

• Budget v/s Actual Sales Achievement
• YOY Sales Growth
• Net Sales per sq.ft
• Category-wise/Store-wise Performance
• Discrepancies/Wastages
• Payment mode trend
• Stock Report
• Gross Margin
• RTV
• Sampling

2. Margins/Inventory :

• Reporting Monthly Margins Sending SKU-Wise List of Major losing Category and Follow up with stores for feedbacks
• Follow up with stores for completing Purchase & RTV entries
• Follow up with ISD Team to upload sales ontime
• Preparing Closing Stock File of active SKUs for respective locations
• Final Valuation Of Actual Closing Stock after correction given by all stores
• Sending file of Expired and damaged stock reported by stores for writing off from the system
• Book Stock v/s Actual Stock variance analysis
• Follow up with ISD Team for adjusting Approved Wastages/Shrinkages

3. Stock Analysis:

• Fast Moving/Slow Moving/Non Moving SKUs
• Other analysis as required by management
• Stock in Transit: Monitoring completion of stock in transit entries
• GR_IR: Monitoring completion of purchase entries.

4 . PPTs:(Power Point Presentation)

• Monthly Review Presentations for BOD Meetings.

• Handling 56 Clients (IT/ Telecom/ Manufacturing)
• Major Clients –Textron, GE Group, Rambus Chip
• Maintaining Insurance Premium Details
• Checking and Updating Endorsements in the System
• Addition /Deletion of Lives in the System
• Updating Corrections of Lives In the System
• Reconciliation Of Reports (Identifying Correction In Count of Lives and their respective data)
• Generating Reports as needed by the Insurer
• Generating TAC (Tariff Advisory Committee) Report for all 56 Clients(Weekly/Monthly)

1. Business Operations:

• Handled Pan India Collections (Staffing & Facility Management Service Division)
• Follow-up with PAN India RM's for Collections of Outstanding Invoices (Funding & Non Funding).
• Getting details from RM's for unidentified amount received in the company's accounts.
• Ensuring on time release of the salaries (Staffing & Facility Management clients).
• Daily Co-ordination with internal Client Service & Payroll team for the process of raising invoices

• Preparation of Outstanding Reports RM wise segregating the funding & non funding cases
• Preparation of reports for salaries not released/ Operational Committee Reports(Monthly)

Market Research:

• Collection of Database from Consumers
• Collating the collected Information and presenting it to the Field Controller
• Tele-calling & gathering information on various products from the consumers