Dhairyav Jatin Shah

857-***-**** adyjlo@r.postjobfree.com github.com/dhairyav-s linkedin.com/in/dhairyav-shah/ Boston MA EDUCATION

Master of Professional Studies in Analytics, Major – Statistical Modelling Expected April 2024 Northeastern University, Boston, MA 3.78 GPA

Courses: Probability & Stats, Data Mining & Visualization, Predictive Analytics, Data warehousing & SQL, Artificial Intelligence Bachelor of Technology, Electronics & Telecommunication October 2020 University of Mumbai, India

TECHNICAL SKILLS

Languages & Database: Python, SQL, R Programming, HTML, CSS, MS SQL Server, Snowflake, Redshift, MySQL, MongoDB Libraries and Frameworks: Tableau, MS Power BI, Microsoft Office, MS Excel, MS PowerPoint, NumPy, Pandas, Scikit-Learn, TensorFlow, Matplotlib, Seaborn

Machine Learning Models: Linear & Logistic Regression, KNN Classification, Decision Tree, Random Forest, Natural Language Processing

PROFESSIONAL EXPERIENCE

Kinesso, India: Reporting Analyst November 2020 – April 2022

• Executed end-to-end weekly reporting within electronic fitness & CPG domains, utilizing Advanced Excel & Alteryx for efficient data processing & analysis

• Integrated Snowflake server with Tableau to develop & maintain a dynamic dashboard tracking digital marketing KPIs, driving actionable insights for impressions & site visits

• Spearheaded a team of 5 in automating ETL operations across various social media platforms using Python Selenium, resulting in a significant reduction of 75 hours of manual work per week

• Leveraged data analytics to provide stakeholders with valuable revenue & ad spend insights, enabling informed decision- making & driving business growth

Jobs Quest, India: Data Analyst Intern August 2020 – October 2020

• Performed ETL, EDA & trend analysis to analyze sought-after job sectors including data science, software engineering, & full- stack development, assisting in strategic planning, optimization, & informed decision-making for product development

• Assessed reports, classified charts from research papers & defined metrics to keep track of distinguished job market & visualized Tableau dashboards to deliver reports to 20+ employees for better business intelligence & optimization IFA Global, India: Business Analyst Intern November 2019 – January 2020

• Analyzed LinkedIn pages of 3-5 companies, including BCG & McKinsey, to design a LinkedIn post schedule; boosting global impressions by 15% and increasing followers by 1200

• Idealized a data-driven sales pitch based on significance of global economic indicators & forex market resulting in converting 2 potential clients

ACADEMIC PROJECTS

Studying Plastic Pollution in North America (Python & Tableau) April 2023 – May 2023

• Rectified data inconsistencies, imputed missing values by implementing TF-IDF vectorizer & LinearSVC; achieved an average prediction accuracy of 74.44% (product type: 85.67%, material type: 66.96%, layer: 71.69%)

• Executed comprehensive EDA on audit-specific, time, and location variables, revealing valuable insights on audit types, prevalent trash categories, and trends; Designed interactive dashboard in tableau for dynamic data exploration

• Employed regression analysis to examine predictors' impact on plastic waste pollution, achieving an R-squared value of 0.2558 and predicting total trash per million inhabitants with an average RMSE of 10.67417

• Conducted a two-sample t-test to compare the average trash per million habitants between states with plastic bans and those with preemption laws; finding no significant difference in mean trash counts, thus failing to reject the null hypothesis Understanding Magazine Subscription Behavior (Python) January 2023 – March 2023

• Actualized exploratory data analysis through tables & heatmaps to capture insights into consumer subscription patterns for a publisher, resulting in actionable recommendations for improving subscription rates

• Incorporated SVM & Logistic Regression model with accuracy of 86% & 88%, precision of 88% & 90% & recall of 98% & 97% to predict consumer subscription

• Showcased expertise in enhancing model performance by implementing feature selection & engineering, cross-validation techniques, data wrangling, & model building for predictive analytics tasks, while effectively preventing overfitting A Prescriptive Model for Strategic Decision-making: An Inventory Model (R & MS Excel) January 2023 – March 2023

• Developed & implemented a decision model for inventory management for a manufacturing company, resulting in improved financial performance

• Conducted what-if analysis to study sensitivity of total cost to changes in holding cost & order cost, providing insights on cost fluctuations based on parameter variations

• Utilized Excel Solver to optimize total inventory cost by adjusting reorder point, resulting in a cost reduction of $304.21, decreasing total cost from $6,161.05 to $5,856.84, & increasing number of orders from 11 to 15 annually

Contact this candidate