Information Technology Data

BINDUSHREE RAJASHEKARAIAH

https://in.linkedin.com/in/bindushreehr 469-***-****) ************@*****.*** BUSINESS EXPERIENCE

Verizon Communications Inc., Irving, Texas, Data Science/Analytics Intern June 2016 – Present Customer Journey – Cross Channel Analysis (Apache Spark, R)

Analyzed customer calls, sitecatalyst data and order status of 200k Verizon customers using Hive

Applied Frequency Pattern mining to reduce customer call volume in Apache Spark using Scala

Predicted prospect customers and reduced churn rate by applying decision tree model using R FiOS Video On Demand(VOD) Recommendation Model (Apache Spark)

Analyzed FiOS Video Usage, VOD purchase and customer demographic details of one-year data

Performed data mining in Hive and data processing using PySpark to filter out irrelevant VODs

Recommended top 5 trending VODs by applying collaborative filtering using Alternating Least Squares algorithm TESCO HSC, Bangalore, India, Teradata ETL Developer Oct 2012 – Dec 2014

Gathered requirements, performed impact analysis, prepared design and test plan documents for work parcel

Designed Terdata ETL scripts to collect transaction data from 3,513 stores

Performed data mapping and transformation on source data to load data into Teradata data model

Improved performance of queries that impacted CPU and server utilization by 60% by debugging bad queries

Resolved skew/space issues with PI and SI recommendations to enhance table structure

Applied compression techniques to increase space and enhance retrieval performance ACADEMIC PROJECTS

Big Data Analytic Solution on Bankruptcy Dataset (Pig, Hive, R, Python) Jan 2016 – May 2016

Loaded 3 years’ financial data into HDFS and performed pre-processing using Pig Latin

Predicted bankruptcy status by applying Decision Tree, Random Forest, Neural Networks & Logistic Regression models

Enhanced model performance using Bagging, Boosting, and Ensemble methods in Python by reducing error rate Marketing Research Analytic Solutions for ConAgra Foods (SAS 9.4) May 2015 – August 2015

Analyzed private label gateway product transactions and performed behavioral segmentation on 10million customers

Applied Logistic regression and Market Basket Analysis to recommend best product bundles increasing sales by 25%

Provided insights to ConAgra by predicting a revenue growth of 3% in private label products Sentiment analysis and data visualization for Yelp customers (Tableau, R) Aug 2015 – Dec 2015

Analyzed 1.6 million Yelp customer reviews of around 61K business across USA, Europe and Canada

Performed text mining using R, made understandings on top & bottom rated business enhancing functionality by 5%

Visualized best and worst restaurant and cuisine different for each city using Tableau for reporting results Analysis of why renewable energy has to be the future (Tableau) Aug 2015 – Dec 2015

Analyzed energy demand, coal consumption, renewable energy utilization, carbon dioxide emission for 193 countries

Visualized how a country can grow sustainably by embracing renewable energy and reducing carbon dioxide emission LEADERSHIP EXPERIENCE & ORGANIZATIONS

Business Intelligence & Analytic Tools, UT Dallas Student Contributor Feb 2015 – Present

Indo American Community Services, UT Dallas Student Ambassador Sept 2015 – Present EDUCATION

The University of Texas at Dallas December 2016

M.S., Information Technology & Management GPA 3.79 Visvesvaraya Technical University June 2012

B.E., Electronics and Communication GPA 4.00

CERTIFICATIONS & TECHNICAL SKILLS

Languages: SQL, Teradata SQL, Python, Scala, Pig, Hive, R programming Software/Tools: Hadoop, Teradata, Spark, SAS, Tableau, R Studio, MS SQL Server, Microstrategy Teradata Utilities: BTEQ, Fast load, Fast export, Multiload, TPT, TPump, ETL Certifications: SAS Certified Base Programmer for SAS 9, Teradata 14 Professional Certification, UT Dallas SAS Data mining and Business Intelligence, Google Analytics using AdWords, Coursera R Programming

Contact this candidate