Rashmi Chauhan
Herndon, Virginia, USA,VA
Summary
Experienced Business Analyst professional with+5 yrs. of experience working in data analytics for fortune 500 clients in the CPG and technology industry. Skilled in Business Analysis & KPI Dashboards, Data modeling & visualization, and Business Intelligence.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Senior Analyst - Data Strategy & Democratization
Kantar
09.2017 - 01.2021
- Part of the Kantar Analytics practice handled multiple projects in the CPG & technology industry for North American clients
- Roles and responsibilities: Project management, Quality control, Client servicing, Database management, Data analysis, Insights generation & Reporting
- Major Projects handled: - Worked on menu pricing project for a large restaurant chain in the US, worked closely with the pricing analytics team
- Lead development of a stocks monitoring dashboard, with volatility and market index comparison, trend analysis, and scheduled reports - Price Check: Compared competitor menu pricing across various categories and locations in the US by preparing dashboards and decks
- Also understanding the key point changes and making deep-dive reports for significant changes
- Designed and launched the Brand Health Tracker dashboard for a Global Donut/Coffee brand
- The visualizations and insights from the dashboard helped the client to measure and track their brand health vis-à-vis competitors
- Worked for a major chocolate manufacturer and supported the global insights dashboard for 10 markets
- Worked on a Dashboard tool for one of the largest Restaurant Brands in the US which involved regular updates & addition of modules
- Technologies used: Power BI, Tableau, SQL, Python, R, SPSS, Advanced Excel & VBA.
Data Analyst
SLICeR.
03.2017 - 08.2017
- Worked on data visualization & analysis projects for clients in the fashion & lifestyle industry
- Performed ETL, Data Cleansing, and Data manipulation activities on large volumes of customer data by writing complex SQL queries and using advanced excel before inputting data into the company's Analytical tool, Kanvas
- Experience in writing T-SQL, Postgre SQL & MySql queries
- Performed ETL activities on the client data by doing source to target mapping and performing different transformations on the input data to make it load ready for the application
- Worked on a database project which involved ETL activities for the migration of data from SSIS to the company's own ETL tool, Klens
- Technologies used: MySQL, PHP, Python, Excel, R, Tableau, Excel.
Associate Consultant
Mount Talent Consulting Pvt Ltd.
01.2011 - 03.2012
- Part of the HR consulting team
- Worked for recruitment and learning & development projects for clients in the ITES, FMCG, Telecom & E-Commerce industry.
Education
High School -
Kendriya Vidyalaya
Master of Business Administration (M.B.A.) - Marketing & Finance
Symbiosis Institute of Management Studies
01.2010
Bachelor of Science - BS - Biology, General
AGRA COLLEGE, AGRA
01.2007
Skills
- SQL
- Tableau
- KPI Dashboards
- Data Visualization
- Business Analysis
- Business Intelligence (BI)
- Microsoft Power BI
- Python (Programming Language)
- R (Programming Language)
- Data Modeling
Websites
Certification
- Data Science professional certificate - IBM
- Data Analytics Certificate - Google
- EdX Honor Code Certificate for Foundations of Data Analysis - Statistics Using R
- EdX Honor Code Certificate for Introduction to R Programming - edX
- Data Visualisation & Analytics (Dashboard designing using Excel- VBA- SQL & Tableau) - AnalytixLabs
- Introduction to Data Analysis using Excel - Microsoft
- Text Analytics and Predictions with Python Essential Training - LinkedIn
- Power BI Data Modeling with DAX - LinkedIn
Awards
Sirius Award - Kantar, 10/2020, Awarded Sirius award for outstanding contribution & client satisfaction to the TCA dashboard for a major financial industry client.
Timeline
Senior Analyst - Data Strategy & Democratization
Kantar
09.2017 - 01.2021
Data Analyst
SLICeR.
03.2017 - 08.2017
Associate Consultant
Mount Talent Consulting Pvt Ltd.
01.2011 - 03.2012
High School -
Kendriya Vidyalaya
Master of Business Administration (M.B.A.) - Marketing & Finance
Symbiosis Institute of Management Studies
Bachelor of Science - BS - Biology, General
AGRA COLLEGE, AGRA
- Data Science professional certificate - IBM
- Data Analytics Certificate - Google
- EdX Honor Code Certificate for Foundations of Data Analysis - Statistics Using R
- EdX Honor Code Certificate for Introduction to R Programming - edX
- Data Visualisation & Analytics (Dashboard designing using Excel- VBA- SQL & Tableau) - AnalytixLabs
- Introduction to Data Analysis using Excel - Microsoft
- Text Analytics and Predictions with Python Essential Training - LinkedIn
- Power BI Data Modeling with DAX - LinkedIn
Similar Profiles
Yamuna BasavarajuYamuna Basavaraju
Market Research Analyst Intern at KantarMarket Research Analyst Intern at Kantar
Márcia BritoMárcia Brito
Business Title Panel Advisor/Administrator at KantarBusiness Title Panel Advisor/Administrator at Kantar
Pikku BachhukaPikku Bachhuka
Research Manager at KantarResearch Manager at Kantar