Resume

Sign in

Business Analyst

Location:
Frisco, TX
Posted:
March 20, 2020

Contact this candidate

Resume:

SUSHANTH ALAPATI

+1-682-***-**** adcdxz@r.postjobfree.com github linkedin

EDUCATION

The University of Texas at Dallas December 2020

M.S. Business Analytics GPA 3.6

Amrita Vishwa Vidyapeetham University, Bangalore, India August 2018 B.Tech. Electronics and Communications Engineering GPA 3.7 TECHNICAL SKILLS

Programming: Python, R,SAS Databases: MySQL, Oracle SQL, MS SQL Server, MongoDB Visualization: Tableau, Power Bi, QlikView, Gephi Tools: R Studio, Spyder, Jupyter, Excel Algorithms: Gradient Descent, Regression, Classification, Decision Trees, Random Forest, K–Nearest Neighbor (KNN), Ensemble Methods, Support Vector Machines (SVM), Artificial Neural Networks (ANN) Libraries and Packages: NumPy, Pandas, Scikit-Learn, Matplotlib, ggplot2, dplyr, Beautiful Soup, TensorFlow,Seaborn INDUSTRIAL EXPERIENCE

Bharat Sanchar Nigam Limited, Hyderabad, India June 2018 - September 2018 Analyst Trainee

• Collaborated in a team to manage a data warehouse with 100,000+ telecommunication equipment and retrieved data using SQL

• Helped in making a presentation to suggest effective measure in the existing system of the company

• Used Python library Beautiful Soup for web scraping to extract data for building graphs

• Visualized and created Sales reports and dashboards using Tableau increasing sales by 6%

• Generated graphs to analyze the financial changes over a period of five years using Python matplotlib ACADEMIC PROJECTS

Online News Popularity : Tools Used - Python September 2019 - October 2019

• Classified whether the post is trending or not based on the number of shares and various factors using classification models like KNN, Logistic Regression, Linear SVM, Kernelized SVM, Decision Tree resulting in 65% accuracy

• Formulated Confusion matrix, ROC and F1 Score to compare model accuracy and chose best option to predict the popularity

• Generated the best features by implementing Radom Forest Classifier and Boruta Package for higher precision Data Visualization: Tools Used - Tableau, Power BI, QlikView May 2019 - August 2019

• Visualized data in QlikView using multi-maps(Trellis maps) to track youth employment, income and expenditure trends over the years globally

• Performed Web Scraping on ‘weather.com’ and located the cities in US with highest temperatures and visualized the average temperatures using Tableau

• Designed decision tree, logistic regression, K-means clustering in R and visualized the same to analyze Titanic Dataset by integrating R and Tableau

• Created visualization using Power BI on how the population of US cities changed from 1790-1990

• Developed a Tableau Dashboard to analyze natural disaster effects on ConocoPhillips’ refineries Sales Forecasting Model - Walmart: Tools Used - R April 2019 - May 2019

• Led a team of 4 to collect and analyze three years of sales data at Walmart and forecasted sales for 45 retail locations

• Coded visual plots such as bar plots, histograms and correlation between the features using R to understand the driving factors impacting sales

• Utilized Cross Validation to check the performance of models, resulting in 95% accuracy using Linear Regression, 92% accuracy with Ridge Regression and 91.3% accuracy with Lasso Regression Home Credit Database: Tools Used – SQL Shell, MySQL, Mongo DB February 2019 - April 2019

• Constructed a database from scratch using SQL Shell. Created tables and loaded data into the tables from 7 different excel files which consisted of 30 columns and 1million rows and implemented 3NF on all tables

• Created an ER Diagram consisting 20 tables using MySQL Workbench to describe the relationship between the features and can be used to fetch data from the database using inner joins, outer joins. LEADERSHIP & ORGANIZATIONS

TBI Pitch fest, Amrita – Organized a fest by accumulating some incipient founders to pitch in their conception so that they can get a chance for Amrita Vishwa vidyapeetham to invest 50,00,000 INR in their company.



Contact this candidate