Data Analytics, Project Management

TANMAY GUPTA

469-***-**** *********@*****.*** https://www.linkedin.com/in/gupta-tanmay/ https://github.com/gupta12tanmay

EDUCATION

The University of Texas at Dallas, TX, USA May 2020

M.S., Information Technology & Management 3.55 GPA

Rajiv Gandhi Proudyogiki Vishwavidyalaya, India June 2016

B.E., Computer Science & Engineering 3.67 GPA

COURSES Agile Project Management, Statistics & Data Analysis, Business Analytics with R,

Object Oriented Programming with Python, Big Data Analytics, Data Visualization

TECHNICAL SKILLS

Certifications: Tableau Desktop Specialist, Alteryx Designer Core

Analytics: Tableau, Power BI, MS Excel (VLOOKUP, Pivot), Google Analytics

Project Management: MS Project 2016, JIRA, SCRUM, Confluence, Visio, SharePoint

Programming: R, SQL, Python, .Net, Fiddler

Databases: SQL Server, MySQL, Apache Hive, Apache Impala

BUSINESS EXPERIENCE

Tata Consultancy Services, Bengaluru, India July 2016 - July 2018

Business Analyst

Reported interactive dashboards in Tableau & SQL for rural locations, detected trends which increased business sales by 25%

Conducted analysis on research findings, provided insights and recommended strategic business decisions to investors boosting revenue by 37%

Examined client’s business requirements and collaborated with cross functional teams in Agile, thereby increasing efficacy

Identified trends and patterns in consumer data to helped clients learn about their customers and proposed new business objectives

Analyzed the market data and performed time series forecasting using ARIMA in R to predict the sales across different locations in UK providing them with results which reduced problems to 45% related to pricing, customer churn

Managed a team of 3 people to enhance an existing product by migrating and collaborating technology with profits up by 11%

ACADEMIC PROJECTS

Employee Churn Prediction, Exploratory Analysis in Python February 2019 - March 2019

Efficiently predicted the future churn of 20k employees based on 10 major attributes using the dataset of an IT company

Performed exploratory analysis for analyzing different patterns, outliers, trends and using Pandas, Matplotlib, Seaborn for descriptive statistics and visualization

Executed cluster analysis by bunching into a set of people based on the overall satisfaction and performance in the company

Built and evaluated model performance using Gradient Boosting model with an accuracy of 92% in Jupyter Notebook

Weather Data Scraping in Python January 2019 - February 2019

Collected and analyzed the weather data of Texas on a day along with climate situations and wind speed using Python script

Designed a python code in Jupyter notebook via BeautifulSoup to transform web-scrape data into a structured csv file

Automated the process of scraping weather forecast data based on geospatial input and gained knowledge about HTML, CSS

Constructed graphical visualization to correlate the average and normal temperature of different locations using MS Excel

Vanilla Production Analysis, Data Visualization using Tableau January 2019 - March 2019

Extracted data from 1961-2017 and performed analysis on vanilla production worldwide, identified insights and trends of Area Harvested vs Yield within the data

Designed the geographical production of Vanilla bean in various countries and identified the highest crop manufacture in tones

Performed visualization on bean price summary with actual price and used forecast indicator to predict estimated price of crop

Labor Work-force Evolution, Data Visualization using Power BI January 2019 - March 2019

Wrote a python script using various libraries to format csv data file into State, Year and Rank based on population

Defined a workforce measure by sum of populations of states for active ad-hoc data exploration and KPI trends using Power BI

Presented animated visualization of trend in the population work-force from 1790 to 1990 in the United States

Stock Market Analysis with respect to Bitcoin, R Studio September 2018 - November 2018

Extracted and merged the prices of Bitcoin and various stocks in Excel to determine a collaboration of each stock with Bitcoin

Performed time series analysis and forecasted the trend for next 30 days using ARIMA modelling

Determined the interrelation between the stocks and bitcoin using Granger causality tests and interpret them

Worked on designing attractive graphical and visualization UI to deploy time series models

LEADERSHIP & ORGANIZATIONS

Negotiation Club, The University of Texas at Dallas – General Secretary August 2018 - Present

EnVision Club, The University of Texas at Dallas – Creative Officer September 2018 - Present

Contact this candidate