Yarshil Shah

adbueb@r.postjobfree.com https://www.linkedin.com/in/yarshilshah/ https://github.com/yarshil Edison, NJ 08820

PROFESSIONAL SUMMARY

•Expertise in Data Analysis, Business Intelligence, Data Mining, Machine Learning and Statistical Modelling

SKILLS

Python, R, Excel, VBA, SAS

Oracle SQL, SQL Server, MySQL

Tableau, Power BI, PowerPoint

SSMS, SSIS, Visual Studio

Microsoft Azure, GitHub, Hadoop

Talend, Toad Modeler, MongoDB

Google Analytics, Salesforce

Alteryx, NoSQL, T- SQL

Lean Green Belt (IISE certified)

EDUCATION

Northeastern University, Boston, MA 12/19

Master of Science in Data Analytics GPA - 3.6/4.0

Gujarat Technological University, India 05/17

Bachelor of Engineering in Mechanical Engineering CPA - 7.5/10.0

PROFESSIONAL EXPERIENCE

Teaching Assistant (Data Science Department) 09/19 – 12/19

Northeastern University Boston, MA

•Conducted training sessions to help graduate students grasp the important aspects of data analysis and visualization using Excel, Tableau, R and Python

•Evaluated and assisted graduate students with their projects on business intelligence and data analysis

Data Operations Co-Op 06/18 – 12/18

Enel X North America Boston, MA

•Queried large amounts of data from Salesforce using complex SQL Queries for data analysis and manipulation

•Automated the work logging processes for 10 individuals in cross-functional teams through active collaboration

•Reduced time required for data quality checks by 30% by writing process automating scripts in R

•Visualized and presented statistics on the performance of devices from 14 million records to internal stakeholders

•Delivered actionable insights by analyzing 150+ data streams weekly for quality of data collection from hardware

•Improved workflow between 4 teams, by eliminating redundant processes and merging workflows

Search Engine Optimization (SEO) Project 09/17 – 12/17

Intelli Bookkeeping Boston, MA

•Increased domain rating for the website by 5% by performing keyword analysis and SEO using Google Analytics

•Reported and delivered actionable insights on a weekly basis on types of traffic on the website

•Lead and managed a team of 4 to achieve set targets and goals of the project.

PROJECTS

Financial Trading Strategy Using Time Series For Stocks (Skills used - Python & Tableau)

•Designed a trading strategy in Python using GARCH, Linear Regression, LSTM, CAPM, and Kalman Filter models

•Modelled a Recommendation System using Random Forest to find the best fitting model for a trading strategy

•Built a Trading strategy model with a return of 20% and a lowest RMSE value of $6.73 over 3 years

Data Warehouse & B.I. Dashboards (Skills used - Microsoft Visual Studio, Azure, T-SQL & MongoDB)

•Designed Data Warehouses with Snowflake Schema in SQL & Tableau Dashboards from multiple data sources

•Modeled OLAP Cubes & ETL processes using SSAS, designed Validation Tables with 3NF on Azure Cloud

•Reduced processing load by optimizing the buffer time & cache from 15 to 5 mins for 10 million rows in T-SQL

Database Design For E-commerce Companies (Skills used - MySQL & SQL)

•Created a secure database with user authentication for an E-commerce company using MySQL

•Added features like transactions, stored procedures and triggers to facilitate a secure transaction capable model

•Created meaningful entity relationships abiding by business requirements of the client

Cryptocurrencies Forecasting (Skills used - R, Excel & Tableau)

•Developed models using dimension reduction and linear modeling techniques in R for over 7 million records

•Presented reports using Tableau on statistics like predicting future prices for cryptocurrencies using Regression

Contact this candidate