Sanjay Patel Email & Phone Number

Mumbai, Maharashtra, India

Led a high-performing team of analysts in developing cutting-edge analytics to drive business growth and operational efficiency.Spearheaded the implementation of Veeva CRM integration across various modules based on organizational requirements, streamlining sales processes and enhancing customer relationship management.Developed robust budgeting models and forecasting techniques to optimize resource allocation.Led market analysis initiatives using advanced datasets and tools from agencies such as IQVIA, AWACS, CMARC, and SMSRC, providing actionable insights to support strategic decision-making.Collaborated with cross-functional teams to define key performance indicators (KPIs) and develop dashboards for real-time monitoring of business metrics.Managed initiatives that required extensive market research and competitive analysis to identify growth opportunities and assist with product development strategies.Participated in corporate social responsibility (CSR) activities organized by the company to support societal improvements in education and basic amenities.

Mumbai

Partnered with leadership team to give trends, dashboard, new product analytics pertaining to Indian pharma market as well as Nepal and Sri LankaFacilitated competitive benchmarking, inventory analytics, gap analysis, and new product analytics for the company's senior management team, in addition partnered with commercial teams to provide insights on competitive benchmarking at the national, regional, and city levels which helped decide fair targets for field teams New opportunities: A proactive identification of prospects in therapies, new products, and existing products, as well as the delivery of insights through different data sets of IQVIA Sales, Rx, and Internal data, all in partnership with colleagues from finance and the business team.The brand team and I collaborated on ideas for geographic improvements, brainstormed, and compared multiple statistics to find the source of the problem. Contributed to the beneficial growth of the brandProjects in partnership with the IT team, I oversaw several projects using QlikView and Power BI data visualization. Developed a self-service application for the commercial teams that decreased their reliance on queries by 80% and led initiatives to automate IQVIA and internal data in Power BI.Increase the number of people using QlikView and Power BI dashboards by 60% by holding training sessions and practical project-based workshops that reduced reliance on data queries by 80%Using data from IQVIA, AWACS, and SMSRC, I authored over twenty-five insight letters covering therapy, brands, new products, and competitionBy utilizing SNA (Sub National Audit) data at the patch level, we were able to create Excel and Power BI dashboards to support and uncover brand potential in various parts of our cities.

Mumbai

Provided analysis (Internal & External) and analytical support to Sr. Management & Commercial teams.Strongly bound with commercial teams in their strategic decisions & KPI tracking.Supported MD office in requirement of analytical support regularly.One point contact for external teams pertaining to various subscriptions as well as PMR.Worked closely for MD office related analysis & requirements.Conducted PMRs through outside agencies and maintain company SOPs in line with internal requirements & final objective.Responsible for regular release of Analysis/MIS pertaining to commercial teams.Expertise in IQVIA/IMS, SMSRC, CMARC & AIOCD AWACS data & analytics.Key Projects: Portfolio Council, Audit Finalization, Workshop for product management team on awareness of analysis & data & Insights, Competitive intelligence.

Designed and monitored primary market research surveys through third parties with necessarycompliance and SOPs of various cross functional teams.Timely supported domestic marketing, senior leadership team and international teams on variousdashboards, monthly MIS, analytics and presentations.Designed and implemented various Brand & division level excel dashboards with external data &internal data on various KPIs like value sales, unit sales, market share, growth.Trained internal stake holders on QlikView & external data sources and promoted self-serviceanalytics through various workshops which involves case studies.

Extensive data analysis from prescription/sales audit conducted by agencies like IMS Health, ORGIMS Research.Identify and Evaluate potential areas for business expansion of the company in various therapeuticareas by analysis.Scrutinize industry movement, Trends, Behavior of the company, Therapeutic segments, Moleculesand Brands.Prepare and presenting analysis on Therapies, Divisions and Brand performance and theirrespective covered market level to superiors.Provided Ad Hoc Requests from Divisional Heads and other Members for Brands Review, DivisionalPresentation, Quarter Review, Budget Meeting etc.Providing analysis of various Divisions with their brand performance.Watching competitor trends, activities and market movements.Generation of reports based on secondary and primary research.Performing active job in providing analysis in new product launch project.Performing analysis through MS Excel and its advanced features.

Primary market research for key brands.Data analysis & monthly MIS.Data support to marketing teams with primary research.

Design Thinking

International Marketing, International Marketing.

Marketing Management, Marketing

B Sc, Chemistry