About

Sawan Kumar Salhotra is a result-oriented professional with over 7 years of experience in the Data Analytics and Business consulting industry. He is currently working as a Team Lead at Eli Lilly Services and is responsible for leading a Commercial Analytics team that provides data-driven actionable insights. His key areas of expertise include Impact Assessment, Marketing Mix Modelling, Segmentation & Targeting, Sales Force Effectiveness(SFE), Project Management, and Team Management. Sawan holds a Post-Graduate Diploma in Sales & Marketing from Institute of Management Technology (IMT), Ghaziabad, and a B.Tech in Electronics & Communication Engineering from G.G.S.I.P.U, Delhi. He possesses knowledge of statistical concepts such as Clustering, Regression, Time Series Modelling, etc. and is proficient in R, Tableau, SAS, SQL, Excel, and PowerPoint along with exposure to Python, SPSS, and PowerBI. In his previous role at Eli Lilly Services India Pvt. Ltd., Sawan led projects related to impact assessment, market research, business intelligence, marketing mix modeling, and sales force effectiveness. He also mentored resources to reach their full potential and build expertise in pharmaceutical analytics. He spearheaded the project on segmentation and targeting to help identify key customers and save salesforce effort. He evaluated resource deployment amidst current products’ lifecycles, new indications, competitive launches, and internal pipeline considerations. He was responsible for setting up the PLD database in SQL and creating a tableau dashboard for performance summaries. He used patient prescription data along with extensive business rules to synthesize patient treatment journeys and measured the impact of different price points on consumer purchasing behaviors by using loess smoothing. Prior to Eli Lilly Services, Sawan worked with ZS Associates as an Associate Business Consultant. He handled a team of eight resources and led projects related to impact assessment, market research, business intelligence, marketing mix modeling, and sales force effectiveness. He assessed the impact of various promotional activities and allocation of budget across various channels. He analyzed and recommended options for distributing calls based on profitability and influence score. He integrated customer perceptions from primary market research data with their behavior from secondary data to understand drivers of growth. Sawan is a Data Science Enthusiast and possesses relevant experience of 9.87 years. He is a strategic thinker with excellent analytical and creative skills. He has worked for varied clients i.e. pharmaceutical giants, e-commerce giants, and multinational technology companies specializing in internet-related services and products.