SNEHAL RANE : +91-982******* ~ : adj6ve@r.postjobfree.com
~ BUSINESS & DATA ANALYTICS ~ DATA VISUALIZATION ~ SALESFORCE EFFECTIVENESS ~
~ PROCESS IMPROVEMENT ~ OPERATIONAL EXCELLENCE~
Offering 22+ years of rich experience; excels in Business Analysis, Data / Statistical Analysis, Modelling, Data Visualization & Analytical Dashboards, Salesforce Effectiveness Improvement / Automation, Project Execution, Stakeholder Engagement & Team Leadership functions Proficient in Data Analytics: interpreting large-sets of data, analysing results using Statistical Tools, summarizing findings and providing insightful, quantifiable & actionable Analytical inputs to sr. management/ stakeholders for critical decision-making. Strong knowledge of Data Mining /Data Visualization, Algorithms, Machine Learning Concepts, Predictive Modelling & Analytical Techniques - Clustering, Classification Tree, Logistic Regression Analysis to maximize prediction and provide quality results. Successfully executed various Analytical / Process Improvement Projects with necessary recommendations to help companies achieve operational excellence, cost & resource savings. Expertise in identifying improvement areas & providing strategic leadership in developing Analytics – Centres of Excellence (CoEs) through Process Reengineering/ Automation Initiatives, development & testing of New Tools & Platforms; recorded key achievements at Merck like:
- Drove Automation of In-Market Sales at Account level for Super Specialty Businesses
- Championed CLM Analytics to enhance Marketing Excellence in 2018; Success Story shared as India CLM Best Practices at APAC Com-Ex Meet-2018 & appreciated by APAC Regional Leadership
- Steered Performance Grid for SF in 2017-2018 a concept of performance improvement
- Provided Dashboards of SF Efforts vs Sales Performance at all levels of hierarchy to help all BP BU’s drive performance in 2017; effectively drove SF Optimization for CM Care
- Awarded for Project CRM Systems Implementation towards the One Healthcare integration in 2017
- Led the successful launch, adoption and implementation of Veeva CLM & Rep Approved E-Mail System in 2017-19 Area of Expertise
Data Visualization/ MIS Reports & Dashboards Project Execution/ Process Improvement / Automation
Business Analysis/ RCA / GAP Analysis Cross-Functional Collaboration
Sales, Marketing Support / Salesforce Effectiveness Stakeholder Engagements
Analytics Techniques: Cluster Analysis, Factor Analysis, Multivariate (Linear and Logistic) Regression Analysis/ Predictive Modeling IT Skills: MS Excel, PowerPoint & Word, Tableau, Python MySQL & Internet Applications CORPORATE S U C CESS
Oct’07 – Dec’20: Merck
Growth Path:
Key Result Areas:
Manager - Advance Analytics Apr’19 – Dec’20
Managing the Business Analytics / Data Visualization / Digital/MCM Capabilities & driving SFE operational excellence for Merck - Healthcare Coordinating activities of the Analytics Team; applying latest technology, quantitative methods, statistical models and algorithms that address customer requirements, or internal BU analytical needs; guiding the team in:
- Understanding the requirements / deliverables & accordingly presenting analysis through various reports /dashboards
- Collating, transforming and cleaning large vehicle data sets from multiple sources using IT enabled tools
- Contributed in identifying, analysing, and interpreting trends or patterns in complex data sets and providing recommendations Identifying areas of improvement and communicating the same to all involved stakeholders; working on process improvement plans Scheduling timely meetings with the Stakeholders to discuss various issues to ensure operational excellence Guiding and mentoring team members and motivating them to achieve the desired business objectives Oct’07 – Oct’15: Sales & Marketing
Coordinator
Apr’16 – Apr’19: SFE Manager
Apr’19– Dec'20: Manager - Advance
Analytics
SFE Manager Apr’16 – Apr’19
Led & guided a team of 3 including Analyst and System Admin; engaged with BU stakeholders to support the business needs Worked on 2 CRM Systems (Veeva & FMS) for 4 BUs of the company; provided them accurate data points in the form of KPI Dashboards Transformed customer data into meaningful insights in order to drive Salesforce performance, Data Analysis and correlation with KPI Sales & Marketing Coordinator Oct’07 – Oct’15
Prepared Cardio-Metabolic BU Sales Performance Reports, managed marketing activities (approvals for proposals – coordination with Marketing
& Sales Team to ensure smooth execution – loop closing) Tracked & monitored SPE, provided support to BUH as well as coordinated with SF P R E V I O U S E X P E R I E NCE
Nov’05 – Aug’07: Wanbury Limited as MIS Executive
Managed CRM, Marketing Spent vs Sales Performance Monthly Reports & IMS Reports (Market Research) for GM Jul’98 – Nov’05: Universal Medicare Pvt. Ltd. as Officer Sales Support Assisted in preparation of Sales Performance Reports, IMS Reports for President & CEO ACADEMIC & O T H E R C R E D E N T I A L S
Pursuing MBA (Exec.) - Business Analytics from NMIMS Global Access School for Continuing Education; Dec’19 - Present Advance Diploma in Computer Software, Systems Analysis and Application from BTE, MH B.Sc. - Physics & Computer Science from Mumbai University o Building Trust & Resolving Conflict in 2020
o Mitigating Unconscious Bias / Taking the Lead, 2019 o Managerial Foundation Program, 2018
o Accountability at Workplace, 2017
o Advance Excel, 2016
o Strategic thinking & Strategic Perspective, 2016 o Personal Effectiveness & Presenting with Impact, 2012 o Voice of the Internal Customer, 2010
MAJOR P ROJECTS F ROM MBA P R OGRAM
Exploratory Data Analysis using Python / MySQL for Business Problem Solving & Data Visualization using Tableau Google Analytics: understanding consumer behavior of the Google Merchandise store website using statistical tools Marketing Analytics: Simulation on Strategic marketing by applying Segmentation/Targeting/Positioning, predictive analytics. Establish link between different strategy levers and outcome (Harvard Business Publishing) Fraud & Risk Analytics using Machine Learning to detect fraudulent transactions Supply Chain Analytics: Simulation 'Root Beer Game' to maximise profits and minimise cost by applying concepts of inventory optimisation
(Harvard Business Publishing)
Time-series Analysis for forecasting and Cluster Analysis for customer segmentation & profiling using Machine Learning HR Analytics: Diversity Analysis for workforce planning & Attrition Analysis to analyse and improve employee performance Capstone Mini Project: Market Analysis, Churn Analysis, Customer Segmentation, Employee performance/selection of new project team using Python and ML techniques