Data Analyst Tableau

PRATIK GURAM

I analyze so well; I can already visualize how great it’d be to have me in your team

***********@*****.*** 973-***-**** www.linkedin.com/in/pratikguram https://github.com/pratikguram Data Analytics Business Intelligence Business Forecasting Data Visualization Master of Information Technology & Analytics (STEM) (GPA:3.4/4) December 2020 Rutgers University, Rutgers Business School, New Jersey

• Business Data Management, Analytics for Business Intelligence, Data Structures & Algorithms, Data Visualization, Data Analysis & Decision Making, Project Management, Business Forecasting. Bachelor of Electronics &Telecommunication Engineering (GPA: 3.7/4 – US Equivalent) May 2019 Mumbai University, India

PROFESSIONAL EXPERIENCE

Data Analyst Intern May 2018 – August 2018

Air India Limited Mumbai

• Tabulated aircraft data, scraped data by cleaning (removing ambiguities, null values, duplicities) for structured data analysis

• Evaluated business processes, unearthed areas of improvement enhancing quality of procedures by handling client relations

& expectations by working on analytics support tickets

• Used Tableau for error reporting & mapping changes in incubator budgets and participated in guiding new BI initiatives Data Analyst Intern Nov 2017 – Feb 2018

Sapphire InfoTech Venture Mumbai

• Involved with the Data Science team responsible for increasing customer engagement & designing business models tailored towards potential customers’ needs with extensive focus on KPIs

• Led daily standups with SMEs & transformed business problems into technical solutions in a Scrum environment

• Rendered actionable business insights, using Tableau & provided solutions to SMEs by developing interactive dashboards Marketing Analytics Intern May 2016 – Mar 2018

Grapevine Mumbai

• Spearheaded the Marketing Analytics team that successfully integrated 50 restaurants and food chains.

• Conducted statistical analysis of marketing databases using Python to assist in targeted campaigns.

• Analyzed & visualized customer demographics using Excel, which contributed in increasing customer outreach by 35%. SKILLS

Programming Languages: Python, R, C, C++, Java

Software skills: MySQL, PostgreSQL, Tableau, RStudio, Salesforce, Google Analytics, Power BI, Airflow, Flask, MATLAB, HTML5, Jupyter Notebook, Eclipse, Microsoft Office (Excel, Word, Access, PowerPoint) ACADEMIC PROJECTS

User funding prediction (Predictive Analytics, Data Visualization) September 2020

• Applied regression techniques on a dataset consisting of 50,000 rows & 14 columns, predicting user funding data

• Deployed the system on Flask & created reports on Tableau, combined & altered data using joins, data blends, unions & simplified comprehension by delivering granular insights over the dataset Scrutinizing the Arrests in NYC (Data Visualization) April 2020

• Visualized a dataset consisting of 65,535 rows & 18 columns on Tableau, where Precinct 41 had a 30% increase in Petit Larceny arrests while Assault related offences were the maximum occurrence every month, peaking in September.

• Geospatial data analysis allowed segregation of unsafe neighborhoods, a factor in real estate price valuation. Bike Sharing Demand Prediction (Predictive Analytics) May 2020

• Performed data exploration & hypothesis testing on a training set with 12 variables & applied decision tree, conditional inference tree & random forest to conclude that random forest performs well for the dataset. Loan Approval Prediction (Predictive Analytics) December 2019

• Applied Exploratory Data Analysis on a dataset with 615 rows & 13 columns using Python (sklearn, matplotlib, numpy)

• Used statistical modelling techniques & identified random forest to be the best fit with an accuracy of 82.573 Analyzing the Videogame sales dataset (Data Visualization) September 2019 - December 2019

• Core focus on Exploratory Data Analysis applied on a Kaggle dataset with 16,719 rows & 16 columns using Python.

• Used Univariate & Multivariate Analysis to project the business strategy needed to maximize profits. Soil erosion Prevention by Phytoremediation Process (Data Visualization, IoT) July 2018 – April 2019

• Created exploratory dashboards on Excel, analyzed results and discussed research objectives.

• Led a team of 4 in which the system managed water and pH level efficiently, sending real time information to the user on their cellphone directly responsible for deriving maximum productivity from the cultivable land. CERTIFICATIONS & COURSES

Tableau Analyst (Tableau) Tableau Data Scientist (Tableau) Gold Badge, SQL (Hackerrank) Integrating Tableau and R for Data Science The Data Science of Marketing AWS Cloud Practitioner Essentials (Second Edition) LEADERSHIP

• Volunteered at Robotics Cell, taught Robotics to students from 25 schools in Mumbai as a Robotics trainer

• Headed the Marketing team for IETE in college, increasing sponsorship deals by 50% through targeted marketing

Contact this candidate