Data Analyst Tableau

VIPUL MAYANK

+1-513-***-**** *************@*****.*** LinkedIn GitHub

EDUCATION

Master of Science: Business Analytics Aug 2019 – Aug 2020 Carl H. Lindner College of Business, University of Cincinnati Available: Immediately GPA: 4.0/4.0

Bachelor of Technology: Computer Science & Engineering July 2012 – May 2016 Manipal Institute of Technology, India

CGPA: 8.59/10

TECHNICAL SKILLS

● Programming: R, R Shiny, Python, SAS, Tableau, Power BI, Hadoop, Spark, Scala, ABAP, C, C++, JAVA, C#

● Tools: GIT, Microsoft Excel, MySQL, SQL, S/4 HANA, HTML, Microsoft Office, Google Analytics WORK EXPERIENCE

SAP India Private Limited, Bengaluru, India August 2016 – June 2019 Development Associate Consultant

● Designed and developed end to end ERP solutions and WRICEF objects to solve complicated business problems of modules such as Inventory Management, Logistics Management, MM, SD and Finance in S/4HANA and ABAP

● Initial Data Analysis and Solution Design - to support assumptions, assisted in developing business cases, translated problems into technical and analytics projects.

● Lead Developer for ‘Warranty Module’ where I extensively worked on the design and implementation, enabling descriptive analytics for customers and automation programs for assignment of warranty to equipment and vehicles

● Designing dashboards for customers to summarize all the major insights, thus helping them in making data-driven decision-making using SQL and SAP Analytics

● Prepared a trend-setting estimation matrix to evaluate effort and cost of landscape transformations using Excel, which was used for more than 25 customers across the globe, eliminating the manual effort ACADEMIC PROJECTS

Text Mining Twitter Tweets for Disaster Management GitHub April 2020

● Build a machine learning model (in Python) thus differentiating between disastrous and non-disastrous tweets which can be used to correctly alert in case of any tweets about natural disasters

● Used the GloVe technique for word embeddings. Modelling the data using Logistic Regression, KNN, XG Boost, Decision Tree and Voting Classification Method and obtained an F1 score of 0.784 using Boosting Forecasting Google Stock Price during COVID-19 RPubs GitHub March 2020

● Forecasting the Google Stock Price incorporating the impacts of COVID-19 on its price

● Modelled the data using ARIMA Model, KNN and Neural Networks Model and a designed a RShiny app for the users Analysis of Anime Data from MAL using R RPubs GitHub November 2019

● Analyzed the Anime Data from MAL to derive insights such as the most popular anime type, genre, broadcasting days, season which attracts the maximum audience, the anime trend over the last 50 years and most popular producers

● A predictive analysis using regression for the producers which will help them decide the various factors that needs to be checked before investing in an anime to gain maximum profit Ranking of US States by Fiscal Condition Tableau February 2020

● Designed a Dashboard in Tableau to visualize the ranking of US States by Fiscal Condition and how states are prepared to handle their short-term and long-term needs

Tree Based Algorithms for Adaptive Learning Springer May 2016

● Implemented ‘FP Tree Algorithm’ in place of ‘Apriori Algorithm’ in building concept maps which reduced the time taken initially from 350 ms on an average to 75 ms on an average using R which is now currently being used in the college as POC for that subject, thus helping students integrate their old and new concepts better, thus resulting in better understanding of the concept. This research was also published in the Springer series in the year 2018 EXTRA-CURRICULAR & ACADEMIC ACTIVITIES

KPMG, Virtual Internship April 2020 – June 2020

Data Analyst Intern

● Analyzed existing customer trends and behavior via data exploration to identify key factors while targeting new customers in their marketing strategy to boost bike sales and designed a Tableau dashboard for the same

Contact this candidate