Data Analyst

PARTH KALARIYA

214-***-**** **************@*****.*** https://www.linkedin.com/in/parth121096

EDUCATION

The University of Texas at Dallas December 2020

M.S., Information Technology Management GPA – 3.67/4 Gujarat Technological University Gujarat, India May 2018 Bachelor of Information Technology GPA - 3.70/4

TECHNICAL SKILLS

• Programming Languages: Python, Java, SQL, R, C, C++, HTML, PHP, Javascript

• Tools: MS Excel, R Studio, SAP Bex Query, SAP Lumira, SAP Crystal Report, MS PowerPoint, SAP HANA, Microsoft Access, Microsoft Project, Microsoft Visio,Tableau, Power BI, PyCharm, Gephi, Qlikview, ArcGIS, CRSYSTAL report

• Database: Oracle, MYSQL, Firebase, MongoDB(Basics)

• Certifications : SQL for Data Science, Google Analytics IQ, Google AdWords, Google Analytics Individual Qualification WORK EXPERIENCE

Data Analyst Intern - BINARY DEVELOPERS, Gujarat India Jan 2018 to August 2018

• Analysed and interpreted large datasets, conducted reports & performed accurate, successful data management.

• Developed visualizations and dashboards which democratized data across product team and tracked organizational key performance indicators to drive actionable business decisions

• Automated data retrieval process, creating complex stored procedures, reducing manual work

• Improved data quality by identifying errors and performing data cleaning operations using SQL

• Worked on SQL queries to validate data integrity across multiple databases to improve data’s accuracy Business Analyst Intern - TEKSUN LAB PRIVATE LIMITED, Gujarat India June 2017 to Sep 2017

• Identified, analyzed and interpreted trends/patterns in complex and large data sets and generate insights to suggest KPIs that helps in decision making

• Performed statistical methods low variance, High Correlation, TTest,Cluster Analysis to decide the most important predicators

• Improved Data Mining process, resulting in 15% decrease in time needed to infer insight from customer data used to develop marketing strategies

ACADEMIC Projects

Time Series Forecasting R, Python August 2019 - September 2019

• Performed data cleaning, data filtering and processing on time series data to identify relationship among bitcoin price, oil price, euro price and gold price

• Used time series forecasting models ARIMA (Autoregressive Integrated Moving Average model) and VAR model to forecast the next 30 days prices of bitcoin

Customer Segmentation - Cluster Analysis Python, R August 2019 - September 2019

• Built clustering algorithms like K-Means Clustering and hierarchical clustering in Python and R

• Clustered customers based on Gender, Age, Annual Income and spending score for easy targeting Integrated Analysis on Titanic Data set R,Tableau Oct 2019 –November 2019

• Performed Data Retrieval, Data pre-processing. Built Decision tree using R and K-mean clustering using Tableau- R integration by invoking Rserve • Analyzing whether sex, class of ticket, Age and other factors affected the survival rate of the passengers in the Titanic Business Data Warehousing using SAP SAP HANA January 2019 – May 2019

• Developed ER model and designed Dimensional Modelling to capture and review transaction data

• Implemented Data Models and Data Marts using Universe/Information Design Tool (SAP Business Objects)

• Developed interactive workbooks and dashboard reports using filters, calculated fields and sets in Tableau Data Manipulation – Excel January 2019 – May 2019

• Leveraged functions like pivot tables, VLOOKUP and conditional formatting to manipulate data

• Performed various statistical tests to evaluate hypothesis and drive business decisions

Contact this candidate