Sonali Yadav
Email: *************@*****.*** Phone: +1-510-***-**** LinkedIn: https://www.linkedin.com/in/sonaliyadav1 EDUCATION
Santa Clara University, Leavey School of Business Santa Clara, CA Master of Science in Business Analytics June 2017
Indian Institute of Foreign Trade New Delhi, India Master of Business Administration – Marketing April 2014 CRSCE Murthal, Maharishi Dayanand University Sonepat, India Bachelor of Engineering – Electronics and Communications June 2010 TECHNICAL SKILLS
• Programming Languages: Python, R, SQL
• Databases: MySQL, MS SQL Server
• Visualization Platforms: PowerBI, Tableau Desktop, Orange3
• Data Processing Libraries: Pandas, Scipy, Numpy, Scikit-Learn, GraphLab, Shiny, MatplotLib
• Big Data Tools: Hadoop (Map/Reduce), Hive, Spark
• Marketing Analytics, Excel Modeling, Statistical Analysis EXPERIENCE
Magento Campbell, CA
Business Analytics Engineer 2017-Present
• Creating interactive and analytical dashboards to generate, visualize and quantify knowledge of customer interactions and business continuity behavior
• Designing and implementing the predictive churn rate model utilizing the customer attrition parameters, engagement levels Technology: Python, R, Tableau, PowerBI, Amazon Redshift, Churn Rate Prediction, Competitor Benchmarking RatePig Inc San Carlos, CA
Data Scientist (Consultant) 2017-Present
• Developing solutions by leveraging text analytics techniques for sentiment analysis and topic clustering
• Designing automated dashboards and data visualization to extract relevant ad targeting market insights Technology: Python, R, Tableau, Text Mining & Analytics, Market Segmentation, Customer Targeting Medtronic New Delhi, India
Manager, Marketing Research 2014-2016
• Managed a portfolio of 49 products with over 2000 SKUs while leading a team of 7 analysts and sales associates
• Developed scalable frameworks to gain insights to assess product lag performance (cluster analysis), KPIs, marketing ROI, and sales forecasting
Technology: R, SPSS, Marketing Engineering for Excel, Statistical Modeling - Forecasting, Regression Analysis, Hypothesis Testing Tata Consultancy Services Mumbai, India
Software Engineer 2010-2012
• Developed SQL queries with multi-table joins, group functions, subqueries, set operations and stored procedures, user defined functions (UDFs) for data analysis
• Collaborated on ETL Processes such source, mapping, transformation, staging areas and created ETL mapping documents Technology: SQL, ETL Documentation, Requirement Gathering, Business Analysis PRACTICAL TRAINING
• 3M Company: Data Science Practicum
• Identified top performing cluster of products – leading/lagging with business sales cycle and key divisional inter- relationships for resource optimization;
• Created Shiny App for reproducing the similar results; and generated EDA reports using Tableau Dashboard Technology: Python, R, Tableau, Shiny, Sci-kit Learn, Text Analytics, Classification, Clustering, Principal Component Analysis Github: https://github.com/syadav88/Academic-Projects.git