SHOUVIK ASH

Boston, MA 617-***-**** adkc9c@r.postjobfree.com https://www.linkedin.com/in/shouvik-ash-a416aa101/

EDUCATION

Northeastern University, Boston, MA Dec 2021

Candidate for Master of Science in Data Analytics Engineering GPA: 3.87/4.0

Relevant Coursework: Data Mining, Machine Learning, Data Warehousing and Business Intelligence, Probability and Statistics

Activities: Graduate Student Government, Data Analytics Engineering Student Organization

Nirma University of Science and Technology, Ahmedabad, India Jun 2017

Bachelor of Technology in Electrical Engineering

Activities: Make a Difference, Entrepreneurship Awareness Club, Intramural Table Tennis

TECHNICAL SKILLS

Programming Languages: C, Python, SQL, R

Libraries & Packages: NumPy, Pandas, Matplotlib, Seaborn, Scikit Learn, TensorFlow, ggplot2, RShiny, rpart, Caret, IBM SPSS

Databases: MySQL, Microsoft SQL Server, Oracle SQL, NoSQL (MongoDB, Neo4j)

ETL/BI Tools: PowerBI, Tableau, Qlik Sense, SSIS, SSAS, SSRS, Talend, Excel (VBA, VLOOKUP, Pivots)

Cloud Technologies: Microsoft Azure, Amazon Web Services (AWS), IBM Cloud, Google Cloud

Machine Learning Algorithms: Regression, KNN, SVM, Naïve Bayes, Decision Tree, Neural Network, Clustering, Anomaly Detection

Other Relevant Skills: Significance Testing, Statistical Inference, Web Scraping, Dimensional Modeling, Data Integration Pipelines

WORK EXPERIENCE

D’Amore McKim School of Business, Northeastern University, Boston, MA Sep 2020 - Present

Teaching Assistant (MGSC 2301 - Business Statistics)

Implement a class plan with flexible assignment submission and grade weekly assignments of students on Canvas

Mentor 110+ students on concepts including probability distributions, hypothesis testing and regression analysis

Torrent Power Ltd, Ahmedabad, India Jul 2017 - Dec 2019

Energy Operations & Planning Analyst

Developed interactive KPI dashboards using Excel and reported critical business metrics to senior management

Analyzed monthly energy balance reports and recommended strategic decisions to improve operational efficiency by 10%

Employed long-term load forecasting techniques using time-series analysis and optimized network capacity by 20%

Lead a team of 5 engineers to implement 400kV double circuit transmission line project in association with key stakeholders

ACADEMIC PROJECTS

Hotel Booking Cancellation Prediction Model Sep 2020 - Dec 2020

Performed exploratory data analysis on 119k records using R to identify factors affecting hotel reservation cancellation

Reduced dimensionality of dataset containing 32 variables using principal component analysis keeping 89% of variance

Built classification models to predict cancellation, evaluated model performance and achieved best accuracy of 83%

E-Commerce Industry and Online Shopping Growth Analysis Aug 2020 - Sep 2020

Conducted data wrangling of e-commerce and online shopping statistics obtained from online data sources using R

Developed various dashboards on Tableau to give visual insights using bar charts, time-series plots and interactive maps

Presented storyboard to showcase potential growth of e-commerce sector worldwide and online shopper conversion rates

Wholesale Database Management System May 2020 - Aug 2020

Designed relational database to generate and support prices, orders and sales of goods through logical data modeling

Constructed ER diagram on Lucidchart and normalized it to 3NF to curb insert, update anomalies and avoid redundancy

Implemented database on using SQL data definition and manipulation queries incorporating triggers, functions and views

Developed dashboards on PowerBI to present analytical insights on region wise sales and refunds and sales of products

Data Driven Storytelling on Petroleum Industry in the United States Apr 2020 - May 2020

Extracted, cleaned and aggregated raw data from US Energy Information Administration website using Python (Pandas)

Created visualizations in the form of bar charts, time-series graphs and projection maps using libraries: Matplotlib, Seaborn

Published a webpage on Google Sites to present a story backed on insights, background statistics and visual information

CERTIFICATIONS & EXTRA CURRICULAR ACTIVITIES

IBM Data Science Professional Certificate - Completed data science specialization along with capstone project on Coursera

LEAD 360 Graduate Leadership Institute Spring 2020 - Completed 8-week training program organized by Employer Engagement and Career Design Studio at Northeastern University

Make a Difference - Lead fundraising campaign for education of the underprivileged children in Ahmedabad region

Contact this candidate