VATSAL GANDHI
Harrison, NJ • *.*******@*****.*** • 973-***-**** • linkedin.com/in/vatsal-gandhi • github.com/vatsal-gandhi OBJECTIVE
A fast-learning individual seeking an opportunity to leverage diverse skills and experience in data analysis into the open data analyst position at your company. A M.S in Information technology & analyst from one of the renowned universities coupled with my strategically minded with 1.5+ year of experience in analytics will make me a positive asset to your organization. EDUCATION
Rutgers University – Newark, New Jersey Dec 2020
M.S in Information Technology and Analytics GPA: 3.76/4 Relevant Courses: Analytics Business Intelligence, Business Forecasting, Business Data Management, Data Mining, Statistics, ML. University of Mumbai, India Jun 2018
B.E in Electronics and Telecommunication Engineering Relevant Courses: Neural and Fuzzy Logic, Business Communication & Ethics, Structured Programming Approach, Random Signal. TECHNICAL SKILLS
Programming Languages : Python, R, SQL, C, C++, Java Databases : MySQL, SQL Server, MS Access, Oracle Database, MongoDB ETL : SQL Server Integration Services SSIS, Analysis Services SSAS, Reporting Services SSRS Functional Tools : Jupyter Notebook, R Studio, MATLAB, MS Office, Pivot tables, Macros Visualization Tools : Tableau, Power BI, Google Analytics PROFESSIONAL EXPERIENCE
Data Science & Analytics Intern Forkaia California Jul 2020 – Dec 2020
• Modelled and created databases for easier search using SQL & defined new data collection for analysis purposes.
• Organized datasets successfully to find name of startups and no. of members to analyze different committee based on relevant skills and developed SQL schemas using views, indexes, and development Stored Procedures.
• Devised NLP algorithm with text mining for more than 3000 job applications to figure all essential details which gave 89% accuracy.
• Created pie chart on tableau to identify challenges which helped to analyze number of skilled employees resulted into 63%. Data Analyst GMP Mumbai (India) Aug 2018 – Jun 2019
• Built data visualization dashboards using Tableau to identify key performance indicators in ERP application, enable better decision-making and transparency in daily business operations.
• Designed and implemented new business processes to improve workforce development.
• Analyzed inventory usage reports to avoid backordering resulting 15% of unnecessary stock purchased.
• Executed SWOT analysis on buying patterns of customers which helped to refresh the stock and increase in profit. RELEVANT PROJECTS
Analysis of Car Collision in New York City (Python, Plotly) Jun 2020
• Identified the area of most frequently occurring car collision based on contributing factors.
• Applied OLS (Ordinary Least Square) regression technique, resulted in F-static as 219.9, and p-value was zero.
• Graphical library PLOTLY was used to search the location of most occurred collisions in city. Time Series Analysis and Forecasting of the S&P 500 Stock Index (R) Feb 2020
• Predicted future trends based on training and testing data and applied Time Series Forecasting methods.
• Implemented forecasting techniques like Simple Average, Naïve, Seasonal Naïve and ARIMA and computed accuracy.
• Analyzed models results into minimal errors and ARIMA model gave best fit with least RMSE value as 49.35. Analysis of Job Search for data scientist in the USA (Python) Sep 2019
• Reviewed analytical methods such as Logistic Regression, KNN method, Random Forest methods, Decision Tree, Linear Regression and K-means methods on the training dataset for data exploration analysis.
• Estimated accuracy and confusion matrix for all these methods, where Random Forest was the utmost accuracy of 81% based on companies and location.
Multimodality Biometric Identification System using Fusion Technique (MATLAB) May 2018
• Selected random texture pattern produced from fingerprint and knuckle fingerprint of everyone for identifying true value.
• Processed images under Gabor filter to extract texture information with accuracy of 73% perfectly matched individual. LEADERSHIP
• Career Peer Rutgers Career Development Center – Organized events/podcasts for students about mental health, technology, job search and approved jobs on Rutgers University job portal (Handshake) for 11 months.
• Treasurer Magazine Committee VCET, India – Published college newspaper/magazine about technology and events.