Sign in

Social Media Customer

Durham, NC
December 27, 2020

Contact this candidate


VEDANT SAHAY • +1-609-***-**** • Fremont, CA • GitHub • LinkedIn



Senior Business Analyst

• Analyzing onboarding behavior as well as customer-centric activities such as customer acquisition & customer retention for our top 10 sponsors & developing a playbook using Amplitude, SQL & Power BI

• Responsible for sentiment analysis for ~1000 customer reviews using the Syuzhet package in R & identified the seasonalities in comments & feedbacks with forecasts & insights for the next business decision FRACTAL ANALYTICS


• Developed linear regression models using R to evaluate the impact of the number of purchasers vs. product volume for Old Spice with a MAPE of ~16% while recommending actionable insights. Awarded Spot Award

• Spearheaded Spotfire solutions for optimizing marketing tactics for each targeted segment by examining their positive/negative customer sentiments & explaining their likelihood of considering a brand. Awarded the P&G Explorer award

• Setup one-stop solution for brand health, thereby facilitating new solution utilization by 60% in domains such as Pricing, Share Decomposition, E-commerce; Developed client proposals for new projects

• Transitioned Excel reports to Power BI dashboards for E-IMEA region for 5 categories with 18 brands

• Improved solutions with effective measures in distribution, pricing, shelving, & merchandising for the skincare category in the NA region. Positive NPS rating from the client for three consecutive quarters

• Examined Automation & Productivity gains using tools such as Excel & KNIME, saving ~310 hours every six months; technical facilitator for KNIME & Excel training Remote - Fremont

Aug – Oct’2020

Mumbai, India

2016 − 2019


Cloud Engineer Intern

• Implemented ‘OpenStack deployment of Virtual Machines’ on Ericsson live network using a Web-based dashboard using RESTful APIs

Bangalore, India

Spring 2016


Loan Defaulters:

Implemented supervised learning (Logistic Regression & LASSO), predicted whether a customer would default on their repayment of the loan & supported business recommendations through unsupervised learning techniques(K-means). Compared five supervised learning algorithms via K-fold cross-validation, resulting in Logistic Regression with an accuracy of 86% as the best model iPhone 11 Sentiment Analysis:

Performed Network & Sentiment analysis using Twitter data for iPhone 11 & analyzed network centrality measures. Evaluated sentiment scores & identified seasonality in terms of customer tweet behavior. ‘Unboxing’ & ‘YouTube’ were the top terms in terms of Betweenness & Degree Centrality

NetJets (Capstone Project):

Processed & analyzed customer behavior patterns for a private charter organization, generating actionable insights into improving lead conversion to customers. Primary insight focused on social media activity & reducing the gap between acquisition in first vs. second campaign. Cleaned, processed, & modeled with Python & R, visualized in Tableau EDUCATION

Master of Science in Quantitative Management: Business Analytics, Marketing Track DUKE UNIVERSITY, THE FUQUA SCHOOL OF BUSINESS

Durham, NC

May 2020

Bachelor of Engineering in Computer Science


Bangalore, India

June 2016


Tools: R, Python, SQL, KNIME, Amplitude, MS Excel Databases: Nielsen, Crimson Hexagon Visualization: Spotfire, Tableau, PowerBI Certifications: Operations Analytics (License 36CY67PEVMZK), People Analytics (License NXCHUPYLKLSU), Customer Analytics

(License YN5JBX83LXZH) from Coursera (UPenn); Reporting in SQL (License 14201207) from DataCamp

Contact this candidate