Shrey Kshatriya

+1-908-***-**** adm3c5@r.postjobfree.com https://www.linkedin.com/in/shreykshatriya

EDUCATION

Stevens Institute of Technology – Hoboken, USA May 2021 Master of Science in Information Systems GPA: 3.78/4.0 Related courses: Analytics & Machine Learning, Data Mining, Big Data, DBMS, Applied Analytics, Project Management University of Mumbai – Mumbai, India May 2019

Bachelor of Engineering in Information Technology GPA: 3.3/4.0 SKILLS

Programming: Python, R, PySpark, Apache Spark, SQL(Complex Joins & Stored Procedures), PL/SQL, T-SQL, VBA Tools: Tableau, Power BI, SAS, MS Excel, MS Word, SharePoint, JIRA, Splunk, SolarWinds, RStudio, Salesforce, AWS Databases: MySQL, PostgreSQL, IBM DB2, MS SQL Server Certifications: Introduction to Machine Learning, Fundamentals of SQL, Mastering SQL joins, Tableau, VBA with Excel EXPERIENCE

Junior Analyst Intern, IPC Systems, Jersey City, NJ Jun. 2020 – Dec. 2020

• Developed an automation system in Python to integrate server data into weekly single top report; collaborated with Network team to develop automation in Perl to update CMDB with new IP addresses

• Manipulated and transformed data in Excel and Python from wide to long format to ease visualization of data in Tableau

• Monitored data from 500+ syslog in Splunk and SolarWinds, performed analysis to identify areas of failures, and identify bottlenecking; proposed action plan for reducing future server failures by 75%, saving $230,000

• Showcased demographic based server data on Tableau to analyze global servers which reduced manual intervention by 80%

• Facilitated weekly scrum meetings with product team to understand requirements and propose workable solutions for SharePoint data migration; assisted in allocating resources using ETL and integrate JIRA service desk Business Data Analyst, Premiere Getaways, Mumbai, India Dec. 2018 – Jul. 2019

• Performed data analysis for market research using customer segmentation analysis in python for clustering customers

• Built Tableau dashboard for analyzing competitor prices and targeted customer segments to drive business decisions

• Utilized Google Analytics to monitor digital KPI’s and analyze success of marketing campaign through online ads and emails

• Worked directly with clients to conduct A/B tests, closed beta tests to improve product and understand client decision drivers Digital Content Intern, Pyrite Technologies, Mumbai, India Jun. 2018 – Jul. 2018

• Implemented SEO on company website and showcased website performance with Tableau and Google Analytics

• Administered 50+ JIRA and Confluence websites involving workflow and dashboards management on Kanban/Scrum board

• Published 40+ articles on website by conducting extensive research, and analysis for maintaining integrity of articles ACADEMIC PROJECTS

Pair Trading Strategy – (Python, Pandas, NumPy) Apr. 2021 – May 2021

• Devised a pair trading strategy in Python and Machine Learning to minimize trading risk due to an unexpected event

• Analyzed yahoo finance data that behaved like cointegrated pairs and plotted pair ratio, 5-day, and 60-day Moving Average

• Plotted buy/sell signals for select pair and trained, validated, and calculated profit, Sharpe ratio for different trading windows Stock Prediction using Machine Learning – (Python, scikit-learn, NumPy, Pandas) Sep. 2020 – Dec. 2020

• Analyzed data in Python with 19k rows for forecasting stock trend of UnitedHealth at the start of 2019 fiscal year

• Cleaned dataset and performed exploratory data analysis to aid for better model building leveraging statistical imputations

• Performed classification on dataset to predict buying/selling of stock by Random Forest and increase base accuracy by 4.4% Airbnb Dataset analysis – (MySQL Workbench, SQL) Nov. 2020 – Dec. 2020

• Worked in a group of 2, to create a database of Airbnb listing in New York City in MySQL Workbench

• Imputed data from Airbnb dataset and queried database to answer critical questions and aid in taking business decisions COVID-19 twitter sentiment analysis – (Hadoop, AWS, PySpark, Tableau) Jan. 2020 – Apr. 2020

• Parsed and fetched 20,000+ tweets on COVID using twitter API for analyzing and performing sentiment analysis in AWS

• Pre-processed raw data by using REGEX and TF-IDF vector to present analysis using PySpark, EC2, S3 buckets and EMR

• Compared Random Forest, DTree and opted for Linear Regression with 86.16% accuracy: visualized key insights in Tableau Predicting employee termination in R – (R, Tableau, plots) Jan. 2020 – Apr. 2020

• Inspected a large dataset in R with a goal to predict whether an employee is terminated, resigns, or stays by classification

• Ran comparative analysis by studying Random Forest, Naive Bayes, Decision Tree (Cart, C5.0), KNN algorithms

• Selected Decision Tree with 83% accuracy; explored model performance using confusion matrix; portrayed results in Tableau EXTRACURRICULAR ACTIVITES

• Peer Ambassador, Stevens School of Business Apr. 2020 – May 2021

• Member, Indian Graduate Students Association Aug. 2019 – May 2021

Contact this candidate