KASHMIRA AMIT PUJARA

Jersey City, NJ ***** adwnoi@r.postjobfree.com 551-***-**** www.linkedin.com/in/kashmirapujara SUMMARY

Adept Marketing Analyst with 2 plus years of experience in data collection, analysis, and visualization. Proficient in analytical skills with SQL, R programming, Python, SPSS, Tableau, Advance Excel. A talented leader with excellent communication, management, and solutionist skills with an ability to present findings to both technical and non-technical audiences. EDUCATION

Pace University, Lubin School of Business, New York, NY September 2021- May 2023 Master of Science: (MS) Customer Intelligence and Analytics Concentration: Marketing Analytics Relevant Coursework: SQL, Predictive Analytics (R Script), Business Analytics & Statistics (Advance Excel), Marketing Research & Research Methods, Customer Intelligence, Strategic Marketing Planning. Malini Kishore Sanghvi College, Mumbai, India July 2016 - August 2019 Bachelor of Mass Media

Relevant Coursework Advertising and Marketing research, Globalization and International Advertising, Advertising in Contemporary Society, Brand Building, Media Planning & Buying, Consumer Behavior, Digital Marketing, Customer Relationship Management. SKILLS

Technical: SQL, R, SPSS, SAS, Tableau, Stat Tools, @Risk, Sales Force, Python, Google Analytics, Advance Excel (Pivot Tables, VLOOKUP, Formulae) Analytical: Estimation, Hypothesis Testing, Linear Regression, Multiple Regression, Simulation Technique, Linear Programming, Predictive Analytics. Certifications: Certified Google Analyst, Certified in Google AdWords, Digital Marketing, Inbound Marketing EXPERIENCE

Stefee, Inc., New York, NY. September 2022 – December 2022 Marketing Research Analyst Intern – 20 hrs /week

• Performed in depth analysis in 40 GB data using SQL to analyze customer datapoints and identify areas for improvement in business process.

• Created 4 actionable dashboards using Tableau to derive insights for sales strategy and build roadmap decisions for the revenue analysis to model cost, reduction report from 4.8 hours to 15 minutes.

• Collaborated with product managers for developing KPI’s to determine product sales and identify opportunities that increased revenue by 3.75M annually thereby reducing refund request to 32.74% and labor expenditure by 4.73%. MarketFX Media, Nasik, India April 2020 – August 2021 Digital Marketing Specialist – 40 hrs /week

• Led implementation of commercial marketing strategies and analyzed customer interaction to improve customer flow

• Designed and developed content for websites CRM with ServiceNow, salesforce and developed social media marketing strategies for clients in accordance with objectives and budgets.

• Collaborated with the marketing team to design and deploy personalized ad-based Google digital marketing strategy

• Managed SEM, SEO using SEMrush, Screaming Frog, such as content strategy, link building, and keyword strategy to increase rankings. Atmosphere India, Mumbai, MH March 2019 – March 2020 Lead Marketing Analyst – 40 hrs /week

• Engaged with the web development team to develop a website and merge with Amazon India ( http://freegoindia.com/)

• Executed data cleansing operation on the website and analyze metrics affecting website performance using R and SQL

• Performed deep dive analysis and identified trends to reduce bounce rate, load time and traffic volume by 13.8% yearly using R.

• Merged with upcoming townships to up-sell the product as a bulk generating 1.85 Cr Rs within 6 months

• Worked with developers to enhance websites maintenance and full fill business targets resulting in 17.89% increase in traffic, thereby reducing load time by 0.565 seconds.

ACADEMIC PROJECTS

Trending Songs Prediction May 2022 – June 2022

• Analyzed Spotify dataset, performed statistical analysis, implemented t-test, chi-square test and developed hypothesis testing to identify factors responsible for #1 trending song.

• Modeled data using logistic regression, achieved an accuracy of 86.8% and identified that artist with popular music genre and catchy lyrics are more likely to be top artist, validated this with predictive analytics using R and Tableau visualization. Research paper – Lab grown diamond Industry. September 2022 – December 2022

• Conducted extensive secondary research on “will they hold their market value in future?”. Heald Primary research through Qualtrics survey to understand customer buying behavior and personal interviews to understand retailers’ perspective.

• Developed hypothesis using the secondary and primary data. Using SPSS approved my hypothesis.

• Drew recommendations and conclusion using tableau.

Contact this candidate