Sonika Shivani Vijaykumar
Business Analyst
Business Analysis professional with experience in providing strategic insights to drive business decisions. Strong data analytical and visualization skills to improve business, marketing and operational effectiveness. Involvement in working on complex initiatives with cross-functional teams in a dynamic environment.
Personal Info
Address
Bellevue, WA - 98007
Phone
*************@*****.***
Tableau Public
https://public.tableau.com/profile/soni
ka.shivani.vijaykumar#!/
GitHub
https://github.com/sonikasonu
www.linkedin.com/in/sonikashivani
Skills
Tableau
Power BI
SQL
Python
R Studio
Azure ML Studio
Database
Management
Business Research
& Data Analysis
MS Office
Social Media
Analytics
Academic Projects
CRISP-DM Project
Data modeling for predicting Student
grades using Azure ML Studio
Business Analytics
Built dashboards and storyboards to
visualize the trends in Drug Poisoning
Mortality in the US from 1999-2017
using Tableau
Applied Regression
Analysis of likelihood of adoption of a
cat using R-Studio and Gretl
Text mining
Email spam classification - Application
of multiple classification models (SVM,
Naive Bayes etc) using Python
Experience
Jun 2019 -
Jun 2020
Business Analytics - Student Consultant
TCS World Travel
Designed database schema and performed ETL using SSIS to integrate required customer data for analysis.
•
Performed descriptive and diagnostic analyses using Tableau and Power BI to create business KPIs using analytical and reporting tools that enabled the marketing team to become more operationally efficient.
•
Performed predictive analysis to build customer segmentation models using Python, Azure Machine Learning Studio, and R that enabled the company to maximize the effectiveness in marketing and minimize wasted web marketing dollars.
•
Performed Cognitive text analytics to create a model in Python to make the popular destinations search swift and effortless.
•
Sep 2019 -
Mar 2020
Marketing Analytics Intern
TCS World Travel
Queried database to pull necessary data for GSAT (Guest Satisfaction) and Cost Analysis.
•
Performed CRISP-DM methodology for Data Preparation, Exploratory analysis and Data Validation in Excel and Tableau.
•
Analyzed post-trip survey data to create a complete 6 year historical view of guest satisfaction (GSAT) in Tableau to analyze cost for destinations and hotels and to help product team prioritize destinations and hotels for future TCS World Travel expeditions.
•
Identified historical patterns in key themes from survey results, both positive and negative and created dashboards and storyboards for the management team to make data driven business decisions.
•
Feb 2017 -
Sep 2017
Business Development Executive
Skyries Innovations Pvt. Ltd.
Performed research to segment the targeted market and carried out online
(Email and Mobile) and offline (guerrilla) marketing campaigns. Collaborated with sales and marketing departments to support business objectives and client acquisition.
•
Identified revenue opportunities by collaborating with distribution partners.
•
Education
Jun 2019 -
Jun 2020
Master of Science in Business Analytics, University of Washington- Tacoma
GPA - 3.69
Coursework - Data Mining using R, Text Mining using Python, Big Data Management, Social Media Analytics, Cognitive Analytics May 2018 -
May 2019
Masters in Business Administration, University of Wisconsin-River Falls GPA - 3.7
Coursework - Statistical Analysis, Operations Management, Financial Management, Corporate Accounting, Team Engagement, Organizational Behavior, International Business, Leadership and ethics, Strategic Management, Fundamentals of Business Law
Volunteering Experience
Oct 2012 -
Feb 2015
Youth for Seva
Scribe for visually challenged & Diversity Promoter May 2018 -
May 2019
Indian Students Association, University of Wisconsin-River Falls Secretary