Data Scientist, Insights Analyst, Data Analyst

SHIVAIN MEHTA

DATA SCIENCE AND ANALYTICS PROFESSIONAL

EMAIL: *********@*****.*** PHONE: +65 83100566

LINKEDIN: /in/shivainmehta DOB: 08 December, 1989

SUMMARY

Experienced Data Science professional with deep knowledge in Statistical theory and data modelling techniques. Extensive exposure to machine learning algorithms for predictive modelling and Text Mining. Hands on experience on working on R, Python, SQL, Excel VBA. Technical Skills on Big Data processing with Hadoop and Spark. Excellent Visualization skills with Tableau and R Shiny. Looking for opportunities where I can exhibit my skills to filter signal and noise from structured or unstructured data.

SKILLS

MACHINE LEARNING & STATISTICAL METHODS: Predictive, Descriptive and Prescriptive Analytics, Statistical Analysis, Time Series Analysis and Forecasting, Text Analytics, Natural Language Processing (NLP), Collaborative Filtering, Feature Engineering, Optimization, Graph Analysis, Web & Sequence Mining.

PROGRAMMING LANGUAGES & DATABASES: R Programming, Python (NLTK, Numpy, Pandas, Scikit Learn etc.), SQL, Excel VBA, Mongo DB (NO SQL) SPSS, Hadoop, MapReduce, HDFS, Hive, Spark, Solver

VISUALIZATION & REPORTING TOOLS: Tableau, R Shiny, Alteryx, Tibco Spotfire

WORK EXPERIENCE

ASM Front End Manufacturing Singapore

Data Science Analyst June, 2017 to Present

• Spearheading the data science and analytics initiative to optimize business processes and improve operational efficiency.

• Predictive Modelling using to build the dynamic Material Lead Time Prediction System for efficient Material Resource Planning and Manufacturing planning.

• Inventory Management for low demand Spares to address the problem of Material Obsolescence.

Aon Centre for Innovation and Analytics (ACIA) Singapore

Data Science and Analytics Intern August, 2016 to March, 2017

• Text Analytics Project: Worked on the companies description data scraped from the web, cleaned the data for analysis and applied Natural language Processing techniques on the scraped data and to classify companies based on their description into AON pillars, categories and sub categories using R and Tableau to develop a proprietary AON dashboard which would be used by AON Business units to track the companies.

• Customer Analytics Project: Worked on the project where I analyzed the transaction data of the AON client which is also one of the leading cruise line. The objective of the analysis was to find out the relationship between the given variables and outcome variable and also find pattern from the data which lead to outcome variable. This was done using R and SQL.

• Quantitative Market Research: Worked on various small projects where we were required to understand the client’s business problems from brainstorming sessions, do quantitative research and develop POC to assist Business development team.

Amdocs India

Subject Matter Expert (Analytics) September, 2014 to December, 2015

• Worked on Training Need Analysis project for internal employee development where given the skills required, per person available training days and the cost and duration of the training. We were required to optimize the training calendar.

• Worked on to provide the necessary reports to the senior management as and when required by extracting the data from SAP business Objects and transforming and manipulating it in Excel.

NIIT Limited India

Software Engineer June/2011 to September/2014

• Outsourced project by one of the world’s largest IT equipment manufacturer where we were on to gather the training needs of the client’s customers and come up with the optimum training plan given the skills required, availability of in-house trainers or vendor trainers.

• Worked on the operational analytics project to optimize the productivity of the front desk executives to come up with incentive calculation structure and automate the process of calculation of monthly variable compensation using dashboard built using Excel VBA and Pivot tables.

• Involved in the development and testing of Learning Management System for one of the world’s largest IT equipment manufacturer using C++, JS and writing test cases on HP Quality Centre.

• Involved in administration of the Salesforce CRM to develop and customize forms and reports to be used across different project teams.

EDUCATION

National University of Singapore

Masters Business Analytics (Data Science, Machine Learning, Statistical Modelling) 2017

Maharshi Dayanand University

Bachelors Computer Science Engineering 2012

PROJECTS

Marketing Analytics for leading Nutrition Supplement Company

Tools Used: Excel, R and Tableau

Project Details: Designed a Go to Market strategy for nutrition supplement online portal with a goal of increasing online presence and sales.

• The data was collected doing research on competitor market and reading available case studies.

• Accessing the target market (size and potential)

• Performed product & market analysis to create different customer personas and different channels to reach out to them

• Addressed customer acquisition strategies and how to build out future CRM initiatives;

• Analyzed customer transaction data to perform Customer Segmentation using K-Means Clustering for tailored marketing campaigns using Recency Frequency Monetary techniques;

• Predicting the Customer Lifetime Value using Linear Regression and the Wallet Size using Quantile Regression and targeted marketing campaign strategy based on the results

• Presented the insights using Tableau Dashboard

Text Analytics on Fatality and Catastrophe Investigation Summaries

Tools Used: Python

Project Details: Text analytics on the Construction site accident summaries to extract specific information.

• The dataset consisted of the training data where the cause of accident was already defined and the larger set of test data from which cause of accident and other information was to be extracted using text mining.

• Cleaned the given data set and applied Text pre processing on the given text data to prepare it for further analysis.

• Used pre classified investigation reports as training data, performed Machine Learning classification method like Support Vector Machines, Gradient Boosting Models and Naïve Bayes Classifier to detect the cause of accident on test data.

• Used NLP technique like POS tagging and Regex approach to identify the objects in the accident reports, activity which victim was doing and occupation of the victim.

Valuable Customer Prediction for Marketing Campaign and Insight Discovery

Tools used: R and Excel

Project Details: Data mining project to help a Mail Order company to identify customers who are most likely to respond to its mailing campaign.

• Statistical Analysis of the variables using Chi-Square Test for Categorical variables and t-test for continuous variables.

• Used feature engineering and dimensionality reduction techniques like Correlation Analysis, Principal Component Analysis and Random Forest Imputation to reduce 200 variables to 60 variables.

• Trained different classification models like Decision Tree, Support Vector Machines and Artificial Neural Networks to achieve the satisfactory prediction accuracy.

• Used clustering techniques like K Means to find the neighborhood where almost 90% of population were respondents to the mailing Campaign.

Contact this candidate