SOURABH D KHOT

Mountain View, CA +1-650-***-**** ad4lks@r.postjobfree.com LinkedIn GitHub

INTEREST & SKILLS

Data Analytics, Business Intelligence, Product, Statistics, A/B Testing; Cert.: AZ-900 Azure Funda., Google Analytics SQL, Tableau, PowerBI, Sharepoint, Python, R; Leadership Communication, Cross-functional Collaboration PROJECTS

Data Analytics for Phare Counselling, an online therapy startup Sep–Dec 2023

• Developed methods to measure client conversion & counselor performance across stages of client journey

• Built interactive Tableau dashboard on operational & financial trends; delivered insights for client retention Data Modeling for Pragmatic Institute, a corporate L&D training institute Sep–Dec 2022

• Designed Tableau dashboard to surface insights from customer funnel, user badges & platform usage data

• Built models to identify leads for cross-selling courses & top engagement behaviors causing repurchases EXPERIENCE

Sirius Mindshare, AI Email Service Apr–Jul 2023

Data Scientist Intern, Subject Line (SL) Optimization for Marketing Campaigns San Jose, USA

• Developed a Python algorithm to predict & improve subject line performance measured by email open rate

• Identified insights by analyzing 4000+ SLs & open rates in SQL; applied data cleaning, NLP steps using Python

• Extracted & built repository of 200 power words; assigned weights reflecting impact on subject performance Wipro, Assistant Manager, Cloud Ecosystem Jun 2018 – Dec 2021 BI, Data Analytics Bengaluru, India

• Built PowerBI dashboards to monitor business health; provided weekly communication & addressed ad-hoc data requests from 15+ cross-functional leaders; prepared C-suite decks with data, strategy plan & research

• Developed processes to measure cloud business metrics from company-wide data of sales pipeline, order book, margin, win-loss ratio, penetration in 90+ key accounts, competency metrics, project satisfaction score

• Automated computation using Excel saving 66% efforts; collaborated across teams to forecast above metrics

• Led change management to improve tagging accuracy of cloud business in sales CRM system by gathering stakeholder requirements, proposing simplified UI, negotiating with IT & facilitating knowledge sessions Business Analysis

• Evaluated insurance client’s IT landscape of 150 apps for cloud adoption using discovery & assessment; gave per app recommendations like R-lanes, containerization feasibility, target cloud provider & cost economics

• Supported sales on 10+ client pitches with artifacts & cases; maintained knowledge repository in Sharepoint British Council Shared Services, Global Finance Delivery Apr–Jun 2017 Business Analyst Intern, Knowledge Management (KM) Delhi NCR, India

• Designed methodology for KM best practices (capture, storage, usage & retention) & improving processes through documentation, document lifecycle management, new hires’ training, lessons learnt, exit interview

• Defined KPIs to measure SharePoint-based knowledge site’s usage; created wireframe for improved design COMPETITIONS

• Winner, Analytics with Python Hackathon (2022), Northeastern: Analyzed how emotions in music have changed over decades; imported lyrics using APIs, built word cloud & performed sentiment analysis

• National Winner, Steel-a-thon Business Competition (2017), Tata Steel: Developed overall strategy & business model for Jamshedpur Football Club, including marketing plan & financial forecast for 5 years EDUCATION

Northeastern University (NU), San Jose Campus, USA (3.9/4.0) Jan 2022 – Dec 2023 Masters in Analytics (Courses: Enterprise Analytics, Databases, Visualization) Activities: Statistics TA, Data Club Indian Institute of Management (IIM) Shillong, India Jun 2016 – May 2018 MBA (Courses: BI & Analytics, B2B Marketing, Product Mgmt.) Activities: Consulting & Strategy Club Malaviya National Institute of Technology (NIT) Jaipur, India Jul 2012 – May 2016 B.Tech (Major: Electronics & Communication Engg.) Activities: Alumni Committee, Student Mentor