SANYUKTA SHANDILYA

adlp60@r.postjobfree.com (c): 646-***-**** Syracuse, NY https://www.linkedin.com/in/sanyuktashandilya/ EDUCATION

Master’s in Information Management - Certificate of Advanced Study on Data Science Syracuse University – GPA: 3.86 May 2021

Relevant Coursework: Data Analytics, Business Analytics, Cloud Management, Project Management, Enterprise Risk Management Bachelor of Technology, Electronics and Telecommunication Mukesh Patel School of Engineering Management and Technology, NMIMS June 2019 SKILLS

Programming Languages: R, Python, SQL

Tools: Tableau, Salesforce CRM, RStudio, Power BI, SQL Server, Excel, MS Project Professional, PowerPoint, Google Analytics EXPERIENCE

Data Analyst - Wasserman Media LTD, Los Angeles September 2020 - November 2020

• Supported key internal data platforms that connected disparate sources of industry, client and fan information

• Performed SQL programming using My SQL Workbench for data retrieval and cleaning followed by quality assurance

• Created detailed dashboards using Tableau to provide insights to company leadership on multiple KPIs for brand awareness, etc. Faculty Assistant – Enterprise Risk Management, Syracuse University August 2020 - Present

• Mentored a class of 12 students, cohosted classes, facilitated breakout sessions and updated the course work

• Assisted in designing the undergraduate Enterprise Risk Management course with industry specific case studies Business Analyst - iConsult Collaborative, Syracuse University February 2020 - August 2020

• Gathered business requirements by interviewing a non-profit client to implement Salesforce CRM for better donor management

• Built a data model specific to the client’s requirements and performed data cleaning in Excel to setup the data for Salesforce CRM

• Configured Salesforce Non-Profit Success Pack using custom and standard objects, triggers, automated dashboards and reports

• Created functional specification documents and custom product handouts to provide Salesforce training resources to the client PROJECTS

Prediction of Online Customer Shopping intension - Data Analytics August 2020 - November 2020

• Conducted data preprocessing, outlier detection and data normalization on variables to setup data for analysis using R

• Predicted shopping intentions of customers using classification models such as ANN, Naïve Bayes and K means Clustering

• Provided recommendations about attracting customers based on prediction by Artificial Neural Network with 92% accuracy Analysis of Airbnb Listings in Seattle - Scripting for Data Analytics August 2020 - November 2020

• Analyzed Airbnb house listing activity using Python programming using Pandas, NumPy and Matplotlib

• Performed data cleaning of missing values followed by categorical encoding of string values

• Identified price hikes over different times of the year and the most and least expensive neighborhoods in Seattle Student Loyalty Program for the Syracuse University Bookstore - Database Management January 2020 - April 2020

• Designed the ER Diagram and developed a relational database using SQL for the SU Bookstore to improve inventory management

• Created front-end forms in MS Access to gather data and connected it to the SQL server backend with proper role-based access

• Started a customer loyalty program using the stored data to attract more students to purchase directly from the Bookstore Prescriptive Analysis for Southeast Airlines - Data Science August 2019 - December 2019

• Analyzed data of 1 million customers using R to understand why the airlines was facing a declining customer count

• Performed data munging and predicted factors through feature generation and regression analysis with 85% accuracy

• Generated a report of the results and visualizations obtained through R Studio thus providing recommendations Smart Billing and Content-based Recommender System using Fingerprint - Machine Learning August 2018 - June 2019

• Developed a smart cart using Python to solve the problem of long queues at billing counters along with recommending products

• Analyzed and created a recommender system based on purchase history using content-based collaborative filtering

• Designed a cart to recommend products and simultaneously display and update the bill for a customer methodically LEADERSHIP

Teacher - Dharma Bharathi Mission (NGO) June 2018 - July 2018

• Managed the curriculum for students of grade 5, 6 and 7 with approximately 50 students in each class

• Taught English communication with focus on spellings, formation of sentences, written and verbal communication PUBLICATION

Smart Billing Content-based Recommender System using Fingerprint ICT4SD2019 Certified, 4th International Conference on Information and Communication Technology

Contact this candidate