Varshil Shah

Jersey City, NJ ***** 917-***-**** adk0qp@r.postjobfree.com https://www.linkedin.com/in/varshilshah

EDUCATION

Pace University, Seidenberg School of Computer Science and Information Systems New York, NY

Master of Science (M.S.) in Enterprise Analytics GPA: 3.80 May 2020

Gujarat University, SD School of Commerce Gujarat, India

Post Graduate Diploma in Investments and Financial Analysis (PGDIFA) May 2018

Gujarat University, HA College of Commerce Gujarat, India

Bachelor of Commerce (B.COM) in Accounting and Statistics June 2017

COURSEWORK:

Business Analytics for Decision Making Mathematical Foundation in Analytics Big Data Warehousing Enterprise Intel Development Customer Intelligence Data Mining Data Warehousing Marketing Research Data Visualization

TECHNICAL SKILLS

Programming Languages: SQL, R, SAS

Analytical Tools and Software: Teradata, SPSS, Tableau, Google Analytics, Google Big Query, Microsoft Office Suite

EXPERIENCE

Semrush Inc. Feasterville – Trevose, PA

Customer Success Analyst July 2020 – Present

Built a Tableau dashboard which reports the monthly cancellations requests and their reasons which help the CS team to better understand the customer behavior and introduce new strategies to reduce churn.

Built various Tableau dashboards which highlight the customer’s product and tool usage broken down by month, quarter and year. This helps the retention team segment the customers and formulate marketing strategies.

Creating performance reports for every month, quarter, and year broken out by each Team and rep., by querying the data from google big query and uploading the necessary data to tableau for visualization.

SiriusXM Radio Inc New York, NY

Partner Data Management (PDM) Intern September 2019 – December 2019

•Collaborated with four team members to import the Partner Data into the system, identified potential data anomalies, transferred it into Teradata to get descriptive insights of the data by executing numerous SQL queries.

•Presented the insights of the data to the Director of the team and the marketing team to target and market the shows and channels to new subscribers based on various factors like demographic segments, taste and preference.

Hitachi Hi-Rel Power Electronics Pvt. Ltd Ahmedabad, Gujarat, India

Business Analyst October 2017 – March 2018

Forecasted the financial position as well as the financial requirements of the business using regression in R.

Collaborated with the finance team that prepared the CMA report which describes the financial conditions of the company to attain financial support from financial institutions by providing them with my insights from the forecast

Analyzed data from different departments and summarized their requirements using R to present the findings to the manager of the finance team to prepare the annual financial budget for the next financial year.

Astha Creations Ahmedabad, Gujarat, India

Business Analyst February 2016 – July 2017

Forecasted the total overseas sales of the company for the year using Linear Regression algorithm in R.

Assisted the marketing team by clustering the customers based on different factors like their income, taste preference, geographical location, which helped the team to market the products based on different segments.

ACADEMIC PROJECTS

Customer Segmentation

Imported the customer data from various platforms and transformed it to get insightful information.

Clustered the data based on similar spending score and income, into segments using k-means clustering in Tableau, for the business to target the customer groups and customize the marketing strategies based on these clusters

These clusters would help save company’s cost on marketing campaigns since it will only target those potential customers who fall under same clusters.

Contact this candidate