Rajesh Khatri

Business Intelligence professional enabling online sales growth through data-driven insights and automation. Specializes in sales data analysis, demand forecasting, and building dashboards to enhance visibility and decision-making across e-commerce and marketplace channels. Key focus areas: ✅ Online sales tracking and reporting ✅ Demand forecasting and inventory planning ✅ Marketplace sales trend analysis ✅ Data-backed strategies to boost conversion ✅ Collaboration with sales and operations teams

• Managing E-commerce business for Beetel, FLiX & Philips-Feature Phone for outright Amazon/Flipkart/Myntra), Marketplace (Tatacliq /Snapdeal etc.), B2B online (Udaan/Amazon business). • Order Fulfillment & Online Store Operations - Supply Chain, Inventory Management, Invoicing on AVC • P&L and ROI - Demand planning & forecasting, revenue forecasting & generation, budgeting, cost of operation • Fortnightly and Weekly inventory forecast and planning. • Catalog management : o Complete listing on all E-commerce platforms o Rich Content (A+/RPD)

• Evaluation of Primary, Secondary and Tertiary Trend and Employees past performance • Preparing & Analyzing Channel & National Dashboards formats – Daily, fortnightly and Weekly • Analysis of channel reports and reviewing with the Business heads • Conducting Zonal, regional reviews and ensuring all Minutes of the meeting are closed within timelines • Building and implementing Sales Polices and Processes like Price Protection policy, Margin structures and Infiltration policy • Preparing National reports for the Top management • Execution/ Monitoring of the sales incentive/ schemes based on the performance and target achievement • Preparing and implementing the Distribution and retail schemes within the budgets • Ensuring all schemes are closed and credit notes are issued within the time frame • Implementing of special programs like Distributor/ Retail meets, loyalty programs

• Managing entire backend data management system related to stock procurement, Sales, Customer services related to DOA/DAP, Claims, Invoicing & various reports • Facilitate Business team in generating reports related to Inventory management, Stock transfer and aging stock. • Validation of IMEI Activation of channel partners and keep track of Primary, Secondary and tertiary, • Channel claim making, validation and provide solution to partners for any discrepancies in claims. • Manage invoicing to channel partner in close co-ordination with Finance and logistic team • Reports directly to Sales Head and Business manager; generate standard reports to Beetel Teletech Ltd. & Lenovo on daily and weekly basis • Channelize regular follow-ups with sales team on their sales target’s achievement/balance plan on daily and weekly basis, regular business follow-ups with partners through assigned Sales Co-coordinator.

• Prepare Daily/Weekly/Monthly retention and collection Dashboard of Airtel/Tata Telecom • Take care of receipt reconciliation process • Annexure management to deposit & tracking the cash collected from customers • To resolve the day to day customer escalation with coordination of principles • To accomplish the audit requirements of principles • Allocation distribution at tele calling & FOS level • Feedback capturing & sharing with principles on daily basis • Preparation of data for reviewing the all portfolios time to time

• Responsible for various kinds of reports related to Retention and Collection. • Share recovery dashboard for both LOB (Mobility &Telemedia) with all respective recovery agencies Managers • Preparation of all presentations and data analysis for management required & decision making. • Preparing of Collection, Bad Debt & Churn Dashboard on Daily Basis with LMTD comparison. • Coordinating between circle and shared service center at Chennai for Exposure, Dunning & FMS. • Retaining customers by promptly solving customer complaints with the assistance of the other departments. • Special Exposure, Dunning monitoring on Solitaire customer. • Daily TBS (TO BE SUSPEND) analysis as per Shared service center data and shared with all respective team • Facilitating all vendors’ backend activities like billing, reconciliation, payouts, audit. • Responsible to calculate prepare & roll out bucket wise collection agencies payouts on monthly basis. • Manage To coordinate with vendor help desk to resolve payout related queries. • Responsible to prepare bucket/Process wise provisioning of agencies payouts on monthly basis. • Taking care of online PR/PO creation & approval process for all vendors by coordinating with SCM & Finance.

• Team leader & leading a team of 20 members for auditing. • Validating, provisioning, documentation and activation of postpaid connection • Data processing & maintaining MIS reports. • Making debit notes & reversals. • Coordinating with audit team & different department team members. • Checking of Active No.’s status in software for complete activation. • Subscriber Enrollment Form tracing. • Providing total support, in terms of back office & field visits