Pankaj Kaushik

Experience

• 

  Mercer

  Oct 2007 - Apr 2010

  Marketing analyst

  -in mercer i was administrating all india marketing data over marketing crm tool siebel.i was responsible for co-ordinating with oversease team for smooth functioning of siebel system in india• reporting of trends and analysis on the crm database, along with key proposals, top wins, top losses (with reasons) - for weekly sales reviews for each service line• revenue, profitability, sales pipeline analysis, with exposure to forecasting, budgeting and variance analysis• management reporting and preparing advanced analytics dashboards on pre-decided intervals.• marketing data on seibel (m-drive) for all over india.• analysis based on key performance indicators• work closely with business head to provide analytical support• maintaining historical database for all the projects• guiding staff for effective functioning on seibel is one of another responsibility. • generating mis for marketing and consultants team using excel and power point• maintaining data consistency in centralize database.• coordinating with overseas team for suitable updation on seibel.• marketing campaign management using exact target • provided content management support on mercer college cms site• align with mercer college (enterprise executive training program) and was co-ordinator for the mercer college events.• adhoc reporting show less

• 

  Accenture

  Apr 2010 - Sept 2012

  Research analyst

  i was part of database and web technology service area in accenture’s marketing and communications team, i was primarily working in the field of market research, swot analysis, report building using sfdc,microsoft packages and organisation own tool.• primary and secondary research on data. extensive internet searches to ensure that data is resolving with quality. • worked on assignments for high level branding & networking projects for the company across the globe.• review,preparation and analysis of cost center level capex.• maintain all necessary record keeping for tracking, expediting and communication of status of projects.• quality checking of the work done by assigned team. taking one-o-one sessions of individual team members of assigned team to give suggestion/feedback/updates from client side. • work closely with marketing team to devise relationship campaigns and then design segment based targeted programs• work closely with marketing team to devise relationship campaigns and then design segment based targeted programs• design, deployment and reporting of online marketing campaigns for clients. consulting - crm , marketing automation systems and email marketing tools.• develop dashboards that provide insights and visualization• presentation work for clients and participate in various activities of communication and marketing• client account management salesforce.com show less

• 

  Tata communications

  Sept 2012 - Mar 2018

  providing analytical support to sales and business operation team. managing cross functional activities and relationships, including but not limited to crm in information systems but also to address various escalation and issue resolution for global business operations cutting across sales processes.• analyse and working on data (business performance data like rfp volumes, booked revenues basis regions and products etc.) to bring out insights that will help sales in pitching the right products in the relevant markets. • design, develop and deploy strategic program plans and functional requirements for sales effectiveness and sales transformation programs covering entire quote to cash cycle.• create and maintain project plans for program initiatives. develop and document comprehensive measurement and success criteria.• support the control and change management team, working with business and functional units to identify high-impact operational improvement opportunities.• produces daily, weekly, monthly, quarterly reports and/or interactive “dashboards” using advance excel (vba), birst powerpoint, etc. • work closely with sales team to devise relationship campaigns and then design segment based targeted programs. guide sales, account & product managers to create, customize and automate reports that help the business leaders to make informed decisions. show less a data visualization expert with extensive experience in building business interactive dashboards using tableau and ms excel/vba for effective decision making.• mine data and analytics at the rider level to gain a better understanding of their usage behaviors, including impacts on various cem strategies• analyse digital data as well as offline data to monitor applications (customer service portal) performance (e.g. customer experience, customer engagement, customer adoption, customer demographics & trends, etc.).• social media engagement analysis for internal stakeholders from various departments that comprises members engagement, post published and active groups reporting. • produces daily, weekly, monthly, quarterly reports and/or interactive “dashboards” using advance excel, tableau powerpoint, etc. • customer experience survey analysis using sfdc, ms excel and statistics and program manage csat findings for process improvements. • work closely with marketing team to devise relationship campaigns and then design segment based targeted programs. leading the customer digitization journey to ensure industry’s best customer experience.• working with marketing, sales & product managers to create, customize and automate reports that help the business leaders to make informed decisions.• track customer interactions and crunch the data to understand individual customer behaviour and measure the effects of manipulating journey variables.• develop dashboards that provide insights and visualization into rider and channel performance related to kpis, projections, and historical performance.• implement and analyse a/b or multi-variate tests to provide in-depth insights to the cem team• analyse and drive csat findings for improvements and working with key stakeholder internally to mitigate customer pain areas and program manage this cycle end to end show less

• 

  Valvoline Cummins Ltd

  Mar 2018 - Apr 2023

  Manager - rtm strategy and analytics

  handing the sales enablement and business intelligence unit fororganisation and providing channel sales strategical support forupbringing excellence in business operation. managing crossfunctional activities and relationships, including but not limited to thedistribution management system and crm, and addressing variousescalations and conflict resolution for global business operationscutting across retail sales processes.

• 

  Valvoline Cummins Pvt Ltd India

  Apr 2023 - now

  Sr manager rtm strategy and analytics