Summary
Overview
Work History
Education
Skills
Certification
Websites
Accomplishments
Software Skills
Timeline
Generic

Param Anand

Rochester,NY

Summary

Leveraging market research and analytics skills & tools to help businesses in
analyzing KPIs, understanding customers' pain points in various phases of the
marketing funnel, promoting products & services, and establishing relations. Always eager to explore new marketing concepts and go out of comfort zone to acquire quantifiable gain.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Technology Analyst

Kimberly-Clark
01.2023 - Current
  • Analyzing DTS data models within Supply chain, creating & modification of ETQ forms using SQL & Python programming, developing and maintaining dashboards for ETQ forms to analyze KPIs on Power BI.
  • Update & Maintain database for ETQ using MS SQL Studio
  • Developing Report automation within Power BI for DTS Global Innovation Capabilities Dept , using SQL and advanced DAX language to increase reporting efficiency.

IT Business Partner Intern

Kimberly-Clark
05.2022 - 12.2022
  • Campaign optimization & tracking KPIs for Google Analytics & Google AdWords.
  • Data Visualization of KPIs using Tableau , Exploratory Data Analysis (EDA) using Python.
  • Webscraping , sentiment analysis, text mining, regression analysis, & data cleaning using R Programming (R-Studios).
  • Conducting A/B testing for various organic & paid ad campaigns.
  • Utilized diverse research techniques and online or published data collection tools to amass key information or statistics, supporting business objectives.

Graduate Research Assistant

Rochester Institute of Technology, Saunders College of Business
08.2021 - 05.2022
  • Conducting Literature Review & secondary research for the Professor in the field of Marketing Analytic, E-commerce & more.
  • Using R programming to conduct web scraping, data cleaning & manipulation, performing regression analysis , logistic regression, choice modeling, cluster analysis in R-Studio.
  • Using Tableau and Excel for report and data visualization.

Market Research Intern

ABB
01.2021 - 05.2021
  • Analysis of market, competitors, customers, and interactions to identify business opportunities in targeted segments.
  • Analyze all Transit Authorities and Class 1,2&3 Railroads financial, and business documents, and map available money at each customer, related to projects and potential for ABB.
  • Research defined consultants, and map who works with which of our customers.
  • Using R programming for data cleaning, statistical modeling uses for regression analysis Using Excel and Tableau to make visualization and reporting dashboards for KPIs on "State of Good Repair" funding research.

Digital Marketing Intern

Surescripts
06.2020 - 08.2020
  • Used Google Analytic, Google Ads, and Google Tag Manager to create audience segments, re-marketing campaigns both search and display ads.
  • Tracked and analyzed web analytics to recommend a proactive adjustment to strategies for improving landing pages, and reducing avg bounce rate by 15%. Improve avg. session duration to 11mins/user and engagement by 10%.
  • Made Tableau dashboards for Google Analytics & AdWords campaign KPIs.
  • SEO and rebuilding pages within confluence for product marketing department.
  • Keyword optimization and A/B testing of ads with customized landing pages for higher conversions.
  • Rebuilding Atlassian Confluence page for departmental use.
  • Used R programming for sentiment analysis, market basket analysis & forecasting, text mining & web scraping.

Marketing Coordinator

Rochester Institute of Technology
01.2020 - 05.2020
  • Twitter Sentiment Analysis using R Programming with methods like NRC, TF*IDF, word-level & sentence-level analysis & Topic Modeling( Text Mining)
  • Creating Organic Ad campaigns on Google AdWords and tracking performance via Google Analytics by making real-time dashboards for KPIs. Using Tableau to communicate performance metrics across Ad platforms via Interactive Dashboards & Stories.
  • Created optimized social media promotions with customized URL tracking parameters for RIT Dining Services, RIT Arenas, and RIT Global Village.

Education

MBA - Management Information Systems

Rochester Institute of Technology
Rochester, NY
12.2022

Bachelor of Science - Marketing

Rochester Institute of Technology
Rochester, NY
05.2021

Skills

  • Python for Exploratory Data Analysis & Visualization
  • Microsoft Office (Excel, Word, Powerpoint, Outlook)
  • Google Analytics & AdWords
  • Tableau
  • Minitab (Regression Modeling, ANOVA Testing, Chi-sq,Predictive Analysis, Multivariate Testing)
  • R-Studios (Logistic Regression, Market basket Analysis, Survival Analysis, Cluster Analysis, Choice Modeling)
  • Pay-Per Click Ads
  • Market Research & Data Analysis
  • Search Engine Optimization(SEO)

Certification


  • Udemy: Microsoft Power BI Desktop for Business Intelligence
  • Data Camp: Data Science with R
  • DataCamp: Data Analyst with SQL Server
  • Udemy: R for Data Science
  • Coursera Python & R
  • Microsoft Ads
  • Google Analytics Individual Qualifications
  • Google Search Ads 360
  • Google Search Ads
  • Hubspot Social Media Marketing
  • Hubspot Inbound Marketing




Accomplishments

  • Future Portfolio Dashboard Migration : Consist of migration work of 4 dashboards to Power BI from Tableau using DAX and SQL. The report consists of multiple dynamic filters and new visual modification to increase reporting efficiency and provide more detail analysis on various KPIs.

  • Developing COPQ (Cost of Poor Quality From in the ETQ ) Developed the COPQ form to record the data and move from the use of excel worksheet. Developed the COPQ form, view and workflows along with Py script for the automation of form fields like cost calculation, re-routing form from within workflows,fetching data from database based on the selection of product SKU/material number like product description, product category. Creating master keyword lists (MKLs) for Events classification, product category.

  • Developing Power Bi Dashboard for the COPQ Connecting the COPQ form records in the ETQ to Power Bi dashboard and merging it with the existing datasets from Excel for year 2022 and 2023 till date. To make a COPQ overview Dashboard and COPQ details report.

  • Tableau Reports migration to Power Bi : Worked on the migration of Tableau report for Maumelle Training & Training Report to Power Bi. Used DAX in power BI to create multiple calculated fields, columns for improvement , addition new visuals to improve the dashboards reporting.

  • R Programming Applied Exercises & Projects : Weekly Applied exercise on Churn Modeling, Market Basket Analysis, Logistic Regression, Text Mining using TF*IDF, UDPipe, NRC, tSNE, Topic Modeling, webscraping Customer Reviews. Finding Customer Life-time Value using RFM, CAC, CLV, Historic CLV and Lifecycle Grids and CLV Predictions Using the sBG Approach & Choice Modeling.

  • Capsim Capstone Project: Led team of four in the business strategy simulation tournament by Capsim and ranked in the top 1% globally among 2000 teams.

  • Morgan Cereal Bar's Marketing Plan: Lead team of 3 in planning & drafting marketing plan for Morgan Cereal Bar Rochester, NY. Using Python & Tableau for data exploration, & Visualization and R Studios for conducting Twitter Sentiment analysis.

Software Skills

  • R Programming (R-Studio)
  • MS Excel
  • Tableau & Power BI
  • PostgreSQL & MS Sql Server Mgmt Studio
  • Python (Jupyter Notebook)
  • Minitab & SPSS
  • Google Analytics & Google AdWords
  • Atlassian Jira & Confluence

Timeline

Technology Analyst

Kimberly-Clark
01.2023 - Current

IT Business Partner Intern

Kimberly-Clark
05.2022 - 12.2022

Graduate Research Assistant

Rochester Institute of Technology, Saunders College of Business
08.2021 - 05.2022

Market Research Intern

ABB
01.2021 - 05.2021

Digital Marketing Intern

Surescripts
06.2020 - 08.2020

Marketing Coordinator

Rochester Institute of Technology
01.2020 - 05.2020

MBA - Management Information Systems

Rochester Institute of Technology

Bachelor of Science - Marketing

Rochester Institute of Technology
Param Anand