Kajol Chauhan

Mobile : +91-932*******

Email address : adi2az@r.postjobfree.com

Professional Summary

A versatile and dynamic professional with almost 2 years of experience in Data Analysis, Consulting, Consumer Insights and Recommendations in FMCG & Retail Analytics/Research at Tata Consultancy Services. Aiming to utilize my strong problem-solving skills and analytical ability to achieve an action-based business solution.

Work Experience

Tata Consultancy Services, Analytics & Insights (04 th

Feb 2019 – Till date)

Project: Sales Effectiveness

Designation: Business Analyst

Key Responsibilities:

Extracting, analysing and preparing the sales and pricing data using SAS programs for Pricing and Promotion Modelling for US FMCG market.

Advising clients on their Store Level, Online and Digital campaigns.

Analysing impact of increased activity in one pricing and promotion campaign on other tactics and giving clients actionable insight.

Supervising junior analysts in their projects and ensuring quality of their deliverables.

Training new joiners in the team on basic tools used like MS Office and Unix.

Maintaining KPIs for different projects, sharing best practices with the team and documenting the same.

Major Accomplishments:

1. Building Tableau Dashboards for Leading FMCG Client – Situation: One of the leading FMCG client wanted their Sales Effectiveness project to be presented as a Tableau report instead of PowerPoints. It was crucial for the client since they were using Tableau at organisational level and did not want presentations to be made in PowerPoints anymore.

Value Add: None of the team members had worked/exposed to Tableau before. I readily took the task and learnt Tableau through online tutorials. I was able to build complex, visually appealing and re-usable Dashboards in Tableau well before client deadline. Extra Mile: The whole process was very much appreciated by the clients and I was awarded with “TCS On the Spot” award for my innovative thinking and learning approach. 2. Delivering the most highly customized project for New FMCG client – Situation: First ever project on one of the leading FMCG client which was highly customized with a crunch timeslines.

Value Add: Implemented the automation tool and the programs which reduced the processing time - Very helpful during the crunch timelines plus no chances of manual errors.

Extra Mile: Client was delighted to have what they were looking for, that too in very less time. This boosted client’s trust in the organization and they happily continued their business with our organisation.

Project: User Acceptance Testing

Designation: Business Analyst

Key Responsibilities:

Involved in Smoke Testing of a Business Intelligence tool developed on micro strategy.

Actively involved in setting up of a new User Acceptance Testing process at TCS Gandhinagar location.

Responsibilities include understanding client requirements for the UAT, lead client meetings, client communication, assuring adherence to timelines and quality of delivery.

Training new joiners on the some of the process, Client Application and Databases.

Preparing training materials, process manuals, QC manuals and ensuring deliverables are of appropriate quality standards and timelines are met as per SLA’s Project: Retail Analytics, Client Services

Designation: Business Analyst

Key Responsibilities:

End to end management of business and market research projects for Retail Sector, using client tool such as Global Modelling Operations, Output Viewer, Nielsen Answers and MS- Office.

Hands on experience of POS and scantrack data

Analysing and giving insights & recommendations on the buying pattern of U.S. households and the changes in trend over a period for US retailers.

Identifying business issues, research objectives and storyboarding analysis in consultation with clients for US FMCG market.

Analysing trends, identifying growth drivers, measuring sales effectiveness and quantifying opportunities for US Retail market.

TECHNICAL PROFICIENCY

Microsoft Office

Tableau Desktop

Unix

Skilled with Advance Excel

Knowledge of SQL

Experienced in other client specific tools like – Price Evaluator, Nielsen Answers, Promo Source of Volume, Strategic Planner and Pricing Insights CORE COMPETENCIES

Problem Solving Approach

Strong Analytical Ability

Efficient in Multi-Tasking and Prioritizing Work

Excellent Communication Skills

Education

Bachelor of Commerce (Advance Accounting and Statistics) from H.L College of Commerce, Ahmedabad, April 2018

Cleared CT1 (Financial Mathematics) from IFOA (Institute and Faculties of Actuaries. Awards & Certifications

Received “Star of the Month” award twice for different projects in TCS.

Received “Nielsen Certificate of Appreciation 2019” award for reducing significant amount of process time by automating the process.

Received TCS on the Spot award for delivering highly customized project on time.

Received “Cheers for Peers” from Clients multiple times.

Agile Way of Working Foundation, awarded by TCS continuous learning program. Date: 08

th

Dec 2020 Kajol Chauhan

Contact this candidate