Data Customer

SWARNA DURGA VALLURUPALLI, Data Science

ac6ygd@r.postjobfree.com 704-***-****, San Diego

https://www.linkedin.com/in/swarna-vallurupalli-b88320106 https://github.com/SwarnaVallurupalli TECHNICAL SKILLS: Statistical Techniques : Regression, Generalized Linear Mixed Model, Survival analysis, Clustering, Neural Network, Segmentation, A/B testing, Time Series Analysis, Descriptive Analysis, Classification

Data Bases : MySQL, Teradata, Netezza, Snow Flake

Data Visualization : Tableau, Seaborn, ggplot, Shiny Tools : R Studio, Microsoft Excel, Git, Netbeans

Programming Languages: Python, R

EXPERIENCE: Data Science Analyst -Petco Animal Supplies Inc, San Diego September 2017- Present Customer & Market Intelligence (CMI)

Optimized Churn model by improving accuracy from 68 to 76% and reduced the dimensionality from 74 to 7 variables for effective targeting by mining through 20+ MM customers transactional data and by isolating patterns.

Improved customer engagement (retention) by leveraging churn model scores to identify trigger points and made recommendations to the CRM team for a trigger-based marketing campaign.

Leveraged time series models to forecast new customer and retention counts for future quarters to help senior leadership team plan acquisition and retention strategies

Built RShiny Dashboard for private label sales forecast analysis and Customer Lifetime Value for dynamic reporting.

Provided insights on most valuable customers by predicting Customer Lifetime Value to help marketing team plan on targeting customers for Upsell and Cross-Sell

Presented findings to senior leaders and cross functional business units by effectively translating complex data and analysis into clear insights, opportunities, and tangible business recommendations. Data Science Intern – Petco July 2017 – September 2017

Introduced new Marketing Metric called “Clumpiness” (binge purchase) to better understand customer behavior and purchasing patterns for superior targeting of customers (Performed Monte -Carlo Simulation, Entropy method)

Performed analysis on Petco coupons which resulted in finding out that Petco is over couponing customers and gave recommendations to CRM team for channel and coupon optimization.

• Analyzed data to recommend actionable insights for Ad-hoc business requests

• Generated SQL scripts in Teradata and Netezza for data pull and data cleansing

• Communicated insights on Clumpiness and Coupon Analysis effectively through presentations and visualizations to the entire department as part of intern capstone presentation. Responsibilities: Data Cleansing, Variable creation, Statistical Analysis, Modeling and Visualization Research Assistant, Data Science-University of North Carolina at Charlotte May 2016- December 2016

Built a Theilsen, linear regressor model to predict the number of birds seen at a particular location in order to identify the unusual patterns of the bird observations made by users through ebird.org. Responsibilities: Data Cleansing, Feature Extraction and Transformation, Modelling, Data Analysis and Visualization.

SWARNA DURGA VALLURUPALLI, Data Science

ac6ygd@r.postjobfree.com 704-***-****, San Diego https://www.linkedin.com/in/swarna-vallurupalli-b88320106 https://github.com/SwarnaVallurupalli Data Analyst/QA Analyst–Computer Sciences Corporation, India September 2014 – December 2015

Responsible for the entire test cycle for the Zurich North America in-house insurance application by Analyzing client’s business requirements, authorizing and executing software test plans, test scenarios, test cases, and by tracking and managing the entire process in HP ALM tool.

Worked with real time insurance data by querying database, running Macros, Vlookup’s and Pivot tables to integrate data from various sources.

Managed and modified excel spreadsheets for data accuracy and performed statistical analysis in Excel.

Facilitated weekly defect meetings with Business Analysts to verify requirements and explored potential solutions for defects.

EDUCATION: University of North Carolina at Charlotte (GPA: 3.6) Jan 2016 - May 2017

• Master of Science in Information Technology (Advanced Data & Knowledge Discovery) Jawaharlal Nehru Technological University (India) August 2010-May 2014

• Bachelor of Engineering in Computer Science and Engineering ACADEMIC PROJECTS Movie Recommendation System: Jan 2017-May 2017

Designed a Hadoop MapReduce programming model for making movie recommendations by finding nearest neighbors (KNN) using item based collaborative filtering technique. Kaggle-Two Sigma Connect Competition March 2017-April 2017 Used scikit-learn’s Random Forest Classifier to predict the interest level of users based on the historical data.

Contact this candidate