VEDIKA SHENOY, CAPM®

adcg5d@r.postjobfree.com ● 315-***-**** ● www.linkedin.com/in/vedika-shenoy/

EDUCATION

Master of Science, Information Management, Syracuse University, Syracuse, NY [GPA: 3.97] May 2020 Electives: Data Analytics, Database Management, Business Analytics, Information System Analysis, Enterprise IT Consultation, Project Management, Lean Six Sigma, Enterprise Risk Management Bachelor of Engineering, Information Technology, Mumbai University, Mumbai, India May 2018 Electives: Business Intelligence, Database Management, Data Mining, Big Data Analytics, Software Project Management CERTIFICATIONS

• Certificate of Advanced Study in Data Science

• Google Data Studio

• Certified Associate in Project Management (CAPM)

• Google Analytics Individual Qualification

SKILLS

Data/ Business Analytics: Tableau, Power BI, MS Excel, R, SQL, Python, MS Access, RStudio, Weka, Minitab, Data Studio Project Management: Trello, MS Project, JIRA, MS Visio, MS Word, MS PowerPoint Digital Marketing: Google Analytics, Google Tag Manager, Star Chapter AMS, WordPress, HTML, Bootstrap EXPERIENCE

Analytics Intern, Syracuse University, Syracuse, NY Sep 2019 – Present

• Gathering data by coordinating with cross functional teams as part of Operations team in the Marketing department

• Developing interactive dashboards using Google Data Studio to assist marketing campaigns and website management

• Performing statistical analysis and quantitative analysis to detect abnormalities in the data and developing reusable solutions to prevent them from affecting campaign’s budget

• Using advanced MS Excel functions such as Pivot Tables, Power Query and VLOOKUP for improving student enrollment by integrating web traffic data and enrollment application data

• Performing UI/UX testing for websites to understand important elements of interaction and how it affects web data Data Analyst, NEXIS Student Technology Lab, Syracuse, NY Sep 2019 – Present

• Extracting, transforming and loading open data with 22 million rows using MS SQL Server Management Studio

• Performing preliminary data analysis to identify key variables and dependencies using Python and Jupyter notebook

• Utilizing machine learning algorithms such as Decision trees, Random forests, Naïve Bayes, Clustering analysis, SVM and Association rule mining to determine efficiency and accuracy of proposed model

• Developing PowerBI dashboard reports for effective resource allocation and developing strategies for improvement Business Analyst, iConsult Collaborative, Syracuse, NY Apr 2019 – Present

• Analyzing web traffic data and developing customized reports using Google Analytics to improve member retention

• Utilizing MS Excel to perform pricing analysis and suggesting economically feasible content management platform

• Developing an improved web platform which aids in better data management and providing support for maintenance Process Improvement Analyst, National Grid, Syracuse, NY Sep 2019 – Dec 2019

• Performed statistical analysis using Minitab such as correlation, regression, variation, sampling, measurement system analysis and statistical process control to analyze stability and capability of existing processes

• Integrated data from multiple sources to develop Tableau dashboard with unique functionalities for each department

• Improved data collection and mining process which led to 26% improvement in electricity and gas billing processes Business Analyst, Project Management Institute, Syracuse, NY Jun 2019 – Aug 2019

• Tracked and analyzed web traffic trends using Google Analytics to develop strategies for improved website layout

• Performed root cause analysis for PMI Chapter meeting and provided detailed insights to improve member retention

• Created detailed reports using MS Word and MS Excel and presented solutions to clients during weekly meetings ACADEMIC PROJECTS

Database Management - HealthCare Portal SQL, MS Access, MS Visio Jan 2019 – May 2019

• Designed Entity relationship diagrams, process flow and data flow diagrams of the infrastructure using MS Visio

• Developed database to manage the entities involved in health center by using MS SQL Server management studio

• Utilized MS Access for front end development of the portal and automated the patient appointment booking system

• Improved the existing system and reduced the processing time using triggers, functions, stored procedures and cursors ADDITIONAL INFORMATION

Graduate Mentor: Volunteering to help graduate students in resume reviewing, course selection for academic guidance and organizing events with the Career Services at iSchool of Syracuse University Student Supervisor: Leading a group of 12 to 15 students for ensuring smooth functioning of daily activities at dining hall Extracurricular Activities: Competed in district level competitions with over 8 years of gymnastics and yoga training, Choreographed and performed on various social events as lead dancer of Syracuse Orange Bhangra dance team