OPS GURU DATA SUBMISSION

Process Overview

Field	Description
Process Name	Ops Guru data submission
Segment	SMB
Process Family:	Lenovo India
Process User(s):	Wyzmindz solutions pvt ltd
Process Purpose:	This report is instrumental in providing actionable insights, tracking performance, and supporting Lenovo’s sales strategies

Version history

Version Tag	Prepared By	Date of Update/Revision	Reviewed by	Approved by	Revision Details
V 1.0	Sanjay Gowda	12-12-2025	Sushruth Vasista	Vishwanath Mosale	SOP Document Creation

Distribution & Access List

Designation	Read	Write	Approval
Analyst	Yes	No	No
Team Lead	Yes	Yes	No
Manager	Yes	Yes	Yes

1.1 Purpose

The OPS Guru Data Publish process is designed to consolidate, standardize, and prepare SMB sell-through, sell-out, and inventory ageing data for analytical consumption. The primary purpose of this process is to provide a summarized and reliable overview of SMB sales performance by converting multiple source reports into clean, structured CSV datasets.

1.2 Scope

• Geographic Scope: India.
• Business Segment: SMB Segment
• Process Frequency: Everyday
• Key Distributors Covered: PAM, ISR & CM

1.3 Business/Segment Overview

This process supports Lenovo India’s SMB analytics ecosystem by integrating data from key operational reports such as overall sell-through, daily sell-out, and T1 ageing inventory. Managed by the MIS and reporting teams, the activity involves data cleansing, master data mapping, validation, and formatting to create analysis-ready datasets. The finalized files are shared with the analytics team for further processing in OPS Guru and related tools.

1.4 Responsibility and authority

• Analyst: Sanjay Gowda
• Process Owner: Nadeem Budihal
• Process Manager: Dayanand U
• Approval authority: Vishwanath Mosale

1.5 Escalation matrix: (Wyzmindz and Lenovo)

Escalation Matrix - Wyzmindz Solutions Private Ltd

Level	Name	Designation	Mail
1	Sushruth Vasista	Manager	sushruth.vasista@wyzmindz.com
2	Vishwanath Mosale	Director	vishwanath.mosale@wyzmindz.com

Escalation Matrix – Lenovo india Private Ltd

Level	Name	Designation	Mail
1	Marlene Pinto	Manager	mpinto4@lenovo.com

1.6 RACI Matrix

RACI Matrix – WyzMindz Solutions Pvt Ltd India

Report / Process	Responsible	Accountable	Consultation	Informed
Ops Guru data submission	Sanjay Gowda	Sanjay Gowda	Dayanand. U	Lenovo Ind Pvt Ltd, Wyzmindz Solutions pvt Ltd India

1.7 Legends

• “SMB Overall Sell Thru Report Date”

• “Daily SM Sell Out DSR Date”

• “SMB T1 Ageing Date”

1.8 Access Required

• Outlook & Webmail Access
• Access to it.irainbow@wyzmindz.com Mails (to get latest DSR’s)

1.9 Flow Chart

1.10 Process Description:

• 1.10.1 Open the “SMB Overall Sell Thru Report” report which we publish from SMBOPS mail ID.
• 1.10.2 Delete all sheets except Data sheet.
• 1.10.3 Save it in CSV format in a file named “Data Sellthru Q*”
• 1.10.4 Open the “Daily SM Sell Out DSR” report which we publish from SMBOPS mail ID.
• 1.10.5 Delete all sheets except Data sheet.
• 1.10.6 Save it in CSV format in a file named “Data Sellout Q*”
• 1.10.7 Open MTM MASTER LEMB file.
• 1.10.8 Open the “SMB T1 Ageing” report which we publish from SMBOPS mail ID.
• 1.10.9 Delete all sheets except Data sheet.
• 1.10.10 Save it in CSV format in a file named “SMB Inventory”
• 1.10.11 Add them in a folder
• 1.10.12 Share it with Manikandan on Zulip.