Sandeep Jaiswal Email and Phone Number

Develop Analytical Segmentation ModelResource OptimizationTerritory AlignmentDashboard Development and MaintenanceReports AutomationCaproate / Individual Training on Business Analytics with Power Bi and Advanced Excel

Strategic Planning:-• Developed Customer Segmentation models for existing and new launch products• Recommended optimal sales force sizing with maximum ROI • Designed Territory and Territory Alignment to balance workload and potential • Developed effective Call Plan and managed Call Plan adjudication• Set realistic sales quota (Top Down and Bottom Up approach)• Designed Incentive Plan which motivates the Field force and managed Incentive calculation and disbursementAdvanced Analytics:-• Developed Interactive SFE dashboard to monitor the productivity of sales force by integration of PowerBI and CRM tool which got refreshed automatically every day • Developed statistical models that relate marketing and sales activities to results and generate decision enabling insights and Territory action plan• Developed transparent analytics and ensure KPI standards are realistic• Identified new opportunities through Gap Analysis • Analysed Competitive pricing to regulate the competition • Developed Statistical Forecast Models• Managed Primary and Secondary Sales Crediting• Have hands on experience in IMS Data sets and Tools (MIDAS, IAM, Dataview)Automation:-• Automated long and repetitive reports / dashboards by using VBA Macro.• Automated Business Review PresentationSFA/CRM:-• Implemented I-pad, mobile and web based SFA tool (MyDay, Salesforce.com) • Optimized sales processes and define the optimal workflow • Integrated sales and marketing strategies with business process• Trained new and existing sales force on SFA and develop all training materials• Managed queries of sales force and provided solution to them regarding the DCR

Strategic Planning:-• Developed Customer Segmentation models for existing and new launch products• Recommended optimal sales force sizing with maximum ROI • Designed Territory and Territory Alignment to balance workload and potential • Developed effective Call Plan and managed Call Plan adjudication• Set realistic sales quota (Top Down and Bottom Up approach)• Designed Incentive Plan which motivates the Field force and managed Incentive calculation and disbursementAdvanced Analytics:-• Developed Interactive SFE dashboard to monitor the productivity of sales force by integration of PowerBI and CRM tool which got refreshed automatically every day • Developed statistical models that relate marketing and sales activities to results and generate decision enabling insights and Territory action plan• Developed transparent analytics and ensure KPI standards are realistic• Identified new opportunities through Gap Analysis • Analysed Competitive pricing to regulate the competition • Developed Statistical Forecast Models• Managed Primary and Secondary Sales Crediting• Have hands on experience in IMS Data sets and Tools (MIDAS, IAM, Dataview)Automation:-• Automated long and repetitive reports / dashboards by using VBA Macro.• Automated Business Review PresentationSFA/CRM:-• Implemented I-pad, mobile and web based SFA tool (MyDay, Salesforce.com) • Optimized sales processes and define the optimal workflow • Integrated sales and marketing strategies with business process• Trained new and existing sales force on SFA and develop all training materials• Managed queries of sales force and provided solution to them regarding the DCR

Sales Automation • Implement I-pad, mobile and web based SFA tool (MyDay, Salesforce.com)• Optimize sales processes and define the optimal workflow • Integrate sales and marketing strategies with business process• Train new and existing sales force on SFA and develop all training materials• Handling queries of sales force and provide solution to them regarding the DCR Business Analytics • Develop dashboards / reports to monitor the productivity of sales force• Develop transparent analytics and ensure KPI standards are realistic• Analyse sales and sales activities and recommend territory action plan• Identifying new opportunities through Gap Analysis • Analyse Competitive pricing to regulate the competition • Conduct market research to understand market dynamics and competition• Primary and Secondary Sales CreditingStrategic Planning • Develop Go-to-Market strategies for new launches • Develop Customer Segmentation models for existing and new launch products• Recommend optimal sales force sizing and their structure• Design Territory and Territory Alignment to balance workload and potential • Develop effective Call Plan and manage Call Plan adjudication• Develop Sales forecast model (Regression analysis)• Set realistic sales quota (Top Down and Bottom Up approach)• Develop and implement robust Incentive plan Project Management • Collaborate with cross functional teams for Budget planning• Collaborate with BD team for Portfolio Planning and new launches

• Supported in driving Sales Force Effectiveness towards improving the productivity of Sales Force.• Supported in Implementation of CRM (SFDC).• Looked at basic customization in the CRM based on Business needs that arise with time.• Provided CRM training to new and existing users and develop all required training materials.• Supported in Solving Queries related to DCR/CRM.• Market Segmentation and Targeting• Computation of Incentive as per the plan• Provided Analytical Support to BUs

• Supported in driving Sales Force Effectiveness • Provided Analytical Support to BUs • Published MIS and Dashboard• Managed the large database of Customer, supported in Updating of Customer List on OnDemand CRM.• Supported in Solving Queries related to DCR.

• Took Care of all data gathering as per requirement• Published MIS and Dashboard• Coordinated with stakeholders for data gathering.