•Leading a group of 15 across Pharmaceutical and Consumer Healthcare domain to cater to Sales Force Effectiveness projects such as Segmentation and Targeting, Resource Optimization, Sizing and Structuring, Field Force diagnostics, Deep dive, Portfolio prioritization, multichannel resourcing and budgeting, etc. for a top UK pharmaceutical company•Leading the service offering of Segmentation & Targeting across EU and EMAP markets•Recruit and up-skill the team to be able to understand business requirements and to be able to deliver with utmost quality within the agreed timelines•Maintaining the MIS report for the team and sharing with onshore team to plan out the pipeline projects•Building capabilities within team based on industry evolution to be able to cater to latest methodologies and solutions•Training the team on Advance Excel, VBA and SQL to be able to design automated solutions for sales force •Fortnightly update over teleconferences and video conferences to above country team on project progress•Providing support on conducting workshops offshore and remotely with stakeholders on strategic project

•Understanding onshore team requirements for the design and functionality of the software•Designing and developing the PCRS (Portfolio Company Reporting System) using Excel/VBA/SQL•Unit test the application, debug and maintenance of the application for timely and smooth transition to onshore

•Analyzing secondary research information available online by extracting via setting up the web crawling tool•Evaluating the information and run a comparative analysis for our competitors to find the gaps in our offerings•Reporting on daily, weekly and monthly basis for providing the update and progress on key KPIs