• Python

• R programming

• SQL

• Microsoft BI

• Google Data Studio

• Metabase

• Stata

• Tableau

• JMP

• Excel

• Market Research

• Team Management

• Curriculum Design

SKILLS

Projects

Colgate Palmolive Company

– Choosing the Right Price

for a New Pet Food Product

- Predicting the sales price of

new pet food products and

providing related insights into

the drivers of their price using

the product’s descriptions and

other text-based attributes.

Data Visualizations Project

(Optimal Climate Event

Monetization)

Data Visualizations Project

(Optimal Climate Event

Monetization)

Kargo Technologies June 2020 - August 2020

• Created an interactive commercial dashboard to track financial, brokerage, product and marketing metrics

• Led weekly insights regarding top shippers, transporters, routes and gross margin with all teams

• Built a job bundling proposal model for the brokerage platform to allow transporters to increase their overall margins and efficiency by 45%

Johnsons & Johnsons July 2020 - August 2020

3052 Harper Hall, 240 West Campus Dr, Blacksburg, VA 24061 Mozaiko – Virginia Tech University August 2019 - May 2020

+1-312-***-****)

adiicv@r.postjobfree.com

https://www.linkedin.com/in/simran-kathuria

• Student President of the international community made up of over 120 students representing 21 countries at Virginia Tech

• Successfully led over 50+ events representing immersion in intercultural exchange, language practice and leadership promotion

• Coordinated regular forums with the program faculty staff managing and served as the student representative at the Mozaiko Advisory board.

Business Strategy Analytics Intern

• Created a pricing framework to optimize pricing decision based on internal and external metrics

• Recommended an increase in price totaling to an additional 200,000 USD in revenue for the top four brands based on pricing framework

• Conducted a 3 year performance analysis with head to head competition for each SKU in Indonesia brands Nestle June 2019 - August 2019

• Automated eBusiness performance dashboard of KPIs across all pillars (Data, Content, Media) using both Google Data Studio and Microsoft BI

• Analyzed monthly updates compared with legacy data for KPIs including Traffic Source, Brand Website session duration and Bounce Rate and presented at weekly business review meetings

• Automated all manual data sources and created a storage template for agency analytics in a responsive sharepoint saving 900 man hours per year

Bayer May 2019 - August 2019

• Created marketing mix models to estimate country trade areal sales volumes allowing the salesforce to implement microtargeting business strategies

• Processed data and conducted multivariate regression analysis of marketing mix of three-years to produce an equation for optimizing spending’s

• Recommended optimal spending zones to increase their revenue by 7% within the next two quarters UWC USA Global Leadership Forum June 2017 - August 2017

• Coordinated with the program director in recruiting 42 international participants representing 12 countries

• Led workshops to foster social change at local and global level through skill-building workshops, NGO site visits and immersive volunteer work

• Collaborated with 5 instructors in designing sessions including a 30-day schedule of morning hikes, workshops (e.g. Power and Inclusion), debrief meetings and engaging activities

- Analyzed growth rates for a

basket of stocks during periods

of environmental tragedies to

determine:

EDUCATION

BACHELOR OF SCIENCE

(Dual Degree)

Computational Modeling

and Data Analytics,

Economics

Virginia Polytechnic & State

University

Blacksburg, VA

Expected graduation

December 2020

INTERNATIONAL

BACCALAUREATE DIPLOMA

Mahindra United World

College

Pune, India

Received May 2016

WORK EXPERIENCE

Strategy and Product Intern

Student President of Living Learning Community (LLC) SIMRAN KATHURIA

Business Analytics Intern

Digital Marketing Analytics Intern

Curriculum and Instruction Manager

Contact this candidate