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

715-***-****

E-mail

addu2t@r.postjobfree.com

Tableau Public

https://public.tableau.com/profile/soni

ka.shivani.vijaykumar#!/

GitHub

https://github.com/sonikasonu

LinkedIn

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

Contact this candidate