Karan Bajaj

• Company Overview: E-commerce logistics
• Defined and led scorecard dashboards for area managers and hub leads to improve operations on KPIs such as productivity, waiting time, etc. Built and managed the entire data pipeline and dashboards on Data Suite
• Created inbound volume forecast models for hubs to plan the last-mile riders and manage the operations efficiently
• Developed a network planning model for last-mile riders using operations research to reduce travel time, thereby saving on operational costs

• Company Overview: E-commerce customer experience
• Worked as the analytics lead with Flipkart’s customer experience team to track and improve NPS across various customer journey nodes. Set up multiple Power BI dashboards for different journey nodes
• Generated insights to drive improved NPS across different journey nodes and provided recommendations to leadership
• Built a regression model to forecast NPS for the delivery node and to understand its key drivers

Pharma sales improvement:

• The client aimed to improve profitability for pharma sales in a business unit
• Established various models for leadership, defined and tracked KPIs related to sales representatives’ performance

Sales rep attrition:

• The client faced a 40% sales representative attrition rate
• Developed a random forest model to predict the employees likely to attrite within the next 3 months
• The model captured 70% of employees likely to attrite by flagging only 15% of employees

Manufacturing plant performance optimization:

• Created a linear search optimizer to allocate contractors to different tasks based on their skillsets, improving both cost-efficiency and overall performance
• Improved profitability by nearly 10% for the client by the second month after the optimizer was adopted

Marketing Mix Modeling:

• Assisted a U.S.-based telecom client in designing a customized targeting plan for their customer base
• Developed a marketing mix model (conjoint simulator) to understand customer preferences for different telecom plans and related attributes
• The client was able to offer customized discounts, perform targeted marketing, and design tailored telecom plans based on customer needs

• Company Overview: Data science consulting

Billing anomaly:

• The client faced legal issues due to overbilling and required a framework to reduce manual audit work
• Proposed a framework based on hypotheses—extreme rates for any product may indicate anomalies, infrequently occurring rates may be anomalies, and negative or zero rates may signal anomalies
• Delivered an automated VBA tool that captured more than 80% of billing errors

Staffing optimization:

• The client experienced poor customer satisfaction across its 2,000 retail stores in the U.S
• Developed a model to predict the number of employees required at each store, taking into account factors such as customer traffic, store size, and sales
• After piloting the model, the client improved its customer experience rating from 6 to 7.5 on a 10-point scale

Supply Chain Management:

• The client incurred significant losses due to poor inventory management, with millions of dollars worth of inventory stranded across its stores
• Provided both short-term and long-term actionable insights to enhance inventory management