Data Analyst Social Media

JUGAL SHETH

Boston, MA *****.**@************.*** 857-***-**** Linkedln_J Github_J Tableau_J

EDUCATION

Northeastern University, Boston MA September 2019 - May 2021 Master of Science, Engineering Management

Minor: Data Analytics & Business Intelligence

Coursework: Database Management and Design, Computation and Visualization, Data Mining and Machine Learning, Algorithmic Digital Marketing University of Mumbai, Mumbai India June 2014 - June 2018 B.E, Mechanical Engineering

SKILLS

● Languages: Python(pandas, numpy, matplotlib,sklearn), R,SQL

● Analytics: Tableau, PowerBI, Digital Studio,Einstein Analytics(Salesforce), DataBricks(Spark), MS Excel, Hadoop

● Cloud: AWS(RDS,S3), Azure Data Explorer, Snowflake,EC2, Heroku, PostgreSQL

● Web Libraries: Streamlit, Flask

CERTIFICATION

● KPMG Six sigma green belt (KPMG, MU072019139)

● IBM Data Analyst Professional (Under Practice)

PROFESSIONAL EXPERIENCE

Toroid Technologies, Marketing Analyst March 2019 - July 2019

● Lead the marketing campaign by analysing customer interactions, resulting in conversion rate increase by 8%

● Performed EDA on transactions, Data Mining using python, Spark on demographics, reported with Tableau dashboards to stakeholders

● Conveyed insights to the various teams, which lead to development of two new products, increasing sales by 5% that quarter

● Managed company’s social media activity, media management systems, content creation using Blogger growing reach by 20 view/day

● Performed reoccurring and ad-hoc business intelligence projects

● Pulled and reported data from numerous database (Excel, SQL,data management systems) dived deep and researched about different problem solving techniques

Hydac India PVT LTD, Data Analyst October 2018 - March 2019

● Collaborated with the Design department on a testing project with an objective to reduce cost and increase manufacturing capacity

● Designed and developed KPIs to provide strategic insights to drive growth and performance

● Set up test stand, set standards, paraments and recorded the result on excel for 1 million hydraulic cycles

● Tweaked testing parameters, Analyzed test data on python using pandas and sklearn, visualized the cycle performance on company reporting software, and conveyed reports to the senior management

● Successfully completed the analysis of 1 million cycles and aggregated the visualization and analytical results at the end leading to a direct stopping of import and increase in in-house production, decreasing the cost by 19%. ACADEMIC/INDIVIDUAL PROJECTS

HR Data Science Recruiting(Python, EDA, Linear Regression,Scikit, Tensorflow,AI) January 2021

● Performed exploratory data analysis on HR data to classify candidates for recruitment call, in order to optimize resources

● Generated insights on the HR data, and found many correlations and irrelevant fields which had to be removed for further steps

● Achieved an accuracy score of 89.4% and mean absolute error of 0.42, with Linear regression model with Sklearn E-Retail Store (Python/Keras/Machine Learning/Streamlit/ElasticSearch/AWS) : December 2020

● Developed end-to-end Application API for Retail Product Recommendation and Similarity search and hosted it on AWS through Streamlit

● Generated BI reports using PowerBI and Google Digital Studio resulting in 77% customer satisfaction and 14% increase in sales Stock Market Sentiment Analysis(Python/BagOfWords) October 2020

● Studied the News headlines in the data, Cross-Vectorization to create a Bag-of-words model to train the machine learning model

● Built a RandomForest classifier to predict the stocks and achieved through Sklearn, and achieved an accuracy of 85.4% Attribution Modelling(Python/Keras/Machine Learning/Voila/Heroku) October 2020

● Analyzed Customer journey using touchpoints from historical campaign data using Criteo Attribution Bidding data

● Staged the data in Snowflake and built a pipeline to connect it with Salesforce’s Einstein analytics, Observed a CPC of 0.01$

● Developed Multi-Touch Attribution models to optimize marketing budget across various advertising channels, Visualized results with, pyplot and Salesforce Analytics resulting in a campaign with 6% increase in conversation rate Anime insights(Tableau/Python) June 2020 – July 2020

● Extracted Anime data, transformed it using tableau tools and python, Loaded the cleaned data and staged it on tableau desktop

● Created a Storyboard depicting time series dashboard and Created audience clusters with the help of visualization to target the audience by age, 18-35 were 70% of total audience.

Contact this candidate