JINAL SAPARIYA

R adbtvr@r.postjobfree.com jinal-sapariya jinalsapariya Æ 732-***-**** Boston, MA EDUCATION

Northeastern University, Boston, MA

Masters of Science in Information Systems May 2020 Relevant Coursework: Data Science, Statistics, Machine Learning in Finance, Data-Warehousing and Business Intelligence Mumbai University, Mumbai, India

Bachelors of Engineering in Information Technology May 2018 Relevant Coursework: Database Management Systems, Data Structures, Distributed Database TECHNICAL SKILLS

Programming Languages Python, Spark, Hadoop, PL/SQL R-programming, Java, JavaScript, C Machine Learning Scikit-Learn, Keras, Tensorflow, NumPy, Pandas, SciPy, Matplotlib, Seaborn Databases MySQL, MS SQL Server, Oracle 18c, PostgreSQL Data Integration/ETL SQL Server Integration Services(SSIS), Talend, Alteryx Visualization Tools Tableau, Power BI, Qlik Sense, QlikView, Other Tools Amazon Web Services, NetBeans, Eclipse, MS Excel, R Studio, Visual Studio Version Control Git, BitBucket

PROFESSIONAL EXPERIENCE

Philips Lighting Cambridge, MA June 2019 - August 2019 Deep Learning Intern

- Increased user interactions with the Hue System upto 20% by developing dynamic prototype tool using JavaScript.

- Designed a data pipeline using PySpark to read 100TB data and preprocess data by cleaning noise for user activity recognition.

- Researched RNN based time series models for forecasting the need for new light, compared the results with ARIMA model.

- Collaborated with the business team to analyze user requirements, converted them to functional requirements. ACADEMIC PROJECTS

Data Warehouse for Electronic Retail Company (Talend, SSIS, Tableau, PowerBI, Qlik) September 2019

- Modelled a Data Warehouse and performed ETL to coalese 40 million records using SSIS and Talend

- Implemented Source to Target Mappings, Data Profiling, Slowly Changing Dimensions, Reject Codes in the warehouse.

- Optimized the warehouse by performance tuning on a dataset sourced from multiple SORs (MySQL, SQL Serves, Oracle).

- Developed interactive dashboards to monitor performance of retail business KPIs by using Tableau, Power BI and Qlik Sense. Alphabet Google Stock Price Forecasting (ARIMA, LSTM, Random Forest) September 2019

- Manipulated the time series data by cleaning, scaling, outlier removal and converted to stationary through decomposition.

- Forecasted the stock prices using Random Forest with Kalman filter, Exponential MA algorithms with best RMSE of 0.17.

- Build Portfolio with trading strategies such as Buy Hold, Long Short based on historical data and performed risk analysis. Sarcasm Detection in English Language Sentences (RNN, Tensorflow, NLP) March 2019

- Participated in Kaggle competition to detect sarcasm in news headlines using different NLP Methods.

- Preprocessed the corpus using techniques such as tokenization, POS tagging, lemmetization, stemming and stopping methods.

- Trained RNNs of various configurations using glove embeddings of sentences to achieve 88% accuracy. Price Prediction on AirBnB listings (Scikit-Learn, Seaborn, Matplotlib) January 2019

- Performed supervised regression analysis on data-set of 74k records for price prediction of the property using 14 features.

- Conducted data cleaning, sorting to create and manipulate DataFrames using Pandas for designing regression based models.

- Visualized performance of regression models, received prediction error rate of 16.3% in Ridge Regression with regularization Re-Order Database System (PL/SQL, MySQL Workbench) December 2018

- Designed a secure reservation and ordering system using MySQL and toad data modeler to store transaction data.

- Leveraged CSV based data-set and performed data cleaning, normalization to design structural relational database.

- Developed single table inheritance, Full Text Search concepts to create one stop solution for users to find all relevant events.

- Efficiently used cursors, stored procedures, triggers, user defined functions to give analytical insights. LEADERSHIP AND PROFESSIONAL DEVELOPMENT

- Participated in Techtogether Boston 2020. Designed and developed a healthcare feel chat bot.

- Managed fundraising and organized knowledge sharing events for Graduate Woman In Science & Engineering at Northeastern.