YASH MEHTA

***, ****, **** ****** **, Seattle, Washington 98105 ac7mt2@r.postjobfree.com 206-***-****

EDUCATION

The Information School, University OF Washington- Seattle, USA September 2017-June 2019 Master of Science in Information Management with a focus on Data Science, Analytics and BI (3.88/4.0) Dwarkadas J.Sanghvi College of Engineering, University of Mumbai, India July 2013-May 2017 Bachelor of Computer Engineering (3.7/4.0)

TECHNICAL SKILLS

•C, C++, Java, Python. •Excel, R •Hadoop, Hive, AWS

•MySQL, Postgres • Tableau, Power BI • R Shiny, Javascript d3 PROFESSIONAL EXPERIENCE

Expedia Group June 2018- September 2018

Data Analytics Intern

• Identified, measured & recommended improvement strategies across all (KPI’s) to analyze different point of sales

• Performed A/B testing on Split Ticket analysis project that resulted in increasing conversion rate by 65%

• Developed an incremental framework to understand new customer growth & allocate capital based on opportunity & performance.

• Analyzed and processed complex data sets using advanced querying, visualization & analytical tools Deloitte Touche Tohmatsu India Pvt Ltd March 2017-May 2017 Technology Consultant Intern

• Optimized the Global Staffing & Scheduling System (GSS) that resulted in efficient forecasting of the availability of resources in contrast to the pipelined projects

• Designed a process flow diagram to counter the flaws detected in the GSS tool PROJECTS

GradNGo Database System September- Present

• Using MS Visio, developed ER diagrams, process flows & work flow diagrams.

• Created databases, indexes & stored procedure as part of data migration initiative using PostgresSQL

• Ingested data using python (psycopg2) to migrate data on AWS Sentiment Analysis Jan 2018-March 2018

• Using Twitter Api and R extracted 4,500 tweets & used Bag of Words approach to tokenize the tweets

• Implemented the TF-IDF approach to score each word across all the tweets

• Using logistic regression trained my model trained my model on 1.6 million predefined tweets

• Created a sparse document term matrix as input to predict the sentiments of my extracted tweets. BI System

• Built SSIS packages and scheduled jobs to migrate data from various disparate sources into SQL server.

• Generated ad-hoc reports, drill down reports to provide visible data using Tableau Employee Attrition Oct 2017-Novr 2017

• Performed HR analytics on 15000 employee records to understand reasons behind high attrition rate

• Extracted 5 most important features using Recursive Feature Elimination (RFE)

• Performed data modeling using logistic regression that resulted in classification accuracy of 76%. Credit Card Fraud Detection Jan 2017- March 2017

• Implemented credit card fraud detection technique on 284807 records to predict fraudulent transactions

• Used Random Forest algorithm to predict the fraudulent transactions generating an accuracy of 99.27% LEADERSHIP

• Worked as Vice Chairperson for the Student Council of my college for managing finance & admin

• Organized Indian Nationals 2014- a Rubik’s Cube competition in association with World Cube Association

Contact this candidate